Methodology and Data Source Information
Data sources
The heat maps in this section of the website are based on publicly available data from the Department for Education’s Performance data tables. The maps use performance data at the school and local authority level for three years, 2016/17, 2017/18 and 2018/19.
The information available in the performance data include school information such as postcode, total number of pupils on roll, number of EAL pupils, school type, deprivation (% Free School Meals), and attainment and progress data at Key Stage 2 (KS2) and Key Stage 4 (KS4). Key variables mapped include:
- KS2: Percentage of EAL pupils reaching the expected standard in reading, writing and maths.
- KS2: Reading, writing and mathematics progress.
- KS4: Attainment 8 score.
- KS4: Progress 8 score.
Additional data included in the mapping exercise, at the local authority level:
- The Income Deprivation Affecting Children Index (IDACI).
- English proficiency of EAL pupils¹.
- Descriptive statistics for the key variables are included in Appendix A (below). At the school level, attainment data was available for two thirds of all primary schools in England (66%, n=17,938) and for 70% of secondary settings (n=3,570).
- In KS2, progress data was only available for around a quarter of all primary settings (27%, n=17,938). This skews the available data towards settings with greater proportions of EAL pupils. Two fifths are EAL pupils in the progress sub-sample (40%, n=4,535), compared to the average proportion of EAL pupils overall (16%, n=17,938).
- A calculated variable is included in the analysis, relative attainment which expresses the average attainment of EAL pupils (at the school and local authority level) relative to the average attainment of all pupils. At the school level, this variable is only calculated where we have three full years of data for the numerator and the denominator.²
Methods
Cloud Chamber collated data sets from three years (using the school’s unique reference number) and took a simple mean average of each of the data points. This averaging of data minimises cohort specific variation from the school data, presenting a more consistent set of data at the school level (given some data might be missing).
Note that the data informing the mapping work only includes maintained schools and academies. Independent schools and FE colleges are not available in the performance data and are therefore not included in the analysis. Data is for English schools only.
The maps use the following types of visualisations:
- Choropleth maps: a type of thematic map in which a set of pre-defined areas are coloured in proportion to a statistical variable. We use these maps to visualise a range of data at the local authority level (unitary/upper-tier).
- Heat maps: or a density map use different gradations of colour to represent clustering/density of data points on the map. We use heat maps to visualise school-level data, using postcode information in the performance data.
The main analytical technique is to produce visualisations based on contrasting top and bottom deciles or quartiles of data (top or bottom 10%, or decile, of the distribution). Visualisations are created and hosted in Tableau Public.
The KS2 and KS4 Composite indicator maps combines four factors, equally weighted to indicate where need might be highest among local authority areas. A Z-transformation was used and a simple average of the proportion of pupils who use EAL (%EAL), the attainment of pupils who use EAL, the proportion of pupils who have reached competency or fluency in English, and the proportion of children living in deprived neighbourhoods (IDACI).
Appendix A: Summary data
Summary data for the measures mapped in visualisations. Data is organised by level of aggregation (school and local authority), and key stage.
School level - KS2
Measure | N | Mean | Median | Stdev | 10% | 90% |
---|---|---|---|---|---|---|
% EAL pupils | 18,079 | 16.1 | 6.6 | 21.2 | 0.66 | 49.3 |
% EAL achieving the expected standard in reading, writing and maths (A) | 11,830 | 0.400 | 0.395 | 0.194 | 0.14 | 0.67 |
% achieving the expected standard in reading, writing and maths (B) | 13,233 | 0.647 | 0.657 | 0.136 | 0.473 | 0.813 |
Relative attainment (A/B) | 7,976 | 0.642 | 0.286 | 2.913 | 0.218 | 0.959 |
Reading progress | 4,773 | 0.906 | 0.9 | 2.67 | -2.5 | 4.3 |
Writing progress | 4,783 | 1.354 | 1.4 | 2.43 | -1.6 | 4.3 |
Maths progress | 4,771 | 2.212 | 2.2 | 2.50 | -0.9 | 5.4 |
School level - KS4
Measure | N | Mean | Median | Stdev | 10% | 90% |
---|---|---|---|---|---|---|
Attainment 8 (EAL) (A) | 2,502 | 47.7 | 48.1 | 13.1 | 37.4 | 60.4 |
Attainment 8 (B) | 3,165 | 45.2 | 45.6 | 11.6 | 34.9 | 56.3 |
Progress 8 (EAL) | 2,181 | 0.538 | 0.550 | 0.453 | 0.0 | 1.097 |
Relative attainment (A/B) | 2,410 | 1.095 | 1.042 | 0.282 | 0.942 | 1.21 |
Local authority level - KS2
Measure | N | Mean | Median | Stdev | 10% | 90% |
---|---|---|---|---|---|---|
% EAL achieving the expected standard in reading, writing and maths (A) | 151 | 0.656 | 0.650 | 0.070 | 0.552 | 0.740 |
% achieving the expected standard in reading, writing and maths (B) | 152 | 0.653 | 0.650 | 0.048 | 0.600 | 0.710 |
Relative attainment (A/B) | 151 | 1.006 | 1.000 | 0.107 | 0.874 | 1.166 |
Reading progress (EAL) | 151 | 0.799 | 0.700 | 0.944 | -0.200 | 1.800 |
Writing progress (EAL) | 151 | 1.679 | 1.600 | 1.221 | 0.320 | 3.180 |
Maths progress (EAL) | 151 | 2.363 | 2.200 | 1.197 | 1.100 | 3.780 |
Local authority level - KS4
Measure | N | Mean | Median | Stdev | 10% | 90% |
---|---|---|---|---|---|---|
Attainment 8 (EAL) (A) | 149 | 48.4 | 48.4 | 4.2 | 43.3 | 53.7 |
Attainment 8 (B) | 150 | 46.7 | 46.1 | 3.9 | 42.7 | 51.6 |
Progress 8 (EAL) | 149 | 0.6 | 0.6 | 0.2 | 0.27 | 0.82 |
Relative attainment (A/B) | 149 | 1.041 | 1.035 | 0.067 | 0.966 | 1.127 |
Local authority level - Contextual
Measure | N | Mean | Median | Stdev | 10% | 90% |
---|---|---|---|---|---|---|
% EAL pupils | 147 | 0.230 | 0.160 | 0.191 | 0.04 | 0.532 |
English proficiency | 147 | 0.610 | 0.610 | 0.080 | 0.518 | 0.71 |
IDACI | 147 | 0.735 | 0.800 | 0.184 | 0.488 | 0.94 |