Grading Rubric: Bean & Bloom Roastery — Sales Dashboard

6 graded items  |  100 points total

Graded Items

#TypeSheet / dashboardPts ChartShelvesFiltersCaption
1WorksheetRoast Level Batch Count12barcolumns: CNT(roastBatchId) · rows: roastLevelmin 100 chars
2WorksheetMonthly Roast Volume Over Time13linecolumns: MONTH(roastDate) · rows: SUM(roastedWeightKg)roastLevelmin 100 chars
3WorksheetWeight Loss by Roast Level and Duration18scattercolumns: AVG(roastDurationMin) · rows: AVG(Weight Loss %)min 100 chars
4WorksheetGreen Bean Roast Efficiency Heatmap20highlight_tablecolumns: roastLevel · rows: YEAR(roastDate)roastDate (context filter: >= 2021-01-01)min 100 chars
5WorksheetDual Axis: Green vs Roasted Weight by Batch22barcolumns: roastLevel · rows: AVG(greenWeightKg), AVG(roastedWeightKg)min 100 chars
1Dashboard15dashboardRoast Level Batch Count, Monthly Roast Volume Over Time, Green Bean Roast Efficiency Heatmap, Dual Axis: Green vs Roasted Weight by BatchFilter Action: clicking Roast Level Batch Count bars filters all other sheets by roastLevel

Worksheet names must match exactly — the grader locates each view by name. Captions are checked for the stated minimum length.