xlsx, 24.62 KB
xlsx, 24.62 KB


This tracker, as with the others in my store, is designed to make the lives of your A level Media Studies teachers easier, whilst also providing an effective tool for promoting self evaluation in students.

The formula is all in place, all you have to do is export the info from SIMS, copy and paste, then enter the marks for your mocks/assessed pieces as they’re done and as you complete each question, a predicted grade will be offered. When completing a component you will be given an overall predicted grade based on the % of marks that students has achieved.
I have come to the final grade by calculating the % of marks students required in order to achieve each grade on the old spec (different for exam and coursework components). I have then reweighted this based on the number of marks available in the new spec. This, from what I can tell, is the best way of estimating grades on the new specification.
As with all new specifications, this is guesswork. Please approach the grades given with caution and always explain to students/parents/SLT etc that this is simply a best guess until the exam board provide something more conclusive.

The spreadsheet calculates grades for each separate component as well as an overall grade for the qualification. Furthermore, I’ve added a 6 mark buffer to account for grade boundary increases
Any queries or clarification, or any faults with the spreadsheet, please contact me directly at steel123@hotmail.com and I will happily try to repair or resolve any problems.

Happy with your purchase? Please leave a positive review so that this is promoted to others that may benefit!



Something went wrong, please try again later.


4 years ago

I've just bought this and there appears to be an error on the spread sheet, or at least it's not working for me. I can't click in some of the cells (I should be able to so I can input something) and the overall grade coming up for is contradictory to the question by question grades for Component 2 - my student achieved and A on all questions in Component 2 but her 'Media Overall Component 2 Grade' is appearing as a D in the bright yellow column... can you help please?

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.