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 Hub Browse Year 11 Computing Guides

Year 11 - Computing

Spreadsheet project II

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 use a spreadsheet to model different scenarios for an event and use the model to make recommendations.

Key Notes

A spreadsheet model can be used for what-if analysis.
Different types of charts are suitable for different purposes.
The COUNTIF function can be used to count how many cells meet a set criterion.

Vocabulary To Learn

scenario: where different sets of input values are used within a spreadsheet to explore various potential outcomes
COUNTIF: function used to count how many cells meet a set criterion

Common Mistakes To Avoid

The COUNTIF function is the same as the COUNT function.

3 Quick Questions (With Answers)

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

A spreadsheet model can be used for what-if analysis. Different types of charts are suitable for different purposes.

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

where different sets of input values are used within a spreadsheet to explore various potential outcomes. Add one real device or system example to prove understanding.

3. Correct this common computing misconception.

Mistake: The COUNTIF function is the same as the COUNT function. Correction: A COUNTIF function returns the total number of cells based on a set criterion, whereas the COUNT function returns the number of cells that contain a number in a range.

More Lessons In This Unit

Browse all guides in the Year 11 Computing guide library.