A weighted gradebook with SUMPRODUCT
This lesson is part of the course
In this lesson
You turn four category averages into a weighted final grade for all 20 students of Class 10B, then find the class average and how many students pass.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- A weighted gradebook with SUMPRODUCT Locked
- Dropping the lowest score Locked
- Letter grades with an approximate-match lookup Locked
- Class statistics: mean, median, spread & pass rate Locked
- Curving scores: bonus, scaling & z-scores Locked
- Attendance tracking & at-risk flags Locked
- Progress over terms: growth & rankings Locked
- Item analysis: difficulty & discrimination Locked