Intermediate
60 mins
Teacher/Student led
+80 XP
Pupils work through this independently

What's a Spreadsheet For?: Suitable Uses

Learn to identify when spreadsheets are the best tool for tasks like budgets, trackers and lists. Decide between spreadsheets and word processors, and connect ideas to your Something Real project by picking the most useful one.

Teacher Class Feed

Load previous activity

    1 - Introduction ~5 mins

    Today you will

    • find out what jobs a spreadsheet is good at
    • decide when a spreadsheet is better than a word processor
    • write three spreadsheet ideas for your Something Real project and pick the best one

    Warm-up

    Think of one number that matters for your project, like a cost, a score or a stock count. Would you keep it in a paragraph, or in a grid where you can add it up?

    The same four costs for a club car wash, written two ways. In a paragraph: sponges €6, two buckets €10, car shampoo €8.50 and posters €4, with the total still to work out. In a spreadsheet grid: the same costs down one column, with the total, €28.50, at the bottom.

    2 - Key Concepts ~6 mins

    A spreadsheet is a grid of cells in rows and columns, built for numbers and short labels.

    Suitable uses are jobs like budgets, trackers, tallies and stock lists.

    Tool fit means you use a spreadsheet for data and a word processor for writing.

    Your project pick is the most useful idea for your project.

    Aoife's example

    Aoife bakes cakes to order. Her ideas are a budget, an order tracker and a stock list. She picks the budget because it helps her set her price.

    Aoife's first-month budget in a spreadsheet: a grid with columns A to D and rows 1 to 5. Row 1 has the labels Item, Category, Cost (€) and Date. Each row below is one thing she buys: flour, sugar and butter, eggs and cream, 20 cake boxes and delivery fuel. One column, one row and one cell are marked.

    3 - Right Tool or Wrong Tool? ~15 mins

    You will sort each job into the tool that fits it best, as a class. When every card is in a bucket, click Check.

    Right tool or wrong tool?

    4 - Common Issues ~4 mins

    Common issues

    • Both tools seem to fit. If you need a total, a sort or a chart, use a spreadsheet. If you need sentences, use a word processor.
    • My project has no numbers. Look for costs, dates, hours, scores or a list of people.
    • A card bounced back. Ask yourself if the job is data or writing, then try the other bucket.
    123learn · Online learning platform

    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.

    Hundreds of curriculum-aligned lessons
    Interactive activities in every lesson
    Printable resources & progress tracking
    Copyright Notice
    This lesson is copyright of Coding Ireland 2017 - 2026. Unauthorised use, copying or distribution is not allowed.
    🍪 Our website uses cookies to make your browsing experience better. By using our website you agree to our use of cookies. Learn more