Drop your attendance export here
A CSV from your MIS — Bromcom, SIMS, Arbor, ScholarPack, any of them
Or choose a file…
Your data never leaves this device. The analysis runs entirely inside your
browser — nothing is uploaded, stored or sent anywhere. Please export an anonymous pupil reference rather than
pupil names; the analysis never needs them.
The export this tool needs
One row per pupil, or — better — one row per pupil per half term, which is what produces the direction-of-travel chart. Column order doesn't matter and headings are matched loosely, so “Sessions Possible”, “sessions_possible” and “Possible Sessions” all work.
| Heading | Need | Notes |
|---|---|---|
Year Group | Required | 7, 8, 9… (or Reception/Nursery as text) |
Sessions Possible | Required | Sessions the pupil could have attended |
Sessions Attended | Required | Sessions present. Attendance is calculated attended ÷ possible, exactly as the DfE, your IDSR and Ofsted calculate it — an average of pupils' individual percentages gives a different and wrong answer. |
Sessions Authorised AbsenceSessions Unauthorised AbsenceSessions AEA | Recommended | Splits absence, and separates approved educational activity. Without these the absence-composition analysis is skipped. |
Half Term | Recommended | AUT1 AUT2 SPR1 SPR2 SUM1 SUM2 — one row per pupil per half term unlocks the trajectory view |
FSM6 | Recommended | Ever eligible in 6 years. This is the measure your IDSR benchmarks against — not the same as Pupil Premium |
Pupil Premium, SEN Status, SEN Primary Need, Gender | Recommended | SEN Status as E/K/N; primary need as ASD, SEMH, SLCN… |
Pupil Ref | Optional | An anonymous, stable reference — never a name. Lets the tool name which pupils sit on each rung of the support cycle. |
EAL, LAC, Young Carer, CIN, CP | Optional | Adds vulnerable-group rows to the gap analysis |