This tracker, as with the others in my store, is designed to make the lives of your AS 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 a component you will be given a predicted grade based on the % of marks that students has achieved.
I have come to the final grade for each unit by calculating the % of marks students required in order to achieve each grade on the old spec (different for exam and coursework components) from WJEC's June 2017 boundaries. 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. I've also added a 6 mark safety buffer column, were the boundaries to be this much higher. If you are entering your students for A level only, the same has been created for A level only - please search my shop for this.
Any queries or clarification, or any faults with the spreadsheet, please contact me directly at email@example.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!