Monthly Archives: June 2023

PROJECT STEPS

1. Takara Hiyashi is on the board of the Green Lake Sports Camp, a recreational summer camp in Syracuse, New York. She is using an Excel workbook to analyze the camp’s financials and asks for your help in correcting errors and solving problems with the data.
Go to the Teams worksheet. Takara asks you to correct the errors in the worksheet. Correct the first error as follows:

a. Use the Trace Precedents arrows to find the source of the #VALUE! error in cell C8.

b. Use the Trace Dependents arrows to determine whether the formula in cell C8 causes other errors in the worksheet.

c. Correct the formula in cell C8, which should add the baseball registration fee per person (cell C4) and the equipment fee (cell C7), and then multiply the result by the minimum number of campers (cell C6).

d. Remove the trace arrows.

2. Correct the Name error in cell C22 as follows:

a. Use any error-checking method to determine the source of the error in cell C22, which should calculate the average revenue per week.

b. Correct the error by editing the formula in cell C22.

3. Correct the divide by zero errors as follows:

a. Evaluate the formula in cell C18 to determine which cell is causing the divide by zero error.

b. Correct the formula in cell C18, which should divide the revenue per session (cell C16) by the minimum number of campers (cell C6).

c. Fill the range D18:G18 with the formula in cell C18. 

4. Takara suspects that the remaining divide by zero errors and the two negative values in the range E16:E18 are related to the zero value in cell E6. She wants to make sure that anyone entering the minimum number of campers enters a number greater than zero.
Add data validation to the range C6:G6 as follows:

a. Set a data validation rule for the range C6:G6 that allows only whole number values greater than 0.

b. Add an Input Message using Number of Campers as the Input Message Title and the following text as the Input message:
Enter the minimum number of campers for this session. 

c. Add an Error Alert using the Stop style, Campers Error as the Error Alert Title, and the following text as the Error message:
The minimum number of campers must be greater than 0. 

5. Identify the invalid data in the worksheet and correct the entry as follows:

a. Circle the invalid data in the worksheet.

b. Type 10 as the minimum number of campers for the lacrosse sessions (cell E6).

c. Verify that this change corrected the remaining divide by zero errors and resulted in positive values in the range E16:E18.

6. Go to the Private Lessons worksheet. This worksheet analyzes financial data for private and semi-private lessons, which the camp runs throughout the day. Takara has already created a scenario named Current Campers that calculates profit based on the current number of campers enrolled for each session. She also wants to calculate profit based on the maximum number of campers.
Add a new scenario to compare the profit with maximum enrollments as follows:

a. Use Max Campers as the scenario name.

b. Use the enrolled campers per day data (range C9:G9) as the changing cells.

c. Enter cell values for the Max Campers scenario as shown in bold in Table 1, which are the same values as in the range C8:G8.

Table 1: Cell Values for the Max Campers Scenario

Cell

Value

Baseball_Campers (cell C9)

10

Basketball_Campers (cell D9)

12

Lacrosse_Campers (cell E9)

10

Soccer_Campers (cell F9)

12

Volleyball_Campers (cell G9)

15

7. Takara also wants to calculate profit based on the minimum number of campers.
Add another new scenario to compare the profit with low session enrollment as follows: 

a. Add a scenario to the worksheet using Min Campers as the scenario name.

b. Use the enrolled campers per day data (range C9:G9) as the changing cells.

c. Enter cell values for the Min Campers scenario as shown in bold in Table 2.

Table 2: Cell Values for the Min Campers Scenario

Cell

Value

Baseball_Campers (cell C9)

8

Basketball_Campers (cell D9)

8

Lacrosse_Campers (cell E9)

7

Soccer_Campers (cell F9)

8

Volleyball_Campers (cell G9)

7

8. Show the Min Campers scenario values in the Private Lessons worksheet.

