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

What Real People Actually Use Spreadsheets For

Discover how creators, sports clubs, event organisers and small businesses use spreadsheets for tracking engagement, match statistics, budgets and profits. Explore real examples and select two uses that support your Something Real project.

Teacher Class Feed

Load previous activity

    1 - Introduction ~5 mins

    Today you will

    • see what real people use spreadsheets for
    • sort real spreadsheet jobs with the class
    • pick two uses that fit your Something Real project

    Warm-up

    Think of one number you care about outside school, like streams, match points or money from a side hustle. Could a spreadsheet help you track it?

    Keep one project question in mind, such as a cost or a time question. You will use it later.

    2 - Key Concepts ~8 mins

    A spreadsheet helps you answer a question with numbers. Real people use them in four main ways.

    • Creator analytics tracks views, saves or streams over time.
    • Money and budgets work out sales, costs and ticket prices.
    • Sport stats log scores and points across a season.
    • Survey data puts each answer in its own row.

    Example: Sam's two picks

    Sam sells custom stickers. Sam picked a money model for profit on 40 packs at €8, and an inventory log so stock never runs out.

    3 - Sort Real Spreadsheet Uses ~15 mins

    As a class, you will sort real spreadsheet jobs into groups. For each card, say where it goes and why. It's fine to disagree.

    Then drag every card into a group, and press {{btn:Check}} when the class is ready.

    What job is this spreadsheet doing?

    4 - Independent Practice ~20 mins

    Independent Practice

    Your goal: Write five real spreadsheet uses and pick the two that help your Something Real project most.
    Time: ~20 minutes
    Task:
    1. In {{code:09_specialism/sm3/}}, make a document called {{code:sm3_spreadsheet_uses}}.
    2. Type the three headings from the box below.
    3. Under Five uses, write five uses in full sentences, like Sam's.
    4. Under the other headings, name your two picks and write one reason for each.
    5. Make sure at least one pick answers your Spreadsheet Problem Statement or your project question.

    Five uses

    Two project picks

    Why it answers my question

    For example, write "Money model for profit if 40 packs sell at €8", not just "budget".

    Success criteria:
    • {{code:sm3_spreadsheet_uses}} is saved in {{code:sm3/}}.
    • I listed five real uses in full sentences.
    • I picked two uses, each with a reason.
    • One pick links to my project question.

    5 - Reflection ~5 mins

    Think about

    • Which spreadsheet use surprised you most today?
    • Which of your two picks would change a decision if the numbers looked bad?

    Tell a partner one of your answers.

    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