If you find yourself asking ‘Why don’t our headline figures match the DfE’s?’ don’t panic – here are 4 key areas to check:
1) Cohort total and Key Stage 2 data
Always check the number of pupils on roll in the DfE June Tables Checking Exercise (your headteacher will have received a letter in May). You should also check pupils who are classed as SEN and FSM Ever 6. Ensuring eligible pupils and their characteristics are correct can make significant differences to performance tables, as this data effectively determines the calculations.
Finally, check the KS2 data you have matches what is supplied by the DfE. It has been known for the DfE to have KS2 data for some students which you have never been able to track down. Ensure the data matches exactly to 2 decimal places – the odd student with differences of 0.01 can affect your Attainment 8 and Progress 8 figures.
Remember, exams results are based on the cohort at the time of the January Census (19th January 2017) – you can ask that certain pupils are removed if they meet specific criteria e.g. ‘admitted from abroad with English not first language’, or ‘Permanently left England’. Guidance can be found in the documentation on the Tables Checking website: https://tableschecking.education.gov.uk/
2) Non-curricular subjects
It’s good practice to always check with your exams officer whether any students are sitting exams for non-curricular subjects. At the school in which I worked, we often entered pupils for examinations in their home language. These can make a significant difference to your school’s headline figures.
Below we can see the Attainment 8, Progress 8 and EBacc data for our school, compared against targets:
The above data excludes the 6 home language grades which were all B grades.
The above data includes the 6 home language grades which were all B grades.
I also found that the odd student took Grade 6, 7, or 8 music qualifications. Whilst these exams were sat externally, they are still included in the performance measures. A Grade 6 Pass is the equivalent of an A in the open basket. This has the benefit of increasing the Average Attainment 8 score and grade for the student and your school. It might be slight but every little helps! For some students, it may even fill an empty slot in the open basket.
A GCSE Music grade could also count in the open basket. I’d recommend you always check the discount codes here though: https://www.raiseonline.org/opendocument.aspx?document=418
I used to ask form tutors to enquire whether their tutees had external music awards and tried to obtain a copy of any Certificates.
Beware of reformed and unreformed qualifications particularly with home languages – if a student takes an unreformed exam prior to Year 11 and it is reformed in Year 11, it will count for student performance, however it will NOT count for school performance! These qualifications can still be analysed within Analytics, but should always have ‘Unapproved’ as the method so they do not affect the headline figures.
A timeline of reformed qualifications can be found here: https://www.gov.uk/government/publications/get-the-facts-gcse-and-a-level-reform/get-the-facts-gcse-reform
You may wish to consider AS-levels for some students who have already taken an unreformed GCSE. These will count in the appropriate Progress 8 ‘basket’ for their subject. If a GCSE in the same subject has been taken, the AS will always discount the GCSE – grades A and B will score higher points than an A* at GCSE!
Finally, in the October Tables Checking Exercise you will be able to access a csv file which contains details of the grades awarded. There’s also a handy Progress 8 column – an easy way of checking your data is to compare this to the Progress 8 figure in your own internal software, whether it’s SISRA Analytics, Excel, or otherwise.
3) The grades data
Have any students been previously examined in any qualifications? The DfE’s early entry/first entry rules came into effect on 29th September 2013 and from this ‘only a student’s first entry to a GCSE examination will count in their school’s performance tables’. Any subsequent entries after this point (in the same or any related qualifications) are ineligible to count towards school performance measures, although they will still count for the student. Guidance can be found here:
During the autumn term, you may have some grades which need to be updated due to remarks too.
4) Incorrectly set-up qualifications
Finally, always check that qualifications are set up correctly. Start by checking the measure is correct – this affects how it counts towards your KS4 measure and headlines. Are GCSEs correctly set up as either A*-G or 9-1, BTECs and Cambridge Nationals as Non GCSEs?
As mentioned above, AS qualifications discount GCSEs so ensure discount codes are used (you do not need to use the official ones in Analytics e.g. for Polish GCSE you could use POL, and for Polish AS *POL – the asterisk ensures the AS takes priority). Also check that similar qualifications do not discount each other too!
Are your grade methods using the correct points? These can be found here:
Now it’s time to check which subjects count towards the EBacc (this is known as the ‘special’ column in Analytics). It is really important to ensure qualifications are correctly set up as it can make a significant difference to your figures if not. For example home languages such as Polish, Urdu etc. should be set to ‘language’ in the ‘special’ column. Computer Science is another subject which is often omitted from the Ebacc too (it should be set to ‘Comp Sci’). Conversely Religious Studies is often incorrectly included as a subject which counts towards the Ebacc as a ‘Humanity’. It doesn’t count towards the EBacc, but can count in the open basket. A list of the qualifications which count towards the EBacc can be found here: https://www.gov.uk/government/publications/english-baccalaureate-eligible-qualifications
Last but not least, are you using the most recent publishing options? As at June 2017 in SISRA Analytics, these are 2017 DfE rules, 2016 (2017 points) Attainment 8 estimates and 2016 Value Added.
At this point your headlines should be matching ☺