Analysis of 9-1 Subject GCSEs 2019 - Relative Difficulty - GAPS - KS2-4 relationships

These resources use a combination of two sets of data from the DfE.

The 2019 KS2-KS4 transition matrices.

Data received under FOI request 2019-0040993: KS2-4 transition data for GCSE English language and mathematics for the cohorts for individual GCSE subjects.

The spreadsheet can be used to look at or determine

The “dependence” of the results in a GCSE subject of pupils’ prior performance as measured by KS2 SAT data in English reading and maths.
The patterns in attainment and progress “gaps” in pupil performance due to gender, disadvantage, SEN and EAL characteristics.

The relative difficulty or leniency of grading in subject GCSEs compared to a subject cohorts’ performance in GCSE English language and maths.

It is for users to investigate and draw their own conclusions.

Over time I intend to add explanatory documents with my conclusions and opinions, which you are free to ignore.

The spreadsheet uses a small amount of visual basic for filtering so macros need to be enabled. These just to add additional functionality to the filtering in Excel.