National 5 PE Tracker | Editable Excel Spreadsheet
A ready-to-use Excel tracking and monitoring workbook for National 5 Physical Education — with every portfolio question tracked on a single sheet.
Type your pupil names in once and every sheet updates automatically.
Includes:
Portfolio sheet with a column for all 20 assessment items, Q1 through to 3f, with marks available shown for each
Performance sheet for both single performance events
Pupil overview — portfolio and performance combined out of 120, working grade and progress against target
Question analysis — class average on every individual question, so you can see exactly where marks are being lost
Class summary with grade distribution and section-by-section performance
Editable grade boundaries
“How to Use” sheet
Cells won’t accept a mark higher than the question is worth, and every mark shades itself green, amber or red against the marks available — so a weak answer stands out whether it’s a 1-mark or a 6-mark question.
Fully editable and built for up to 150 pupils. Ideal for tracking meetings, parents’ evenings, estimate submissions and faculty reporting.
Question wording follows the current portfolio assessment task.









