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.
✓ One-off payment ✓ Instant download ✓ Excel for Windows & Mac
| Student | Overall | Grade | Missing | HW 1 | Quiz 1 | HW 2 | Test 1 | HW 4 |
|---|---|---|---|---|---|---|---|---|
| Amelia Chen | 90.1% | A | – | 10 | 16 | 10 | 91 | 9 |
| Benjamin Scott | 85.0% | B | – | 9 | 14 | 7 | 88 | 10 |
| Chloe Patel | 78.6% | C | – | 9 | 17 | 9 | 72 | 8 |
| Aiden Brooks | 67.9% | D | – | 7 | 15 | 8 | 64 | EX |
| Caleb Nguyen | 55.8% | F | 3 | 7 | 11 | 6 | 55 |
Grading shouldn’t take longer than teaching
Weighted grades by hand
Tests 40%, homework 20%… working it out for 30 students takes hours.
Missing work slips through
It’s easy to miss that a student hasn’t handed in three assignments.
Spotting who’s struggling
By the time report cards come round, it’s too late to help.
Set it up once. Type scores as you go.
Set your weights
Your categories, like homework, quizzes, tests and projects, and what each is worth.
Add assignments
The name, category, due date and points. Each becomes a column in the gradebook.
Type the scores
Weighted grades, letter grades and missing work are worked out for every student.
Weights done for you
Set up to 6 categories and their weights. Each student’s category averages and weighted overall grade are worked out from the assignments that have been graded, and turned into a letter grade on your scale.
- Up to 6 categories
- A check that the weights add up to 100%
- Your own grade scale
| Category | Weight | Class avg |
|---|---|---|
| Homework | 20% | 83% |
| Quizzes | 20% | 83% |
| Tests | 40% | 82% |
| Projects | 20% | 84% |
| Total | 100% ✓ |
See missing work at a glance
Anything past its due date without a score turns pink, and each student’s missing count is added up. Type EX to excuse an assignment and it doesn’t count at all.
- Missing work turns pink
- Excused assignments (EX)
- Low scores in red
| Student | Overall | Grade | Missing | HW 1 | Quiz 1 | HW 2 | Test 1 | HW 4 |
|---|---|---|---|---|---|---|---|---|
| Amelia Chen | 90.1% | A | – | 10 | 16 | 10 | 91 | 9 |
| Benjamin Scott | 85.0% | B | – | 9 | 14 | 7 | 88 | 10 |
| Chloe Patel | 78.6% | C | – | 9 | 17 | 9 | 72 | 8 |
| Aiden Brooks | 67.9% | D | – | 7 | 15 | 8 | 64 | EX |
| Caleb Nguyen | 55.8% | F | 3 | 7 | 11 | 6 | 55 |
Know who needs support
The dashboard shows the class average, the grade spread, and a list of students below 70% or with 3 or more missing assignments, plus the hardest assignments so you can reteach.
- Need support list
- Grade spread chart
- Hardest assignments
| Need support | Overall | Missing |
|---|---|---|
| Caleb Nguyen | 56% | 3 |
| Noah Walker | 66% | 2 |
| Aiden Brooks | 68% | – |
| Olivia Young | 69% | – |
For anyone who grades
Middle & high school teachers
Weighted categories, missing work and letter grades for every class.
Tutors & coaches
Track progress for a group of students across the term.
Homeschool families
Keep a proper gradebook with weighted subjects and a grade scale.
Everything you get
- 40 students and 40 assignments
- Up to 6 weighted categories
- Weighted overall grade and letter grade
- Your own grade scale (A–F, or A+ to F)
- Missing work flagged in pink and counted
- Excused assignments with EX
- Class average, highest and missing for every assignment
- Dashboard: grade spread, need support, hardest assignments
- Use one copy per class
One-off payment. Yours to keep.
Get instant access $9.99Secure checkout by Payhip · Card or PayPal
Download link emailed straight away
Hi, I’m Lee
I run Sheet Leveller on YouTube, where I make quick, no-nonsense Excel tutorials.
This gradebook is built on the SUMPRODUCT and LOOKUP formulas from my tutorials, so weighted grades work themselves out.
Questions
How are weights worked out?
Each category’s average is its total points scored divided by total points possible. The overall grade weights those averages, counting only categories with something graded.
Can I use points instead of weights?
Yes. Put everything in one category at 100% and it becomes a total-points gradebook.
What about more than 40 students?
Use one copy per class. Most teachers keep one file per class and period.
Does it work in Google Sheets?
It’s built for Excel. It opens in Google Sheets, but some colours and features may not work the same.
Does it use macros?
No. It’s a normal .xlsx file, so there are no security warnings and nothing to enable.
Which versions of Excel does it work with?
Microsoft 365, Excel 2010 or later on Windows, and Excel for Mac. It’s built for Microsoft Excel.
Is this a subscription?
No. You pay once and the file is yours to keep.
Spend less time on grades.
Weighted grades, missing work and who needs support, all worked out for you.
Get the gradebook $9.99Not ready yet? Try the free Simple Gradebook.