© boardworks ltd 2010 1 of 7 introduction to spreadsheets

7
© Boardworks Ltd 2010 1 of 7 Introduction to Spreadsheets

Upload: clarissa-lynch

Post on 13-Jan-2016

234 views

Category:

Documents


4 download

TRANSCRIPT

Page 1: © Boardworks Ltd 2010 1 of 7 Introduction to Spreadsheets

© Boardworks Ltd 20101 of 7

Introduction to Spreadsheets

Page 2: © Boardworks Ltd 2010 1 of 7 Introduction to Spreadsheets

© Boardworks Ltd 20102 of 7

Teacher’s notes included in the Notes Page

Flash activity. These activities are not editable. Web addresses

Icons key: For more detailed instructions, see the Getting Started presentation

Functional Skills check

Student task accompanies this slide Printable activity

The advantages of using spreadsheets.

The basic layout of a spreadsheet.

This lesson will cover:

Page 3: © Boardworks Ltd 2010 1 of 7 Introduction to Spreadsheets

© Boardworks Ltd 20103 of 7

Tracking marks – on paper

Page 4: © Boardworks Ltd 2010 1 of 7 Introduction to Spreadsheets

© Boardworks Ltd 20104 of 7

Why use spreadsheets?

Page 5: © Boardworks Ltd 2010 1 of 7 Introduction to Spreadsheets

© Boardworks Ltd 20105 of 7

Spreadsheets can:

do all sorts of calculations, both simple and complex, using formulae

recalculate things quickly when the numbers change

use functions to help you set up complex formulae

act as simple flat-file databases so that you can sort or search your data

plot charts and graphs

change the appearance of fonts, cell backgrounds and borders

control how many decimal places are shown.

What does the software do?

Page 6: © Boardworks Ltd 2010 1 of 7 Introduction to Spreadsheets

© Boardworks Ltd 20106 of 7

Basic features

Page 7: © Boardworks Ltd 2010 1 of 7 Introduction to Spreadsheets

© Boardworks Ltd 20107 of 7

True or false