Dropping the lowest score
This lesson is part of the course
In this lesson
You drop each student's weakest quiz (and then the two weakest) with MIN, SMALL and LARGE, and turn the best five into a percentage.
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