Skip to content

Grade tracker templates

3 templates

All templates

Compare grade tracker versions

Grade TrackerStudy PlannerTeacher Gradebook
FormatSpreadsheetSpreadsheetSpreadsheet
Works inGoogle Sheets and ExcelGoogle Sheets and ExcelGoogle Sheets and Excel
Length4 slides5 slides3 slides
StyleFriendlyModernFriendly

How to choose a grade tracker template

A grade tracker records scores for assignments and tests and works out a running grade for each student or course. A study planner helps students schedule the work needed to reach their target.

Read more

Cover assignments and tests, maximum scores, weight for each category, current grade, target grade, and study plan with due dates.

Show the weight of each category, and recalculate whenever a new score goes in, so students can see the effect of each result.

Compare Grade Tracker, Study Planner, and Teacher Gradebook, all 3 to 5 pages long, then pick the closest match and replace the sample text with your own.

Questions

What is a grade tracker?

A grade tracker records scores for assignments and tests and works out a running grade for each student or course. A study planner helps students schedule the work needed to reach their target.

What should a grade tracker include?

Include assignments and tests, maximum scores, weight for each category, current grade, target grade, and study plan with due dates. Show the weight of each category, and recalculate whenever a new score goes in, so students can see the effect of each result.

How do you calculate a weighted grade?

Work out the percentage for each category, multiply it by that category's weight, add the results together and divide by the total weight. Dividing by the total weight means the result still works if the weights do not add up to 100.

How do you work out the score needed on a final exam?

Work out the points you need for your target overall, subtract the points you already have, then divide by the points the exam is worth. Check that the answer is a score you can realistically reach.

How should students plan their study time?

Break each subject into topics, estimate the hours each one needs and place them in the week before exams. Review earlier topics at intervals so they stay fresh.

Which grade tracker template should I start with?

Start with Grade Tracker: Record assignment marks, weight them by course and see averages and an overall GPA. If that is not the right fit, compare it with Study Planner.

How long is a grade tracker?

The templates here are 3 to 5 pages long. Cut any section you do not need; each template explains what its sections are for.

Which apps can I use for a grade tracker?

Yes. These grade tracker templates work in Google Sheets and Microsoft Excel. All 3 templates are free, with no account or email needed.

Preparing your template…