A simple gradebook, free.
Type each assignment and its points, then each student’s score. Totals, percentages and letter grades are worked out for you, with a class average for every assignment.
✓ 100% free ✓ Instant download ✓ Excel for Windows & Mac
| Student | HW 1 | Quiz 1 | HW 2 | Test 1 | % | Grade |
|---|---|---|---|---|---|---|
| Aiden Brooks | 8 | 17 | 8 | 91 | 89% | B |
| Amelia Chen | 9 | 20 | 7 | 75 | 79% | C |
| Ava Martinez | 7 | 16 | 8 | 87 | 85% | B |
| Grace Thompson | 9 | 17 | 8 | 86 | 87% | B |
Simple, and it does the maths
Percentages
Each student’s total and percentage, from the assignments graded so far.
Letter grades
A to F, colour-coded, on a standard scale.
Class average
The average for every assignment, so you can spot a tricky one.
Yours in under a minute
Click “Download it free”
You’ll go to a secure download page. There’s nothing to pay.
Enter your email
The download link is sent straight to your inbox, and you can download it straight away too.
Open it in Excel
Type your assignments, then your students’ scores.
Free version or full version
The free gradebook uses total points. The full Teacher Gradebook adds weighted categories, missing work and a dashboard.
| Free | Full version · $9.99 | |
|---|---|---|
| Percent and letter grade | ✓ | ✓ |
| Class average per assignment | ✓ | ✓ |
| Low scores in red | ✓ | ✓ |
| Students | 30 | 40 |
| Assignments | 10 | 40 |
| Weighted categories | – | ✓ |
| Missing work and EX | – | ✓ |
| Need support dashboard | – | ✓ |
Hi, I’m Lee
I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials. This free gradebook uses the SUM and LOOKUP formulas from my tutorials, ready to use today.
Questions
Is it really free?
Yes. You just enter your email address so the download link can be sent to you.
Will you email me?
Now and then, with new Excel templates and tips. You can unsubscribe at any time with one click.
Does it use macros?
No. It’s a normal .xlsx file, so there’s nothing to enable and no security warnings.
Which versions of Excel does it work with?
Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac.
Grade faster this term.
Download the free Simple Gradebook and let it do the maths.
Download it freeWant weighted categories and missing work? See the full Teacher Gradebook.