Letter grades with an approximate-match lookup
This lesson is part of the course
In this lesson
You convert the final percentages into letter grades and grade points with VLOOKUP and XLOOKUP, then count the B range and find the class GPA.
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