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

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

Example from the “Grades” tab, with the numbers and formulas that are in the file.
StudentHomeworkQuizzesTestsProjectRunning gradeLetterRankStatus
Emma Johnson96.0%93.8%93.0%92.9%93.9%A4On track
Liam Carter86.0%78.5%84.0%82.9%83.0%B9On track
Olivia Bennett100.0%98.5%97.0%97.1%98.1%A1On track
Noah Williams75.0%69.2%73.0%71.4%72.4%C10On track
Ava Thompson90.0%86.2%87.0%85.7%87.4%B7On track
Ethan Brooks42.0%47.7%53.0%50.0%48.5%F14At risk
Sophia Martinez94.0%90.8%91.0%90.0%91.6%A5On 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.

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 sheetIn 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 · Ask for a demo

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

All templates · Free tools