Try the sheet here, on the example
The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.
Example from the sheet
| Student | Homework | Quizzes | Tests | Project | Running grade | Letter | Rank | Status |
|---|---|---|---|---|---|---|---|---|
| Emma Johnson | 96.0% | 93.8% | 93.0% | 92.9% | 93.9% | A | 4 | On track |
| Liam Carter | 86.0% | 78.5% | 84.0% | 82.9% | 83.0% | B | 9 | On track |
| Olivia Bennett | 100.0% | 98.5% | 97.0% | 97.1% | 98.1% | A | 1 | On track |
| Noah Williams | 75.0% | 69.2% | 73.0% | 71.4% | 72.4% | C | 10 | On track |
| Ava Thompson | 90.0% | 86.2% | 87.0% | 85.7% | 87.4% | B | 7 | On track |
| Ethan Brooks | 42.0% | 47.7% | 53.0% | 50.0% | 48.5% | F | 14 | At risk |
| Sophia Martinez | 94.0% | 90.8% | 91.0% | 90.0% | 91.6% | A | 5 | On track |
Example from the “Grades” tab, with the numbers and formulas that are in the file.
What is inside
- Setup: School, class, subject and term, the 'as of' date, the passing mark, up to 6 weighted grade categories and an editable letter scale with GPA points.
- Scores: Assignments across the top (name, category, due date, points possible), students down the side. Type X for excused work; empty cells that are already due turn yellow.
- Grades: Category percentage, running grade, letter, GPA points, rank, missing items and a status (On track, Watch, At risk) for every student.
- Class stats: Class average, range, pass rate, students at risk, letter-grade spread, category averages, average % per assignment and the hardest assignment, with 3 charts.
- Student report: Pick a student ID and print a page with their grade, rank, each category and every assignment score, plus space for comments and a signature.
The file opens on a start tab (“Start here”) that explains how to use it.
What makes it different
Most free gradebooks stop at a total. This one handles the things teachers actually run into: categories that have no scores yet do not drag the running grade down, excused work is left out of the maths, and work that is due but not entered is flagged instead of silently ignored. The letter scale and the passing mark are cells you edit, not formulas you have to rewrite.
How does a weighted gradebook calculate the final grade?
Inside each category the sheet adds up the points a student earned and divides by the points possible for the work that has a score, so a 50-point test counts for more than a 10-point quiz. That gives a percentage per category.
The category percentages are then combined using your weights. In the sample class the weights are Homework 20, Quizzes 20, Tests 30, Project 10 and Final exam 20. Ethan Brooks, for example, has a running grade of 48.5%. The final exam has no scores yet, so only the first 80 points of weight are counted and the result is scaled back to a percentage.
How do I handle missing and excused assignments in an Excel gradebook?
Decide for each item. Leave a cell empty if the work has not been handed in yet, type 0 if it counts as a zero, and type X if the student is excused. Empty and X cells are left out of the running grade; a 0 is counted.
Work that was due on or before the 'as of' date on Setup and still has no score is highlighted yellow and counted in the 'Missing items' column. In the sample, Logan Murphy has 4 missing items and Ethan Brooks has 1, which is why Logan is flagged on the Grades sheet.
Can I change the letter grades and the grading scale?
Yes. On Setup, the scale lists a minimum percentage, a letter and GPA points per row. The sample uses A 90, B 80, C 70, D 60 and F 0. Add plus and minus grades such as B+ or A- by filling the spare rows, or change the cut-offs to match your school. Rows can be in any order.
The passing mark is a separate setting (60% in the sample), so the At risk flag and the class pass rate follow your own rules. Check your school or district policy for how grades must be calculated and reported.
How to use it
- On Setup, type your school, class, subject and term, then list the grade categories (Homework, Tests...) with their weights. Edit the letter scale if your school uses different cut-offs.
- On Scores, list the assignments across the top: name, category (pick from the list), due date and points possible.
- Type each student's ID and name down the left side, then their points for each assignment. Type X for an excused assignment; leave a cell empty if it has not been handed in yet.
- Open Grades to see each student's category percentages, running grade, letter, rank, missing items and status.
- Open Class stats for the class average, letter-grade spread, category averages and the assignments students found hardest.
- On Student report, pick a student ID from the list and print the page for a parent meeting or conference.
Before you start:
- Capacity: 40 students, 20 assignments and 6 grade categories. Unused columns and rows stay blank.
- The running grade only counts categories that already have at least one score, so a category with no scores yet (for example the final exam) does not pull the grade down. Weights are re-balanced automatically.
- Inside a category, every point counts equally: a 50-point test is worth more than a 10-point quiz. Categories are then combined with the weights you set.
- Yellow cells on Scores are work that was due on or before the "as of" date on Setup and has no score yet. Type 0 if it counts as zero, or X if the student is excused.
- Give every student a different ID: the Student report looks the student up by it.
Still running this on Excel?
This sheet holds the numbers of one class, typed in by one teacher. In the School Performance Management Platform, each student's grades, attendance and teacher notes come together, and reports reach parents.
| In this sheet | In School Performance Management Platform |
|---|---|
| Every teacher has a sheet, and the administration collects the files. | One dashboard for students, teachers and classes, with exam results tracking and a comparison of performance across terms. |
| A student's decline shows up in the end-of-term result. | AI analyzes the student's grades, attendance and teacher notes, warns early about a possible decline, and suggests a development plan that the teacher decides on. |
| The parent learns about the problem late. | Regular reports to parents on the student's level, teacher notes and the attendance record, plus direct contact with the school through the app. |
| Attendance lives in a notebook or a sheet per class. | Attendance, absence and lateness are recorded for each student and turned into attendance reports and rates that the administration follows for each class. |
Frequently asked questions
Is this gradebook template free for classroom use?
Yes. It is free to download, change and share. It is a normal Excel file, so it also opens in Google Sheets and LibreOffice.
How many students and assignments does it hold?
40 students, 20 assignments and 6 grade categories per file. Save a new copy of the file for each class or term.
What if my category weights do not add up to 100?
Setup shows the total and warns you when it is not 100. The running grade still works, because it divides by the weights that are in use.
Can I use points-based grading instead of weights?
Yes. Put all assignments in one category with a weight of 100. Every point then counts equally.
How do I give parents a printout?
Open Student report, choose the student's ID from the list and print. It shows the grade, rank, each category and every assignment score. See also parent communication log for keeping track of contacts.
Is the template free?
Yes, with no sign-up and no email address. Use it, edit it and share it as you like.
Does it work in Google Sheets and on mobile?
The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.
What is the difference between the white and the gray cells?
You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.
Can I use the sheet from an AI assistant?
Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html
All the templates in this group: Excel templates for teachers: gradebook, lesson planning and follow-up
More free templates for: Schools and students
More free templates
- Student attendance sheet
- Study planner and lesson tracker
- Weekly study routine sheet
- Nursery and school fees tracker (Excel)
- Tutoring center manager (Excel)
- School class timetable (Excel)
- Exam schedule with committees and invigilators (Excel)
- Homework and behavior tracker for teachers (Excel)
- School bus subscriptions tracker (Excel)
- University applications tracker (Excel)
- Complete nursery management sheet
- Private school management sheet
- Lending library management sheet
- Graduation project manager sheet: tasks, team, phases and deliverables
- Cash Book Template for Excel
- Invoice Template with Invoice Log (Excel)
- Garment style costing sheet
- Production tracking sheet by stage
- Piece-rate payroll and worker efficiency sheet
- Production tracking sheet for home textiles factories
- Fabric requirements and marker sheet
- Clothing shop inventory sheet by colour and size