9. Go to the Revised Fees worksheet. Takara is considering whether to change the coaching fees for the private lessons. She has created three scenarios on the Revised Fees worksheet showing the profit with a $5 or $10 increase or a $5 decrease to the coaching fees.
Compare the average profit per session based on the scenarios as follows:

a. Create a Scenario Summary report using the average profit per session (range C11:G11) as the result cells to show how the average profit changes depending on the coaching fee changes. 

b. Use Revised Fees Scenario Report as the name of the worksheet containing the report.

10. Takara also wants to focus on one or two types of private lessons at a time when comparing the average profit per session. Return to the Revised Fees worksheet and create another type of report as follows:

a. Create a Scenario PivotTable report using the average profit per session (range C11:G11) as the result cells to compare the average profit depending on the fee changes in a PivotTable.

b. Use Revised Fees PivotTable as the name of the worksheet containing the PivotTable.

c. Format cells B4:F6 in the Revised Fees PivotTable worksheet using the Accounting number format with 0 decimal places and $ as the symbol.

11. Go to the Games worksheet. Takara wants to determine the number of games the camp can hold on Fridays and Saturdays to make the highest weekly profit without interfering with practices, which are also scheduled for Fridays and Saturdays and use the same resources.
Use Solver to find this information as follows:

a. Use the total weekly profit (cell H17, named Total_Weekly_Profit) as the objective cell in the Solver model, with the goal of determining the maximum value for that cell.

b. Use the number of Friday and Saturday games for the five sports (range C5:G6) as the changing variable cells.

c. Determine and enter the constraints based on the information provided in Table 3.

d. Use Simplex LP as the solving method to find a global optimal solution.

e. Save the Solver model in cell B27.

f. Solve the model, keeping the Solver solution.

Table 3: Solver Constraints

Constraint

Cell or Range

Each game is scheduled at least once on   Friday and once on Saturday

C5:G6

Each Friday and Saturday game value is   an integer

C5:G6

Each sport is scheduled for a game 1   time per week or more

C7:G7

Each sport is scheduled for a game 3   times per week or less

C7:G7

The total number of Friday games is 10   or less

Total_Friday_Games (H5)

The total number of Saturday games is   15 or less

Total_Saturday_Games (H6)

The total number of games per week is   13

Total_Weekly_Games (H7)

The total number of Friday practices is   2 or less 

Friday_Practices (E21)

The total number of Saturday practices   is 2 or less

Saturday_Practices (E22)

The total number of practices per week   is 5 or less

Total_Practices (E23)

12. Takara wants to document the answer Solver found, including the constraints and a list of the values Solver changed to solve the problem. Produce an Answer report for the Solver model as follows:

a. Solve the model again, this time choosing to produce an Answer report.

b. Use Games Answer Report as the name of the worksheet containing the Answer report.

Your workbook should look like the Final Figures on the following pages. Save your changes, close the workbook, and then 

Lists five tools that can be used by security administrators, network administrators, and attackers alike. 

Search the Web for three to five other tools that fit this description. 

Using a Web browser and the names of the tools you found, find a site that claims to be dedicated to supporting hackers. 

Do you find any references to other hacker tools? 

If you do, create a list of the tools along with a short description of what the tools do and how the tools work.

Whats  the similarities and differences between viruses and worms.

 After doing so, you need to perform some internet research on actual real world examples where organizations in any sector (retail, banking, healthcare, etc.) were impacted by either viruses or worms and what they did to defend against them. 

In addition, you need to explain what repercussion(s) the organization experienced, in terms of, publicity, financial impact, customer dealings and investments made to better protect all those impacted.  

Exp22_Excel_Ch10_CumulativeAssessment – Movie Rentals

Exp22_Excel_Ch10_CumulativeAssessment – Movie Rentals

Excel Chapter 10 Cumulative Assessment – Movie Rentals

Project Description:

You are the systems manager for Blue City Movies Rentals and you have been asked to create a report on historical sales data. To complete your task you will combine and edit data from multiple sources using Excel’s Power add-ins, XML, and text functions.

