Hero image

Mrs M's English and Media Den

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

127Uploads

15k+Views

4k+Downloads

Selling a range of resources and assessment materials for English, Film Studies and Media Studies.
NEW SPEC 9-1 EDUQAS MEDIA STUDIES GCSE TRACKING DOCUMENT SPREADSHEET from 2017
chloesteel

NEW SPEC 9-1 EDUQAS MEDIA STUDIES GCSE TRACKING DOCUMENT SPREADSHEET from 2017

(5)
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
NEW AND IMPROVED AQA ENGLISH LANGUAGE GCSE 9-1 TRACKING SHEET USING JUNE 2017 GRADE BOUNDARIES
chloesteel

NEW AND IMPROVED AQA ENGLISH LANGUAGE GCSE 9-1 TRACKING SHEET USING JUNE 2017 GRADE BOUNDARIES

(2)
Designed on Microsoft excel, this tracking document will help you keep track of the progress of your KS4 students, with specific columns for each of the questions on the exam paper. The sheet will auto calculate INDIVIDUAL GRADES FOR EACH QUESTION, total marks on the paper as well as total overall marks, which then feed into an overall grade based on the boundaries released by AQA this week (Aug 2017). Furthermore, to account to boundary movement next year, I have added a buffer column which shows you the grade that would be achieved should the boundary increase by 10% on this year’s grade. 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. For each question there is also an intervention column so you can easily add information as to what intervention has been given to underachieving pupils for certain questions. The literature version of this sheet has too been added in my shop. THE LINK TO THE 2018 VERSION OF THIS IS BELOW: https://www.tes.com/teaching-resource/gcse-english-language-aqa-9-1-data-tracking-sheet-june-2018-official-grade-boundaries-excel-11962733
GCSE ENGLISH LANGUAGE AQA (9-1) DATA TRACKING SHEET JUNE 2018 OFFICIAL GRADE BOUNDARIES EXCEL
chloesteel

GCSE ENGLISH LANGUAGE AQA (9-1) DATA TRACKING SHEET JUNE 2018 OFFICIAL GRADE BOUNDARIES EXCEL

(0)
BACK DUE TO POPULAR DEMAND! Designed on Microsoft excel, this tracking document will help you keep track of the progress of your KS4 students, with specific columns for each of the questions on the exam paper. The sheet will auto calculate INDIVIDUAL GRADES FOR EACH QUESTION, total marks on the paper as well as total overall marks, which then feed into an overall grade based on the boundaries released by AQA (JUNE 2018 OFFICIAL BOUNDARIES). Furthermore, to account for boundary movement next year, I have added a buffer column which shows you the grade that would be achieved should the boundary increase by 5 marks on this year’s grade, as it did last year for some grades. All you need to do is add the pupil information from SIMS/your marksheet and the marks they have achieved for each question and the rest is done for you.
FULL BREAKDOWN Eduqas GCSE Media Studies 9-1 tracking spreadsheet tracker using WJEC 2017 summer
chloesteel

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

(0)
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
Complete Scheme of Work Eduqas GCSE Media Studies 9-1 comp 2a TV Sitcoms IT Crowd and Friends 20 lessons.
chloesteel

Complete Scheme of Work Eduqas GCSE Media Studies 9-1 comp 2a TV Sitcoms IT Crowd and Friends 20 lessons.

11 Resources
This bundle includes all lessons, fully resourced for the new Eduqas GCSE Media Studies TV Sitcoms option for component 2a. This is planned over 10 weeks, with 20 lessons (several double lessons included which may need tweaking for single lessons) to cover all key information for both texts. Mock questions are also built into the unit. Please note: these are planned on smart software. I have converted all to powerpoint but often the export changes the format and things may need adjusting - if you plan on using the powerpoints to teach, please check these before delivery.
NEW AQA ENGLISH LITERATURE GCSE 9-1 GRADE TRACKING DOCUMENT OFFICIAL GRADE BOUNDARIES JUNE 2017
chloesteel

NEW AQA ENGLISH LITERATURE GCSE 9-1 GRADE TRACKING DOCUMENT OFFICIAL GRADE BOUNDARIES JUNE 2017

(1)
Designed on Microsoft excel, this tracking document will help you keep track of the progress of your KS4 students, with specific columns for each of the questions on the exam paper. The sheet will auto calculate total marks on the paper as well as total overall marks, which then feed into an overall grade based on the boundaries released by AQA this week (Aug 2017). Furthermore, to account to boundary movement next year, I have added a buffer column which shows you the grade that would be achieved should the boundary increase by 10% on this year's grade. 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. The literature version of this sheet has too been added in my shop. A Level will too be added in due course - subscribe for notifications!
FULL BREAKDOWN AUTO CALCULATE EDUQAS NEW SPEC A LEVEL TRACKER SPREADSHEET JUNE 2017 WJEC BOUNDARIES
chloesteel

FULL BREAKDOWN AUTO CALCULATE EDUQAS NEW SPEC A LEVEL TRACKER SPREADSHEET JUNE 2017 WJEC BOUNDARIES

(0)
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!
AQA GCSE Media Studies Legacy Spec Mock exam review lesson genre/case study serial drama lesson
chloesteel

AQA GCSE Media Studies Legacy Spec Mock exam review lesson genre/case study serial drama lesson

(0)
Planned to accompany the mock exam that I have written. This lesson allows students to review their answers to question 1, a genre convention question which asks students to explore two case studies from the genre and the ways they are successful. As part of the lesson pupils are given two example answers to discuss compared with the student friendly mark scheme, they then mark and review their own answer using this criteria. Great for intervention sessions too. Case Studies explored in this lesson are Stranger Things and Game of Thrones.
Eduqas GCSE Film Studies (9-1) Long Term Plan LTP
chloesteel

Eduqas GCSE Film Studies (9-1) Long Term Plan LTP

(0)
Includes a column for suggested QA focuses for the year. Editable if you have selected different films from those on the plan. Currently working on this for teaching from SEPTEMBER. Will be uploading MTPs and lesson packs and when they’re complete - subscribe for updates.