Starting Graphs

Before You Begin….

• Underpinning knowledge:• How to sort• Can use keyboard and mouse• Data skills like sorting, using tables and tally

charts• Have number skills: comparing numbers,

terms like more, less, same/equal; operations

Before the Computer

• Start with concrete activities:• Sort objects according to characteristics• Record results of sorting in a table or tally

chart• Create simple graphs with table data using

pencil and paper• Ensure students have a basic understanding of

data handling especially organizing data

Click this Icon to Open Excel

Rows

Columns

Cells

Rows

Columns

Cells

The columns and rows form a pattern of cells

Cells

Rows

Columns Cells

Each cell has its own address. Cells are named by their row and column.

H3J2

K4

L2

Templates are a Great Place to Start!

Spreadsheets are used to Store Information

• Sort these balls Colour: orange, blue

Size: large, small

Orange Blue

Large Orange Large Blue

Large Small

Sample 1B

Spreadsheets are Used to Store Information that We Collect

Class survey question:Which pet do you own?“What if…” questions

Dog Cat Rabbit Fish

Mika

Susan

Ebony

Lisa

Jason

Andrew

Rosa

We can record this information or data in a chart in a spreadsheet workbook

We can write numbers or values in the cell boxes

We can write words or labels in the cell boxes

Click the cell you want to enter the data into and begin to type here.

Sample 1A

We can add clip art to a spreadsheet

• Insert clipart from the illustrations menu.

Sample 1A

We can create graphs with a spreadsheet

Bar Graph Pie Chart

To Create A Chart/Graph

Step 1. Click and drag to highlight the data you want to use for your chart.

Step 2. Click the Insert menu to see the types of charts you can make.

Select the type of chart you want to use.

Use the Chart Menu to make changes to your chart.Change chart

type

Change chart appearance

Students should be able to answer:• What does the chart

tell us?• What comparisons can

you make?

Meaningful

• Student surveys• Data about Bermuda,

neighbourhoods• Planning an event

What if…. questions

• Session 4

Cells can contain…..

• Labels (words, text)

• Numbers (1,250 etc.)

• Formatting Labels & Numbers

Formula

• Always starts with = sign =6+10• Entered in place where you want the answer

to appearTyped in formula bar

Answer appears in cell B1

Formula

• can include mathematical functions

+ add - subtract* multiply / divide

Formula

• Can include the address of another cell

=A3+B3=3*(b2-c2)

=D3-7

Talking about Spreadsheets

• What is the spreadsheet displaying?

• What are the formulas doing?

• Which cells are they working on?

• What does this ~ mean?

Session 2

Cell Locations

• Using cell names in calculations

• What difference does this make?

Number One Operation Number Two Answer Number One Operation Number TwoAnswer

45 Add 54 99 Add 0Subtract Subtract 0Multiply Multiply 0Divide 1 Divide 1 1

Session 2&3

Plan First!A B C D E

1

2

3

4

• Plan your spreadsheet on paper.• Check formulas and cell locations• At the computer, enter data carefully!

Special Points to Cover

• Review tab for Spelling check• Importance of recording correct data• Strategies for checking accuracy of data• Show Formulas – Control~

Check!Check!

Using Spreadsheet Functions

• Formulas = Functions• Functions are built into your

spreadsheet• Common functions are

average, sum, count, mode, mean

• They include a range of numbers or cells

=average(B1:B10)

=sum(A1+E3+D5)

=mode(B9:J11)

Working with Formulas

• Moving formulae- copying and pasting: Click + Drag! Session 3

• What difference does it make? Does moving or copying formulas make a difference? What do you notice about a formula when you copy it?

• Brackets and Order• Show Formulas - Control ~

Spreadsheet Vocabulary

CellColumnsRowsData

InformationCalculateFunctionTotal

WorkbookSumReplicateModel

What if..Formatting data Formatting text