Lesson 1 - Spreadsheet basics

Lesson 1 - Modelling Data

1 / 19

Slide 1: Diapositive

ComputingLower Secondary (Key Stage 3)

Cette leçon contient 19 diapositives, avec quiz interactifs et diapositives de texte.

La durée de la leçon est: 50 min

Éléments de cette leçon

Lesson 1 - Modelling Data

Slide 1 - Diapositive

Answer the questions below from the data in the image. You can click to enlarge the image.

1. Which country won the most gold medals?
2. How many did Great Britain win in total?
3. Who won the fewest medals?

Slide 2 - Question ouverte

Slide 3 - Diapositive

How could you organise the data in the do now task to make it easier to read?

Slide 4 - Question ouverte

Spreadsheets!

Slide 5 - Diapositive

Slide 6 - Diapositive

Slide 7 - Diapositive

Slide 8 - Diapositive

Slide 9 - Diapositive

Slide 10 - Diapositive

What cell is this?

Slide 11 - Question ouverte

Slide 12 - Diapositive

What cell is this?

Slide 13 - Question ouverte

Slide 14 - Diapositive

Spreadsheet Bingo

1. Click here to Open Excel

2. Select Blank Workbook

3. Put an X in 5 boxes cells between A1 and E5 for example:

4. Your teacher will call the cell reference, if you have an X in the box change it to an O.

Slide 15 - Diapositive

Slide 16 - Diapositive

Fill Colour Tool

This is the fill colour tool. You use it to change the colour of a cell.

To choose different colours you press the little down arrow on the right hand side.

Slide 17 - Diapositive

Slide 18 - Diapositive

Link to extension worksheet

Slide 19 - Diapositive