Study Hub

Study Guides

This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.

Back to Study HubBrowse Year 11 Computing Guides

Year 11 - Computing

Spreadsheet modelling

Spreadsheets

Unit Summary

In this unit pupils will explore how to use spreadsheets to store and manipulate data. They will use common functions and extract data to create visual representations using charts. Pupils will use spreadsheets to track and calculate income, make predictions, and answer "what if…?" questions.

Lesson Summary

You will learn to identify the key components of a spreadsheet and use a spreadsheet model for a given scenario.

Key Notes

  • Key components of a spreadsheet model include cells, rows, columns and sheets.
  • Spreadsheet formatting can be used to visualise data effectively.
  • Mathematical operations can be performed within cells using formulas and functions.
  • A spreadsheet model represents real-world scenarios using data, formulas and rules.

Vocabulary To Learn

  • cell: a rectangular box that holds data in a spreadsheet
  • formula: performs calculations in a spreadsheet
  • formatting: modifying the appearance of data in a spreadsheet
  • function: a predefined formula that performs a calculation

Common Mistakes To Avoid

  • Spreadsheet formatting is only used to make a spreadsheet look attractive.

3 Quick Questions (With Answers)

1. Describe the system or process from this lesson in clear steps.

Key components of a spreadsheet model include cells, rows, columns and sheets. Spreadsheet formatting can be used to visualise data effectively.

2. Define this computing term and give one practical example. 'cell'

a rectangular box that holds data in a spreadsheet. Add one real device or system example to prove understanding.

3. Correct this common computing misconception.

Mistake: Spreadsheet formatting is only used to make a spreadsheet look attractive. Correction: Spreadsheet formatting is used to make information clearer but is also important to ensure data values such as currency are formatted correctly.

More Lessons In This Unit

Browse all guides in the Year 11 Computing guide library.