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

Choose 5 cells and enter an X

Bingo

50 points for the winner

Pixel art

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

Create a flag

Switch tabs to create some Pixel flags, I have added the Italian flag as an example 

Extension tasks

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

Code combat

Toxicode

Nitrotype

Semantris