Topic 3 spreadsheets and modelling
This presentation is the property of its rightful owner.
Sponsored Links
1 / 13

Topic 3 Spreadsheets and Modelling PowerPoint PPT Presentation


  • 77 Views
  • Uploaded on
  • Presentation posted in: General

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 Presentation

Topic 3 Spreadsheets and Modelling

An Image/Link below is provided (as is) to download presentation

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


Topic 3 spreadsheets and modelling

Topic 3Spreadsheets and Modelling

Lesson 1Introducing the Unit


What are we learning today

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

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


Your task

Your Task

  • Worksheet

  • Answer the questions about the financial model of a zoo


Terminology recap

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


Topic 3 spreadsheets and modelling

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

Formula

Start with =

then

create formula

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


Topic 3 spreadsheets and modelling

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

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


Why use a spreadsheet

Why use a spreadsheet?

  • Speed

  • Accuracy

  • Automatic calculations

  • Data can be changed easily


In this unit you will learn

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


Spreadsheet exercises

Spreadsheet Exercises

  • Go onto the VLE

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

  • Lesson 1 Spreadsheet Exercises.xls

  • Follow the instructions on screen to complete the exercises


Imagine a school fete

Imagine a School Fete

  • Go onto the VLE

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

  • Lesson 1 Spreadsheet Practise.xls

  • Use the worksheet to complete the spreadsheet


Plenary

Plenary

  • What is a model?

  • What does a formula always start with?

  • What is the symbol for multiplication in a formula?


Homework

Homework

Spreadsheet Crossword of key words


  • Login