xlsx, 21.69 KB
xlsx, 21.69 KB
png, 112.63 KB
png, 112.63 KB

Keep a clean, consistent behaviour log without the follow-up admin of tallying incidents by hand.

Log each incident in the Incident Log tab: date, student, form/class, location, incident type, severity (Low/Medium/High from a dropdown), action taken, staff member, and whether follow-up is needed.

What happens automatically:

  • Student names pull through into the Student Summary tab, no re-typing names.
  • Total incidents, and a breakdown by severity, calculated live for every student.
  • Most recent incident date shown automatically.
  • Students with 3 or more incidents are flagged “Review needed” in red, so patterns don’t get missed.
  • A built-in Dashboard tab shows headline stats (total incidents, students flagged, high-severity count) plus a live chart.

Also included:

  • Clear Instructions tab, no training needed.
  • Dropdown menus for Severity and Follow-up keep data entry consistent.
  • Sheet protection (no password) stops formulas being accidentally overwritten, while the log stays fully editable.
  • Works in Excel 2007 onwards, Excel Online, Microsoft 365 and Google Sheets.

Ideal for: Heads of Year, pastoral leads and behaviour/inclusion staff tracking patterns across a form or year group.

Get this resource as part of a bundle and save up to 25%

A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.

Bundle

Pastoral Pro — 5 Automated Excel Trackers Bundle (Attendance, Behaviour, Rewards, Parent Contact, Interventions)

Was £20.00, now £15.00 (save 25% — 5 trackers, £4.00 each individually) Save hours of admin with this complete pastoral toolkit from Pastoral Pro. Every tracker is a professional, pre-built Excel spreadsheet — just open, add your students, and the formulas do the rest. No formulas to write, no formatting to fix. Bought separately, these 5 trackers cost £20 (£4.00 each). As a bundle, you get all 5 for £15, a 25% saving. What's included (5 spreadsheets, each with its own live Dashboard tab): - Attendance Tracker: log daily AM/PM sessions and instantly see each student's attendance percentage, with an automatic flag for anyone below 90%. Dashboard shows students tracked, students below 90%, and average attendance at a glance. - Behaviour Incident Tracker: log incidents with severity and action taken; automatically totals incidents per student and flags repeat concerns (3 or more). Dashboard shows total incidents, students flagged for review, and high-severity count. - Reward and Merit Points Tracker: log points awarded and get an auto-updating leaderboard plus form/class totals, perfect for house competitions. Dashboard shows total points awarded, students earning points, and the current top student. - Parent and Carer Contact Log: record every call, email and meeting, with automatic tracking of outstanding follow-ups. Dashboard shows total contacts, outstanding follow-ups, and students contacted. - Pastoral Intervention Tracker: track support interventions from start to review, with a live status overview (ongoing, completed, discontinued) and a chart visualising the split. Why teachers love this bundle: - Student names pull through automatically from your log into every summary tab, no double data entry, ever. - Every tracker has a built-in Dashboard: headline stats plus a live chart, ready to present at a pastoral or SLT meeting with zero setup. - Every tracker uses live formulas (COUNTIFS, SUMIFS, INDEX-MATCH): figures update automatically as you type, nothing to calculate by hand. - Dropdown menus keep data entry consistent (no typos in status fields). - Colour-coded flags highlight students who need attention at a glance. - Sheet protection (no password) stops formulas being accidentally overwritten, while every log stays fully editable. - Clear Instructions tab in every file, no training needed. - Fully editable: adapt column names, dropdown options or colours to match your school's systems. - Works in Excel 2007 onwards, Excel Online, Microsoft 365 and Google Sheets, no special or newer Excel functions required, so it opens correctly on any school laptop. Ideal for: Heads of Year, Form Tutors, Pastoral Support staff, SENCOs tracking interventions, Assistant Heads (pastoral), and any staff member managing a form or year group. COMPATIBILITY NOTE All summary tabs auto-populate student names and calculations using formulas compatible with Excel 2007 onwards, Excel Online, Microsoft 365, and Google Sheets. No add-ins, macros, or newer Excel-only functions are required, every tracker works the same way on any device or Excel version your school uses.

£15.00

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.