Today you will
- sort your budget by Cost
- show only one category
- screenshot that view for your portfolio
Open {{code:05_project_budget}} from your Project Portfolio now. If it's missing or has no Category column, make a new spreadsheet with that name. Copy this table in, starting at cell {{cell:A1}}.
| Item | Category | Cost |
|---|---|---|
| Postage bags and labels | Shipping | 12 |
| Heat press hire | Tools | 45 |
| Instagram promo boost | Marketing | 20 |
| Clear phone cases | Materials | 35 |
| Vinyl print sheets | Materials | 28.50 |
| Total | =SUM(C2:C6) |
Warm-up
What are the three dearest items in your budget? Could you find them without scrolling?
Watch the board first. Your teacher will show a wrong sort and a right sort.
- Sort puts whole rows in order by one column, like Cost.
- Filter hides rows you don't need. Nothing is deleted.
- Full range means selecting every column of the table before you sort, leaving out the Total row.
- Header row is the top row of labels, like Item and Cost.
If you sort only the Cost column, prices move but names stay put. Heat press hire ends up next to the wrong price.
Now you'll sort your own budget by Cost and then show one category only. Watch your teacher first, then follow the steps in the box below and tick each one.
- My items don't match their costs. You sorted one column on its own. Press {{kbd:Ctrl+Z}}, or {{kbd:Cmd+Z}} on a Mac, then select the whole table and sort again.
- My headings or Total ended up in the list. Press Undo. Then tick the header box and stop your selection above Total.
- I think the filter deleted rows. They are only hidden. Open the Category arrow and tick Select all.
Portfolio evidence
- Check your budget is still sorted by Cost, biggest first.
- Check that only one Category is showing.
- Take a screenshot with {{kbd:Win+Shift+S}} on Windows, {{kbd:Shift+Cmd+4}} on a Mac, or {{kbd:Shift+Ctrl+Show windows}} on a Chromebook.
- Name the file exactly {{code:05_filtered_view.png}}.
- Save it in your Project Portfolio, in {{code:05_budget}} if you use it.
If something looks wrong, fix just that part using the steps from before.
- My budget is sorted by Cost, and each item keeps its own category.
- Only one Category is showing.
- {{code:05_filtered_view.png}} is saved in my Project Portfolio.
- My Total still works when I clear the filter.
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.