Excel for Teachers: Gradebooks & Class Analytics

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• 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.
• Drop each student's weakest quiz (and then the two weakest) with MIN, SMALL and LARGE, and turn the best five into a percentage.
• Convert the final percentages into letter grades and grade points with VLOOKUP and XLOOKUP, then count the B range and find the class GPA.
• Describe the results of the unit test with mean, median and standard deviation, then calculate the pass rate of the students who sat the test.
• Test 3 was too hard. You compare three ways to curve it: a flat bonus with a cap, scaling to the top score, and a z-score curve to a target mean and spread.
• Count present, absent and late days with COUNTIF, work out each student's attendance %, and flag students at risk with IF, OR and AND.
• Measure each student's growth from Term 1 to Term 3, rank the class by score and by improvement, and find the most improved student.
• Analyse a 10-question test: how hard each question was (p), whether it separates strong from weak students (D), and which questions need a second look.