Education IQ
Embedded in Northwind CRM
N
Northwind CRM

Widget Lab

A reference prototype of the new widget model — Data Family + Lens identity, switchable desktop / distribution / data modes, a neighbourhood picker, direction-of-travel and drill-through.

Data families
Academic Outcomes Financial Workforce Student Demographics Inspection
Lenses (how to read a high value)
Complexity— Higher = more challenging context
Success outcomes— Higher = stronger outcomes
Demographics— Higher = more of this characteristic
Investment profile— Higher = greater financial capacity

Value Highlight

Simplified: percentile as text with the lens beside it. The cohort is a section-level filter (top-right) shared by every widget in the row.

Academic Outcomes +1.2pp

Attendance

The percentage of possible sessions attended by pupils across the academic year.
93.4%
Success outcomes rankingHigher = stronger outcomes. A higher percentile ranks this organisation nearer "Stronger" within the comparison cohort.
72ndpercentile
Academic Outcomes +0.03

Progress 8

Average progress pupils make from the end of KS2 to KS4, relative to similar starting points.
+0.31
Success outcomes rankingHigher = stronger outcomes. A higher percentile ranks this organisation nearer "Stronger" within the comparison cohort.
74thpercentile
Student Demographics +1.8pp

Pupil Premium Students

The percentage of pupils eligible for Pupil Premium funding — a marker of a more disadvantaged intake.
28.4%220 students
Complexity rankingHigher = more challenging context. A higher percentile ranks this organisation nearer "More complex" within the comparison cohort.
64thpercentile
Student Demographics 0.0pp

English as Additional Language

The percentage of pupils whose first language is not English.
9.7%75 students
Demographics rankingHigher = more of this characteristic. A higher percentile ranks this organisation nearer "More" within the comparison cohort.
38thpercentile
Financial +4.1%

Total Annual Income

Total annual income for the organisation across all funding streams.
£7.42m£6.84k / pupil
Investment profile rankingHigher = greater financial capacity. A higher percentile ranks this organisation nearer "More capacity" within the comparison cohort.
55thpercentile
Workforce -2pp

Teacher Turnover

The percentage of teaching staff leaving the organisation over the year — higher turnover is a marker of instability.
11%6 staff
Complexity rankingHigher = more challenging context. A higher percentile ranks this organisation nearer "More complex" within the comparison cohort.
42ndpercentile

Concept variant — lens hidden, colour by valence

No lens name. Colour carries the meaning: green = higher is better, amber = higher is more challenging, grey = neutral.

Academic Outcomes +1.2pp

Attendance

The percentage of possible sessions attended by pupils across the academic year.
93.4%
72ndpercentile
Student Demographics +1.8pp

Pupil Premium Students

The percentage of pupils eligible for Pupil Premium funding — a marker of a more disadvantaged intake.
28.4%220 students
64thpercentile
Student Demographics 0.0pp

English as Additional Language

The percentage of pupils whose first language is not English.
9.7%75 students
38thpercentile

Single Metric Comparison

One metric shown against several cohorts at once (no neighbourhood picker — the cohorts are the comparison).

Student Demographics +0.3pp

EHC Plan Students

The percentage of pupils with an Education, Health and Care plan.
3.2%32 students
Complexity rankingHigher = more challenging context. A higher percentile ranks this organisation nearer "More complex" within each cohort.
National · All schools48th
Nottinghamshire · All55th
Horizon Trust · All62nd
SimplerMore complex
Academic Outcomes +1.2pp

Attendance

Percentage of possible sessions attended across the academic year.
93.4%
Success outcomes rankingHigher = stronger outcomes. A higher percentile ranks this organisation nearer "Stronger" within each cohort.
National · All schools72nd
Nottinghamshire · All78th
Horizon Trust · All61st
Statistical neighbours66th
WeakerStronger

Multi Metric Comparison

Metrics × cohorts grid — whole-widget family/lens, per-metric direction, absolute↔per-pupil toggle, sortable columns, highest/lowest highlighting. Deploy-alone.

Financial

Spend per Pupil

How this school's per-pupil spend by category compares with each cohort.
Investment profile rankingHigher = greater financial capacity. A higher percentile ranks this organisation nearer "More capacity" within each cohort.
Metric
Teaching staff
£4,120
58th
61st
49th
Education support
£760
64th
59th
70th
Premises & energy
£580
55th
62nd
51st
Supply teachers
£240
82nd
76th
88th
ICT
£190
71st
68th
74th

Bold = highest per cohort · dimmed = lowest. Higher = greater financial capacity.

This school
Cohorts

Prototype assumptions (for review): the family/lens taxonomy, the colour + icon choices, the percentile→colour banding per lens, and the neighbourhood list are our proposals — to be confirmed against the spreadsheet and remaining widget specs.