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
  • Total EBacc APS score of pupils
  • Total number of pupils achieving grades 4 or above in English and mathematics GCSEs
  • Total number of pupils achieving grades 5 or above in English and mathematics GCSEs
Filters
  • Ethnicity
  • Length of period of care
  • Placement
Time period
2016/17 to 2022/23

Data set preview

Table showing first 5 rows, from underlying data
time_periodtime_identifiergeographic_levelcountry_codecountry_namesocial_care_grouppupil_sen_statusethnicity_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
202223Academic yearNationalE92000001EnglandAll pupils comparisonAll pupilsAll pupilsAll pupilsAll pupilsRevised60692028087774.5846.327482045.339509065.123832039.31030701714681024.22460730.694.05568530-14980.702-0.03-0.03-0.02
202223Academic yearNationalE92000001EnglandAll pupils comparisonAll pupilsAsian/Asian BritishAll pupilsAll pupilsRevised733603897211.2653.14285058.45486074.83877052.91901025.92523034.4350425.954.786445034387.2440.530.520.54
202223Academic yearNationalE92000001EnglandAll pupils comparisonAll pupilsBlack/African/Caribbean/Black BritishAll pupilsAll pupilsRevised379801768574.6346.61725045.424700651778046.8624016.4944024.8155973.994.11329707121.6430.220.20.23
202223Academic yearNationalE92000001EnglandAll pupils comparisonAll pupilsMixed/Multiple ethnic groupsAll pupilsAll pupilsRevised367201716153.5246.71671045.52383064.91545042.1678018.5950025.9151306.274.1233930-1453.189-0.04-0.06-0.03
202223Academic yearNationalE92000001EnglandAll pupils comparisonAll pupilsOther ethnic groupAll pupilsAll pupilsRevised1299061002647610047834064.2675052281021.6401030.955738.364.2998905266.0350.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. In 2022/23 there was a return to pre-pandemic standards for GCSEs, with protection built into the grading process to recognise the disruption that students have faced. Throughout this release, comparisons are made with 2022 and with 2019. The more meaningful comparison is with 2019, the last year that summer exams were taken before the pandemic, as 2023 saw a return to pre-pandemic grading, with some protections. In 2022 outcomes broadly reflected a mid-point between 2019 and 2021, to take account of the impact of the pandemic and in line with Ofqual’s approach to grading in 2022. It is expected that performance in 2023 will generally be lower than in 2022. 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