S1 PE Tracking Spreadsheet | BGE Progress Tracker with Auto-Levelling | Editable Excel

S1 PE tracking that does the arithmetic for you.

One complete Excel workbook covering a full S1 year. You type your class lists in once and assess from dropdowns. Everything else — overall scores, levels, progress against target, whole-cohort figures — calculates itself.

How it works

Each activity has its own tab with the tracking criteria that genuinely fit it: balance and control for gymnastics, stamina and speed for fitness, decision making and leadership for team games, rhythm and timing for swimming. You select a level from a dropdown for each criterion and the workbook returns an overall score and level for that pupil in that block.

Assessment runs on a 9-point scale from Level 2 Bronze through to Level 4 Gold, so a pupil moving from Silver to Gold within a level registers as progress rather than standing still — which matters enormously in S1, where most of the year is spent inside a single level.

Seven activity tabs: badminton, basketball, fitness, gymnastics, swimming, team games and athletics.

What’s in the workbook

How to Use — a short guide, so a new member of staff can pick it up without a briefing
Rubric — the full 9-point scale, with the year target level as a single input cell
Seven activity tabs — dropdowns on the criteria columns, conditional Bronze/Silver/Gold colour, frozen headers, hidden working columns, space for 200 pupils
Pupil Overall — every pupil’s results across all seven blocks on one screen, with an “against target” column
Summary — whole-cohort view including the percentage of pupils at or above target
Criteria Breakdown — what each criterion actually means, in pupil-friendly descriptors, for every activity

Pitched for S1

Set for second into third level, with the target at Level 2 Silver–Gold — realistic for pupils arriving from a dozen different primaries with wildly different experience. If your department pitches differently, change the target cell on the Rubric tab and every calculation across the workbook follows it.

Why teachers use it

Reporting stops being a weekend job. The summary figures are already there when the deadline lands.
It standardises a department. Everyone assessing against the same named criteria and the same descriptors, rather than four teachers’ four readings of “good”.
Criteria are visible to pupils. The breakdown sheet is written to be shown, not filed.
Fully editable — rename activities, swap criteria, reword descriptors or adjust the scale to match your own tracking policy.

Who it’s for

Scottish secondary PE departments tracking S1 Broad General Education — particularly departments building a tracking system from scratch, or replacing one that’s grown unwieldy.

Please note: the matching S1 lesson slides and S1 lesson plans are listed separately. The slide set shows pupils which criterion is being tracked in each lesson, so the two work well together.