Start Excel. Download and open   the file named Exp22_Excel_Ch10_CumulativeAssessment-MovieRentals.xlsx.   Grader has automatically added your last name to the beginning of the   filename.

Use Get & Transform (Power   Query) to load the file e10c2Movies.txt   to the existing worksheet starting in cell A1. After loading the information   to the worksheet, add it to the data model. 

Rename the worksheet Movies.

Use Get & Transform (Power   Query) to load the Account table from the xml file e10c2Contacts.xml into a new worksheet. Be sure to add the   information to the data model.

Rename the worksheet Contacts.

Use Get & Transform (Power   Query) to load the Rates table from the file e10c2Rates.xlsx into a new worksheet. Be sure to add the   information to the data model. 

Rename the worksheet Rates.

Use Get & Transform (Power   Query) to load the StoreInfo table located in the database e10c2Transactions.accdb into a new   worksheet. Be sure to add the information to the data model.  

Rename the worksheet StoreInfo. 

Use Get & Transform (Power   Query) to load the Transactions table located in the database e10c2Transactions.accdb in the Power   Query Editor. Use the Power Query Editor to change the format of the Date   column from Date and Time to Date. Load the edited data to a new worksheet,   making sure to add the information to the data model.

Rename the worksheet Transactions.

Create a relationship between   the Account table Account field and Transactions table Account field. 

Create a relationship between   the StoreInfo table Store# and the Transactions table Store#.

Use PowerPivot to create a   PivotTable and clustered column PivotChart Horizontal on a new worksheet.   Name the worksheet TotalEarnings. Use the Transactions table Date field in the   Filters area, Account table Type field and Last field in the Rows area, and   Transactions table Total field in the Values area. 

Add the chart title Total   Earnings.

Use 3D Map (Power Maps) to   create a geographical visualization of sales data by store. Use the StoreInfo   Zip as the location dimension and the Transactions Total as the height   dimension. Zoom in as needed to view results.

Save and close Exp22_Excel_Ch10_CumulativeAssessment-MovieRentals.xlsx.   Exit Excel. Submit the file as directed.

Complete  a review of the attached article by writing a 2-3 page overview of the  article. This will be a detailed summary of the journal article,  including concepts discussed and Applications in Health Care. Additionally, find one other  source (2nd – Health_Care.pdf) that substantiates the findings in the article you are reviewing.   Once you find the article, you will read it and write a review of it.  This is considered a research article review. Your paper should meet these requirements:  

• Be approximately 5 pages in length, not including the required cover page and reference page.
• Follow APA 7 guidelines. Your paper should include an introduction, a body with fully developed content, and a conclusion.
• Support  your answers with the readings from the course and at least two  scholarly journal articles to support your positions, claims, and  observations, in addition to your textbook. 

1. Please share your thoughts about Wireshark. (Short Answer)

2. Please explain about Wireshark and explain how to use It? (Detailed)

Contractor Calculator

This week’s journal articles focus on empowering leadership and effective collaboration in geographically dispersed teams, please answer the following questions:

1. How do geographically dispersed teams collaborate effectively?
2. Please find at least three tools on the market that teams can use to collaborate on a geographically dispersed team.  Please note the pros and cons of each tool. 
3. Based on the research above, note which tool you would select if you were managing the geographically dispersed team and why.

Be sure to use the UC Library for scholarly research. Google Scholar is also a great source for research.  Please be sure that journal articles are peer-reviewed and are published within the last five years.The paper should meet the following requirements:

• 3-5 pages in length (not including title page or references)
• APA guidelines must be followed.  The paper must include a cover page, an introduction, a body with fully developed content, and a conclusion.
• A minimum of five peer-reviewed journal articles.

The writing should be clear and concise.  Headings should be used to transition thoughts.  Don’t forget that the grade also includes the quality of writing.

How does allowing all session cookies in your browser strike the right balance between meeting security needs and providing adequate Web access?

Read classmates post and respond with 100 words: