Department Support & Intervention Tracker – Excel Tracking & Monitoring for Underperforming Pupils
This Excel pupil tracking and intervention tracker is designed to help teachers and departments quickly identify and monitor pupils of concern and underperforming learners. It provides a simple, ready-made system for data tracking, monitoring progress, and recording interventions, supporting raising attainment across a department.
All formulas and colour coding are already built in. There is no setup required just enter pupil information and the tracker automatically updates and highlights concerns, saving valuable teacher workload time.
This resource is ideal for secondary teachers, Principal Teachers, Faculty Heads, Data Leads and Senior Leaders who need clear evidence of support, intervention and impact.
Perfect for:
tracking underachieving pupils
recording concerns and barriers to learning
departmental monitoring and review meetings
inspection or quality assurance evidence
raising attainment strategies
targeted support planning
closing the attainment gap
What this tracker records
This resource allows you to record and monitor:
pupil name and candidate number
class, teacher and stage/year group
course/level (e.g. National, Higher, GCSE, A-Level etc.)
target grade/band
current working grade
baseline data or prior attainment
assessment results and progress over time
homework completion
attendance percentage
behaviour/engagement concerns
barriers to learning
pupils of concern / underperforming pupils
tier/level of intervention
actions and support strategies put in place
review date and follow-up
outcome/impact of intervention
staff member responsible
parent/carer contact notes
additional pastoral notes or comments
Key features
fully editable Excel file
automatic colour coding and formulas already applied
intervention tier system built in
fields for attendance, behaviour, homework and progress
space to record actions, outcomes and impact
dashboard overview for departmental data
suitable for whole-school or department use
What it helps you do
identify pupils who are not meeting targets
plan and record interventions
evaluate impact over time
evidence support for inspections or SLT
streamline departmental tracking and monitoring
reduce admin and teacher workload
This is a ready-to-use pupil data tracker designed to make tracking and monitoring simpler, faster, and more consistent across your department.



