FREE editable Excel tracker for Pearson Edexcel GCSE PE, combining written examinations, practical performance and PEP results.
FREE editable Pearson Edexcel GCSE Physical Education whole course class tracker.

This automated Excel workbook allows GCSE PE teachers to record and monitor attainment across the complete Pearson Edexcel 1PE0 qualification.

The tracker includes:

• Component 1: Fitness and Body Systems marks out of 80
• Component 2: Health and Performance marks out of 60
• Three practical activities with scores out of 35
• Team and individual activity classifications
• Automatic checks for valid practical activity combinations
• Component 4 Personal Exercise Programme marks out of 20
• Automatic Pearson Edexcel weighting calculations
• Overall qualification totals out of 350
• Working grades using editable grade boundaries
• Target grade comparisons and progress indicators
• A class dashboard with averages, grade distribution and attainment information
• Dropdown activity lists
• Three example students to demonstrate how the tracker works
• Guidance and editable grade boundary sheets

The spreadsheet applies the correct course weighting of 36% for Component 1, 24% for Component 2, 30% for practical performance and 10% for the PEP.

Yellow cells identify where teachers should enter information. All totals, percentages, grades and progress measures calculate automatically.

This free tracker is designed to save teachers time and provide a clear overview of examination, practical and coursework performance in one place.

If you find this resource useful, please check out my other Pearson Edexcel GCSE Physical Education resources on TES. My wider collection includes complete student workbooks, teaching PowerPoints, original cumulative assessments, mark schemes, revision guides, teacher answer booklets and PEP support materials.

File type: Microsoft Excel workbook (.xlsx)