📊Dashboard
An executive overview that automatically aggregates key metrics from every other sheet — total students, active count, class average, passing rate, and at-risk count.
Why Teachers Need It
Teachers need a single place to see the health of their class at a glance without flipping through 13 sheets. The Dashboard pulls data automatically so you always know where things stand.
Key Benefits
- See total students, active students, and at-risk count in one view
- Class average and passing rate update automatically as you enter grades
- Attendance overview shows patterns without manual counting
How It Works
- 1The Dashboard sheet contains formulas that reference the Student Masterlist, Gradebook, Attendance Tracker, and At-Risk Students sheets.
- 2Every metric cell is a formula — you never type anything on the Dashboard.
- 3Metrics refresh instantly when you update data on any connected sheet.
Example Workflow
“After entering quiz scores in the Gradebook, you switch to the Dashboard and immediately see the class average has shifted from 78 to 82. The passing rate increased from 60% to 70%. No manual recalculation needed.”
Pro Tips for Teachers
- •Check the Dashboard at the start of each week to see what needs attention
- •Use the at-risk count to prioritize which students to follow up with first
Frequently Asked Questions
Do I need to update the Dashboard manually?
No. Every cell on the Dashboard is a formula. It updates automatically when you change data on other sheets.
Can I add my own metrics to the Dashboard?
Yes. You can add rows and write your own formulas referencing other sheets. Just be careful not to overwrite existing formulas.
Related Navigation
Explore the full parent spreadsheet system or browse other teaching resources and interactive tools.