Data set from Outcomes for children in need, including children looked after by local authorities in England

National - Key Stage 4 (KS4)

Latest data
Published
Last updated
Key Stage 4 attainment and progress by special educational need, ethnicity, placement (children looked after only), period of care length (children looked after only) and social care group.

Data set details

Theme
Children's social care
Publication
Outcomes for children in need, including children looked after by local authorities in England
Release type
Geographic levels
National
Indicators
  • Average Attainment 8 score of all pupils
  • Average EBacc APS score per pupil
  • Average Progress 8 score of all pupils
Filters
  • Ethnicity
  • Length of period of care
  • Placement
Time period
2017/18 to 2023/24

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_namesocial_care_groupsen_provisionethnicity_majorplacementpoc_lengthversiont_pupilst_att8avg_att8t_l2basics_95pt_l2basics_95t_l2basics_94pt_l2basics_94t_ebacc_e_ptq_eept_ebacc_e_ptq_eet_ebacc_95pt_ebacc_95t_ebacc_94pt_ebacc_94t_ebaccapsavg_ebaccapst_inp8calct_p8scoreavg_p8scorep8score_CI_lowp8score_CI_upp
202324Academic yearNationalE92000001EnglandAll pupils comparisonAll pupilsAll pupilsAll pupilsAll pupilsRevised62921028894894.4345.928881045.94089206525434040.41130701815882025.22563037.064.07586430-17076.667-0.03-0.03-0.03
202324Academic yearNationalE92000001EnglandAll pupils comparisonAll pupilsAsian/Asian BritishAll pupilsAll pupilsRevised790004182520.452.9466405959280754234053.62139027.12807035.5380006.914.816815034791.3720.510.50.52
202324Academic yearNationalE92000001EnglandAll pupils comparisonAll pupilsBlack/African/Caribbean/Black BritishAll pupilsAll pupilsRevised415201931398.5246.51920046.22748066.21903045.8699016.81050025.3172015.74.14342308754.5270.260.240.27
202324Academic yearNationalE92000001EnglandAll pupils comparisonAll pupilsMixed/Multiple ethnic groupsAll pupilsAll pupilsRevised394201842371.1946.71843046.82571065.21716043.5795020.21094027.7164561.214.1736230-569.139-0.02-0.03k
202324Academic yearNationalE92000001EnglandAll pupils comparisonAll pupilsOther ethnic groupAll pupilsAll pupilsRevised14220665341.7746.8675047.5917064.5746052.5322022.7449031.661454.454.32108405756.6170.530.50.56

Variables in this data set

Table showing first 5 of 25 variables
Variable nameVariable description
avg_att8Average Attainment 8 score of all pupils
avg_ebaccapsAverage EBacc APS score per pupil
avg_p8scoreAverage Progress 8 score of all pupils
ethnicity_majorEthnicity - Filter by ethnicity
p8score_CI_lowProgress 8 lower 95% confidence interval

Footnotes

  1. Special educational needs (SEN) status is taken from both the school census and the alternative provision census. The Key Stage 4 data includes pupils for whom SEN status could not be determined. More detailed information on the SEN data published within this release is available in the accompanying methodology.
  2. Due to the impact of the COVID-19 pandemic, the summer examination series was cancelled in both 2020 and 2021, and alternative processes set up to award grades. The method to award grades was different in 2021 to that in 2020. The changes to the way GCSE grades were awarded in these two years means 2019/20 and 2020/21 pupil attainment data should not be directly compared to pupil attainment data from previous or later years for the purposes of measuring year on year changes in pupil performance. More detailed information on the Key Stage 4 data published within this release is available in the accompanying methodology.
  3. Within this release comparisons are made with 2023 and with 2019. We will compare to 2023 due to it being last year’s data, and to 2019 because it was the last year that summer exams were taken before the Covid-19 pandemic. Users need to exercise extreme caution when considering comparisons over time, as they may not reflect changes in pupil performance alone. More detailed information on the Key Stage 4 data published within this release is available in the accompanying methodology.
  4. For children looked after (CLA) for at least 12 months, due to definitional differences, there can be a small number where the period of care length at 31 March is less than 12 months (where the period of care start date is 1 April).

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