NEW AQA ENGLISH LANGUAGE GCSE 9-1 TRACKING SHEET USING AUG 2017 GRADE BOUNDARIES

NEW AQA ENGLISH LANGUAGE GCSE 9-1 TRACKING SHEET USING AUG 2017 GRADE BOUNDARIES

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!
chloesteel
NEW AQA ENGLISH LITERATURE GCSE 9-1 GRADE TRACKING DOCUMENT OFFICIAL GRADE BOUNDARIES JUNE 2017

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

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

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

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.
chloesteel
FULL BREAKDOWN Eduqas GCSE Media Studies 9-1 tracking spreadsheet tracker using WJEC 2017 summer

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

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
chloesteel
NEW SPEC 9-1 EDUQAS MEDIA STUDIES GCSE TRACKING DOCUMENT SPREADSHEET from 2017

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

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
chloesteel
AQA GCSE Media Studies Single Award Legacy Spec Tracking document with JUNE 2017 GRADE BOUNDARIES

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

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. 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.
chloesteel
NEW AQA ENGLISH LANGUAGE GCSE 9-1 TRACKING SHEET USING AUG 2017 GRADE BOUNDARIES

NEW AQA ENGLISH LANGUAGE GCSE 9-1 TRACKING SHEET USING AUG 2017 GRADE BOUNDARIES

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!
chloesteel
NEW AQA ENGLISH LITERATURE GCSE 9-1 GRADE TRACKING DOCUMENT OFFICIAL GRADE BOUNDARIES JUNE 2017

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

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!
chloesteel
NEW SPEC EDUQAS A LEVEL MEDIA STUDIES ASSESSMENT TRACKER AUTO GRADE CALCULATOR BASED ON JULY 17

NEW SPEC EDUQAS A LEVEL MEDIA STUDIES ASSESSMENT TRACKER AUTO GRADE CALCULATOR BASED ON JULY 17

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 a component you will be given a 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 etc. If you are entering your students for AS only this year, the same has been created for AS Media - please search my shop for this. 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!
chloesteel
NEW SPEC EDUQAS AS LEVEL MEDIA STUDIES ASSESSMENT TRACKER AUTO GRADE CALCULATOR BASED ON JULY 17

NEW SPEC EDUQAS AS LEVEL MEDIA STUDIES ASSESSMENT TRACKER AUTO GRADE CALCULATOR BASED ON JULY 17

This tracker, as with the others in my store, is designed to make the lives of your AS 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 a component you will be given a predicted grade based on the % of marks that students has achieved. I have come to the final grade for each unit by calculating the % of marks students required in order to achieve each grade on the old spec (different for exam and coursework components) from WJEC's June 2017 boundaries. 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. I've also added a 6 mark safety buffer column, were the boundaries to be this much higher. If you are entering your students for A level only, the same has been created for A level only - please search my shop for this. 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!
chloesteel
NEW AQA AS/A LEVEL MEDIA STUDIES TRACKING SHEET  JUNE 2017 GRADE BOUNDARIES legacy spec

NEW AQA AS/A LEVEL MEDIA STUDIES TRACKING SHEET JUNE 2017 GRADE BOUNDARIES legacy spec

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

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

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.
chloesteel