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 

  GO19_AC_CH03_GRADER_3F_HW – Degrees and Students 1.0

Project Description:

In this project, you will use a database to track degrees and grade point averages for honor students in the health professions program in preparation for graduation. You will create reports, modify a report in Layout view and Design view, group data in a report, and keep grouped data together for a printed report.

Start Access. Open the file Students_Access_3F_Degrees.accdb   downloaded with this project, and then enable the content. View the   relationship between the 3F Degrees   table and the 3F Students table. One   type of degree can be awarded to many students. Close the Relationships   window.

Use the Report tool to create a   report based on the 3F Summa Cum Laude Graduates Query object.

With the report displayed in Layout   view, apply the Facet theme to only the report. Delete the Student ID field   from the report. Change the width of the Last Name, First Name, and Degree   text box controls to 1.25   inches.

With the report displayed in Layout   view, sort the records in ascending order by the Last Name field. Change the   width of the Program text box controls to 2.5   inches.

At the bottom of the report and in   Layout view, change the height of the calculated control that displays 8 to 0.25 inch.   For the page number control, set the Left property to 5 inches.

With   the report displayed in Layout view, select the title of the report and   change the font size to 14. In the title, change the word Query to Report.   In the body of the report, for the GPA field name, set the Left property to 0.25 inch (the GPA text box controls move   to the right, and all of the other fields also move to the right). Save the   report as 3F Summa Cum Laude   Graduates Report, close the Property Sheet, and then   close the report.

Use   the Report Wizard to create a report based on the 3F GPAs by Degree Program   Query object. Add the following fields (in this order) to the report:   Program, GPA, Last Name, and First Name. View the data by 3F Degrees, and do   not add any other grouping to the report.

Sort   the records first in descending order by the GPA field and then in ascending   order by the Last Name field. Summarize the report by averaging the GPA   field.

Be   sure the layout is Stepped and the orientation is Portrait. Name the report 3F GPAs by Program   Report,   and then finish the wizard.

Display   the 3F GPAs by Program Report in Layout view. Apply the Wisp theme to this   report only. Select the title of the report, change the font size to 16, and   then apply bold.

With   the 3F GPAs by Program Report displayed in Layout view, delete the controls   that begin with Summary for ‘Program’. Change the width of the Program text   box controls to 2.75   inches.

With   the 3F GPAs by Program Report displayed in Layout view, change the text in   the label control that displays Avg   to Average GPA by Program. At the top of the report, apply bold   formatting to the four label controls that display the field names.

With   the 3F GPAs by Program Report displayed in Layout view, select the GPA label   control, the GPA text box controls, and the calculated controls for the   average GPA. Change the width of the selected controls to 1 inch, and set the Left property to 3 inches. Close the Property Sheet.

Display   the 3F GPAs by Program Report in Design view. Select the following two   controls: the Program text box control (in the Program Header section) and   the Average GPA by Program label control (in the Program Footer section).   Align the right edges of the two selected controls. Save the report.

Display   the 3F GPAs by Program Report in Print Preview as two pages, and notice how   the groupings break across the pages. Display the report in Layout view, and   then open the Group, Sort, and Total pane. Set the grouping option so that each   group of program records is kept together on one page when the report is   printed, and then close the Group, Sort, and Total pane. Display the report   in Print Preview, and notice that the groupings are not split between pages.   Save the report, and then close the report.

If   necessary, close all database objects and open the Navigation Pane. Save and   close the database, and then submit for grading.

 Write about the Joseph Schumpeter’s concept of creative Destruction For example, many think that the introduction of self-driving cars will disrupt the job market for drivers.  

please check the file 

Excel Chapter 1 Mid-Level 2 – Real Estate Sales Report 

Exp22_Excel_Ch01_ML2_Sales

Exp22 Excel Ch01 ML2 Sales

Project Description:

You own a small real estate company in Indianapolis. You track the real estate properties you list for clients. You want to analyze sales for selected properties. Yesterday, you prepared a workbook with a worksheet for recent sales data and another worksheet listing several properties you listed. You want to calculate the number of days that the houses were on the market and their sales percentage of the list price. In one situation, the house was involved in a bidding war between two families that really wanted the house. Therefore, the sale price exceeded the list price.

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

The owners of the house on 640 North Oak Drive took their house   off the market. You want to delete that row since it did not sell.
 

  In the April worksheet, delete row 10, which has incomplete sales data.

The listings are organized by   date listed. The 973 East Mulberry Lane   listing needs to be moved up in the list.
 

  Select and cut row 13 and insert cut cells on row 10.

You want to assign a property ID   to each listing. The code will have the year 2024 with a sequential number.
 

  Type 2024-001 in cell A5 and use Auto Fill to   complete the series to assign a property ID to each property in the range   A6:A13.

Real estate agents study the   number of days houses are on the market. In some cases, the longer a house is   on the market, it might indicate the asking price is too high.
 

  Enter a formula in cell C5 that calculates the number of days the first house   was on the market by subtracting the date listed from the date sold. Copy the   formula to the range C6:C13.

Monetary values look better when   they are formatted to display the dollar signs. Because all monetary values   are whole numbers, you will decrease the decimal points to avoid columns   where all the data ends in .00.
 

  Format the list prices and sold prices in the range F5:G13 with Accounting   Number Format with zero decimal places.

To analyze the real estate   market, it is helpful to calculate the selling prices as a percentage of the   list price. For example, the second house was listed for $500,250, but it   sold for only $400,125. Therefore, the sale percentage of the list price is   .7999 or 79.99%.
 

  Enter a formula in cell H5 that calculates the sales price percentage of the   list price for the first house by dividing the sold price by the list price.   Copy the formula to the range H6:H13.

