Guidance

Schools block dataset technical specification: 2021 to 2022

Published 15 December 2020

This guidance was withdrawn on 20 December 2022

This page has been withdrawn as it is out of date. Please see our latest guidance on the authority proforma tool (APT).

Applies to England

1. Introduction

This document provides a full technical specification for the school-level data that has been made available to local authorities in the prepopulated schools block data sheet of the authority proforma tool (APT), for use in allocating their 2021 to 2022 schools block funding to schools. We have updated the 2021 to 2022 dataset to use the October 2020 census data. These changes are summarised below.

This note accompanies the separate guidance on how to complete the authority proforma tool.

The data contained in the December 2020 APT is based on autumn (October) 2020 school census returns, or other existing data collections. The table below outlines what data will be provided, and summarises the source data for each indicator. The indicators and their descriptions were set out in the Schools operational guide: 2021 to 2022. This document now provides more explanation on the construction of the data.

Data	Breakdown	Data source
School list	LAESTAB, URN, local authority, phase, primary year groups, secondary year groups.	Mainstream schools on autumn 2020 census. URN is matched from get information about schools (GIAS).
Academy type	Recoupment Academy or 0 (0 is a maintained school).	Taken from the department’s records – showing status as at 31 October 2020.
London fringe	1 or 1.0156360164	District as mapped from the school postcode in the autumn 2020 census.
Year groups	Primary and secondary for middle schools. Primary and secondary for all schools. Key stage 3 and key stage 4 for secondary schools.	Autumn 2020 census.
Number on roll (NOR)	Primary, secondary, reception, years 1 to 6, key stage 3, key stage 4, year 7, year 8, year 9, year 10 and year 11.	Autumn 2020 census.
Reception difference	0 or positive value.	Difference between on roll in Year R, autumn 2019 census and spring 2020 census. If difference is less than zero then reception uplift will be zero.
Free school meals (FSM)	Separate primary/secondary.	Autumn 2020 census.
FSM6	Separate primary/secondary.	2020 to 2021 FSM6 data mapped to the spring 2020 census. Where FSM6 ratio is lower than the FSM ratio it will be increased to the same value.
Income deprivation affecting children index (IDACI)	Split into 7 different bands (G to A, where A is the highest level of deprivation), separate primary/secondary. Funding cannot be allocated to band G.	This has been updated for the 2021 to 2022 schools block to use 2019 IDACI data. This is matched to the autumn 2020 census using pupil’s postcodes.
English as an additional language (EAL)	First , first to second, first to third year in system; separate primary/secondary.	Autumn 2020 census for language group, plus autumn 2017, 2018 and 2019 censuses. Mapping on UPN for on-roll records.
Looked after children (LAC)	Aggregated information indicating looked-after children (at 31 March 2020).	SSDA903 March 2020 data mapped onto the spring 2020 census via the National Pupil Database (NPD).
Primary phase low prior attainment	Year 1 to year 6 who did not achieve a good level of development.	Early years foundation stage profile (EYFSP) total score mapped to the autumn 2020 census. Mapping on UPN only. As there were no EYFSP tests this year the year 1 ratio will use the year 2 ratio or the local authority year 2 average.
Secondary phase low prior attainment	Year 7, year 8, year 9, year 10 and year 11 who did not achieve the expected level of attainment.	Key stage 2 (KS2) attainment data mapped to the autumn 2020 census. Mapping on UPN only. As there were no KS2 tests this year the year 7 ratio will use the year 8 ratio or the local authority year 8 average.
Mobility	First entry for the pupil at the school, or any predecessor school where appropriate, was in last 3 academic years; separate primary/secondary.	Autumn 2020 Census.
Sparsity	Primary, secondary, middle, all-through.	Autumn 2020 census, GIAS.

The autumn 2020 census day was 1 October 2020 and therefore the data reflects the status of schools at that date. All data for maintained schools will have been first approved by the local authority prior to being used by the department.

The pupil-level indicators for numbers on roll, IDACI, free school meals (FSM) eligibility and mobility have been calculated from data collected in the autumn 2020 census. This data has also been linked, using the UPN collected in the autumn census, to data held in the department’s national pupil database (NPD) to create the EAL and prior attainment indicators. This data extract has been prepared prior to the autumn 2020 census being formally matched into the NPD. The IDACI indicators are based on the relationship between pupil postcode, local authority district and IDACI ranks.

Changes made to the dataset for the 2021 to 2022 formula, compared to that used for the 2020 to 2021 formula, are:

• following the cancellation of 2020 primary school assessments due to coronavirus (covid-19), the low prior attainment (LPA) ratios for years 1 and 7 for each school have been updated using the corresponding schools ratio for pupils in years 2 and 8 or, for new schools, the local authority average for year 2 or year 8
• we have used 2019 data from the IDACI in place of 2015 data—we have changed the basis on which we assign pupils to the 7 IDACI bands: they are now assigned based on rank rather than score (for example, band A now consists of pupils in the most deprived 2.5% of lower super output areas (LSOAs), instead of consisting of pupils in LSOAs with an IDACI score greater than 0.5)

More information about the school census can be found in the school census guidance. If you have any queries about this specification, please contact us.

1.1 Using the data to allocate school budgets

For each of the pupil-led factors there are one or more allowable indicators. The pupil-led factors are:

• age-weighted pupil units (AWPU)
• deprivation
• English as an additional language (EAL)
• prior attainment
• mobility
• looked after children (LAC)

For AWPU, the indicator to be used is the number on roll (NOR) for primary, key stage 3 (KS3) and key stage 4 (KS4). For the other indicators, schools attract funding through pupil units. These pupil units are calculated as the appropriate NOR weighted by the proportion of pupils that qualify under the indicator. So, the pupil units for primary FSM would be given by:

• primary NOR multiplied by the number of primary pupils eligible for FSM divided by the number of primary pupils with a valid FSM response

Or, from the supplied dataset:

• NOR primary * primary FSM proportion

All the indicator data (except NOR) is presented in the APT in the form of a decimal proportion that should be applied to the NOR. This means that if authorities record a change to a school’s NOR figures in the ‘Inputs & Adjustments’ sheet of the APT (see the circumstances described on the next page in which adjustments to NOR figures can be made), then the proportion in the schools block dataset can still be multiplied by them to derive the appropriate pupil units. The calculations of the proportions always exclude pupils with a NULL value for the required response. This, plus the facility for local authorities to alter the NOR, can result in pupil units for the indicators which are not whole numbers. Values in the schools block are shown to 2 decimal places but this is presentational only and numbers are not rounded.

2. Local adjustments to the supplied schools block data

In some cases it will be necessary to use a local calculation or estimate for an indicator, based on the technical descriptions given in this document, to ensure the data used in the APT to calculate school budgets is representative. This only applies to individual schools. This section describes when and how this should take place. Adjustments should be recorded via the ‘Inputs & Adjustments’ sheet of the APT, and a clear explanation for the change must be provided in each case.

2.1 Schools undergoing change

In the case of a planned amalgamation, the data should be taken from each of the schools as they appear in the ‘Schools Block Data’ sheet of the APT and then merged using weighted sums for each of the factors. In the example shown in the table below, Old Street Infants and Old Street Juniors are combining to form New Street Primary. The primary FSM proportion for the new school is calculated as the weighted average of the relevant proportion figures for the former schools. A similar calculation should be done for all the other pupil-led factors.

School	NOR primary	Primary FSM proportion
Old Street Infants	300	0.10
Old Street Juniors	100	0.05
New street Primary	300 + 100 = 400	((300 * 0.10) + (100 * 0.05)) / (300 + 100) = 0.0875

In the case of a new school with no relevant predecessors, or a school converting from the private sector, a local estimate should be used based on similar schools in the local authority for the first year.

2.2 Individual data points that are not representative

For some schools, the indicator data contained in the schools block dataset will not be representative. In this case, it would be reasonable to use a local estimate for the indicator. Making such a change does not require prior ESFA approval, but clear explanations for any such changes must be provided on the ‘Inputs & Adjustments’ sheet of the APT.

2.3 Anomalous primary/secondary pupils

Where a primary school has only one or two secondary phase pupils in the ‘Schools Block Data’ sheet of the APT (or conversely for a secondary school with a small number of primary phase pupils) this may suggest a school census recording error. Local authorities may wish to verify whether these are errors, and if so, amend individual schools’ NOR data accordingly, to avoid incorrect formula allocations. Making such a change does not require prior ESFA approval, but clear explanations for any such changes must be provided on the ‘Inputs & Adjustments’ sheet of the APT.

2.4 Sparsity distances

Local authorities can make exceptional applications for schools that would have had significantly higher distances if road distances had been used instead of straight line distances, and would not otherwise have qualified for the sparsity factor.

Similarly, exceptional applications can be made for schools that open after the distances have been calculated. An existing school that qualifies for sparsity funding in the data provided will not lose that funding in-year if a new school opens nearby. For schools that may qualify for sparsity funding as a result of another school nearby closing, an exceptional application should be agreed with the relevant schools forum, and submitted to ESFA for approval.

3. Schools block schools and pupils

All mainstream schools that are recorded on the autumn 2020 census are included in the ‘Schools Block Data’ sheet of the APT. This covers all mainstream schools open on census date except the 2 city technology colleges. Special schools, alternative provision (AP) schools, pupil referral units (PRUs), early years providers and other institutions without schools block pupils are excluded.

The school filters applied to the census data to identify the schools included in the dataset are:

• the school type code is a value less than 50 or is equal to 55
• the phase is either ‘PS’ (primary, including academies), ‘MP’ (middle-deemed primary), ‘MS’ (middle-deemed secondary), ‘SS’ (secondary, including academies), or ‘AT’ (all-through excluding PRUs)

The pupil filters applied ensure that only pupils aged 4 or above at the start of the 2020 to 2021 academic year that are in national curriculum year groups R to 11, or pupils aged 4 to 15 in year group X are counted. Note that pupils are counted as headcount not full-time equivalent.

These are:

• On_Roll = 1 – the pupil must be recorded in the autumn 2020 census as on roll at a school passing the school-level filter
• EnrolStatus in (‘C’, ‘M’) – the pupil’s on-roll status at the school is either ‘C’ or ‘M’; the pupil must either be solely registered at the school, or if dual-registered have their main registration at the school

and then either of:

• NCYearActual in (‘R’, ‘1’, ‘2’, ‘3’, ‘4’, ‘5’, ‘6’, ‘7’, ‘8’, ‘9’, ‘10’, ‘11’) and AgeAtStartOfAcademicYear >= 4 – the pupil must be recorded in the autumn 2020 census as in national curriculum year groups R to 11 inclusive, and the pupil must be aged 4 or more as at 31 August 2020
• NCYearActual = ‘X’ and AgeAtStartOfAcademicYear >= 4 and AgeAtStartOfAcademicYear < 16) – the pupil must be recorded in the autumn 2020 census as in year X (not following the national curriculum) and the pupil must be aged between 4 and 15 as at 31 August 2020

The dataset only includes pupils which pass both the school and pupil filters.

3.1 School information

This section explains how the fields in the dataset which provide information about each school are obtained. It also describes how the London fringe, NOR and reception difference figures are produced.

These fields are taken from the autumn 2020 census, except for the URN and the school name which are mapped from GIAS:

• URN
• LAEstab
• school name
• phase
• number of primary year groups for middle schools
• number of secondary year groups for middle schools
• number of primary year groups for all schools
• number of secondary year groups for all schools
• number of key stage 3 year groups for all schools
• number of key stage 4 year groups for all schools

Academy type

This field contains the value 0 for maintained schools and ‘Recoupment Academy’ for academies. Flagging these in the schools block dataset aims to facilitate correct recording. The valid values for this field are:

• Recoupment Academy
• 0

London fringe

