1 of 40

Lesson 1: Getting to know a spreadsheet

Year 7 – Modelling Data – Spreadsheets

2 of 40

Olympic medals – who won what?

Starter activity

Answer the questions on the sheet.

2

3 of 40

Data

Starter activity

What is data anyway?

3

4 of 40

Was this data easy to work with?

How could you organise it to make it easier?

Starter activity

4

5 of 40

Starter activity

5

6 of 40

Lesson 1: Getting to know a spreadsheet

Objectives

In this lesson you will:

Identify columns, rows, cells, and cell references in spreadsheet software
Use formatting techniques in a spreadsheet

6

7 of 40

Cells

Activity 1

Cells are spaces that hold data
A cell reference tells you the location of a cell

7

8 of 40

Each cell reference is made up of...

Activity 1

The column name

8

9 of 40

Each cell reference is made up of...

Activity 1

The column name
The row number

9

10 of 40

This is cell C4

Activity 1

10

11 of 40

What cell is this?

Activity 1

11

12 of 40

What cell is this?

Activity 1

Answer: B4

12

13 of 40

What cell is this?

Activity 1

13

14 of 40

What cell is this?

Activity 1

Answer: A5

14

15 of 40

What cell is this?

Activity 1

15

16 of 40

What cell is this?

Activity 1

Answer: C2

16

17 of 40

Let’s play Bingo!

Activity 1

17

18 of 40

Pixel art

Activity 2

18

19 of 40

Pixel art

Activity 2

Create a new spreadsheet file
Experiment with cell colours and borders

19

20 of 40

Pixel art

Activity 2

20

21 of 40

Row, column or cell?

In the following images, different parts of a spreadsheet are highlighted. Can you identify them?

Plenary

21

22 of 40

Plenary

22

23 of 40

Plenary

Row

23

24 of 40

Plenary

24

25 of 40

Plenary

Cell

25

26 of 40

Plenary

26

27 of 40

Plenary

Cell

27

28 of 40

Plenary

28

29 of 40

Plenary

Column

29

30 of 40

Name the range

In the following images, different ranges of cells in a spreadsheet are highlighted. Can you identify them?

Plenary

30

31 of 40

Plenary

31

32 of 40

Plenary

A2:A6

32

33 of 40

Plenary

33

34 of 40

Plenary

A5:C5

34

35 of 40

Plenary

35

36 of 40

Plenary

A5:C7

36

37 of 40

What kind of borders?

What do you think each of the following border icons does?

Plenary

37

38 of 40

Plenary

Borders

A B C D

38

39 of 40

Homework: Pixel art flag

Homework

Using the sheet provided:

Colour in the cells of the sheet to make a flag

Write instructions on how to create this flag in a spreadsheet

39

40 of 40

Next lesson

Summary

In this lesson you learned…

About cell referencing

How to apply colour to individual cells

Next lesson you will…

Enter data into cells

Use basic formulas for calculations

40