This spreadsheet is a time saving resource for class teachers, heads of department and school leaders.
Included is a ready formatted copy of the spreadsheet and a PDF ‘How to’ guide which breaks down and explains step-by-step. This PDF also offers answers to several FAQs and offers tips and advice.
This spreadsheet is designed to allow class teachers and HoDs to easily monitor student progress over time and identify students for intervention.
Once set up using the how-to guide, class teachers simply need to enter assessment scores and the Excel sheet automatically calculates percentages, grades and whether each student is below, on or above target. The workbook also analyses data and breaks down the % of students above, achieving or below target for key groups such as SEND, PP, EAL, etc. This data can also broken down by each class in that year group.
Please note this version is best used with subjects that have only a single tier of entry (i.e. not foundation / higher subjects)