Behaviour Incident & Pattern Tracker | Automated Excel Dashboard & Intervention Flags

Spot repeat incidents, rising 30-day patterns, severity and intervention gaps with an automated behaviour tracker and dashboard for pastoral teams.
Move beyond a simple behaviour incident log. This automated Excel dashboard helps teachers and pastoral leaders spot repeat pupils, recent escalation, severity patterns and gaps where repeated incidents have not yet been matched by intervention or parent contact.

WHAT IS INCLUDED
• Student setup for up to 100 pupils.
• Behaviour Incident Log for up to 500 incidents.
• Editable incident type and severity categories.
• Automatic severity score.
• 30-day recency flag.
• Student Pattern Engine comparing the last 30 days with the previous 30 days.
• Automatic counts for high / critical incidents, parent contact, intervention and positive repair.
• Action Gap flag when repeated recent incidents have no recorded intervention / contact.
• Pattern Score and Routine / Watch / High / Urgent priority bands.
• Automated Dashboard with incident-type and severity charts.
• Student Behaviour Profile.

WHY THIS RESOURCE IS DIFFERENT
Most behaviour spreadsheets simply store incidents. This system focuses on the next question: is the pattern increasing, how serious is it, and has an appropriate support / follow-up action been recorded?

SUITABLE FOR
Heads of Year, pastoral teams, behaviour leads, form tutors, classroom teachers and school leaders reviewing behaviour patterns.

IMPORTANT
This workbook supports professional review. It should not automatically determine sanctions, exclusions or safeguarding responses. Always follow school policy and use approved safeguarding systems where required.

TECHNICAL INFORMATION
Microsoft Excel recommended. No macros required.

FILES INCLUDED
Automated XLSX workbook, Quick Start PDF, 800×600 TES cover, TES upload text and licence/readme.