A fully-formatted Excel tracker for logging and monitoring all pastoral and academic interventions across a secondary school year group or whole school. One row per intervention, automatic RAG colour coding, dropdown menus on every key column and a live summary dashboard — everything updates as you type.
Four tabs:
Interventions Log — the main tracker. 100 pre-formatted rows, 16 columns covering student name, year group, tutor group, intervention type, subject, programme, lead person, start date, review date, end date, status, RAG rating, notes and parent contact. Filters on every column. Whole row colours automatically from the RAG rating.
Summary Dashboard — auto-calculated totals by intervention type, year group and subject. Updates instantly as data is added to the Log. No formulas to set up.
My Lists — all dropdown values fully editable. Add, remove or rename year groups, tutor groups, intervention types, subjects, programmes, lead persons, status options and RAG ratings to match your school’s systems.
How to Use — full step-by-step instructions and a column-by-column guide.
Key features: review date turns amber automatically when overdue and no end date is set. Subject column accepts free-text input as well as dropdown selection.
Designed by a former Assistant Headteacher with 17 years of secondary experience and responsibility for behaviour and attitudes.
Requires: Microsoft Excel.