Table Tool

Create your own tables

Choose the data and area of interest you want to explore and then use filters to create your table.
Once you've created your table, you can download the data it contains for your own offline analysis.

1. Step 1

   • Publication: Key stage 4 performance

2. Step 2

   • Data set: KS4 national characteristics data

3. Step 3

   • National:
     • England

4. Step 4

   • Time period: 2018/19 to 2021/22

5. Step 5

   • Indicators:
     • Average Attainment 8 score of all pupils
     • Average EBacc APS score per pupil
     • Percentage of pupils achieving grades 5 or above in English and mathematics GCSEs
     • Percentage of pupils entering the English Baccalaureate
     • Total number of pupils at the end of key stage 4
   • All pupils with a primary need (from 2014/15 onwards this consisted of pupils flagged as SEN with a statement, EHC plan, SEN support, school action or school action plus):
     • Total
   • Basis for admission into the school e.g. non-selective schools in other areas, selective schools:
     • Total
   • Disadvantaged status:
     • Total
   • English as an Additional Language status:
     • Total
   • Free school meal eligibility:
     • Total
   • Gender:
     • Total
   • Major ethnic group:
     • Asian
     • Black
     • Chinese
     • Mixed
     • Other
   • Minor ethnic group:
     • Total
     • Any other Asian background
     • Any other black background
     • Any other ethnic group
     • Any other mixed background
   • Primary need grouping:
     • Total
   • Religious denomination of school:
     • Total
   • Special Educational Needs description:
     • Total
   • Special Educational Needs status:
     • Total
   • The types of school in the data:
     • All state-funded

