Excel for Teachers: Gradebooks & Class Analytics
Build a weighted gradebook, drop the lowest score, assign letter grades, curve a test, track attendance and analyse your test questions, every cell checked instantly.
The first 2 lessons are free — no account needed.
Lessons
- A weighted gradebook with SUMPRODUCTFree
- Dropping the lowest scoreFree
- Letter grades with an approximate-match lookup Pro
- Class statistics: mean, median, spread & pass rate Pro
- Curving scores: bonus, scaling & z-scores Pro
- Attendance tracking & at-risk flags Pro
- Progress over terms: growth & rankings Pro
- Item analysis: difficulty & discrimination Pro