An easy to use teacher planner for academic year 26-27.

An easy to use, wizard themed, teacher planner for academic year 26-27.

A ready-to-use Excel pastoral tracker for a whole secondary year group -behaviour, attendance, punctuality, uniform, homework & rewards, fully automated. This is a complete, automated Year Group Pastoral Tracker built in Excel for Heads of Year, Assistant Heads of Year, and pastoral leads managing a cohort of up to 300 pupils (can be extended if needed). Enter your weekly data once and the tracker does the rest. It automatically: Flags pupils who need attention with a colour-coded priority rating (Form Tutor → Head of Year → SLT) Builds a dated, defensible action trail across behaviour, attendance, punctuality (lates to lessons), late-to-school, uniform and homework Calculates a whole-cohort concern level (No Concern → Specialist Services), so you can see at a glance who’s moving in the wrong direction Auto-generates one-click, printable pupil summaries for parents’ evenings, review meetings and staff handovers Tracks positive points and rewards alongside sanctions, so the full picture is visible - not just the negatives Everything is fully configurable to your own school’s behaviour policy from a single settings tab - set your own thresholds, sanction wording and staff terminology, and switch off any category you don’t track (e.g. uniform or iPad damage). No formula editing required. Also included: an iPad damage log, a mobile phone incident log, and an editable escalation policy reference page that updates automatically to match your settings. Designed for UK secondary schools (Years 7-13). Works with any school’s term and half-term dates - enter your dates once at the start of the year and the tracker runs itself. File type: Microsoft Excel (.xlsx). Requires Excel 365 or Excel 2021+ (uses dynamic array formulas) - not compatible with older Excel versions or Google Sheets. Keywords: pastoral tracker, behaviour tracker, attendance monitoring, Head of Year, form tutor, pupil premium, rewards tracker, escalation policy, secondary school, intervention tracker.

This listing is for the customisation service only. You’ll need to already own (or purchase separately) the original Pastoral Tracker resource before this service can be applied. If you don’t have it yet, check out my shop for the base resource, or look out for the bundle deal covering both together at a discount. The Pastoral Tracker is fully customisable to your own school policies - but if you’d rather not spend your own time working through categories, stages, and terminology, I’ll do it for you. This listing covers customisation to match one school policy exactly, including: Matching to your policy’s own wording Setting up the stages, sanctions, intervention levels etc. as they appear in your policy Adjusting any related drop-downs, labels, or scoring so the tracker reflects your policy step-by-step, not a generic version of it Why use this instead of doing it yourself: Saves you the time of manually rebuilding every category and label Done by the person who built the tracker, so it’s set up correctly first time No risk of formulas breaking if changes are made in the wrong place How it works: Purchase the original Pastoral Tracker (if you don’t already own it) Purchase this customisation listing Send me a copy of the policy (or relevant section) you’d like the tracker matched to I customise your tracker to match it exactly You receive the finished file within 1 week Buying both for the first time? Look out for the bundle option, which saves you money compared to buying the tracker and this service separately. Please note: This service can only be applied to the original Pastoral Tracker resource — please ensure you own it before purchasing. This covers matching to one policy.