Online Gradebook
A simple grade book that runs in your browser: add students and assignments, give each assignment a category such as Homework or Tests, set the weights, and every student's average and letter grade updates as you type. Nothing is uploaded; your classes are saved on this device.
Last updated:
Categories and weights
Type points earned. Leave blank if not graded yet, type EX for excused (not counted) or M for missing (counts as 0). Enter or ↓ moves to the next student.
Everything is saved automatically in this browser only. Download a CSV now and then as a backup.
How to use the Online Gradebook
- Set up categories and their weights, or switch the grading method to Total points.
- Press + Add assignment for each test or task, then set its name, category and maximum points in the column header.
- Press + Add student for each student, or import a CSV exported from your spreadsheet.
- Type the points earned in each cell. Use EX for excused and M for missing; Enter jumps to the next student.
- Read the averages and letter grades on the right, then press Download CSV or Print gradebook to keep a copy.
Weighted average formula
For each category c with weight wc: category % = points earned ÷ points possible × 100. The final grade is
Final % = Σ (wc × category %c) ÷ Σ wc
where both sums include only categories that already have graded work. In Total points mode the formula is simply Final % = total points earned ÷ total points possible × 100. The letter grade is looked up from the final percentage after rounding to the number of decimals you choose.
| Category | Weight | Points earned / possible | Category % | Weight × % |
|---|---|---|---|---|
| Homework | 20 | 19 / 20 | 95.0% | 1,900 |
| Quizzes | 30 | 37 / 40 | 92.5% | 2,775 |
| Tests | 40 | 94 / 100 | 94.0% | 3,760 |
| Participation | 10 | 10 / 10 | 100.0% | 1,000 |
| Total | 100 | 9,435 ÷ 100 = 94.35% (A) |
Letter grade scales
| Grade | Standard | Plus/minus | 7-point |
|---|---|---|---|
| A | 90–100 | A+ 97+, A 93–96, A− 90–92 | 93–100 |
| B | 80–89 | B+ 87–89, B 83–86, B− 80–82 | 85–92 |
| C | 70–79 | C+ 77–79, C 73–76, C− 70–72 | 77–84 |
| D | 60–69 | D+ 67–69, D 63–66, D− 60–62 | 70–76 |
| F | below 60 | below 60 | below 70 |
Schools set their own cut-offs, so check your district or syllabus. The standard 10-point scale is the most common in US schools.
CSV layout for import
| Student | HW 1 | Quiz 1 | Unit Test 1 |
|---|---|---|---|
| Category | Homework | Quizzes | Tests |
| Max points | 10 | 20 | 100 |
| Weight % | 20 | 30 | 50 |
| Ava Brooks | 10 | 19 | 94 |
| Liam Chen | EX | 16 | 81 |
The Category, Max points and Weight % rows are optional and can appear in any order before or between student rows. Commas, semicolons and tab-separated files are detected automatically.
Frequently asked questions
How does the gradebook calculate a weighted average?
For each student it first finds the percentage in every category: points earned divided by points possible for the graded assignments in that category. It then multiplies each category percentage by its weight, adds them up and divides by the total weight of the categories that have grades. Example: Homework 95% × 20 + Quizzes 92.5% × 30 + Tests 94% × 40 + Participation 100% × 10 = 9,435, divided by 100 = 94.35%.
What happens to a category with no grades yet?
It is left out and the remaining weights are rescaled, so early in the term a student with only homework and quiz grades is graded on those two categories in the same proportion. This matches how most online grade books show a running grade.
What is the difference between weighted categories and total points?
With total points every point counts the same: the average is total points earned divided by total points possible, so a 100-point test counts ten times as much as a 10-point quiz. With weighted categories each category has a fixed share of the final grade no matter how many points its assignments are worth.
How are blank, excused and missing scores handled?
A blank cell means not graded yet and is ignored (unless you turn on Count blank scores as 0). EX marks an excused assignment that never counts. M marks a missing assignment that counts as 0 points. You can also type a percentage such as 85% and it is converted to points.
Can I give extra credit?
Yes. Enter more points than the maximum (for example 11 out of 10), or add an assignment with a maximum of 0 points in a category; points earned on it are added without increasing the points possible.
How do I import grades from Excel or Google Sheets?
Save or download the sheet as CSV, then press Import CSV. The first row should be Student followed by assignment names. Optional rows whose first cell is Category, Max points or Weight % set those values; without a Max points row the tool assumes 100 points. Exported CSV files from this gradebook import back with their categories and weights.
Where is my gradebook stored? Is it private?
All classes are saved in your browser's local storage on this device and are never uploaded. That also means they do not sync to other computers and are lost if you clear site data, so download a CSV backup regularly. Follow your school's rules for student records.
Are all the tools on FreeToolCabin tested for quality and accuracy?
Yes! Every tool on our site undergoes automated Q/A testing in real browser environments to ensure high precision, correct output, and zero errors. If you happen to spot a bug or have a suggestion, please contact us at [email protected] and our team will review it right away.