Guidance

Schools block technical specification 2024 to 2025: for use in schools block allocations

Published 19 December 2023

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’ worksheet of the authority proforma tool (APT), for use in allocating their 2024 to 2025 schools block funding for schools.

This note accompanies the separate guidance on how to complete the APT.

The schools block data contained in the December 2023 APT is based on the autumn 2023 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: 2024 to 2025. This document now provides more explanation on the construction of the data.

Data	Breakdown	Data source
School list	Local authority, LAEstab, unique reference number (URN), school name, phase.	Mainstream schools on the autumn 2023 census. The URN and school name are matched from get information about schools (GIAS).
Academy type	Recoupment academy or 0 (0 is a maintained school).	Taken from the Department for Education’s (DfE’s) records – showing the status on the autumn 2023 census date.
London fringe	1 or: Buckinghamshire: 1.0175; Essex: 1.0345; Kent: 1.0375; Hertfordshire: 1.031; West Sussex: 1.0584	District as mapped from the school postcode in the autumn 2023 census. Due to the reorganisation in Buckinghamshire, lower super output areas (LSOAs) are mapped to the school postcode to identify eligible schools.
Year groups	Primary and secondary for middle schools. Primary, secondary, key stage 3 and key stage 4 for all schools.	Autumn 2023 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 2023 census.
Reception difference	Zero or positive value.	Difference between on roll in reception, autumn 2022 census and spring 2023 census. If the difference is less than zero then the reception uplift will be zero.
Free school meals (FSM)	Separate primary/secondary.	Autumn 2023 census.
Free school meals ever 6 (FSM6)	Separate primary/secondary.	Autumn 2023 census mapped to earlier census returns to identify any period of eligibility in the 6-year period.
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. Separate primary/secondary.	2019 IDACI data. This is matched to the autumn 2023 census using pupil’s postcodes matched to LSOA.
English as an additional language (EAL)	First to third year in system at any school in England. Separate primary/secondary.	Autumn 2023 census for language group, plus the autumn 2020, 2021 and 2022 census returns. Mapping on unique pupil number (UPN) for on roll records.
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 2023 census. Mapping on UPN only. As there were no EYFSP tests in 2020 (year 3) and 2021 (year 4), year 3 will use year 2 data and year 4 will use the year 5 data or, where this is not available, the value from the 2023 to 2024 APT. Where neither of these are available, the local authority averages for year 2 and year 5 will be used.
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 attainment data mapped to the autumn 2023 census. Mapping on UPN only. As there were no key stage tests in 2020 (year 9) and 2021 (year 10), year 9 will use year 8 data and year 10 will use year 11 data or, where this is not available, the value from the 2023 to 2024 APT. Where neither of these are available the local authority average for year 9 and year 11 will be used.
Mobility	Primary or secondary. Pupil appears in census data at the same school as in the autumn 2023 census for the first time in a spring or summer census in 2021 or later. For pupils in reception only, those first appearing at their current school in the summer census are classed as mobile.	Autumn 2023 census mapped to earlier census returns.
Sparsity	Primary, secondary.	Autumn 2023 census, GIAS, Ordnance Survey, Office for National Statistics

Table 1: data included in the December 2023 APT

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

The pupil-level indicators for NOR and FSM eligibility have been calculated from data collected in the autumn 2023 census. We have also linked this data, using the UPN collected in the autumn census, to data held in DfE’s National Pupil Database (NPD) to create the FSM6, EAL, mobility and prior attainment indicators. The IDACI indicators are based on the relationship between pupil postcode, local authority district and 2019 IDACI ranks. The Department for Levelling Up, Housing and Communities (DLUHC) produced the IDACI data.

This data extract has been prepared prior to the autumn 2023 census being formally matched into the NPD.

The only changes made to the dataset for the 2024 to 2025 formula, compared to that used for the 2023 to 2024 formula, are:

• following the cancellation of the 2020 and 2021 primary school assessments, due to COVID-19, the low prior attainment (LPA) ratios for years 3, 4, 9 and 10 for each school have been updated using the corresponding school’s ratio for pupils in years 2, 5, 8 and 11 or, where that is not available, the ratio entered on the 2023 to 2024 APT. If neither of these are available, the local authority average for years 2, 5, 8 or year 11 will be used
• London fringe multipliers for the 5 local authorities partially within the fringe area are now based on the differential between the 2 area cost adjustment values used in the National Funding Formula (NFF).

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 at:

aptsubmissions.questions@education.gov.uk

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)
• FSM
• FSM6
• IDACI
• EAL
• prior attainment
• mobility

For AWPU, the indicator used is the NOR for primary, key stage 3 and key stage 4. 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.

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 primary NOR multiplied by the primary FSM proportion

All the indicator data (except NOR) is presented in the APT as a decimal proportion that should be applied to the NOR. This means that if you 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 produce 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 you 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. You should record adjustments on the ‘Inputs & Adjustments’ sheet of the APT and must provide a clear explanation for the change in each case.

2.1 Schools undergoing change

In the case of a planned amalgamation, you should take the data from each of the schools as they appear in the ‘Schools Block Data’ sheet of the APT and then merge, 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 of 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

Table 2: example weighted average calculation

In the case of a new school with no relevant predecessors, or a school converting from the private sector, you should use either the local authority average or a local estimate 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 for you to use a local estimate for the indicator. Making such a change does not require our prior approval, but you must provide clear explanations for any such changes on the APT ‘Inputs & Adjustments’ sheet.

2.3 Anomalous primary/secondary pupils

Where a primary school has only 1 or 2 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.

You 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 our prior approval, but you must provide clear explanations for any such changes on the ‘Inputs & Adjustments’ sheet of the APT.

2.4 Sparsity distances

You can make exceptional applications 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 because of another school nearby closing, you should agree an exceptional application with the relevant school’s forum and submit that to us for approval.

2.5 Schools block schools and pupils

All mainstream schools that are recorded on the autumn 2023 census are included in the APT’s ‘Schools Block Data’ sheet. This covers all mainstream schools open on the census date, except the 2 city technology colleges, Emmanuel College and Thomas Telford School. Special schools, alternative provision (AP) schools, pupil referral units (PRUs), early years providers and all 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 over at the start of the 2023 to 2024 academic year and that are in national curriculum year groups reception 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 2023 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

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 2023 census as in national curriculum year groups reception to 11 inclusive, and the pupil must be aged 4 or more on 31 August 2023
• NCYearActual = ‘X’ and AgeAtStartOfAcademicYear >= 4 and AgeAtStartOfAcademicYear < 16) – the pupil must be recorded in the autumn 2023 census as in year X (not following the national curriculum) and the pupil must be aged between 4 and 15 on 31 August 2023

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

The schools block data will allocate unresolved duplicates to each of the schools at which they are registered. This differs from the approach in the dedicated schools grant (DSG) calculation which apportions these pupils to ensure they are only funded once. This can result in slight variations in the number of pupils in each dataset.

2.6 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 2023 census, except for the URN and the school name which are matched 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. Using these in the schools block dataset aims to facilitate correct recording.

The valid values for this field are:

• Recoupment Academy
• 0

London fringe

There are 5 local authorities which have some, but not all, of their schools within the London fringe area. The districts in the 5 affected local authorities that fall within the London fringe are:

• Buckinghamshire - the former districts Chiltern and 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

Any schools located within these districts will be assigned a London fringe multiplier:

• Buckinghamshire: 1.0175
• Essex: 1.0345
• Kent: 1.0375
• Hertfordshire: 1.031
• West Sussex: 1.0584

For all other schools the multiplier will be 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 total, irrespective of whether they are part-time. Pupils recorded in national curriculum year groups reception to year 6 are classed as being in the primary phase and those in year groups year 7 to year 11 are classed as being in the secondary phase. Additionally, primary pupils are split into reception pupils and pupils in year 1 to year 6 and secondary pupils are split into key stage groups key stage 3 (years 7 to 9) and key stage 4 (year 10 to year 11) and individual year 7 to year 11.

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

Pupils recorded in year X in the autumn census aged between 4 and 15 are included in the data. These pupils are allocated to a year group based on their age at the start of the academic year. The following table 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

Table 3: schools block year group for pupils recorded in year group X

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

Unresolved duplicates will be counted in full at each school at which they are registered. This differs from the approach in the DSG where the pupils are apportioned to ensure they are only funded once.

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 2022 and spring 2023 censuses is provided in the dataset.

This is calculated by subtracting the total number of reception year pupils in autumn 2022 from the total in spring 2023 or given as zero if the result of this calculation is negative. If there are no reception year pupils at the school, then the result is zero. This is illustrated in the table below.

URN	Autumn 2022 (1) Number of pupils in reception year	Spring 2023 (2) Number of pupils in reception year	Difference (3) (2 – 1)	Reception difference - Max(0, (3))
xxxx1	0	0	0	0
xxxx2	62	62	0	0
xxxx3	38	33	-5	0
xxxx4	55	62	7	7

Table 4: reception difference illustration

2.7 Detailed specification for individual factors

For all of 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 autumn 2023 census unless otherwise indicated.

Deprivation

The 3 deprivation factors are FSM, FSM6 and IDACI.

Free school meals

• Primary FSM Proportion
• Secondary FSM Proportion

The proportion of pupils eligible for FSM according to the autumn 2023 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 autumn 2023 census that were recorded as eligible for FSM in any of the censuses (autumn, spring and summer, including the AP and PRU census) over the previous 6 years. This uses the same data that will be used for allocating the pupil premium.

More information on this indicator and the pupil premium can be found in Pupil premium information for schools and alternative provision guidance.

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 IDACI is a subset of the indices of multiple deprivation (IMD). It is an area-based measure defined at the level of 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 and 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 in the DLUHC 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 (2.5% to 7.5%)	B
Pupils in the next 5% most deprived LSOAs (7.5% to 12.5%)	C
Pupils in the next 5% most deprived LSOAs (12.5% to 17.5%)	D
Pupils in the next 10% most deprived LSOAs (17.5% to 27.5%)	E
Pupils in the next 10% most deprived LSOAs (27.5% to 37.5%)	F
Pupils in the remaining 62.5% LSOAs	G

Table 5: IDACI bands

For each of the bands, the proportion of pupils on the autumn 2023 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 3 Primary Proportion
• EAL 3 Secondary Proportion

The EAL indicator is 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 2023 census and can be shown to have been in the school system for 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 2020, autumn 2021 and autumn 2022 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 reception, N1 or N2 for any of the years covered. We do this 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 reception, to be partial and unrepresentative. Also, for this reason, pupils in reception are excluded from the ratios calculation. Pupils grouped as ‘3_UNK’ are also excluded.

A school’s ‘EAL 3 Primary Proportion’ is calculated as the number of pupils in year groups 1 to 6 meeting the EAL 3 criteria, divided by the total number of pupils in years 1 to 6 with a valid language code.

Corresponding calculations are done to obtain the secondary proportions.

Prior attainment

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

Primary prior attainment

Funding for primary schools 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 2023 census in years 1, 2, 5 and 6, are matched onto the new EYFSP data using their UPN.

As no tests were carried out in 2021 and 2022 (pupils now in years 3 and 4), data for pupils in year 2 is used for year 3 and year 5 data for year 4. If this data is not available, the proportion entered on the 2023 to 2024 APT is used. If this is also not available, then the local authority average for year 3 or year 4 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 year 1 to year 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 English reading, English teacher-assessed writing, or mathematics at key stage 2. 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 years 7, 8 and 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 7, 8 and 11 in the autumn 2023 census, who could not be matched onto the key stage 2 attainment data, are also excluded.

As no tests were carried out in 2020 and 2021 (pupils now in years 9 and 10), data for pupils in year 8 is used for year 9 and year 11 data for year 10. If this data is not available, the proportion entered on the 2023 to 2024 APT is used. If this is also not available then the local authority average for year 8 or 11 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 autumn census. If the pupil started in reception and their first entry is in autumn or spring, 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 date will not be counted as mobile.

Any pupils which are duplicated (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 registered at school (from 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	Autumn 2023	2023 to 2024	Yes	R	September 2004	Yes	0
2	3	Spring 2021	2020 to 2021	Yes	R	August 2015	Yes	0
3	5	Spring 2022	2021 to 2022	Yes	3	January 2017	No	1
4	5	Summer 2021	2020 to 2021	Yes	2	January 2013	No	1
5	7	Autumn 2023	2023 to 2024	Yes	7	September 2015	Yes	0
6	8	Autumn 2021	2021 to 2022	Yes	6	August 2013	Yes	0
7	8	Summer 2021	2020 to 2021	Yes	5	September 2004	No	1
8	9	Spring 2022	2021 to 2022	Yes	8	December 2020	No	1

Table 6: Illustration of pupil mobility calculation

Funding is not provided for the first 6% of mobile pupils. Only those schools experiencing pupil mobility above the 6% threshold will receive funding. 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

The sparsity distance is the shortest distance by road from the school site to the pupil’s postcode. To identify the points on the road network, we firstly identify schools’ and pupils’ locations on a map. To do this we cross-reference geographic data from the school census and GIAS (the department’s database of schools), with Ordnance Survey address data.

Schools can typically be located using Unique Property Reference Numbers (UPRNs). UPRNs are a unique numeric identifier for every addressable location, which are allocated and overseen by local authorities. Use of UPRNs represents a change to the current process, enabling us to measure distances from a point on the road closest to a school’s specific site as opposed to their postcode centroids, which can be closer to or further away from the actual school site for different schools.

In a minority of cases, UPRNs are inaccurately recorded in GIAS by schools, so we revert to use of postcodes or coordinates to locate schools. The GIAS frequently asked questions webpage includes information on how schools can check their UPRNs and correct them if necessary.

For pupils, we locate the closest building to their home postcode centroid. Locating the building is a necessary additional step allowing us to determine the correct road to route from. We do not include pupils’ postcodes that contain only Welsh or Scottish addresses in the calculation of sparsity distances by the road, because their closest or second closest school(s) might be in Wales or Scotland, for which we are unable to calculate a road distance.

Once we have found schools’ and pupils’ locations, we use the Ordnance Survey road network data to identify the closest access point to their locations on a road. We then calculate the shortest road distance from the nearest point on a road to the school, to the nearest point on a road to the pupil’s address, excluding footpaths and, where possible, avoiding roads such as farm tracks, guided busways and roads that have been altered for use principally by pedestrians as these are either unsuitable for normal school to home journeys, or we cannot be certain they will always be accessible. We acknowledge one-way roads as ones that can be accessed and travelled along from either direction. This avoids treating some schools differently, factoring in one-way streets on journeys from schools and pupils’ homes but not vice versa (because that is the direction of travel the sparsity distance has been based on).

Once we have calculated road distances, we calculate schools’ sparsity distances in the same way as for the ‘crow flies’ distance method: for each school, we identify pupils for whom it is their closest compatible school (by the road) and calculate the average distance to their second nearest compatible schools (by the road).In some cases this will not be the same pupils as those actually attending the school. We compare these distances to the sparsity distance thresholds to determine whether the school is remote.

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

In addition, the factor includes a distance threshold taper. This means that where schools’ sparsity distances are marginally below the main distance thresholds for sparsity funding, they will still attract some allocation through the NFF. The distance threshold taper has been set 20% below the main distance thresholds.

The default distance threshold is 3 miles for secondary schools and 2 miles for all other schools. If a local authority uses the distance taper, a primary school will meet the distance criteria if it has a sparsity distance greater than 1.6 miles (2 miles x 80%). Any primary school with a sparsity distance between 1.6 and 2 miles would receive a tapered amount providing it also meets the year group size criteria.

Local authorities may narrow the eligibility criteria by reducing the pupil numbers and/or increasing the distance 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.