Student Grade Tracking Spreadsheet

Excel document set up for you to start tracking all student work.

You can:

1. Log student names, targets and teaching groups
2. Identify if students fit in key groups such as SEND or if they have exam access arrangements
3. Track homework completion
4. Track folder checks
5. Log grades from quizzes, tests and mocks.

This spreadsheet does all the hard work of tracking for you, I’ve sorted the formulas and conditional formatting so that you can just input the raw test scores and it will work out most of the hard work for you.

For example:

1. If you input a score on a test, it will work out the percentage and what this is as a grade (for this it is set to use the harshest AQA Psychology grade boundaries - but you could easily change these to any boundaries you want to use e.g. another subject’s grade boundaries).
2. It will work out if the student is on, above or below target in each test. It will then colour code this for you so you can visually see if students are on target easily.
3. When you enter a student as not submitting a homework it will also colour code this orange to enable you to see clearly patterns in missed homework.

As a bonus tab I’ve included a tracker to enable you to remember which tests have been set. I use this whenever I set a past paper. This means I never accidentally set the same test twice.

As a teacher of over 10 years at an outstanding school, who has examined and tutored, I have spent time compiling exactly the resources students need to excel in their exams. Now I want to pass these on to you. Whether you are a teacher or student these will help you get ready for the exams.