Today you will
- check your budget spreadsheet against the KA1 checklist
- mark each row Met, Partial or Gap
- write a list of the three fixes you will make first
This is for Key Assignment 1 (KA1).
Warm-up
Open {{code:05_project_budget}} and click your total cell. Look at the formula bar. Do you have several formulas, one, or none? If you can't find the file, that's fine, because you can still do the check.
Key words
- KA1 asks for your best spreadsheet that uses formulas for a real task you are doing.
- Formula bar: this shows what is really in a cell. A formula starts with {{code:=}}, but a typed total is just a number.
- Met, Partial, Gap: done, half done, or missing.
Example
Jamie is planning a budget for a cake side hustle. The total uses {{formula:=SUM(...)}}, so that row is Met. Nothing flags pricey items with IF, so that row is a Gap.
Watch your teacher fill in one row first. Then follow the steps in the box below to make {{code:05_ka1_gap_check}} and mark each row of the checklist.
Copy this starter into your new document:
| Criterion | Met / Partial / Gap | Evidence or fix |
|---|---|---|
| 1. Sheet is for a task I am involved in | ||
| 2. Numeric and character data entered | ||
| 3. At least one aggregate formula (e.g. SUM / AVERAGE) | ||
| 4. MIN / MAX or COUNT-style formula | ||
| 5. Formula that uses a cell reference across rows (autofill or %) | ||
| 6. Logical formula (IF) that flags a decision | ||
| 7. Currency / date / readable formatting | ||
| 8. Formulas answer a real project question |
Action list (top 3)
1.
2.
3.
Common issues
- I can't find {{code:05_project_budget}}. Search for it in your drive. If it's gone, tell your teacher and mark the formula rows as Gap.
- My total shows only a number in the formula bar. It was typed, so mark row 3 as a Gap.
- I don't know what to write as a note. Keep it short, like this: "Partial, total is SUM but no IF flag".
Independent Practice
- Open {{code:05_ka1_gap_check}} in your {{code:05_budget}} folder.
- Make sure all eight rows have a mark and a short note.
- Check that row 1 names your real project, not made-up data.
- Under Action list (top 3), write your three most important fixes, with the most important first.
Lots of Gap marks are fine. They show you what to build next.
- My file is saved in {{code:05_budget}}.
- All eight rows have a mark and a note.
- Row 1 names my real Something Real task.
- My Action list has three fixes in order.
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.