Spreadsheets lesson 1

• Computing
• Lower Secondary (Key Stage 3)

Spreadsheets lesson 1

How many Gold medals did China get?

Who won the most Bronze medals?

Ext: How many medals in total did Great Britain win?

Do Now answers

How many Gold medals did China get?

• 26  

Who won the most Bronze medals?

• USA

Ext: How many medals in total did Great Britain win?

• 67

Learning objective

Conquer: Identify columns, rows, cells, and cell references in spreadsheet software

Aspire: Use formatting techniques in a spreadsheet

Cells

Cells are spaces that hold data/information 

A cell reference tells you the location of a cell so we can find the data. 

Like being assigned a seat at football or in the cinema.

Each cell reference is made up of...

The column name

We use the letters of the alphabet.

Each cell reference is made up of...

The row number

This is cell C4

What cell is this?

1. 4B
2. B4
3. A4
4. 4A

What cell is this?

1. A4
2. 5A
3. A5
4. B5

What cell is this?

1. C2
2. C1
3. C3
4. 2C

Pixel art

We can change the colors of cells to create some pixel art. 

Create a flag

1. Go to Excel 

2. Using Fill colour create a flag of your choice

Pixel art

Now that we have had some practice, Try creating a piece of pixel art. 

Extension tasks

If you complete all tasks, use 1 of these 4 extension tasks to develop your skills.

Code combat

Toxicode

Nitrotype

Semantris