Spreadsheets lesson 1

• Computing
• Lower Secondary (Key Stage 3)

Spreadsheets lesson 1

1. How many Gold medals did China get?

2. Who won the most Bronze medals?

3. How many medals in total did Great Britain win?

Extension

<a href="https://www.typing.com/student/games">Typing</a>

Do Now answers

1. How many Gold medals did China get? 

26  

2. Who won the most Bronze medals?

USA

3. How many medals in total did Great Britain win? 

72

Learning objective

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

Excelling: 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. 

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

Each is made up of the column and row name.

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.Sign in 

3. Create blank workbook

4. 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