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 firstname.lastname@example.org 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!