
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.
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.