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

Specialism Module 3 Kickoff: Revisit Your Project Data

Today you take stock of the project data you already hold, spot what is missing, and write one sharp problem that a spreadsheet can solve for your Something Real project.

Teacher Class Feed

Load previous activity

    1 - Introduction ~5 mins

    Today you will

    • look at the project data you already have
    • list the figures your project still needs
    • write one real problem a spreadsheet will solve

    Warm-up

    Think of one number in your Something Real project that you still guess, like a cost per person or the tickets you need to sell.

    If you have no spreadsheet yet, that's fine. Use notes, receipts or Work Experience hours.

    2 - Key Concepts ~6 mins

    Key words

    • A stocktake is a quick check of the data you already have.
    • A problem-solving spreadsheet answers one clear question.
    • A decision-ready question has an answer that changes what you do next.
    • Data you need means the figures you still have to find out.

    Example: GripLocal

    "Make a budget for my phone-grip side hustle" is too vague. A better question is: "Will GripLocal break even if I sell 40 grips a month at €18 each, when each grip costs €6 and fixed costs are €45 a month?"

    3 - Common Issues ~4 mins

    Common issues

    • I can't find an old spreadsheet. That's fine today. Use notes, receipts, messages or Work Experience details instead.
    • My folder looks different. Use {{code:Project_Portfolio}} and open {{code:09_specialism}}, then {{code:sm3}}. Ask your teacher before you make a new folder.
    • My problem is too vague. Rewrite it as one question with a number, a price and a decision, like the GripLocal example.

    4 - Project Data Stocktake ~15 mins

    Check what you already have

    Your teacher will show an example on the screen first. Then do the same with your own Something Real project.

    1. Open your old spreadsheet, or gather your notes, receipts or Work Experience figures.
    2. Write down what you found. If you have no sheet, write no sheet yet.
    3. Write down two figures that are missing.
    4. Write down one question your data can't answer yet.

    What I found:

    Two missing inputs:
    1.
    2.

    One question my data can't answer yet:

    Exploration

    5 - Portfolio Build ~20 mins

    Class practice: problem statement

    Your goal: Write down one real problem your Module 3 spreadsheet will solve. Key Assignment
    Time: ~20 minutes
    Task:
    1. Open {{code:Project_Portfolio}}, then {{code:09_specialism}}, then {{code:sm3}}.
    2. Make a new document called {{code:sm3_problem_statement}}. On {{code:onedrive.com}}, click {{btn:New}} and then {{btn:Word document}}. On {{code:drive.google.com}}, click {{btn:New}} and then {{btn:Google Docs}}.
    3. Type your name and class on the first line.
    4. Copy the six headings below into your document.
    5. Fill in each heading for your own project. Use the sentence starters if you get stuck.

    Project name

    The real question (one sentence)

    Data I already have

    Data I still need

    Who will use the answer

    Success looks like

    • The real question: Will ___ if I ___ at €___ when ___?
    • Data I already have: price/rate ___; unit or material cost ___; fixed cost or hours ___
    • Data I still need: ___; ___
    • Who will use the answer: me when I decide ___; my teacher / supervisor when ___
    • Success looks like: a sheet where changing ___ instantly shows ___
    Success criteria:
    • {{code:sm3_problem_statement}} is saved in {{code:sm3}}.
    • My name and class are on the first line.
    • My real question is one sentence and names a decision.
    • Both data headings list things from my own project.
    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