For the 5 local authorities who have some of their schools within the London fringe area (Buckinghamshire, Essex, Hertfordshire, Kent and West Sussex), we have determined an appropriate uplift that should be applied to the affected schools’ budgets. The uplift was calculated using the specific cost of teaching staff within the different pay band areas and the proportion of school expenditure that goes on teaching staff. Using the national distribution of teaching staff by pay band spine point (School Workforce Census, 2013) and spine point salary data (School Teachers’ Pay and Conditions Document 2013) we calculated the average uplift between the London fringe and the rest of England teacher pay band areas to be 2.96%.

Analysis of the financial year 2012 to 2013 section 251 outturn reporting lines indicated that 53% of school expenditure goes on teaching staff costs. On this basis, the uplift for London fringe schools was 53% of 2.96% which gives a value of 1.56% to be applied to the school formula funding – excluding factors that should be paid as actual, such as rates, private finance initiative (PFI), split-site and exceptional circumstances.

The districts in the 5 affected local authorities that fall within the London fringe are:

• Buckinghamshire: Chiltern, South Bucks
• Essex: Basildon, Brentwood, Epping Forest, Harlow
• Hertfordshire: Broxbourne, Dacorum, East Hertfordshire, Hertsmere, St Albans, Three Rivers, Watford, Welwyn Hatfield
• Kent: Dartford, Sevenoaks
• West Sussex: Crawley

All fringe schools will have the value 1.0156360164 for this indicator; all other schools will have the value 1.

School number on roll

• NOR
• NOR Primary
• NOR Reception
• NOR Y1-6
• NOR Secondary
• NOR KS3
• NOR KS4
• NOR Y7
• NOR Y8
• NOR Y9
• NOR Y10
• NOR Y11

Pupils have been counted by headcount, irrespective of whether or not they are part-time. Pupils recorded in national curriculum year groups R to 6 are classed as in the primary phase and those in year groups 7 to 11 are classed as in the secondary phase. Primary pupils are additionally split into reception pupils and pupils in years 1 to 6 and secondary pupils are additionally split into key stage groups: KS3 (years 7 to 9) and KS4 (years 10 to 11) and individual years 7 to 11.

The NOR figures are calculated from the autumn 2020 census as the number of pupils at each school passing the pupil filters described in the ‘Schools block schools and pupils’ section of this document, whose national curriculum year group is in the relevant range.

Pupils recorded in year X in the October census aged between 4 and 15 are now included in the data. These pupils are allocated to a year group based on their age at the start of the academic year. The table below shows the year to which these pupils will be assigned.

Year group X pupils

Age at start of academic year	4	5	6	7	8	9	10	11	12	13	14	15
Year group X pupils	R	1	2	3	4	5	6	7	8	9	10	11

For total NOR, the range is years R to 11 (including pupils in year X allocated to years R to 11).

Reception difference

The difference between the number of pupils on roll in reception (only those pupils aged 4 and over at the start of the academic year) in each school between the autumn 2019 and spring 2020 censuses is provided in the dataset. This is calculated by subtracting the total number of year R pupils in autumn 2019 from the total in spring 2020, or given as zero if the result of this calculation is negative. If there are no year R pupils at the school then the result is 0. This is illustrated in the table below.

URN	October 2019 (1) Number of pupils in year R	January 2020 (2) Number of pupils in year R	(2) – (1)	Reception difference
xxxx1	0	0	0	0
xxxx2	62	62	0	0
xxxx3	38	33	-5	0
xxxx4	55	62	7	7

3.2 Detailed specification for individual factors

For all the indicators, the NOR filters apply at pupil level. Where a pupil does not have a valid response for the indicator in the census or other data source, they are excluded when calculating the indicator. For example, a pupil with no postcode recorded on the census is discounted when calculating a school’s IDACI proportions. The data used for each indicator is taken from the October 2020 census unless otherwise indicated.

Deprivation

The allowable indicators are free school meals (FSM), free school meals Ever 6 (FSM6) and IDACI.

Free school meals

• Primary FSM Proportion
• Secondary FSM Proportion

