xlsx, 20.96 KB
xlsx, 20.96 KB
png, 195.59 KB
png, 195.59 KB
png, 153.46 KB
png, 153.46 KB
png, 128.13 KB
png, 128.13 KB

Stop calculating attendance percentages by hand. This Excel tracker does it for you.

Log each session in the Register tab: date, student, form/class, AM/PM, and status from a dropdown (Present, Late, Authorised Absence, Unauthorised Absence, School Activity). That’s it.

What happens automatically:

  • Student names pull through into the Student Summary tab, no re-typing names.
  • Attendance percentage is calculated live for every student.
  • Anyone below 90% attendance is flagged in red automatically.
  • A built-in Dashboard tab shows headline stats (students tracked, students below 90%, average attendance) plus a live chart, ready to show at a pastoral or SLT meeting with zero setup.

Also included:

  • Clear Instructions tab, no training needed.
  • Dropdown menus 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, no special functions or add-ins required.

Ideal for: form tutors, Heads of Year and pastoral leads who need attendance visibility without the admin overhead.

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.