Teacher Gradebook (Excel)

Grades that add themselves up.

Type the scores. The gradebook works out weighted category averages, letter grades, and missing work for every student, and shows who needs support. No macros.

WHAT IT DOES

• 40 students and 40 assignments

• Up to 6 weighted categories, with a check that they add up to 100%

• Weighted overall grade and letter grade on your own scale

• Missing work flagged in pink and counted for each student

• Excused assignments with EX

• Class average, highest score, and missing count for every assignment

• Dashboard: class average, grade spread, students who need support, hardest assignments

• Assignments list with category, due date, and points

• Use one copy per class

WHO IT'S FOR

Middle and high school teachers, tutors, coaches, and homeschool families.

GOOD TO KNOW

• Works in Microsoft Excel: Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac

• Normal .xlsx file: no macros to enable

• One-off payment, instant download

Made by Lee at Sheet Leveller, whose tutorials have been watched 6.3 million times on YouTube.