Maths Standard Year 11 - Module 1 - Lesson 6

Formula Modelling with Spreadsheets

Practise reading cell formulas, calculating outputs and explaining changed inputs.

Name
Date
Class

1. Key Ideas

  • Cell references stand in for values in a table.
  • A copied spreadsheet formula repeats the same relationship.
  • Changing an input changes the output according to the formula.

2. Success Criteria

  • I can interpret a cell-style formula in words.
  • I can write a spreadsheet formula for a practical calculation.
  • I can explain why unit consistency matters.

3. Cell Values

CellMeaningValue
B2Quantity18
C2Price per item$3
D2Delivery fee$12

4. Short Answer Questions

1. Explain in words what =B2*C2+D2 calculates using the table above. 2 marks

2. Calculate the value of =B2*C2+D2 using the table above. 2 marks

3. Write a formula for total pay if B2 is hours worked, C2 is hourly rate and D2 is a fixed allowance. 2 marks

4. A formula is T = 8n + 15. Compare the output when n changes from 10 to 14. 3 marks

5. Explain one error that could happen if one row uses dollars and another row uses cents. 2 marks

HSCScience - Printable lesson worksheet - Maths Standard Year 11 - Module 1 - Lesson 6