The proportion of pupils eligible for free school meals according to the autumn 2020 census has been aggregated to school level, with separate indicators for primary and secondary phase pupils.

Free school meals Ever 6

• Primary Ever 6 Proportion
• Secondary Ever 6 Proportion

This counts the proportion of pupils on roll on the spring 2020 census that were recorded as eligible for FSM in any of the censuses (autumn, spring and summer, including the alternative provision (AP) and pupil referral unit (PRU) census) over the previous 6 years. This uses the same data as that used for allocating the pupil premium. As a consequence, schools that have opened since the spring 2020 census will not have FSM Ever 6 data. More information on this indicator and the pupil premium can be found in pupil premium funding and accountability for schools guidance.

Where a school has an FSM Ever 6 ratio lower than their FSM ratio the FSM Ever 6 ratio will be increased to the level of the FSM ratio.

IDACI

• IDACI Primary Proportion Band G
• IDACI Primary Proportion Band F
• IDACI Primary Proportion Band E
• IDACI Primary Proportion Band D
• IDACI Primary Proportion Band C
• IDACI Primary Proportion Band B
• IDACI Primary Proportion Band A
• IDACI Secondary Proportion Band G
• IDACI Secondary Proportion Band F
• IDACI Secondary Proportion Band E
• IDACI Secondary Proportion Band D
• IDACI Secondary Proportion Band C
• IDACI Secondary Proportion Band B
• IDACI Secondary Proportion Band A

The income deprivation affecting children index (IDACI) is a subset of the indices of multiple deprivation (IMD). It is an area-based measure defined at the level of lower super output area (LSOA) and is based on the data published in September 2019. It is a score between 0 and 1, which can be interpreted as the proportion of children aged under 16 in the LSOA which are in income deprived households. Each LSOA is then assigned a rank, with 1 being the most deprived. Further information on the updated IDACI figures can be found through the Ministry of Housing, Communities and Local Government (MHCLG) statistical release.

Only pupils living in areas with an IDACI rank in the 37.5% most deprived can be assigned deprivation funding through this factor, meaning there are 6 bands which can be given different unit values each for primary, and 6 for secondary phase pupils.

IDACI rank	IDACI band
Pupils in the most deprived 2.5% of LSOAs	A
Pupils in the next 5% most deprived LSOAs	B
Pupils in the next 5% most deprived LSOAs	C
Pupils in the next 5% most deprived LSOAs	D
Pupils in the next 10% most deprived LSOAs	E
Pupils in the next 10% most deprived LSOAs	F
Pupils in the remaining 62.5% LSOAs	G

For each of the bands, the proportion of pupils on the autumn 2020 census with valid IDACI details has been aggregated to school level, with separate indicators for primary and secondary phase pupils.

English as an additional language (EAL)

• EAL 1 Primary Proportion
• EAL 2 Primary Proportion
• EAL 3 Primary Proportion
• EAL 1 Secondary Proportion
• EAL 2 Secondary Proportion
• EAL 3 Secondary Proportion

There are 3 allowable indicators for EAL, all based on the language code given in the census. Both the short code set and the long code set are grouped so that pupils with an English code (including believed to be English) are “1_ENG”, pupils whose language is unknown or undeclared are “3_UNK” and all other pupils are “2_OTH”.

Pupils attract EAL funding if they are grouped as “2_OTH” from the Language Code on the autumn 2020 census and can be shown to have been in the school system for less than one year, less than 2 years or less than 3 years. This is achieved by deriving a pupil level “years in system” count based on the pupil’s presence in the autumn 2017, autumn 2018 and autumn 2019 censuses. Using the years in system indicator and the current national curriculum year, an estimated national curriculum start year can be derived. This is important, as the indicator is offset for pupils who were in year R, N1 or N2 for any of the years covered. This is done because language did not previously have to be declared in the census for pupils aged less than 5, causing the data for pupils when in year R to be partial and unrepresentative. Also, for this reason pupils in year R are excluded from the calculation of the ratios. Pupils grouped as “3_UNK” are also excluded.

