Wee 7 Data Analysis
Course Project: Excel Project
Objectives | Guidelines | Grading Rubrics
| | |
|Objective | |
The 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.
| | |
|Guidelines | |
Organize the Data • Data imported from SalesData.csv text file located in Course Project Materials in DocSharing. • Professional formatting follows the formatting guidelines we studied during the first week of class. • Documentation sheet added to provide author, purpose, and date and provide information about each of the sheets you will create as you analyze the data. • At least one calculated field added and copied to all cells in the worksheet.
Analyze the Data
Analyze 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: • Sort by discount level. Have discounts increased sales volumes? Is there any
Objectives | Guidelines | Grading Rubrics
| | |
|Objective | |
The 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.
| | |
|Guidelines | |
Organize the Data • Data imported from SalesData.csv text file located in Course Project Materials in DocSharing. • Professional formatting follows the formatting guidelines we studied during the first week of class. • Documentation sheet added to provide author, purpose, and date and provide information about each of the sheets you will create as you analyze the data. • At least one calculated field added and copied to all cells in the worksheet.
Analyze the Data
Analyze 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: • Sort by discount level. Have discounts increased sales volumes? Is there any