6. Step 6 Explore data

   This is the latest data

   WarningSome rows and columns are not shown in this table as the data does not exist in the underlying file.

   'KS4 national characteristics data' for All state-funded, Any other Asian background, Any other black background, Any other ethnic group, Any other mixed background and 20 other filters in England between 2018/19 and 2021/22

   		Asian					Black				Chinese		Mixed					Other		White
   		Total	Any other Asian background	Bangladeshi	Indian	Pakistani	Total	Any other black background	Black African	Caribbean	Total	Chinese	Total	Any other mixed background	White and Asian	White and Black African	White and Black Caribbean	Total	Any other ethnic group	Total	Any other white background	Gypsy/Roma	Traveller of Irish heritage	White British	White Irish
   Total number of pupils at the end of key stage 4	2018/19	58,111	9,303	9,877	15,429	23,502	31,175	3,875	19,807	7,493	2,006	2,006	27,018	10,108	6,144	3,262	7,504	9,607	9,607	406,707	28,214	1,243	151	375,411	1,688
   	2019/20	61,023	10,247	10,372	16,129	24,275	32,935	4,258	21,299	7,378	1,959	1,959	29,481	11,093	6,654	3,706	8,028	10,522	10,522	416,504	30,321	1,354	160	383,021	1,648
   	2020/21	63,704	10,805	10,247	16,901	25,751	34,911	4,529	23,240	7,142	2,101	2,101	31,772	11,752	7,531	4,093	8,396	11,265	11,265	421,995	32,109	1,425	171	386,569	1,721
   	2021/22	66,828	11,278	10,690	18,221	26,639	36,070	4,508	24,499	7,063	2,435	2,435	34,068	12,383	8,161	4,629	8,895	11,976	11,976	425,270	33,986	1,432	187	388,054	1,611
   Percentage of pupils achieving grades 5 or above in English and mathematics GCSEs	2018/19	51.9%	60.1%	50.3%	64.1%	41.3%	37.8%	33.7%	42.9%	26.5%	76.3%	76.3%	43.8%	47.0%	55.5%	41.5%	31.0%	43.4%	43.4%	42.4%	41.5%	6.0%	13.9%	42.5%	54.9%
   	2019/20	58.3%	65.0%	57.3%	70.4%	47.8%	46.0%	41.7%	50.7%	34.8%	79.6%	79.6%	50.2%	53.0%	60.9%	50.3%	37.6%	50.5%	50.5%	49.1%	48.7%	8.1%	20.0%	49.2%	60.2%
   	2020/21	60.6%	67.1%	60.6%	72.4%	50.3%	48.9%	45.1%	53.6%	35.9%	83.8%	83.8%	51.5%	54.2%	62.1%	50.0%	39.1%	53.1%	53.1%	50.9%	52.5%	9.1%	21.1%	50.9%	60.9%
   	2021/22	61.5%	66.7%	62.1%	73.0%	51.2%	49.4%	45.3%	54.5%	34.6%	80.0%	80.0%	49.9%	53.0%	60.8%	48.4%	36.2%	52.1%	52.1%	47.9%	52.1%	8.5%	14.4%	47.7%	60.6%
   Percentage of pupils entering the English Baccalaureate	2018/19	50.6%	56.1%	49.1%	59.0%	43.6%	46.5%	44.1%	50.5%	37.4%	61.6%	61.6%	44.3%	48.7%	50.6%	45.5%	32.5%	51.1%	51.1%	37.5%	49.5%	11.1%	15.2%	36.6%	46.9%
   	2019/20	51.9%	55.9%	52.8%	60.0%	44.4%	47.7%	46.8%	50.9%	39.0%	64.2%	64.2%	44.3%	48.8%	49.1%	47.9%	32.5%	51.1%	51.1%	36.9%	49.9%	10.9%	20.6%	35.9%	48.7%
   	2020/21	50.9%	52.9%	53.5%	58.7%	43.9%	45.7%	43.6%	48.8%	36.7%	62.4%	62.4%	41.8%	46.0%	47.0%	41.8%	31.4%	51.0%	51.0%	35.7%	49.2%	10.5%	20.5%	34.7%	44.4%
   	2021/22	51.3%	54.1%	53.1%	58.8%	44.2%	46.8%	44.0%	50.0%	37.4%	61.8%	61.8%	42.1%	46.8%	47.1%	42.9%	30.4%	51.5%	51.5%	35.4%	51.3%	13.1%	11.8%	34.1%	44.8%
   Average Attainment 8 score of all pupils	2018/19	51.2	54.5	50.6	57.3	46.2	44.9	43.0	47.4	39.4	64.3	64.3	47.6	49.2	53.2	47.4	41.0	47.3	47.3	46.1	46.8	19.1	26.6	46.2	52.1
   	2019/20	54.5	57.4	53.9	60.7	49.3	48.9	47.4	50.9	44.0	67.6	67.6	50.8	52.1	55.9	51.1	44.8	50.6	50.6	49.7	50.7	23.3	31.8	49.7	55.6
   	2020/21	55.8	58.6	55.6	62.0	50.5	50.0	48.3	52.2	44.0	69.2	69.2	51.3	53.0	56.2	50.6	45.0	51.7	51.7	50.2	52.1	22.7	30.7	50.2	55.7
   	2021/22	54.6	57.0	54.4	61.3	49.1	48.6	46.9	50.9	41.7	66.1	66.1	49.4	51.2	54.8	49.0	42.1	49.6	49.6	47.8	50.8	21.0	29.2	47.7	54.7
   Average EBacc APS score per pupil	2018/19	4.57	4.97	4.45	5.24	4.03	3.94	3.76	4.21	3.33	5.99	5.99	4.19	4.39	4.77	4.19	3.46	4.30	4.30	4.00	4.25	1.47	2.14	3.99	4.63
   	2019/20	4.89	5.24	4.81	5.57	4.33	4.32	4.18	4.54	3.75	6.31	6.31	4.48	4.65	5.00	4.54	3.81	4.59	4.59	4.31	4.60	1.83	2.68	4.30	4.96
   	2020/21	5.02	5.33	4.98	5.69	4.46	4.42	4.24	4.66	3.75	6.44	6.44	4.52	4.72	5.02	4.45	3.81	4.71	4.71	4.35	4.72	1.78	2.57	4.33	4.96
   	2021/22	4.91	5.18	4.87	5.61	4.34	4.31	4.14	4.54	3.58	6.16	6.16	4.36	4.57	4.90	4.32	3.58	4.53	4.53	4.16	4.61	1.68	2.34	4.13	4.85

   Footnotes

   1. All pupils with a primary need (from 2014/15 onwards this consisted of pupils flagged as SEN with a statement, EHC plan, SEN support).
   2. 'Total' includes pupils for whom Free School Meal eligibility (FSM), Special Educational Needs status (SEN provision) or SEN primary need could not be determined. This figure also includes pupils at further education colleges: as FE colleges do not complete the school census, we do not have matched pupil characteristics data of pupils in FE colleges and therefore these pupils are not included in characteristics breakdowns. This means that there are some cases where the individual characteristics breakdowns will not add up to the all pupils figure.

   Save table

   Related information

   • Publication: Key stage 4 performance, Academic year 2021/22