An editable Excel tracker for recording lesson refusal and lesson avoidance, with an automatic pattern dashboard. Log incidents in seconds, then see what repeats by period, day, subject, year group, reason and location.

A student refuses to go to lesson. It gets dealt with in the corridor… and then it happens again. Same lesson. Same day. Same time. The pattern is often the useful bit, but only if someone’s recording it. Built by a practising DSL.

What’s included
✔ Quick-entry tracker with dropdowns for year group, period, subject, reason, location and action
✔ Time out / time back, so minutes out of learning calculate automatically
✔ Supervising adult recorded every time, so no student is unaccounted for
✔ Red alerts for “left site / missing” or “location unknown”
✔ Amber flags for recording gaps: safeguarding concerns with no record, follow-ups with no owner
✔ Automatic incident count per student, highlighted at the 3rd incident
✔ Pattern dashboard with a date filter for any week or half term
✔ Student, teacher and department lookups
✔ Recording checks panel
✔ Fully editable lists: periods, subjects, reasons
✔ Start Here tab plus a one-page quick-start guide (PDF)

Ideal for DSLs, Heads of Year, pastoral leads, behaviour and inclusion teams, and SLT.

Please note: this is a pattern tracker, not a safeguarding record. Safeguarding concerns should always follow your school’s procedures and be recorded on your safeguarding system.

Format: Excel (.xlsx). Works best in Microsoft Excel (desktop or online).