Data set from Key stage 4 performance

Key stage 2 to 4 transition matrices GCSE subjects

Not the latest data
Published
Last updated
National level distributions of GCSE grades achieved compared with KS2 scaled scores achieved broken down by subject, gender, disadvantage, special educational needs (SEN) and English as an additional language (EAL). Pupils in state-funded mainstream and special schools, hospital schools and non-maintained special schools.

Data set details

Theme
School and college outcomes and performance
Publication
Key stage 4 performance
Release
Academic year 2021/22
Release type
Number of rows
3,375
Geographic levels
National
Indicators
  • Number of GCSE pupils with grade 1 achieved
  • Number of GCSE pupils with grade 11 achieved
  • Number of GCSE pupils with grade 2 achieved
  • Number of GCSE pupils with grade 21 achieved
  • Number of GCSE pupils with grade 22 achieved
  • Number of GCSE pupils with grade 3 achieved
  • Number of GCSE pupils with grade 32 achieved
  • Number of GCSE pupils with grade 33 achieved
  • Number of GCSE pupils with grade 4 achieved
  • Number of GCSE pupils with grade 43 achieved
  • Number of GCSE pupils with grade 44 achieved
  • Number of GCSE pupils with grade 5 achieved
  • Number of GCSE pupils with grade 54 achieved
  • Number of GCSE pupils with grade 55 achieved
  • Number of GCSE pupils with grade 6 achieved
  • Number of GCSE pupils with grade 65 achieved
  • Number of GCSE pupils with grade 66 achieved
  • Number of GCSE pupils with grade 7 achieved
  • Number of GCSE pupils with grade 76 achieved
  • Number of GCSE pupils with grade 77 achieved
  • Number of GCSE pupils with grade 8 achieved
  • Number of GCSE pupils with grade 87 achieved
  • Number of GCSE pupils with grade 88 achieved
  • Number of GCSE pupils with grade 9 achieved
  • Number of GCSE pupils with grade 98 achieved
  • Number of GCSE pupils with grade 99 achieved
  • Number of GCSE pupils with grade U achieved
  • Number of GCSE pupils with grade UU achieved
  • Number of GCSE pupils with grade X achieved
  • Number of GCSE pupils with grade XX achieved
  • Number of pupils achieving a covid 19 impacted double grade
  • Number of pupils achieving a covid 19 impacted grade
  • Percentage of pupils achieving GCSE grade 1
  • Percentage of pupils achieving GCSE grade 11
  • Percentage of pupils achieving GCSE grade 2
  • Percentage of pupils achieving GCSE grade 21
  • Percentage of pupils achieving GCSE grade 22
  • Percentage of pupils achieving GCSE grade 3
  • Percentage of pupils achieving GCSE grade 32
  • Percentage of pupils achieving GCSE grade 33
  • Percentage of pupils achieving GCSE grade 4
  • Percentage of pupils achieving GCSE grade 43
  • Percentage of pupils achieving GCSE grade 44
  • Percentage of pupils achieving GCSE grade 5
  • Percentage of pupils achieving GCSE grade 54
  • Percentage of pupils achieving GCSE grade 55
  • Percentage of pupils achieving GCSE grade 6
  • Percentage of pupils achieving GCSE grade 65
  • Percentage of pupils achieving GCSE grade 66
  • Percentage of pupils achieving GCSE grade 7
  • Percentage of pupils achieving GCSE grade 76
  • Percentage of pupils achieving GCSE grade 77
  • Percentage of pupils achieving GCSE grade 8
  • Percentage of pupils achieving GCSE grade 87
  • Percentage of pupils achieving GCSE grade 88
  • Percentage of pupils achieving GCSE grade 9
  • Percentage of pupils achieving GCSE grade 98
  • Percentage of pupils achieving GCSE grade 99
  • Percentage of pupils achieving GCSE grade U
  • Percentage of pupils achieving GCSE grade UU
  • Percentage of pupils achieving a covid 19 impacted double grade
  • Percentage of pupils achieving a covid 19 impacted grade
  • Total number of GCSE double grades achieved
  • Total number of GCSE grades achieved
Filters
  • GCSE subject entered
  • Key stage 2 scaled score group
  • Pupil characteristic disaggregation
Time period
2021/22

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_nameversioncharacteristic_typecharacteristic_valuesubjectsks2_scaled_score_groupnum_Unum_1num_2num_3num_4num_5num_6num_7num_8num_9num_Xnum_covid_impactedall_gradesperc_1perc_2perc_3perc_4perc_5perc_6perc_7perc_8perc_9perc_Uperc_Xper_covid_impactednum_11num_21num_22num_32num_33num_43num_44num_54num_55num_65num_66num_76num_77num_87num_88num_98num_99num_UUnum_XXnum_covid_impacted_doubleall_double_gradesperc_UUperc_11perc_21perc_22perc_32perc_33perc_43perc_44perc_54perc_55perc_65perc_66perc_76perc_77perc_87perc_88perc_98perc_99perc_XXper_covid_impacted_double
202122Academic yearNationalE92000001EnglandRevisedAll PupilsAll PupilsAncient HistoryLess than 803100000100005200000020006000zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
202122Academic yearNationalE92000001EnglandRevisedAll PupilsAll PupilsAncient History80 - 89.5514201000010147.128.614.307.1000035.77.10zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
202122Academic yearNationalE92000001EnglandRevisedAll PupilsAll PupilsAncient History90 - 95.5115511621000104211.911.926.214.34.82.400026.22.40zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
202122Academic yearNationalE92000001EnglandRevisedAll PupilsAll PupilsAncient History96 - 99.51271649132210006610.624.26.113.619.7331.5018.200zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
202122Academic yearNationalE92000001EnglandRevisedAll PupilsAll PupilsAncient History100 - 1024871191212530017211.19.715.312.516.716.76.94.205.601.4zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz

