Edexcel GCSE PE Class Assessment Tracker with Automatic Excel Formulas

Editable Pearson Edexcel GCSE Physical Education class assessment tracker with automatic Excel formulas, cumulative progress analysis and a clear teacher dashboard.

This professionally designed Excel resource supports the five cumulative assessments within the complete Edexcel GCSE PE teaching sequence. It allows teachers to enter question level marks once and automatically generates student totals, percentages, performance bands and intervention priorities.

The tracker includes:

• A live class assessment dashboard
• Five cumulative assessment points
• Separate Assessment 5 Paper 1 and Paper 2 tracking
• Automatic combined Assessment 5 results out of 140 marks
• Space for up to 35 students
• Question level mark entry
• Automatic totals and percentages
• Class means, highest scores and completion figures
• Counts of students achieving 70% or above
• Identification of students below 40%
• Individual average percentages
• Progress trends across the course
• Latest performance bands
• Suggested intervention priorities
• Three example students with completed Assessment 1 results
• A clear guidance sheet
• Editable yellow input cells
• Professional Edexcel inspired blue branding

The workbook is supplied as an editable Excel file. Teachers can replace the example students, enter their class list and begin recording results immediately. All linked sheets, calculations and dashboard information update automatically.

This resource is ideal for monitoring progress, identifying misconceptions, planning intervention, supporting progress meetings and reporting whole class performance throughout the two year GCSE course.

The percentage performance bands are internal tracking indicators and are not official Pearson Edexcel grade boundaries. Schools can adapt these indicators to match their own assessment policies.