Whole School Foundation Subject Tracking Spreadsheets - Easy, Quick, Useful

Whole School Foundation Assessment Tracking

Important – this has not been created to tick an Ofsted box! It is a quick way to create useful results.

Key Features

• Excellent way to gain a whole school picture of Foundation Subjects to drive school improvement.
• Quick and easy to populate and complete.
• Gain a whole school picture of attainment, coverage and understanding of each subject.
• Self-calculating to quickly give percentage of children working ‘below’, ‘at’ and ‘above’ the expected standard.
• Only needs to be completed twice a year.
• Drop down menus to aid the quick input of data.
• Notes section to allow year groups teams to communicate with subject coordinators (great for noting gaps in resources when setting budgets)
• Objectives included for most foundation subjects*
• Great resource for teachers, subject leaders and senior leaders

*MFL not included for years 1 & 2

Instructions:

1. Copy and paste year group, class and names on to the first sheet.
2. Red, amber or green objectives and coverage (these can be adapted to meet the needs of the school) for each foundation subject on the tabs at the bottom of the spreadsheet.
3. Add any notes for subject leaders.
4. State whether a child is working ‘below’, ‘at’ or ‘above’ the expected standard for each subject on the first tab.

**Note – in our school, year group teams are given two staff meetings a year to complete the document (mid-year and end of year). Having done it for a couple of years, (with some year groups up to 100 children) it can be completed in under two hours. **