A school’s EAL 1 Primary Proportion is calculated as the number of pupils in year groups R to 6 with the EAL 1 value, divided by the total number of pupils in years R to 6 with the EAL 0, 1, 2 or 3 value (pupils not given a category are excluded).

A school’s EAL 2 Primary Proportion is calculated as the number of pupils in year groups R to 6 with the EAL 1 or EAL 2 value, divided by the total number of pupils in years R to 6 with the EAL 0, 1, 2 or 3 value.

A school’s EAL 3 Primary Proportion is calculated as the number of pupils in year groups R to 6 with the EAL 1, EAL 2 or EAL 3 value, divided by the total number of pupils in years R to 6 with the EAL 0, 1, 2 or 3 value.

Corresponding calculations are done to obtain the secondary proportions.

Looked-after children

• LAC X Proportion

Details of children looked after by a local authority are returned to the department on the annual SSDA903 collection. We have produced an extract of the SSDA903 2020 looked after children data collected from local authorities indicating whether a child has been looked after for one day or more on 31 March 2020.

The data is matched into the National Pupil Database using the unique pupil number (UPN), and extracts are obtained showing where the children were on roll based on the spring 2020 census. The UPN is the main field used for matching purposes but other information about the child is also used such as date of birth, gender, ethnicity and responsible local authority.

The school-level weighting for this indicator is given by dividing the number of matched pupils by the NOR in the spring 2020 census.

Prior attainment

The early years foundation stage profile (EYFSP) results and key stage 2 (KS2) attainment data are allowable indicators for primary and secondary prior attainment respectively.

Primary prior attainment

For primary schools, funding can be targeted at pupils who did not achieve a good level of development on the new EYFSP.

• Low Attainment under new EYFSP Proportion

Pupils in the autumn 2020 census in years 2 to 6 are matched onto the new EYFSP data using their UPN. For pupils in year 1, as no tests were carried out in 2020, the year 2 proportion is used if available. If the school has no year 2 pupils then the local authority average for year 2 is used. A school’s proportion in the dataset is the number of pupils in years 1 to 6 recorded as not achieving a good level of development divided by the number of pupils in years 1 to 6 recorded in the attainment data. Pupils who could not be matched onto the attainment data, or for whom the attainment data does not provide a result, are excluded from this calculation.

Secondary prior attainment

• Low Attainment Secondary Proportion Year 7
• Low Attainment Secondary Proportion Year 8
• Low Attainment Secondary Proportion Year 9
• Low Attainment Secondary Proportion Year 10
• Low Attainment Secondary Proportion Year 11

For secondary schools funding can be targeted at pupils who are below the expected standard of achievement in either English reading, English teacher-assessed writing, or mathematics at KS2. Specifically, this means pupils scoring ‘B’ or ‘NS’ or ‘CA’ with a scaled score below 100 (after any adjustment) in mathematics or English reading; and pupils scoring ‘BLW’, ‘HNM’, ‘PKF’, ‘PKE’, ‘PKG’ or ‘WTS’ in English teacher assessed writing.

For each of the years 8 to 11, only pupils who have undertaken the assessment have been considered in calculating each school’s proportion. Pupils marked as absent or with a result other than those listed are excluded from this calculation. Pupils in years 8 to 11 in the autumn 2020 census who could not be matched onto the KS2 attainment data are also excluded.

For pupils in year 7, as there were no tests in 2020, the year 8 proportion is used if available. If the school has no year 8 pupils then the local authority average for year 8 is used.

Mobility

• Mobility Primary Proportion
• Mobility Secondary Proportion

A separate primary and secondary school level proportion is provided based on the number of pupils whose first census entry at their current school (or any of its predecessors) is within the previous 3 academic years and whose first entry was not in an October census. If the pupil started in reception then if their first entry is October or January they will not be counted. Pupils who started the school in nursery classes are not mobile.

Any pupil appearing at a new school in the first census after its opening data will not be counted as mobile.

Any pupils which are duplicated, so appearing against multiple schools, will be given null values (so will be excluded from the calculation of the mobility ratio).

