Excel templates / Gradebook

Gradebook template with weighted grades

Weighted scores, letter grades from a grade table, class rank, and class averages, highs, lows and pass rate.

Download the gradebook template (.xlsx). Free, no sign-up. Works in Excel 2010 and later, Excel for Mac, Excel on the web, Google Sheets and LibreOffice.

How to use it

  1. Set how much each assessment counts in B4 to E4. They should add up to 100% (F4 checks).
  2. Type the students’ names and scores (out of 100) in the yellow cells. Leave a score empty if it isn’t in yet.
  3. Change the grade bands in J6 to K10 to match your school: each row is the lowest percentage for that grade, smallest first.

How it works

Learn the skills behind it

Functions used: SUMPRODUCT, VLOOKUP, RANK, AVERAGE, MAX, MIN, COUNTIF, COUNT, IF, SUM.

More free templates