Today you will
- check your project spreadsheet against six evidence points
- write one sentence in the sheet saying what it does
- save your sheet and a matching PDF for your teacher to check
Your working file today is {{code:05_ka1_best_spreadsheet}} in {{code:05_budget}}. This work is for Key Assignment 1.
Warm-up
Someone from Work Experience asks you, "What does this sheet actually do?" What one sentence would you say back?
A live formula starts with = and updates when a number changes.
A live test means you change one cost and watch the total update.
Your one-sentence description goes in {{cell:A2}}. It says what the sheet works out and why.
Teacher verification means your teacher checks your files before your Key Assignment counts towards your credit.
Sentence frame
This sheet [calculates X] so I can [decide Y].
Example
"This sheet totals my phone-case startup costs and flags any item over €20 so I know where to cut."
First you will build Aoife's sample sheet and run the six checks on it. Then you will do the same checks on your own sheet later. Follow the steps in the box below.
Here is what to copy into Aoife's sheet.
Title for A1
Aoife's Phone-Case Stall: Start-up Costs
Sentence for A2
This sheet totals my phone-case stall start-up costs so I can decide if my €100 savings cover them.
Table to paste at A3
| Item | Category | Cost (€) | Notes |
|---|---|---|---|
| Clear phone cases (20) | Stock | 24 | Online supplier |
| Vinyl sheets | Materials | 8.5 | Mixed colours |
| Craft knife and mat | Tools | 12 | One-off buy |
| Packaging bags (50) | Packaging | 6 | Brown kraft |
| Market stall fee | Venue | 25 | Saturday market, Galway |
| Price tags | Promo | 3 | Roll of 100 |
Common issues
- The total doesn't change in the live test. The total is a typed number, so replace it with a formula like {{formula:=SUM(C4:C9)}}.
- I can't find {{code:05_ka1_best_spreadsheet}}. Open {{code:05_budget}} and rename {{code:05_project_budget}} to {{code:05_ka1_best_spreadsheet}}.
- My PDF has a random name or is stuck in Downloads. Rename it {{code:05_ka1_best_spreadsheet}} and move it into {{code:05_budget}}.
Portfolio Build
- Open {{code:05_ka1_best_spreadsheet}} in {{code:05_budget}}.
- Check your formulas, then do a live test.
- Insert two rows at the top. Type your project title in {{cell:A1}} and your sentence in {{cell:A2}}. Use this sentence frame:
This sheet [calculates X] so I can [decide Y].
- Save a PDF named {{code:05_ka1_best_spreadsheet}} beside the sheet in {{code:05_budget}}.
- If you have time, make a document called {{code:05_unit1_reflection}} in {{code:05_budget}}. Type these three headings and write two or three sentences under each.
What the sheet does (This sheet…)
How it helps my Something Real project (It helps my project because…)
What I learned in Unit 1 (One skill I can reuse is…)
- My formulas update when I change a number.
- My title is in {{cell:A1}} and my sentence is in {{cell:A2}}.
- My PDF, named {{code:05_ka1_best_spreadsheet}}, is beside my sheet in {{code:05_budget}}.
Unlock the full learning experience
You're previewing this lesson. Get full access to this lesson and hundreds more — each one ready to teach, with interactive activities, printable resources and pupil progress tracking built in.
This lesson is copyright of Coding Ireland 2017 - 2025. Unauthorised use, copying or distribution is not allowed.