📐Class Analytics
Statistical analysis of class performance — mean, median, mode, standard deviation, score distribution, and grade ranges.
Why Teachers Need It
Knowing the class average isn't enough. Analytics show you the distribution — is everyone clustered around the mean, or are there two groups? This helps you decide whether to reteach or move on.
Key Benefits
- Mean, Median, and Mode computed automatically
- Standard Deviation shows how spread out scores are
- Grade Range distribution (90-100, 80-89, 75-79, below 75) shows performance bands
- Passing Rate calculated automatically
How It Works
- 1All statistics reference the Final Grade column in the Gradebook.
- 2Mean = AVERAGE of all final grades.
- 3Median = MEDIAN of all final grades.
- 4Mode = MODE of all final grades.
- 5Grade ranges use COUNTIF to count how many students fall in each band.
Example Workflow
“After midterm exams, you check Class Analytics. Mean is 82, but the standard deviation is 12 — meaning scores are widely spread. The grade distribution shows 10 students at 90+ but 6 students below 75. You plan remedial sessions for the lower group while continuing with the main class.”
Pro Tips for Teachers
- •Use analytics after each major assessment to inform your teaching
- •A high standard deviation means you may need differentiated instruction
Frequently Asked Questions
Do I need to enter any data here?
No. Every statistic is a formula. The sheet updates automatically from the Gradebook.
Related Navigation
Explore the full parent spreadsheet system or browse other teaching resources and interactive tools.