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.
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
NEW TRACKER USING ACTUAL GRADE BOUNDARIES NOW AVAILABLE IN MY STORE
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!
A scheme of work I planned and resourced, including powerpoints and accompanying pdfs and word documents (several pdfs are taken from eduqas and used as part of lessons).
Guides students through the entire C3 brief including screenplay, shooting script and evaluation over 25 lessons.
Discounts are available on the bundle linked below:
https://www.tes.com/teaching-resource/resource-12820645
These sheets were designed for classroom use (laminated and distributed when completing extended responses) in order to facilitate more independent working.