Online Gradebook Calculator
Type your students and their scores, set the category weights, and every student's weighted grade and letter grade is worked out as you type. Free, no sign-up, and the grades stay in your browser.
This is a sample class. Type over any score to see the grades change, or start your own gradebook.
Gradebook · Homework 20% · Quizzes 30% · Tests 50%
| Student | Grade | Homework · 20% | Quizzes · 30% | Tests · 50% | Category average | ||||
|---|---|---|---|---|---|---|---|---|---|
| / | / | / | / | / | Homework | Quizzes | Tests | ||
| Maya Johnson | 93.8%A | 95.0 | 92.5 | 94.0 | |||||
| Leo Martinez | 67.8%D | 40.0 | 72.5 | 76.0 | |||||
| Aisha Khan | 90.0%A | 95.0 | 90.0 | 88.0 | |||||
| Noah Williams | 65.8%D | 75.0 | 62.5 | 64.0 | |||||
| Sofia Rossi | 97.8%A | 100.0 | 97.5 | 97.0 | |||||
| Ethan Chen | 69.5%D | 65.0 | 70.0 | 71.0 | |||||
| Zoe Brown | 82.8%B | 85.0 | 82.5 | 82.0 | |||||
| Lucas Silva | 55.8%F | 55.0 | 52.5 | 58.0 | |||||
| Class average | 77.9%C | 80.0% | 72.5% | 78.8% | 75.0% | 78.8% | 76.3 | 77.5 | 78.8 |
– blank = not graded yet, left out0 counts as zeroEX excused, left outEnter moves down
Categories
- %
- %
- %
Weights add to 100%. A category with nothing graded yet is left out and the others are scaled up.
Grade scale
F below 60%
Grades are rounded to one decimal place before the letter is given.
Students
Grades stay in this browser on this device. Nothing is uploaded. Download the CSV to keep a copy.
Also for your class: Attendance sheet · Random name picker
How it works
- Start from the sample class to see how it works, then press Use my own students, or Use my class list if you have already saved one on this site.
- Under Categories, name your categories and set their weights, for example Homework 20%, Quizzes 30% and Tests 50%. Choose Total points instead if every point should count the same.
- Press Add assignment, pick its category, then type its name and the points possible at the top of its column.
- Type each student's score. Leave a box blank if the work is not graded yet, type 0 for missing work, or EX if the student is excused. Press Enter to move down to the next student.
- Change the grade scale if your school uses different cutoffs, or tick Use + and − grades. Press Download CSV to open the grades in a spreadsheet, or Print / PDF for a paper copy.
How weighted grades are calculated
Each category gets its own percentage first: the points the student earned in that category divided by the points possible. Each category percentage is then multiplied by its weight, and the results are added up.
Worked example: a student scores 9 and 9 out of 10 on two homework assignments (18 of 20, so 90%), 17 out of 20 on a quiz (85%) and 78 out of 100 on a test (78%). With Homework at 20%, Quizzes at 30% and Tests at 50%, the final grade is 0.20 × 90 + 0.30 × 85 + 0.50 × 78 = 18 + 25.5 + 39 = 82.5%, a B on the default scale.
Because points are pooled inside a category, a 100 point project counts more than a 10 point worksheet in the same category. If you want every assignment to count the same, give them all the same points possible.
Blanks, zeros and excused work
A blank box means the assignment has not been graded yet for that student, so it is left out of their grade and out of the class average. A 0 is a real score and pulls the grade down. In the sample class, Leo Martinez has a 0 on HW 2 and Aisha Khan has no Quiz 2 score yet; compare the two to see the difference.
Type EX when a student is excused from an assignment. It is left out the same way a blank is, but it shows in the table and in the CSV, so you can tell it apart from work you have not marked.
When a category has no grades yet
Early in a term there may be homework and quizzes but no test yet. The gradebook calculator leaves an empty category out and scales the other weights up so they still add to 100%. With 90% in Homework (20%) and 85% in Quizzes (30%) and no test, the grade is (20 × 90 + 30 × 85) ÷ 50 = 87%. Point at a student's grade to see the weights that were used.
If your weights add up to something other than 100, they are scaled the same way, so 10, 15 and 25 give the same result as 20, 30 and 50.
Letter grade scale
The default scale is the common US one: A is 90% and up, B 80%, C 70%, D 60% and F below 60%. Change any cutoff to match your school's scale, for example A at 93 and B at 85.
Tick Use + and − grades to split each band into thirds. On the default scale that gives A− from 90, A from 93 and A+ from 97, and the same pattern for B, C and D. Grades are rounded to one decimal place before the letter is given, so 89.96% shows as 90.0% and is an A.
Your grades stay in this browser
Everything you type is saved only in this browser on this device, so it is there when you come back. Nothing is uploaded and there is no account. If you clear your browser data or switch computers, the grades will not follow you, so press Download CSV now and then to keep a copy.
The CSV has one row per student with every score as you typed it, each category percentage, the final percentage and the letter grade, plus a class average row. It opens in Excel, Google Sheets or Numbers.
More tools for your class
Keep the attendance record next to the grades with a printable attendance sheet, check a student's attendance rate, or pick who answers next with the random name picker. They all share the same class list on this site.
Attendance sheet · Attendance percentage calculator · Random name picker
Questions
How do I calculate a weighted grade?
Work out the percentage in each category, multiply each by its weight, and add them up. 90% homework at 20%, 85% quizzes at 30% and 78% tests at 50% is 18 + 25.5 + 39 = 82.5%.
What is the difference between a blank and a zero?
A blank means not graded yet and is left out of the grade. A zero counts as a score of 0 and lowers the grade.
What if my weights do not add up to 100%?
They are scaled so they do. The page shows the total under Categories so you can fix it if that was a typo.
Can I grade by total points instead of weights?
Yes. Choose Total points under Categories and the grade is all points earned divided by all points possible.
Can I use plus and minus letter grades?
Yes. Tick Use + and − grades under Grade scale. You can also change the A, B, C and D cutoffs.
Is extra credit allowed?
Yes. A score above the points possible is counted as typed, so 11 out of 10 adds a point to the category.
Are my students' grades uploaded?
No. They are saved only in this browser on this device. Download the CSV to keep a backup or move to another computer.