Warm-up (30 seconds): Think of one thing you've seen someone use a spreadsheet for — a budget, a class list, a sports table? Jot it down.
This lesson helps you pick the right spreadsheet for your Something Real project — the one real thing you're building your Digital Portfolio around across this module.
What's special about spreadsheets: Imagine changing one number in a budget and watching ALL the totals update automatically. That's spreadsheets — a grid where every cell can calculate based on other cells. Unlike a word processor where 2+2=4 is just text, spreadsheets do live maths: type =2+2 in a cell and it shows 4. Change it to =5+3 and it instantly shows 8.
Your Something Real project needs numbers. This module teaches you to make them work for you.
Create two example spreadsheets to see how they organise and calculate numbers for budgets and tracking. Notice how formulas automatically update when numbers change — this is what makes spreadsheets powerful.
You just saw two spreadsheet patterns:
Your Something Real will use one of these patterns. Budgets answer 'How much will this cost?' Trackers answer 'How many attended/did we sell?' Both use the magic: change one number, everything updates.
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.