Gradebook template
A gradebook in Excel: students down the side, assignments across with points possible, weighted categories, a percentage and a letter grade per student.
- ๐บ๐ธ US format ยท Letter size
- Free
Pick your options and the preview updates. The file opens in Excel, Google Sheets or Numbers.
The file is built in your browser. Nothing is uploaded or saved.
Sheets
- How to use
- Grades: assignment name, category (dropdown) and points possible in three yellow header rows, students with one score cell per assignment, Homework, Quizzes, Tests and Projects percent, weighted total and letter grade (formulas), category weights and letter scale in yellow cells under the roster
Color key
- Yellow cells: fill these in
- Blue cells: formulas, leave them as they are
- Gray rows: examples you can delete
Check the weights before the first grade goes home
The categories start at Homework 20, Quizzes 20, Tests 40 and Projects 20 percent. Change them to match your syllabus before you enter scores, and keep the total at 100 so a parent can reproduce the grade by hand.
1 / 1
Gradebook
| Last name | First name | HW 1 | Quiz 1 | Test 1 | Project 1 | ... | Homework % | Quizzes % | Tests % | Projects % | Weighted total | Letter grade |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Category | Homework | Quizzes | Tests | Projects | ... | |||||||
| Points possible | 10 | 20 | 100 | 50 | ... | |||||||
| Lee | Jordan | 9 | 18 | 88 | 45 | ... | 95.0% | 87.5% | 88.0% | 90.0% | 89.7% | B |
| Kim | Taylor | 7 | 15 | 76 | 40 | ... | 75.0% | 72.5% | 76.0% | 80.0% | 75.9% | C |
| Park | Sam | 10 | 20 | 95 | 48 | ... | 100.0% | 97.5% | 95.0% | 96.0% | 96.7% | A |
| ... | (auto) | (auto) | (auto) | (auto) | (auto) | (auto) |
This shows the first part of each sheet as it prints on Letter paper. The file also has a how-to sheet and formulas, and every column fits one page width when you print from Excel.
How to use it
Pick the number of students and assignments and download. Each assignment is a column with three yellow header cells: the name, the category from a dropdown (Homework, Quizzes, Tests, Projects) and the points possible. Each student is a row; type the score as it is graded and leave it empty until then. The category percents, the weighted total and the letter grade fill in by themselves, and the first two columns and the header rows stay on screen as you scroll.
The weights and the letter scale are yellow cells under the roster. Set them to match your syllabus once at the start of the term; the sheet shows a red note if the weights do not add up to 100. Three gray example students show how the math works; type over them.
Things to watch
An empty score is ungraded, not a zero. If a student skipped an assignment, type 0 so it counts. Extra credit works as a separate assignment with a small points possible value in the right category. For the roster itself, start from the class roster template and paste the names into the first two columns.
Calculators that go with this
Frequently asked questions
How is the weighted total calculated?
Each category percent is points earned divided by points possible for the graded assignments in that category. The total multiplies each percent by its weight and divides by the sum of the weights of the categories that have scores, so a term with no projects yet is still a fair number.
Can I use points instead of weights?
Set every weight to the same number, for example 25 each, and the total is still a weighted average of category percents, not a straight points total. For a pure points gradebook, put all assignments in one category and give it weight 100.
Can I change the letter cutoffs or add plus and minus grades?
Change the yellow minimums under the roster for A, B, C and D. Plus and minus grades need more rows in the scale and a longer nested IF in the Letter grade column; the simpler route is to keep the letters and show the percent next to them.
Is what I type saved anywhere?
No. Everything stays in your browser and nothing is sent to our server. If you refresh the page it is gone, so print, save a PDF or download the DOCX when you are done.