sports-day-house-points.xlsx, that does the totalling
for you — the printed sheets work completely on their own without it.
Per-event scoring sheets, a house totals sheet, a display leaderboard and an optional individual record sheet — plus a spreadsheet that totals automatically. The printed sheets are complete on their own; the arithmetic has been kept small enough to do on a calculator at the side of a field.
Make this decision before you print anything
Settings do not agree on a points scheme and there is no standard one. Use the scheme your own setting already uses. If you are starting from scratch, the two below are the ones you will most often meet in UK primary schools — but your setting's own practice is the answer, not ours.
| Place | Points |
|---|---|
| 1st | 4 |
| 2nd | 3 |
| 3rd | 2 |
| 4th and below | 1 |
Everyone who runs scores something, so there is no heat that earns nothing. Totals climb steadily and the gap between houses stays small, which keeps the whole afternoon live. The better scheme if you want the result in doubt until the relays.
| Place | Points |
|---|---|
| 1st | 5 |
| 2nd | 3 |
| 3rd | 1 |
| 4th and below | 0 |
Simpler to add up and more decisive, because winning is worth five times a third place. The cost is that a participant who finishes fourth has scored nothing for their house, which is worth thinking about before you choose it.
Add one point per participant for taking part, in either scheme. It is the single most useful line in this resource and the one most often left out. It means every participant contributes to their house whatever their result; it rewards the house that gets everybody out and entered, which is the behaviour you want; and it means a house full of willing but not especially fast participants is genuinely in the competition rather than nominally in it.
The result slips in resource 02 carry an everyone took part tick box precisely so this point reaches the scorer without anyone being chased for it.
Four houses, one 24-participant event, six in each house, finishing in a realistic spread.
| House | 1sts | 2nds | 3rds | Lower | Scheme A | Scheme B | A + particip. | B + particip. |
|---|---|---|---|---|---|---|---|---|
| Red | 2 | 1 | 1 | 2 | 15 | 14 | 21 | 20 |
| Blue | 1 | 2 | 1 | 2 | 14 | 12 | 20 | 18 |
| Green | 1 | 1 | 2 | 2 | 13 | 10 | 19 | 16 |
| Yellow | 0 | 0 | 0 | 6 | 6 | 0 | 12 | 6 |
Look at the Yellow row. Under Scheme B with no participation point, a house in which six people competed and none placed scores nothing at all. Under Scheme A with a participation point it scores 12. Which is right depends entirely on what your sports day is for — and that is a decision for your setting, not for us.
| Decision | Options | Your answer |
|---|---|---|
| Which scheme? | A / B / your own | |
| Participation point? | Yes / No | |
| Do relays score more? | Often double points, because they are a team event | |
| Do field events score the same as track? | Usually yes | |
| Are heats and finals both scored? | Finals only is simpler | |
| Does the staff race score? | Usually not | |
| How are ties broken? | Most firsts, then most seconds, then shared | |
| An overall individual award as well as a house result? | See the optional sheet on page 7 |
Swap-in by phase
sports-day-house-points.xlsx does the same job with the arithmetic done for you.
| Sheet | What it does |
|---|---|
| Setup | Name your houses and events, choose your scheme, switch the participation point on or off. Fill this in first — the other sheets read from it |
| Points scheme | The points for each place, and the participation point. Editable: if your setting uses something other than A or B, type your own numbers here and everything else follows |
| Event entry | One row per heat result. Type the event, the heat, the three houses and the number who took part. Points are worked out automatically |
| House totals | Totals per house per event, the participation points, and the grand total — all by formula. Nothing to type |
| Leaderboard | The current standings, sorted, large enough to project or print |
SUMIFS or equivalent, so you can check the working and so part-completed entry still totals correctly.If the spreadsheet is not available
The printed sheets are complete on their own. They were designed first and the spreadsheet was built to match them, not the other way round. All you need is: places from the result slips, points from your scheme, one point per participant if you are using the participation point, and two people adding up independently.
One per event. Print as many as you have events, plus spares. The scorer fills it in from the result slips as they arrive.
| Heat | Place | Name (optional) | House / team | Points | Took part | Particip. points |
|---|---|---|---|---|---|---|
| 1 | 1st | |||||
| 2nd | ||||||
| 3rd | ||||||
| 2 | 1st | |||||
| 2nd | ||||||
| 3rd | ||||||
| 3 | 1st | |||||
| 2nd | ||||||
| 3rd | ||||||
| 4 | 1st | |||||
| 2nd | ||||||
| 3rd | ||||||
| 5 | 1st | |||||
| 2nd | ||||||
| 3rd |
How the scorer works it
A slip arrives. Write the three houses against 1st, 2nd and 3rd for that heat, and the points from your scheme beside each. Tick the took part column if the slip says so, and write the number of participants in that heat into the participation points column. When all the heats for an event are in, add each house's column and write the total in the box. Then — and this is the step that gets missed — tick "carried to totals sheet".
One per sports day, printed twice. This is the running ledger.
| # | Event | House 1 | House 2 | House 3 | House 4 | Checked |
|---|---|---|---|---|---|---|
| 1 | ☐ | |||||
| 2 | ☐ | |||||
| 3 | ☐ | |||||
| 4 | ☐ | |||||
| 5 | ☐ | |||||
| 6 | ☐ | |||||
| 7 | ☐ | |||||
| 8 | ☐ | |||||
| 9 | ☐ | |||||
| 10 | ☐ | |||||
| 11 | ☐ | |||||
| 12 | ☐ | |||||
| 13 | ☐ | |||||
| 14 | ☐ | |||||
| Participation points | ☐ | |||||
| GRAND TOTAL |
1st place house 2nd 3rd
Added by Checked by
Two people, always
One adds, the other checks, independently. A sports day result that has to be corrected after it has been announced is a bad afternoon, and it is entirely avoidable.
SPORTS DAY
House points so far
| House | Points |
|---|---|
Updated after event at
SPORTS DAY
House points so far
| House | Points |
|---|---|
Updated after event at
Write the running total in pen and cross it out as it changes — the crossings-out are part of the appeal. Early years: do not display a leaderboard children can read as a ranking of themselves; display the whole group's total as one number climbing through the session instead.
Only if your setting gives an individual award as well as a house result.
| Name | House | Event 1 | Event 2 | Event 3 | Event 4 | Total |
|---|---|---|---|---|---|---|
A note worth making before you use this one: an individual leaderboard changes the feel of a sports day considerably, and in a primary setting it is usually the same small number of children at the top of it every year. That is a decision for your setting. The sheet is here because some settings want it; it is optional for a reason.