Mrs M's English and Media Den
Mrs M's English and Media Den
3.48333333333333336 reviews

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

xlsx, 21.66 KB
xlsx, 21.66 KB

LOOKING FOR INDIVIDUAL GRADES FOR EACH SECTION OF THE EXAM/COURSEWORK SO YOU KNOW MORE SPECIFICALLY WHERE TO FOCUS YOUR INTERVENTIONS? I ALSO HAVE A TRACKER AVAILABLE WHICH PROVIDES YOU WITH THIS FOR ONLY £2 MORE. PLEASE SEARCH FOR ‘FULL BREAKDOWN EDUQAS 9-1 TRACKING’

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.
The sheet will auto calculate total marks on each unit - 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!

Any problems with this or formula doing strange things, please contact me on steel123@hotmail.com

Reviews

4.8

Something went wrong, please try again later.

aussieguy1977

3 years ago
5

Very helpful in preparing for first year of teaching the new spec. Thanks!

egill

4 years ago
4

Fab resource and really useful. Any chance you could talk me through your formulas? I am trying to break it down even further to get a rough level for each question of the exam for when I need to input data entries.

lizzie24

4 years ago
5

What a time saver! Thank you so much - for 'data phobes' like me this is incredibly helpful! An excellent resource.

jesshallissey1

4 years ago
5

lucy_entacott

4 years ago
5

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.

£3.00