OCR GCSE PE J587 Class Assessment Tracker with Automatic Excel Formulas

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

This professionally designed Excel resource supports five cumulative assessment points across the complete OCR GCSE PE course. Teachers enter question level marks once and the workbook automatically calculates student totals, percentages, performance bands and intervention priorities.

The tracker includes:

• A live class assessment dashboard
• Five cumulative assessment points
• Separate Assessment 5 Component 01 and Component 02 tracking
• Automatic combined Assessment 5 results
• Space for up to 35 students
• Question level mark entry
• Automatic totals and percentages
• Class means and highest scores
• Assessment 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 OCR inspired orange and black branding

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

The tracker has been designed to accompany the OCR cumulative assessment package and teaching sequence. It is ideal for monitoring progress, identifying misconceptions, planning intervention, supporting department progress meetings and reporting whole class performance throughout the two year course.

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