ilab 6Day Care Center (50 Points each)
general instructions for this project can be found in the Week 6
Lecture material. The Week 6 Lecture describes the assignment and
provides an overview of the project as a whole. There are no
step-by-steps for the course project. The following are grading criteria
for this project.
Data imported from SalesData.csv text file located in Course Project Materials in DocSharing.Organize the Data
Analyze the Data
the data in at least three different ways. Each form of Data Analysis
should be provided on a separate, appropriately labeled worksheet. It is
expected that each sheet will be professionally formatted and clearly
documented with titles, comments, and explanation. Remove any extra
sheets so your workbook is as compact as possible when you turn it in.
Go back and review your labs for assistance in completing the different
types of analysis.
The following are some examples of analysis you might wish to do:
Present your Conclusions in a Memo
the integration techniques we worked on in the course to develop a Memo
(Word document) that includes data and graphs copied and pasted from
your spreadsheet. You will turn in both your Recommendation Memo and
your spreadsheet. (To help you formulate your report, there is a Word
document named “ExcelProjectMemoTemplate” located in DocSharing – Course
Project Materials. The yellow-lined information provides an explanation
of what should be included in each section of the Memo.)
Memo will focus one paragraph on each of the Data Analysis sheets in
your workbook. Explain the type of analysis you completed, the
conclusions you drew, and a recommendation based on the analysis. (45
You should include a final paragraph that explains three things you learned about using Excel for data analysis. (15 points)
Your email address will not be published. Required fields are marked *
Save my name, email, and website in this browser for the next time I comment.