Hero image

Mrs M's English and Media Den

Average Rating3.41
(based on 39 reviews)

Selling a range of resources and assessment materials for English, Film Studies and Media Studies.

123Uploads

61k+Views

30k+Downloads

Selling a range of resources and assessment materials for English, Film Studies and Media Studies.
AQA GCSE Media Studies Single Award Legacy Spec Tracking document with JUNE 2017 GRADE BOUNDARIES
chloesteelchloesteel

AQA GCSE Media Studies Single Award Legacy Spec Tracking document with JUNE 2017 GRADE BOUNDARIES

(2)
NEW AND IMPROVED This tracker was designed to enable the most accurate and effective data for your SINGLE AWARD GCSE AQA MEDIA STUDIES groups. Once the data for your group is imputed, the spreadsheet will convert the raw marks given into UMS marks (which vary year on year) and then into grades. Grades will be given for both units separately, as well as an overall grade based on the total marks awarded across the GCSE. NEW FOR SPRING - NOW ALL MARKS ARE CONVERTED TO GRADES FOR EACH PART OF THE COURSEWORK AS WELL; GET THAT INTERVENTION SORTED ASAP! All conversions are based on actual grade boundaries from the JUNE 2017 exam results. Please note - grade boundaries are always subject to change as we have found this year in particular and this should only be used as a guide for making accurate predictions. To ensure ultimate success, add a buffer mark on of around 10% higher than this year’s results as a worst case scenario grade.
FULL BREAKDOWN Eduqas GCSE Media Studies 9-1 tracking spreadsheet tracker using WJEC 2017 summer
chloesteelchloesteel

FULL BREAKDOWN Eduqas GCSE Media Studies 9-1 tracking spreadsheet tracker using WJEC 2017 summer

(2)
Designed on Microsoft excel, this tracking document will help you keep track of the progress of your KS4 Media Studies students, with specific columns for section of each exam paper and for individual coursework marks. This NEW AND IMPROVED sheet will auto calculate total marks on each unit AS WELL AS ESTIMATED GRADES FOR EACH QUESTION - which will be converted into a 9-1 grade as well as totalling overall marks, which then feed into an overall grade prediction. The predictions have been calculated using last year's WJEC grade boundaries and the % of marks needed for each grade on each unit. This % mark has then been converted for the new weighting on the new spec. All you need to do is add the pupil information and the marks they have achieved for each question and the rest is done for you. Please be aware that these are not official grade boundaries and it is guess work at this stage. I have tried to make my predictions as reliable as possible by converting from old spec boundaries and converting % etc, but cannot guarantee that these will be the exact boundaries provided by the board. I have also created similar spreadsheets for AQA GCSE English 9-1, old spec AQA Media GCSE and Media A level too; check out my shop for these. A Level will too be added in due course - subscribe for notifications! For reference - I have mapped an old D grade to a new grade 3, a C to a 4, a B to a 5, an A to a 7 and an A* to an 8. Any problems with this or formula doing strange things, please contact me on steel123@hotmail.com