# Gradebook Template Excel (Free, Weighted)

> A free Excel gradebook for one class: weighted categories, a running grade and letter grade per student, class stats and a printable progress report.

Source: https://softwiro.com/templates/gradebook
Language: English
Softwiro, softwiro.com

---

Free Excel template

# Gradebook Template for Excel (Weighted Categories, Letter Grades)

This is a gradebook you can use the day you download it. List your grade categories and their weights once, enter your assignments across the top and your students down the side, and type scores. The sheet works out each student's category percentages, running grade, letter grade, rank and missing work, then gives you class statistics and a one-page progress report for parent conferences. The sample class has 15 students and 12 assignments; clear it and type your own.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-gradebook.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-gradebook-blank.xlsx)

Excel file (.xlsx) · 44 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## 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

1. 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.
2. On Scores, list the assignments across the top: name, category (pick from the list), due date and points possible.
3. 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.
4. Open Grades to see each student's category percentages, running grade, letter, rank, missing items and status.
5. Open Class stats for the class average, letter-grade spread, category averages and the assignments students found hardest.
6. 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.

[Download the free sheet (with a worked example)](https://softwiro.com/downloads/templates/softwiro-gradebook.xlsx) [Blank copy, no example](https://softwiro.com/downloads/templates/softwiro-gradebook-blank.xlsx)

Excel file (.xlsx) · 44 KB · 7 tabs · works in Excel and Google Sheets · no sign-up

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

## 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. |

[See School Performance Management Platform](https://softwiro.com/systems/student-performance.html) · [Ask for a demo](https://softwiro.com/contact)

## When your work grows: a custom system instead of the sheet

A sheet is a great start. When more than one person works on your data, when it grows, or when you need alerts and reports of your own, we build you a custom system at competitive prices. This is what changes:

| In the sheet | In a custom system |
| --- | --- |
| Up to 40 students and 20 assignments per file | Any class size, with all classes and teachers in one system |
| Letter scale you edit by hand | School-wide grading policies applied automatically |
| Printed progress report | Reports sent to parents on a schedule |
| One file per class | One dashboard across classes, subjects and terms |
| Manual flags for missing work | Alerts for teachers and parents when work is missing |

### Extra features in the app

- Every teacher's grades in one place for the whole school, instead of one file per class.
- Attendance, grades and teacher notes together for each student.
- Parents see progress and reports in an app, not on a printout.
- Early warnings when a student's grades or attendance start to drop.
- Term-to-term comparison for classes and students.
- Exam results tracking with school-wide reports.

[Ask for your custom system](https://softwiro.com/contact)

## 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](https://softwiro.com/templates/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](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](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](https://softwiro.com/templates/for-teachers)

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

[All templates](https://softwiro.com/templates) · [Free tools](https://softwiro.com/tools)
