This topic is about building spreadsheets that keep working when the numbers change. You then show the results clearly in charts and printouts. In a practical task you are marked on whether the sheet is correct, readable and sturdy, not just on one right-looking answer.
The lessons take one habit at a time: separating inputs from formulas, choosing a chart, formatting units, testing the edges and checking what actually prints.
What do you need to know first?
You should be able to enter data, write a formula that uses cell references, and use basic functions such as SUM and IF. Cell references (such as B3) matter most, because every lesson here needs formulas that point at cells instead of typed numbers. Practise on the spreadsheet reference practice grid.
One worked example to orient you
An invented school club, the Kelab Sains, sells 120 badges at RM2.50 each. Each badge costs RM1.20 to make.
| Cell | Label | Content | Result |
|---|---|---|---|
| B3 | Price (RM) | 2.50 | input |
| B4 | Badges sold | 120 | input |
| B5 | Cost each (RM) | 1.20 | input |
| B8 | Revenue | =B3*B4 | 300.00 |
| B9 | Total cost | =B5*B4 | 144.00 |
| B10 | Profit | =B8-B9 | 156.00 |
Change B3 to 3.00 and the revenue becomes 360.00 and the profit 216.00 without touching a formula. That is what makes it a model. A column chart of revenue, cost and profit then shows the three results at a glance.
In what order should you study the lessons?
- Separate inputs, calculations and outputs: the layout that makes every later check possible.
- Create a chart suited to the data relationship: matching trend, comparison, share and relationship to the right chart.
- Format units without converting numbers to text: showing RM, kg or % while keeping the cell a real number.
- Test a model with boundary inputs: trying the values at the edge of each rule.
- Check print areas and hidden rows: making sure the printout and the totals say what you think.
Finish with the mixed practice set. To check your own task evidence, use the ICT practical task and evidence checker. Also, the read-only SQL practice lab shows how similar ideas apply to database queries.
What are the common traps?
- Typing a number inside a formula, such as =2.5*B4, so the model ignores the price cell.
- Choosing a line chart for separate categories, or a pie chart with too many slices.
- Typing “12kg” into a cell, which turns the number into text that SUM skips.
- Testing only a typical value and never the exact boundary of a rule.
- Hiding rows and forgetting that the printout, or a total, may not match what you see.
How should you use the practice set?
Attempt each question on paper or in your own sheet first, then open the answer. When you lose a mark, note the habit involved and return to the matching lesson. The mistake log is a simple way to keep that list.
If your models work once and then break when a number changes, a teacher in online one-to-one ICT tuition can go through your own sheets and tasks with you.