This enhanced version of the AQA GCSE tracker has been updated to generate comments from the marks awarded. It has been updated to have the two AQA specimen papers for reference and the 2019 GCSE paper to use as a mock examination which will be added to the NEA assessment to give an accurate prediction based on the previous years’s grade boundaries.
Please note these boundaries are currently estimates but can be changed once real grades are released in August 2019; simply edit the Grade Boundary sheet and all the relevant cells will update.
Simply use the Context sheet to enter all student details including candidate number and attainment target.
Use the Comment sheet to award marks for each Assessment Objective and comments will be provided in the boxes for use in CRF’s or reports.
Use the Mock sheet to add the marks from the 2019 paper used as a mock exam.
Everything will then be transferred to the front Summary sheet, totals will be generated and levels awarded derived from the existing GCSE boundaries. Old grades are also provided for reference.
All the cells that do not need editing are locked to avoid making mistakes but the sheet can be unlocked with the password ‘gcse’.
Updated May 2019 with room for 26 student names and added a pie chart to show percentage of students who were above/below target. More can be added if you are comfortable with editing Excel spreadsheets or simply make additional copies of the spreadsheet for the additional students.
If you have less than 26, ensure that there is nothing entered into the A8 column on the context sheet and the pie chart will ignore these when calculating the percentage of students above/below target.
Extra sheets for homework and assessments can be tailored to suit your needs and will not affect the Summary sheet or the predicted levels.