Variables in this data set

Table showing all 67 variables
Variable nameVariable description
all_double_gradesTotal number of GCSE double grades achieved
all_gradesTotal number of GCSE grades achieved
characteristic_valuePupil characteristic disaggregation - Filter by Pupil characteristic disaggregation
ks2_scaled_score_groupKey stage 2 scaled score group - Filter by Key stage 2 scaled score group
num_1Number of GCSE pupils with grade 1 achieved
num_11Number of GCSE pupils with grade 11 achieved
num_2Number of GCSE pupils with grade 2 achieved
num_21Number of GCSE pupils with grade 21 achieved
num_22Number of GCSE pupils with grade 22 achieved
num_3Number of GCSE pupils with grade 3 achieved
num_32Number of GCSE pupils with grade 32 achieved
num_33Number of GCSE pupils with grade 33 achieved
num_4Number of GCSE pupils with grade 4 achieved
num_43Number of GCSE pupils with grade 43 achieved
num_44Number of GCSE pupils with grade 44 achieved
num_5Number of GCSE pupils with grade 5 achieved
num_54Number of GCSE pupils with grade 54 achieved
num_55Number of GCSE pupils with grade 55 achieved
num_6Number of GCSE pupils with grade 6 achieved
num_65Number of GCSE pupils with grade 65 achieved
num_66Number of GCSE pupils with grade 66 achieved
num_7Number of GCSE pupils with grade 7 achieved
num_76Number of GCSE pupils with grade 76 achieved
num_77Number of GCSE pupils with grade 77 achieved
num_8Number of GCSE pupils with grade 8 achieved
num_87Number of GCSE pupils with grade 87 achieved
num_88Number of GCSE pupils with grade 88 achieved
num_9Number of GCSE pupils with grade 9 achieved
num_98Number of GCSE pupils with grade 98 achieved
num_99Number of GCSE pupils with grade 99 achieved
num_covid_impactedNumber of pupils achieving a covid 19 impacted grade
num_covid_impacted_doubleNumber of pupils achieving a covid 19 impacted double grade
num_UNumber of GCSE pupils with grade U achieved
num_UUNumber of GCSE pupils with grade UU achieved
num_XNumber of GCSE pupils with grade X achieved
num_XXNumber of GCSE pupils with grade XX achieved
per_covid_impactedPercentage of pupils achieving a covid 19 impacted grade
per_covid_impacted_doublePercentage of pupils achieving a covid 19 impacted double grade
perc_1Percentage of pupils achieving GCSE grade 1
perc_11Percentage of pupils achieving GCSE grade 11
perc_2Percentage of pupils achieving GCSE grade 2
perc_21Percentage of pupils achieving GCSE grade 21
perc_22Percentage of pupils achieving GCSE grade 22
perc_3Percentage of pupils achieving GCSE grade 3
perc_32Percentage of pupils achieving GCSE grade 32
perc_33Percentage of pupils achieving GCSE grade 33
perc_4Percentage of pupils achieving GCSE grade 4
perc_43Percentage of pupils achieving GCSE grade 43
perc_44Percentage of pupils achieving GCSE grade 44
perc_5Percentage of pupils achieving GCSE grade 5
perc_54Percentage of pupils achieving GCSE grade 54
perc_55Percentage of pupils achieving GCSE grade 55
perc_6Percentage of pupils achieving GCSE grade 6
perc_65Percentage of pupils achieving GCSE grade 65
perc_66Percentage of pupils achieving GCSE grade 66
perc_7Percentage of pupils achieving GCSE grade 7
perc_76Percentage of pupils achieving GCSE grade 76
perc_77Percentage of pupils achieving GCSE grade 77
perc_8Percentage of pupils achieving GCSE grade 8
perc_87Percentage of pupils achieving GCSE grade 87
perc_88Percentage of pupils achieving GCSE grade 88
perc_9Percentage of pupils achieving GCSE grade 9
perc_98Percentage of pupils achieving GCSE grade 98
perc_99Percentage of pupils achieving GCSE grade 99
perc_UPercentage of pupils achieving GCSE grade U
perc_UUPercentage of pupils achieving GCSE grade UU
subjectsGCSE subject entered - Filter by GCSE subject entered

Footnotes

  1. For pupils at the end of KS4 in 2021/22, where pupils achieved qualifications in subjects between January 2020 and August 2021, we will not use results from these qualifications and these results are shown as covid impacted. The entries into the qualifications are still counted. 
  2. Some percentages may not add up to exactly 100% due to rounding.

Using this data

  • Download the underlying data as a compressed ZIP file

  • View or create your own tables

    View tables that we have built for you, or create your own tables from open data using our table tool

Download this data using code

Access this data using common programming languages using the URL below.

Example code

Python
import pandas as pd

pd.read_csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/850f7194-5b17-4b84-98b9-f9da70549d3a/csv")
R
read.csv("https://explore-education-statistics.service.gov.uk/data-catalogue/data-set/850f7194-5b17-4b84-98b9-f9da70549d3a/csv")

Contact us

If you have a specific enquiry about Key stage 2 to 4 transition matrices GCSE subjects statistics and data:

Attainment statistics team

Email: Attainment.STATISTICS@education.gov.uk
Contact name: Liam Hamilton