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 project I

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 create a spreadsheet model for an event to investigate income and costs.

Key Notes

  • A spreadsheet can be used to model real-world events.
  • A spreadsheet can be used to calculate whether an event will make a profit, loss or break-even.
  • A spreadsheet model can help event organisers decide what they should charge or whether they need to reduce costs.

Vocabulary To Learn

  • fixed cost: something that will stay the same no matter how many people attend the event
  • variable cost: changes depending on how many people attend the event
  • profit: the amount of money made after subtracting all costs from total revenue
  • loss: occurs when total costs are greater than total revenue
  • break-even: the point at which the total revenue equals total costs

Common Mistakes To Avoid

  • A spreadsheet can only be used to explore the costs of the event after it has happened.

3 Quick Questions (With Answers)

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

A spreadsheet can be used to model real-world events. A spreadsheet can be used to calculate whether an event will make a profit, loss or break-even.

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

something that will stay the same no matter how many people attend the event. Add one real device or system example to prove understanding.

3. Correct this common computing misconception.

Mistake: A spreadsheet can only be used to explore the costs of the event after it has happened. Correction: A spreadsheet model can be used to predict and model the costs of the event before it happens to help the organisers make decisions about income and expenditure.

More Lessons In This Unit

Browse all guides in the Year 11 Computing guide library.