School Behaviour Dashboard — Excel | 8 Sheets | Incident Log, RAG Coding, Student View, Watchlist

A complete, professional behaviour tracking and analysis system for secondary schools — built in Excel, fully customisable for your school and ready to use in around 15 minutes. Log incidents in one place and every other sheet updates automatically.
Eight sheets:
Instructions — full setup guide, daily use walkthrough, FAQs and a severity scale. Everything you need to get started, in one place.
Settings — enter your school name, year groups, behaviour types, sanctions, locations, staff and form groups once. All drop-down menus throughout the workbook update automatically.
Data Entry — log one row per incident. 23 columns including date, year group, form, student name, behaviour type, severity (1–5), location, sanction, parent notification, on report and exclusion flags.
Dashboard — auto-updating KPI cards (total incidents, this week, exclusions, on report, PP students, unique students), incidents by year group with RAG ratings, top behaviour types, hotspot locations, and two auto-updating charts.
Student View — type any student name to instantly pull their full behaviour profile: total incidents, exclusions, on-report status, most recent incident and individual incident history.
Year Group — automatic breakdown of incidents by year group and form group.
Weekly Trends — week-by-week incident counts and trend charts. Designed for SLT meetings and governor reports.
Watchlist — flags high-priority students with an action log for recording pastoral support in place.
Sample data pre-loaded so you can see the dashboard in action immediately. Clear the sample rows and start entering your own data. Capacity for up to 1,000 incidents. All lists fully editable to match your school’s behaviour policy, sanction structure and terminology.
Designed by a former Assistant Headteacher with 17 years of secondary experience and responsibility for behaviour and attitudes.
Requires: Microsoft Excel.