Printable grade tracker for students
Track every score you get in every subject on one page, and keep a spreadsheet copy that works out your weighted average as you go.
How to make your sheet
- Type your subjects, separated by commas.
- Edit the assessment columns to match your syllabus and keep Average last.
- Press Print or save as PDF for a paper copy.
- Press Download .xlsx and enter your syllabus weights in row 2.
Why track your own grades
Online grade portals are often updated late, and they rarely show what a single bad quiz really does to your average. Writing each score down the day you get it back means you always know where you stand, and you notice a slide in one subject weeks before the report card. It also gives you a record to compare with the teacher's if a score is missing or mistyped, which happens more often than most students think.
Setting up subjects and columns
Type your subjects in the Subjects box, separated by commas; each becomes a row. Then make the columns match how your classes are graded. The default is Test 1, Test 2, Quizzes, Homework, Project and Average, but if your science class has labs and your language class has oral exams, add those. Use the syllabus as your guide: most syllabi list the categories and their weights, such as tests 40%, quizzes 20%, homework 20% and project 20%. Keep the last column as Average; it is where the result goes.
What the .xlsx file does
Download .xlsx builds a spreadsheet with your subjects and columns. Row 2 holds a weight for each column, starting at 1. Change them to the syllabus weights, for example 40, 20, 20 and 20 (or 2, 1, 1, 1; only the ratio matters). The Average column has a real formula in each row that multiplies each score by its weight, adds them up and divides by the weights of the cells you have filled. Empty cells do not count, so your average is correct even halfway through the term. The bottom row averages each column across subjects. The file is built in your browser and opens in Excel, LibreOffice, Google Sheets and Numbers.
Example: halfway through the term
In Biology you have Test 1 at 78 (weight 40), Quizzes at 90 (weight 20) and Homework at 96 (weight 20); Test 2 and the Project are still blank. The average is (78 × 40 + 90 × 20 + 96 × 20) ÷ 80 = 6840 ÷ 80 = 85.5. Counting the blanks as zeros would show 68.4, which is not your grade, just a sign that work is still to come. To see what you need on Test 2 to reach 90, use the final grade calculator with 85.5 as your current grade and 40 ÷ 120, about 33%, as the weight still to come.
Paper or spreadsheet?
Use both. Keep the printed sheet in your binder and write scores in as you get them; once a week, copy the new numbers into the spreadsheet to see the averages. When term grades are final, the GPA calculator turns them into a GPA, and the GPA planner worksheet helps you set targets for next term.
Classes graded in points
Some teachers grade by total points instead of weighted categories: a 50-point test simply counts five times as much as a 10-point quiz. In that case, write each score as a percentage in the tracker and use the maximum points as the weight in row 2. The result is the same as adding up points earned and dividing by points possible, which you can confirm with the points calculator.