CIC Monitoring Tracker — Termly Overview Spreadsheet

This comprehensive Excel tracker has been designed to support Designated Teachers and pastoral leaders in meeting their statutory duties for Children in Care. It provides a structured, termly record for up to nine looked-after students, bringing all key monitoring information into a single, easy-to-navigate spreadsheet.
Each student record includes:

Social worker contact details and key placement information
PEP (Personal Education Plan) dates and completion status, tracked across the autumn, spring and summer terms
SDQ (Strengths and Difficulties Questionnaire) scores with automatic colour coding to flag normal, borderline and abnormal ranges
Termly attendance data with built-in conditional formatting to highlight students falling below the 90% and 95% thresholds
Subject targets and progress notes
Pupil Premium Plus (PP+) spend log with categorised expenditure, term-by-term totals, and a whole-cohort summary

The tracker is fully editable, clearly colour coded for quick visual monitoring, and structured to support PEP reviews, governor reporting, and Virtual School conversations.

Suitable for: Designated Teachers for CIC, pastoral leaders, SENCOs, heads of year, and Virtual School staff.