This presentation is the property of its rightful owner.
1 / 13

Topic 3 Spreadsheets and Modelling PowerPoint PPT Presentation

Topic 3 Spreadsheets and Modelling. Lesson 1 Introducing the Unit. What are we learning today?. We are learning to use spreadsheet models to answer what if…? questions What I’m looking for using spreadsheet features to find the answers rather than working them out ourselves This is because

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

Lesson 1Introducing the Unit

What are we learning today?

We are learning to

What I’m looking for

using spreadsheet features to find the answers rather than working them out ourselves

This is because

spreadsheet models can be used to analyse data in complicated ways so that we can find the answers to questions

• Worksheet

Terminology Recap

A worksheet

Columns (letters)

Text labels

Numeric data

Each cell has a unique cell reference e.g. D13

Text labels

Rows (numbers)

Column DRow 13

The formula can also be viewed and edited here in the formula bar

Formula

then

create formula

When you press Enter, the formula will automatically be calculated.

The data can be sorted in alphabetical or numerical order – using the AZ icons

The data can be displayed on a chart using the Chart Wizard icon

By dragging the

fill handle,you can copy and paste the formula into other cells

C7*D7

What formula should have been generated in cell E7?

What is a model?

• (In ICT terms!)

• Tool that enables you to put different data into a system and look at the outcomes it produces

• Tool you can use to ask ‘what if…’ questions by changing variable or formulae

• Speed

• Accuracy

• Automatic calculations

• Data can be changed easily

In this unit you will learn:

• To use a spreadsheet to generate models

• To ask questions of the models in order to analyse and present data

• To use techniques to generate more effective models

• To understand the relationship between input and output values in a model

• To discuss other types of modelling that can be used to simulate different events

• Go onto the VLE

• ICT > Years 7-9 > Year 8 > Topic 3 – Spreadsheets and Modelling > Lesson 1

• Follow the instructions on screen to complete the exercises

Imagine a School Fete

• Go onto the VLE

• ICT > Years 7-9 > Year 8 > Topic 3 – Spreadsheets and Modelling > Lesson 1

• Use the worksheet to complete the spreadsheet

Plenary

• What is a model?