Unit Overview

In this unit you will use spreadsheets to model simple situations. You will use basic spreadsheet functions to construct, explore and amend simple models and consider how to manipulate graphs and tables in order to present your findings effectively. This unit uses the example of a school disco.

Lesson outlines

LESSON 1
Using a spreadsheet
1 Starter: Problem-solving using a table and paper-based resource
2 Using a formula in a spreadsheet
3 Creating a times table square
4 Setting up a simple spreadsheet
5 Using formulae to enter information into a spreadsheet
6 Plenary: Advantages and disadvantages of using a spreadsheet
Homework: Recording key advantages and disadvantages of spreadsheets

LESSON 2
Modelling using a spreadsheet
1 Starter: Problem-solving using a simple spreadsheet
2 The idea of a model
3 Using a model to find information
4 Interrogating a model to answer questions
5 Using and interrogating a different model
6 Plenary: Advantages of using a model
Homework: Identifying rules and variables

LESSON 3
Using a spreadsheet to build a model
1 Starter: Identifying rules and variables
2 Using a model to make predictions
3 Developing the model
4 Increasing the function of the model
5 Plenary: Reviewing the model
Homework: Limitations of using a model

LESSON 4
Refining and developing a model
1 Starter: Ways of increasing income from an event
2 Adding a variable to the model
3 Adding a further variable to the model
4 Plenary: Weakness of the model
Homework: Improving the model

LESSON 5
Ways of presenting data from a spreadsheet
1 Starter: Presenting information for audience and purpose
2 Using tables and graphs to present information
3 Inserting tables in a report
4 Creating a report
5 Plenary: Review of the modelling process
Homework: Evaluating the unit