This table shows examples of determining whether pupils are classed as mobile.

Pupil	NC year actual	First census pupil is registered at school (only covers previous 9 returns)	Academic year of first census	In previous 3 academic years?	Start year	School (or predecessor) opening date	Normal entry month	Mobility flag
1	R	October 2020	2020 to 2021	Yes	R	September 2002	Yes	0
2	3	January 2018	2017 to 2018	Yes	R	August 2013	Yes	0
3	5	January 2019	2018 to 2019	Yes	3	January 2015	No	1
4	5	May 2018	2017 to 2018	Yes	2	January 2011	No	1
5	7	October 2020	2020 to 2021	Yes	7	September 2013	Yes	0
6	8	October 2018	2018 to 2019	Yes	6	August 2011	Yes	0
7	8	May 2018	2017 to 2018	Yes	5	September 2002	No	1
8	9	January 2019	2019 to 2020	Yes	8	December 2018	Yes	0

Funding may be targeted only at those schools experiencing pupil mobility above a 6% threshold, and funding is not provided for the first 6% of mobile pupils. Each school’s mobility proportions given in the ‘Schools Block Data’ sheet of the APT are their actual mobility proportions as calculated; the deduction of the first 6% is done automatically by the APT’s calculations.

Sparsity

• Primary Sparsity av. Distance to 2nd school
• Secondary Sparsity av. Distance to 2nd school

A sparsity distance is provided for each school, which measures the straight-line distance that pupils live from their second nearest school. For each school, those pupils for whom it is their closest school are identified, and then the average (mean) distance to the second nearest school for these pupils is calculated. This is the school’s sparsity distance and is calculated in miles.

For the purposes of this factor, selective grammar schools are not considered when identifying the second nearest school, but faith schools are included. Distances are calculated using the crow flies straight line distance from a pupil’s postcode to a school’s postcode. Postcode information is taken from the autumn 2020 census for pupils and GIAS for schools. Straight-line distances are calculated by deriving easting and northing coordinates from the postcodes, then applying Pythagoras’s Theorem.

Where there is at least one other compatible school in the same postcode as the pupil’s nearest compatible school, all compatible schools in this postcode are considered to be this pupil’s ‘nearest schools’. The distance to the pupil’s second nearest school is then the same as the distance to the nearest school. Pupils living outside of England are excluded from the sparsity distance calculations. For these pupils, the calculations would pick up each pupil’s nearest and second nearest English schools, and not necessarily their actual nearest schools, and would likely artificially inflate their sparsity distances. Local authorities can seek ESFA approval to record an adjusted sparsity distance on the ‘Inputs & Adjustments’ sheet of the APT for a school if they think that excluding pupils resident outside of England has distorted the resulting figure.

The process for producing these figures was as follows:

1. Using the autumn 2020 census, eligible pupils attending schools in the schools block dataset were identified. Schools were identified together with the age range of pupil that they admit. These datasets contain postcode coordinates for both pupils and schools.
2. These coordinates were used to identify the nearest and second nearest school for each pupil, and the distance in miles that they live from both schools. These may not be the schools which the pupil currently attends.
3. We then identified the set of pupils who live nearest to each school.
4. For each set of pupils, we calculated the average (mean) distance to the second nearest school. This is the school’s sparsity distance.

A school may attract sparsity funding if it is:

• primary and has fewer than 21.4 pupils on average in each year group, and has a sparsity distance that is greater than or equal to 2 miles
• secondary and has fewer than 120 pupils on average in each year group, and has a sparsity distance that is greater than or equal to 3 miles
• a middle school and has fewer than 69.2 pupils on average in each year group, and has a sparsity distance that is greater than or equal to 2 miles
• an all-through school and has fewer than 62.5 pupils on average in each year group, and has a sparsity distance that is greater than or equal to 2 miles

Local authorities may, if they wish, reduce the pupil numbers and increase the distance criteria (they may narrow the criteria), but the criteria quoted above may not be widened. Exceptional applications can also be made on behalf of existing schools that do not attract sparsity funding using the above criteria.