Today you will
- open a blank spreadsheet.
- move around with Tab, Enter and the arrow keys.
- make {{code:05_project_budget}} in your {{code:05_budget}} folder, with at least five rows of your own costs.
Your budget file counts towards your ICT2 Key Assignment.
Warm-up
Name one cost for your project, like printing or travel to Work Experience. Is it a number you could add up later?
A cell is one box. It is named by its column letter and row number, like A1.
A row runs left to right, and a column runs top to bottom.
A sheet tab is one page in the workbook, often called Sheet1.
Text is words, like an item name. Numbers are values you can add up later.
In the Cost column, type plain numbers only, like 18.5. Never type € or extra spaces.
Example: Niamh's keyring stall budget
| Item | Category | Cost | Notes |
|---|---|---|---|
| Blank acrylic discs (50) | Materials | 18.5 | Craft supplier pack |
| Jump rings (100 pack) | Materials | 3.8 | Silver tone |
| Organza gift bags | Packaging | 5.5 | 50 pack |
| Market stall fee | Event | 25 | Saturday craft market |
| Business cards | Promo | 15 | Local print shop |
You will make {{code:05_project_budget}} and type Niamh's sample rows to learn the layout. Follow the steps in the box below for your app.
If time is short, skip sample rows 3 to 5. Everyone must clear the samples and type the practice row before moving on.
Common issues
- If your file is not in {{code:05_budget}}, move {{code:05_project_budget}} into that folder.
- If a cost sits on the left like a word, clear the cell and type only the number, like 18.5.
- If you delete rows by mistake, press Undo straight away. Then clear the cells with {{key:Delete}} instead.
Independent Practice
- Stay in {{code:05_project_budget}} in your {{code:05_budget}} folder.
- Clear the Travel row so only the headings in row 1 are left.
- Add at least five rows of your own costs. Ten rows is the stretch target.
- In Cost, type plain numbers only, with no € sign or spaces.
- In Notes, write a supplier name, or write planned if the cost is a guess.
If your list is short, you can pick costs from the list below.
materials pack, printing, travel to Work Experience, tools, stall or platform fee, packaging, poster or flyer, gloves or safety kit, online listing fee, notebook or stationery
- My file is saved in {{code:05_budget}}.
- Row 1 has Item, Category, Cost and Notes.
- I have at least five rows of my own costs.
- Every Cost is a plain number.
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.