The calculated percentages need   to be formatted with the percent symbol rather than displaying the values as   raw numbers.
 

  Format the values in the range H5:H13 with Percent Style with two decimal   places.

Currently, the labels on row 4   are hard to read. You will wrap the headings within each cell to improve   readability.
 

  Center horizontally and wrap the headings in the range A4:H4.

For better sequencing of   columns, you want to display the Days on Market column after the two columns   containing the dates.
 

  Insert a new column between the Date   Sold and List Price columns.   Move the Days on Market data to the   new blank column F by moving the range C4:C13 to F4:F13. Delete column C.

You notice the list contains a   wrong date and wrong list price that need to be corrected.
 

  Edit the date sold of the 41 Chestnut   Circle house to be 4/22/2024.

Increasing the height of the   rows of data and centering the data vertically between the top and bottom   cell margins will make it easier for the other agents to review the data.
 

  Select the property rows (rows 5:13), set a 25 row height, and apply Middle Align.

Displaying borders helps separate   the property listings.
 

  Apply the All Borders border style to the range A4:H13.

You want to improve the   alignment of number of days on market below the column label.
 

  Apply Align Right and increase the indent two times on the days on market formula   results in the range E5:E13.

You noticed some misspelled   words in the worksheet.
 

  Use Excel to check the spelling and correct misspelled words.

You don’t need the data on the   Properties sheet but you do want to copy the April worksheet to create a   template for May.
 

  Delete the Properties sheet. Insert a new sheet named May. Make sure the May sheet is the   second sheet tab.

You want to copy the original   data to the new sheet so that you can modify the duplicated data.
 

  Use the Select All feature to select all data on the April worksheet and copy   it to the May worksheet. Use the paste option to Keep Source Column Widths.

After copying data from the   April worksheet to the May worksheet, you want to prepare the May worksheet   for data.
 

  In cell A2, change April to May. Select the ranges A5:D13 and   F5:G13 and clear cell contents but keep the formatting In cell F5, type 1. In cell G5, type 1. Copy the values to the range   F6:G13.

The property listings dataset is   small. To improve readability on the printed copy for the other real estate   agents, you will increase the scaling.
 

  Select both worksheets and apply 120% scaling.

You want to apply page setup   options to both sheets, so you need to group the sheets first.
 

  Select both worksheets. Select Landscape orientation. Center the page   horizontally and vertically between the margins.

With both worksheets still   selected, insert a footer with the text Exploring Series on the left side, the sheet   name code in the center, and the file name code on the right side.

Save and close Exp22_Excel_Ch01_ML2_Sales.xlsx. Exit   Excel. Submit the file as directed.

Case Study 2.1

Case Study:

You have just been hired to perform digital investigations and forensics analysis for a company. You find that no policies, processes, or procedures are currently in place. Conduct research to find information, and then create a policy and process document (3 to 4 pages in length) to provide the structure necessary for your lab environment. Be sure to cite your online sources and follow APA formatting.

Writing Requirements

• 3–4 pages in length  (excluding cover page, abstract, and reference list)
• At least two peer reviewed sources that are properly cited and referenced
• APA format, Use the APA template located in the Student Resource Center to complete the assignment.
• Please use the Case Study Guide as a reference point for writing your case study.

CASE: PepsiCo
“Take PepsiCo, for example. As one of the leading soft drink makers and bottlers, PepsiCo turned to IoT for the most basic of reasons and found an efficient solution. Like many enterprises, the company had inefficient and ineffective IT and OT infrastructure, as well as limited IT and OT resources available inside its plants. It also suffered from server sprawl, where each server supported a very small portion of the production load. PepsiCo essentially incurred high costs to purchase and support an ever-expanding infrastructure of underutilized servers, operating systems, and networking assets. The result: highly inefficient use of capital—at a minimum. Even worse, its inefficient network hindered the collection of data that would ordinarily drive plant productivity.”

What were the paybacks to PepsiCo after implementing IoT? Elaborate.

 Please a topic from the below list and create a one-page answering the question noted below.    

• Define the IT organizational structure and how the IT organizational structure impacts culture and change management practices.  Additionally, how does the organizational structure impact competitive advantage?
• How do you define operational excellence?  What factors are involved in achieving operational excellence?  Who (within an organization) is responsible for operational excellence and why is this important?

** Please note you have minimal space and time to complete the assignment, do not write an introduction, rather just answer the selected question noted above. This is a test of both knowledge and your ability to be succinct in messaging** 

Please choose a topic from the attachment

Propose and defend a topic for your final project.  Write  500 words or more explaining why this topic is important for your peers to understand. Be focused and specific. Look into the general topic provided in the list below to find something new and interesting to write about. You should do a deep dive into a topic. Do not do a survey. Make use of academic references such as you can find in the Danforth Library research databases  

Use at least five sources. Include at least 3 quotes from your sources enclosed in quotation marks and cited in-line by reference to your reference list.  Example: “words you copied” (citation) These quotes should be one full sentence not altered or paraphrased. Cite your sources. 

Write in essay format, not in bulleted, numbered, or another list format. 

The proposal must be in your own words and not written directly from the PowerPoint Presentations or papers that you completed with your group. You can include the network diagram. cost-benefit- analysis, and budget that you worked on with your group.Your paper will include a detailed proposal including the following: 

• Part I: Planning the Network
• Part II: Building the Network
• Part III: Securing and Maintaining the Network
• Include the diagram of the network and cost-benefit- analysis that you would recommend from Part II.
• Include the budget from Part III.

See the attached document for complete instructions and grading rubric. Submit your completed Project Management Networking Business Plan: Presentation to Stakeholders to the above submission link by 11:59 p.m. EST, Sunday of Unit 7.