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.

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

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!

Focuses on the use of media language in Friends pilot. Please subscribe for updates - lessons to be added as and when planned.

Includes two booklets - one for component 1 and one for component 2. In this I have broken down a variety of possible questions for each set text (opted for LOM and TB, Zoella and Attitude, Huck and WR for C2, Beyonce for C1). This could be used as a revision tool for students - colour coding their confidence in answering each and working on the questions they deem red or amber. Alternatively this could be very useful in creating mock papers using a combination of questions from the two booklets.

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

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). Includes MTP. 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

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). Includes MTP. 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

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). Includes MTP. 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

Lessons I planned for Year 10 to support with creation of screenplay writing NEA. Discounts are available on the bundle linked below: https://www.tes.com/teaching-resource/resource-12820645

Like with the GCSE Media Studies tracker in my shop, this too is all you would need to accurately report grades for your post 16 media studies groups following the LEGACY AQA SPECIFICATION. There are three tabs included on this spreadsheet depending on the routes being taken by the students in your group: - Those resitting some AS modules alongside A2 modules. This allows input for all 4 units alongside existing results from Y12. Each unit is broken down into different areas for possible marks and each unit is also converted into an overall grade based on JUNE 2017 boundaries. - Those only completing A2 units this year. This allows input for unit 3 and 4 broken into each mark, alongside each students certified AS results. Calculations will be made totalling scores from the marks already achieved alongside the new units being completed as the year goes on. Overall A level grades are produced using this data. - Those students who are only entering for AS Media Studies legacy spec this year with the intention of dropping at the end of the year (otherwise you would be entering them for the NEW spec). Individual boxes are there to enter marks for each question/mark of each component and overall AS grades are calculated based on JUNE 2017 boundaries. On each tab there is also an additional column - the buffer. Here I have made the boundaries 10% tougher in case of a surprise grade boundary increase in June 2018. This could help identify those who are only just toughing each grade and who may benefit from a few more marks on their coursework or extra revision to ensure they are comfortably into each grade boundary and so avoids any nasty surprises on results day. I have used these trackers (alongside the ones produced for English) for several years with great success. Not only can you monitor the progress of you group, but they are invaluable when reporting at parents evening and students love to be able to see exactly where they have marks, what grade each unit is on and where they can gain more marks to achieve success. This tracking sheet really is a must for ALL media departments! If you do purchase and are happy with my work, please leave a positive review so others are more likely to come across this product in TES searches. If you experience any issues, please contact me at steel123@hotmail.com and I will happily try and resolve it. Likewise, similar trackers are available in my shop for GCSE AQA Media Studies and GCSE 9-1 AQA English Literature and Language. I am in the process of writing trackers for the new 9-1 Eduqas Media Studies as well as AQA English language, English Literature and English Lang and Lit A levels, so subscribe for updates for these subjects. Enjoy!

This booklet breaks the specification down into areas of revision and can be used to create mock papers easily. Students have a page or half page on which to plan responses to each question.

This bundle is all the resources I used to teach the Submarine unit (minus the textbooks that are occasionally referred to). All resources are editable, all key scenes are on youtube so students can access without several copies of the DVD. Includes powerpoints, song lyrics, key scene screen grabs, structure strips and more.

This is a tracker I developed which auto calculates the grades for every assessment year 12 and 13 do throughout the year using actual grade boundaries from the June 2019 examination series. It includes mock exams and overall grades too. Headers can easily be changed if different texts have been chosen. Hopefully this will save you a lot of time! Any issues or guidance using needed please email steel123@hotmail.com and I’ll do my best to look into it for you.

A resource i created to condense down information students needed to learn for the exam. The following texts are summarised: E.T IOTBS Whiplash District 9 Let the Right One In Submarine Contains information from factsheets, the textbook and elsewhere. A link to the original can be sent on request for editing purposes. Please comment if so.

To aid in revision, this booklet breaks down the specification into relevant areas of revision/exam questions for each section of the paper. Texts featured are Life on Mars & The Bridge, Woman’s Realm & Huck, Zoe Sugg and Attitude. Would also work as a bank to create mocks from. Hope this is useful! Similar for component 1 also available in my shop.