Unit 7 by tyndale

VIEWS: 15 PAGES: 2

• pg 1
```									Unit 8.4 Models and presenting numeric data                                                                           1

Unit Objectives : Lesson 1                                      'Pupil-speak'?
Today you will:
DEVELOPING IDEAS AND MAKING THINGS HAPPEN
Models and modelling                                             Revise and review spreadsheets and modelling.
 Develop ICT-based models and test predictions by               Evaluate against features of a good model.
changing variables and rules.
 Review and modify ICT models to improve their
accuracy and extend their scope.
Outcomes
 Explain the following – cell, row column, label, numeric data, formula, drag, fill handle, sort, worksheet,
chart, chart wizard, variable.
 Explain what a model is and how they work.
 Use and interrogate a model (e.g. to answer “What if…?” questions).
 Explain and use “Goal Seek”.
 Explain features of a good model and use them to evaluate a model

Unit Objectives : Lesson 2                                      'Pupil-speak'?
Today you will:
DEVELOPING IDEAS AND MAKING THINGS HAPPEN
 Develop an existing spreadsheet model to compare
Models and modelling
mobile phone tariffs.
 Draw and explain conclusions.
 Use the model to determine which tariff offers the best
 Review and modify ICT models to improve their
accuracy and extend their scope.                                value.
Outcomes
 Name variables that will influence the choice of a mobile phone.
 Develop, explore and analyse a mobile phone model to identify tariffs that offer the best value.

Unit Objectives : Lesson 3                                      'Pupil-speak'?
Today you will:
DEVELOPING IDEAS AND MAKING THINGS HAPPEN
 Amend and extend the mobile phone tariff model to
Models and modelling
 Develop ICT-based models and test predictions by                 include appropriate charts.
changing variables and rules.                                 Create a graph to compare monthly mobile phone
tariffs.
FINDING THINGS OUT
Organising and investigating
 Explore and interpret collected data in order to draw
conclusions.
Outcomes
 Amend and extend the model using an absolute cell reference and including a graph.
 Explain the benefits of using charts and graphs.
 Create a graph to compare monthly mobile phone tariffs.

Unit Objectives : Lesson 4                                      'Pupil-speak'?
Today you will:
DEVELOPING IDEAS AND MAKING THINGS HAPPEN
Models and modelling                                             Amend and extend the mobile phone tariff model to
 Develop ICT-based models and test predictions by                 include a random number generator.
changing variables and rules.                                 Evaluate the spreadsheet model against an online
 Review and modify ICT models to improve their                    commercial model.
accuracy and extend their scope.
Outcomes
 Explain the operation of a random number generator.
 Amend and extend the model using a random number generator.
 Investigate the best tariff using a random number generator.
 Consider the merits of using a random number generator in the model.
 Explore an online mobile phone model and compare it to the spreadsheet model.

Norfolk Education Advisory Services - 2003
Unit 8.4 Models and presenting numeric data                                                                              2

Unit Objectives : Lesson 5                                     'Pupil-speak'?
Today you will:
DEVELOPING IDEAS AND MAKING THINGS HAPPEN                       Explore and investigate a range of simulations and
Models and modelling                                              models.
 Develop ICT-based models and test predictions by
changing variables and rules.
 Draw and explain conclusions.
Outcomes
 Explain the difference between a simulation and a model.

Level Descriptors

Level 4:
g.   Explore patterns and relationships.
h.   Make predictions about the consequences of decisions.
Combine and refine work; interpret and
k.   Compare their use of ICT with other methods and
question plausibility
l.   Compare their use of ICT with its use outside school.

Level 5:
f. Explore the effect of changing variables in ICT-based models.
Combine the use of ICT tools to achieve an end    j. Discuss knowledge and experience of using ICT and their observations of
or solve a problem; evaluate the fitness for         its use outside school.
purpose.                                          k. Assess the use of ICT in their work.
l. Able to reflect critically in order to improve subsequent work.

Level 6:
d.   Use models to make predictions.
Increased integration and efficiency in the use   e.   Vary the rules within models.
of ICT. Greater range and complexity of           f.   Assess validity of models.
information sources.                              g.   Compare their behaviour with information from other sources.
k.   Discuss impact of ICT on society.

Norfolk Education Advisory Services - 2003

```
To top