Today you will
- finish your problem-solving spreadsheet
- write a short explanation of how it answers your question
- save both files in {{code:sm3/}} for your Key Assignment
Every answer on your sheet must work itself out with a formula.
Open {{code:Project_Portfolio/09_specialism/sm3/}} and find {{code:sm3_problem_statement}}. What is your question, in one sentence? If you can't find it, write a new sentence about a real number question from your project.
A problem-first spreadsheet is built to answer one clear question.
Inputs are the numbers you can change, like the price or the number sold.
A live formula works out the answer again every time an input changes.
Your explanation says which features you used and why.
Aoife's question was: "Will I make a profit if I sell 50 cases at €12 each, with materials at €4.50 per case and fixed costs of €80?" Her sheet shows those inputs, live formulas and one highlighted answer.
Now you will finish {{code:sm3_ka1_problem_solver}}, your problem-solving spreadsheet for Key Assignment 1. Watch your teacher first, then follow the steps in the box below and tick each one.
Common issues
- My answer does not change. You typed a number, so delete it and type a formula like {{formula:=B10-B12}}.
- I see {{code:#DIV/0!}}. A cell you divide by is blank or zero, so give it a real number.
- My explanation has no reasons. Write each point as "I used X because Y".
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 123Learn.ie 2017 - 2026. Unauthorised use, copying or distribution is not allowed.