School Attainment, Open Data Analytics and Policy in England — Lessons from Brighton and Hove
Bartlett Centre for Advanced Spatial Analysis, UCL
2026-07-21
Class Divide have published a thoughtful response to this report today. I am grateful for it — they have spent six years working on exactly the barriers this talk is about, and we share the same goal.
The UK Government’s 2026 “Every child achieving and thriving” White Paper sets ambitious targets:
Achieving these requires LEAs to understand the national picture and local situation simultaneously
This paper is motivated by direct experience of policy development in Brighton and Hove in 2024–25
The problem: A crucial gap exists between the availability of open data and the availability of accessible, contextualised intelligence for decision makers.
The risk: Policy designed around an incomplete understanding of local situation can pull the wrong lever — doing little good and potentially causing harm in the process.
Halve the local authority intelligence gap - following the report present a Policy Simulator tool that bridges the gap between data and intelligence for decision making
Convince you that attainment levels are very predictable - show that DfE open data can explain ~80% of variation in school-level attainment with just a handful of variables
Demonstrate the relative importance of different policy levers — and reveal which ones actually have mechanical advantage
Re-calibrate how we view ‘good schools’ - and convince you that most of what many conflate with good schools (their outcomes), is out of their hands
Use Brighton and Hove as a case study to illustrate all of these issues
We are not claiming the best possible model — we are showing that good enough models built from open data can transform the quality of local policy conversations.
The Coleman Report (US, 1966): family background and peers explain far more of attainment than anything schools do — a finding that shocked policymakers (reinforced by Jencks, Inequality, 1972)
The British response: Rutter et al., Fifteen Thousand Hours (1979); Mortimore et al., School Matters (1988) — schools do differ, measurably → the birth of school effectiveness research
The settled consensus: school effects are real but a minority share — ~10% of achievement variance at school level in the landmark UK studies (Teddlie & Reynolds’s 2000 summary of Smith & Tomlinson, 1989), with early field estimates of 12–15% (Reynolds et al., 2014); intake and context carry the rest
“Context outweighs school” is a sixty-year-old finding — what has been missing is a way to make it usable. This work makes the decomposition open, reproducible and local — and later in this deck, puts today’s numbers on it.
Attendance: strongest predictor — persistently absent pupils: 36% pass rate vs 84% for full attenders (DfE, 2022, 2025)
Prior attainment at KS2: reflects accumulated earlier inequalities (Gorard and Siddiqui, 2019; Stopforth and Gayle, 2025)
Disadvantage (FSM): some residual effect remains after accounting for above. Gap narrowed post-2011, reversed post-COVID (Tuckett et al., 2023)
Workforce: leadership quality, teacher retention, and teacher sickness matter — especially for disadvantaged pupils (Gibbons et al., 2018; Menzies, 2023; Zuccollo et al., 2023)
Selectivity: creams-off rather than improves - grammar school premium largely disappears after SES controls (Anders et al., 2024; Gorard et al., 2022; Gorard and Siddiqui, 2019)
Individual Pupil characteristics (Houtepen et al., 2020; O’Connell and Marks, 2022)
The factors are multifaceted, complex and interrelated. What’s needed is an analysis combining them so their relative importance can be assessed concurrently.
The evidence base is vast — many factors, many studies, many interactions
Hard for anyone to judge which driver is most important in a particular context
Requires analysis that combines drivers simultaneously so relative influences can be assessed
This is exactly what was missing in Brighton and Hove in the 2024 consultation. A single strand of evidence (segregation) was treated as the whole story, to the exclusion of other — potentially more impactful — factors.
6 community schools (LEA-controlled), 2 academies (BACA, PACA), 2 church schools
Catchment areas with lottery tie-break for oversubscribed schools (since 2008)
In 2023, FSM priority added — already affecting mixing without opposition
Brighton & Hove is already in the top 1/4 of LEAs nationally for integration of disadvantaged/non-disadvantaged pupils
What was proposed:
Council’s stated objectives (Dec 2024 Cabinet papers):
“reducing some schools’ barriers to success” for disadvantaged pupils
“a more mixed pupil intake creates better outcomes for disadvantaged pupils”
Stated premise: results in the city were “driven by economic advantage” — so redistribute → narrow the gap
Being close to a good secondary school has barely any effect on house prices in Brighton and Hove
We examined 81,000 residential property transactions over 20 years (2000-2019) in Brighton and Hove and looked at the factors influencing those prices
Being within walking distance of a mainline train station or a short bus ride to the city centre far more important for house prices than being close to a good secondary school
Public reaction:
The institutional context:
Is the premise correct? Is attainment in Brighton & Hove really “driven by economic advantage”?
Is this the right lever? Even if concentrations of disadvantage matter, are they the most important factor?
How is the city actually performing once structural factors are accounted for?
What are the risks of pulling this particular lever — including second-order effects?
Should you even be pulling it - or pushing it the other way?
We can answer all of these with DfE open data.
Data sources:
Our panel:
All publicly available. All linkable. All underutilised.
Figure 2
Figure 3
Where a school or a whole LEA sits on the curve matters enormously for policy.
Figure 4
Logging both axes straightens the curve — so a single elasticity captures the relationship.
Multilevel linear mixed effects model — schools nested within LEAs within regions:
\[\log(\text{ATT8}_{ij}) = \beta_0 + \sum_{k=1}^{9} \beta_k \, x_{kij} + u_{\text{year}} + u_{\text{Ofsted}} + u_{\text{region}} + u_{\text{LA|region}} + \varepsilon_{ij}\]
Fixed effects (predictors):
Random effects (grouping):
Three models:
Multilevel linear mixed effects model — schools nested within LEAs within regions:
\[\log(\text{ATT8}_{ij}) = \beta_0 + \sum_{k=1}^{9} \beta_k \, x_{kij} + u_{\text{year}} + u_{\text{Ofsted}} + u_{\text{region}} + u_{\text{LA|region}} + \varepsilon_{ij}\]
Fixed effects (predictors):
Random effects (grouping):
Three models:
A Statistical Model
| Model | Marginal R² | Conditional R² |
|---|---|---|
| All pupils | 0.63 | 0.77 |
| Disadvantaged | 0.56 | 0.73 |
| Non-disadvantaged | 0.62 | 0.79 |
\(R^2\) measures how much variation in Attainment 8 is explained by the model
Essentially - How close to the line of best-fit are the points in the scatter-plot?
Can be interpreted as a % - e.g. 0.8 = 80%
School-level attainment is remarkably predictable from a small number of structural factors.
~80% of variation explained for all pupils; ~70–80% for subgroups.
Mediating variables sit on the causal pathway, not including can inflate apparent relationships: Disadvantage(FSM) → Absence → Attainment
| M1: FSM only | M2: + Absence | M3: + Prior att. | |
|---|---|---|---|
| FSM coefficient | -0.201 | -0.122 | -0.073 |
| Absence coefficient | — | -0.364 | -0.287 |
| Prior att. coefficient | — | — | -0.006 |
| R² | 0.393 | 0.612 | 0.669 |
The coefficient is a number that represents how steep the line through the scatter plot is. Bigger number (positive or negative) → steeper the line → stronger the effect. 0 = flat line = no effect
Adding absence halves the FSM coefficient. Adding prior attainment reduces both further. With just 3 variables → two-thirds of variation in GCSE scores between schools explained.
Figure 5
Same schools, same axes — but once absence and prior attainment are held constant (right), the disadvantage line flattens dramatically: most of the apparent effect ran through attendance and prior attainment.
The Gorard Segregation Index is not statistically significant in the full model
Once a school’s own FSM levels, attendance, prior attainment and geographic location are accounted for → no additional predictive power
Any harm segregation causes is fully mediated by the other variables
This doesn’t mean segregation is harmless — it means its effects operate through absence, prior attainment, and other measured factors
We include it because it formed much of the justification for the Brighton & Hove proposals
Also remember - Brighton and Hove is in the top 1/4 of LEAs for least segregation / most integration of disadvantaged / non-disadvantaged students already
Figure 6
Absence is the most powerful predictor of school-level attainment by a considerable margin — its coefficient is roughly 2.6 times larger than concentrations of disadvantage.
For disadvantaged pupils, nearly half of school-level performance variation is explained by attendance alone
Absence matters ~1.8× more (≈77%) for disadvantaged than non-disadvantaged pupils’ attainment
Disadvantaged pupils lack safety nets (tutors, engaged parents, revision guides) — they are more reliant on classroom instruction
Attendance is the ultimate equity lever
On the council’s own framing — “reducing some schools’ barriers to success” for disadvantaged pupils — attendance is the largest, best-evidenced barrier the model can quantify
For non-disadvantaged pupils:
For disadvantaged pupils:
Why? Schools with higher concentrations likely develop specialised support systems — targeted use of Pupil Premium, vocational pathways, specialist staff.
Effect shrinks in the full multilevel model → operates through LEA/Ofsted factors, not concentration per se.
Impact Even before negative impacts of redistribution policy (longer journeys etc.), BHCC policy likely to negatively impact disadvantaged attainment at city level.
To be clear: We do not advocate for active concentration of disadvantaged pupils.
But deconcentration policies premised on the assumption disadvantaged students inevitably fare worse in higher-disadvantage schools are not supported by this evidence.
Where deconcentration policies create other negative externalities, classic example of pulling the wrong lever
Figure 7
Each dot is one LEA’s average boost (above the dashed line) or penalty (below) to disadvantaged attainment, after accounting for intake, absence and prior attainment — i.e. how much better or worse its schools do than the national picture predicts.
LEA rankings (after structural adjustment):
| Pupil group | Rank / 152 |
|---|---|
| Disadvantaged | 7th |
| Non-disadvantaged | 5th |
| All pupils | 4th |
The positive random intercept ≈ +2 GCSE points above what structural factors predict.
This was entirely unknown at the time of the 2024 consultation and completely absent from the public narrative.
The starting point was a narrative of failure. The evidence says the opposite: this is one of the highest-performing LEAs in England.
Rather than “what is the city doing wrong?”, the question should be “what is it doing right?”
FSM/Disadvantaged Mixing (the lever chosen):
Absence (the lever totally ignored):
Brighton & Hove has near-average disadvantage but near-worst absence. The city’s strong underlying performance is being dragged down by an absence problem at the extreme of the national distribution.
| Local Authority | 2024-25 | 2023-24 | 2022-23 | 2021-22 |
|---|---|---|---|---|
| Knowsley | 10.9% (152/152) | 11.9% (151/152) | 11.8% (149/152) | 12.6% (152/152) |
| Brighton and Hove | 10.8% (151/152) | 11.0% (143/152) | 10.5% (137/152) | 10.8% (144/152) |
| Newcastle upon Tyne | 10.6% (150/152) | 11.4% (150/152) | 12.9% (152/152) | 12.2% (151/152) |
| Southampton | 10.5% (149/152) | 11.0% (145/152) | 10.6% (139/152) | 10.1% (119/152) |
| Bradford | 10.3% (148/152) | 11.2% (147/152) | 11.9% (150/152) | 11.5% (149/152) |
| Plymouth | 10.2% (147/152) | 11.3% (149/152) | 10.8% (144/152) | 11.1% (147/152) |
| Middlesbrough | 10.1% (146/152) | 12.2% (152/152) | 12.9% (151/152) | 11.8% (150/152) |
| Sefton | 10.0% (145/152) | 10.5% (133/152) | 10.3% (129/152) | 10.1% (122/152) |
| Devon | 9.9% (144/152) | 10.8% (139/152) | 10.9% (145/152) | 10.8% (145/152) |
| Dorset | 9.9% (143/152) | 10.7% (137/152) | 10.2% (127/152) | 10.3% (134/152) |
| Halton | 9.8% (142/152) | 11.0% (144/152) | 10.3% (131/152) | 10.1% (118/152) |
| Blackpool | 9.8% (141/152) | 11.3% (148/152) | 11.1% (147/152) | 9.8% (103/152) |
| Hartlepool | 9.8% (140/152) | 10.5% (134/152) | 11.1% (148/152) | 10.2% (130/152) |
| Bristol, City of | 9.6% (135/152) | 11.0% (142/152) | 11.0% (146/152) | 10.6% (141/152) |
| Gateshead | 9.5% (130/152) | 11.2% (146/152) | 10.8% (143/152) | 11.4% (148/152) |
| St. Helens | 9.1% (121/152) | 10.0% (122/152) | 9.6% (103/152) | 10.7% (143/152) |
| Torbay | 8.2% (75/152) | 10.3% (126/152) | 10.2% (125/152) | 10.9% (146/152) |
Figure 8
| School | Current Absence % | National Avg (Target) | Reduction (pp) | ATT8 gain (all) | ATT8 gain (disadv.) |
|---|---|---|---|---|---|
| Longhill High School | 16.7 | 8.2 | 8.4 | 5.3 | 6.1 |
| Brighton Aldridge Community Academy | 14.4 | 8.2 | 6.2 | 4.6 | 6.2 |
| Hove Park School and Sixth Form Centre | 12.9 | 8.2 | 4.6 | 4.1 | 4.7 |
| Portslade Aldridge Community Academy | 11.3 | 8.2 | 3.1 | 3.0 | 3.2 |
| Blatchington Mill School | 10.8 | 8.2 | 2.6 | 3.0 | 3.3 |
| Dorothy Stringer School | 9.8 | 8.2 | 1.5 | 2.0 | 1.9 |
| Varndean School | 9.0 | 8.2 | 0.8 | 1.0 | 1.0 |
| Cardinal Newman Catholic School | 8.5 | 8.2 | 0.3 | 0.3 | 0.4 |
Bringing absence to the national average → predicted gains of 3–5 GCSE points (even more for disadvantaged) at the worst-affected schools. FSM reductions → closer to 1–2 points (and not for disadvantaged students).
Schools about much more than raw attainment:
But in purely attainment terms:
Figure 9
| Rank | School | 2021-22 | 2022-23 | 2023-24 | 2024-25 | Mean |
|---|---|---|---|---|---|---|
| 1 | Brighton Aldridge Community Academy | +3.2 | -1.3 | +4.1 | +5.2 | +2.8 |
| 2 | Varndean School | +3.2 | +3.6 | +4.5 | -1.9 | +2.3 |
| 3 | Dorothy Stringer School | +2.9 | +3.2 | +0.3 | +1.7 | +2.0 |
| 4 | Cardinal Newman Catholic School | +2.4 | -5.0 | +6.5 | +2.5 | +1.6 |
| 5 | King's School | +5.8 | +0.9 | +4.4 | -5.4 | +1.5 |
| 6 | Blatchington Mill School | -5.4 | +1.3 | +5.2 | +3.4 | +1.1 |
| 7 | Hove Park School and Sixth Form Centre | +2.4 | -1.7 | +1.3 | +0.5 | +0.6 |
| 8 | Portslade Aldridge Community Academy | +2.6 | -4.0 | +4.7 | -1.3 | +0.5 |
| 9 | Patcham High School | +3.8 | +1.6 | -11.9 | -3.7 | -2.6 |
| 10 | Longhill High School | -4.6 | -6.2 | +0.8 | -1.4 | -2.9 |
Progress 8 — England’s official value-added measure — adjusts each pupil’s Attainment 8 for one thing only: KS2 prior attainment.
Known criticisms (Leckie & Goldstein; Perry; FFT Datalab)
What this measure adds
The trade-off: Progress 8 is pupil-level; this is school-level open data — richer context, coarser resolution.
How much does the school really matter? New, exploratory material — not in the accompanying paper
Workforce — the part schools directly control — is a sliver (3%) next to the hand they are dealt (62%). Even the persistent school effect (16%) is an upper bound bundling genuine school ethos/management etc. with other things they don’t control in their catchment, not otherwise measured e.g. cultural capital, parental motivation.
Even for disadvantaged pupils, workforce (school-controllable) is just 1.1% vs 56.8% inherited — the persistent school effect (10.5%) is still a dwarfed upper bound.
Figure 10
Bar height = each group’s average school-level score; each block = that factor’s share of the variation in school outcomes. The pink block — what leadership & teaching add — is real and visible for all three groups, and it is a floor, not a ceiling: a school like BACA adds ~1 SD more than the typical school for its disadvantaged pupils. Figures are unweighted school-level averages (each school counts once); the pupil-weighted national gap is ~15 points.
That pink slice was the school’s share of the variation — so what does a school one step better than average actually add to a disadvantaged pupil?
Figure 11
The school effect is additive — a good school adds its ~2.7 points to the pink block, a very good school ~5.5. A genuinely good school closes a good part of the gap to the typical non-disadvantaged pupil (~46% for the best) — the lever is real, but even the best schools cannot close it alone. BACA does exactly this: +2.8 over four years.
What people thought:
What the data shows:
Patcham — “the safer choice”:
Parents, acting rationally on available information and vocal campaigning, may have been choosing the school with lower value-added for their children — if that is the most important factor.
Well intentioned but poorly informed campaign could have nudged parents into poor decisions.
Patcham is one of only two schools in the city with attendance better than the national average
This is an actionable lever at the school level
BACA exemplifies the national finding: schools with higher disadvantage can develop specialised, effective support
Every school in the city could learn from Patcham on attendance — and from BACA on supporting disadvantaged pupils
The city needs to disaggregate the attendance problem — different causes require different strategies: family holidays, SEND challenges, transport barriers, caring responsibilities.
Absence in our headline model is a single number, but conceptually it sits in two roles at once
Part of it is structural — driven by intake, family circumstances, area health, deprivation, SEN, EAL…
Part of it is school-managed — pastoral systems, attendance officers, parental engagement, ethos around getting children into class
A two-stage decomposition1 separates these:
Most of school-level absence variance nationally is structural. The school-controllable share is the smaller part — but it is the share local policy can actually move.
Figure 12
BACA sits firmly in Q2 — adding value despite worse-than-predicted attendance. Closing its residual-absence gap would compound an already-strong pedagogical signal.
Patcham sits in Q4 — underperforming despite better-than-predicted attendance. The simple “fix attendance” story isn’t available here.
Schools in Q3 (underperforming + attendance worse) are the cleanest single-lever targets — both signals point the same way.
Schools in Q1 (adding value + attendance helping) are where the city should look for practice worth sharing.
Reading value-added alongside residual absence separates “this school adds points to attainment” from “this school’s pupils attend more than their intake predicts” — two distinct signals that single-residual league tables fold together.
The council’s proposals were built on the premise that attainment was “driven by economic advantage”
This premise is false in the context of the DfE’s own research (Macleod et al. 2015) — our modelling confirms this was at best a flawed understanding
Concentrations of disadvantage are one of the weaker levers available
For disadvantaged pupils specifically, the direction of effect runs contrary to the policy assumptions - across England over 4-years of data, disadvantaged pupils get better results in schools with higher concentrations of disadvantaged pupils
The policy was pulling a lever with relatively little mechanical advantage while ignoring one with considerably more
The chosen policy if implemented as intended requires longer journeys for many children
Thomson (2023): pupils who travel further to school are absent more often
Given absence is the city’s most acute problem and the strongest predictor of attainment…
A policy that even marginally increases absence could be counterproductive in attainment terms. The claim of “almost no cost” for social mixing overlooks these second-order effects.
Following opposition and appeals: PAN reductions rejected, 20% out-of-catchment → 5%.
But the policy reverberations continue through:
Low levels of pupil displacement on 2026 offer day luck not judgement!
Underlying belief that current policy direction will benefit disadvantaged pupils in the city
The council has recently agreed to a cross-party working group on schools — a positive step. Our strongest recommendation:
Priority one: a deep dive into absence. The city has the 2nd worst absence rate in England but near-average disadvantage. This is not inevitable — it is, in principle, solvable.
The absence problem needs disaggregating — very different situations exist within the headline statistics:
Each requires a different strategy. Schools like Patcham — one of only two with attendance below the national average — offer lessons in what works locally.
Every LEA has a different profile of challenges — different positions along non-linear curves
What works in one context may be irrelevant or counterproductive in another
The DfE open data provides the raw materials for local understanding
But there’s a crucial gap between raw data and actionable intelligence
National ambitions will founder if pursued locally without adequate analytical infrastructure
What it does:
Built with:
Not the finished article — but a demonstration of what’s possible when open data + appropriate methods + accessible tools come together.
School Finder → select any school → view contextual statistics → send to the Policy Simulator
adam-dennett.shinyapps.io/School_Attainment_Policy_Simulator
Non-linear effects mean the same adjustment produces different impacts depending on the school’s starting position
School-level attainment is remarkably predictable (~80% variance explained) from a handful of open data variables
Absence is the dominant predictor — 2.6x more important than concentrations of disadvantage
For disadvantaged pupils, the concentration effect runs in the opposite direction to common assumption
For disadvantaged pupils the most important factor impacting their attainment is attendance
Brighton & Hove is one of the highest-performing LEAs — but has the 2nd worst absence in England
The 2024 policy was pulling the wrong lever — targeting the weaker factor while ignoring the stronger one
Crude metrics (raw league tables, single-word Ofsted) mislead parents and policy makers
For the DfE:
For LEAs:
For schools, governors & parents:
The caution: Policy made in haste, anchored to a single causal narrative and implemented without adequate regard for evidence, risks doing more harm than good — particularly when it disrupts a system that is working well.
The encouragement: The raw materials for better policy already exist in DfE open data. With the right analytical tools and a commitment to evidence over ideology, it is possible to understand with considerable precision what drives attainment in any local context — and where the most productive interventions lie.
The challenge: Ensuring this understanding reaches decision makers in a usable form before decisions are made — not after.
The paper:
Contact:
📧 a.dennett@ucl.ac.uk
Funding:
🔗 UKRI AI4CI Hub — National AI Research Hub for Collective Intelligence
All data used in this analysis are publicly available from the Department for Education. All processing code is open source.
:::::::::::::::::::: ::::::::::::::::::::::