BIAM 500 Week 1 Lab

Week 1 Lab Rubric-500
Criteria	Ratings	Pts
This criterion is linked to a Learning OutcomeStep 1 – Importing, Cleaning, and Converting Data Sales data sheet contains data imported from the text file, professionally formatted, with added columns OrderTotal, FullName, and OrderCategory. Any spelling errors are corrected and duplicate records, or records with missing data, are removed.		10.0 pts
This criterion is linked to a Learning OutcomeStep 2 – Table Analysis Mountain-500 U.S. Orders and Touring-3000 Australia Orders sheets contain records filtered as indicated. Sales by Product Category and Sales by Country sheets contain appropriate subtotals and pie charts.		15.0 pts
This criterion is linked to a Learning OutcomeStep 3 – Pivot Tables Sales Pivot by Product Country sheet contains a pivot table and pivot chart as described in instructions. A second pivot sheet contains a pivot table and pivot chart using different fields selected by the student.		15.0 pts
This criterion is linked to a Learning OutcomeStep 4 – /What If Analysis Mountain-200 What If sheet contains baseline model, two one-variable data tables, and two two-variable data tables. Scenario Summary sheet contains a scenario summary report as described in instructions.		15.0 pts
This criterion is linked to a Learning OutcomeStep 5 – Opinion Paper Provide at least two findings and recommendations.		15.0 pts
Total Points: 70.0