Lesson 1 - Spreadsheet basics

Lesson 1 - Modelling Data

1 / 19

Slide 1: Tekstslide

ComputingLower Secondary (Key Stage 3)

In deze les zitten 19 slides, met interactieve quizzen en tekstslides.

Lesduur is: 50 min

Onderdelen in deze les

Lesson 1 - Modelling Data

Slide 1 - Tekstslide

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 - Open vraag

Slide 3 - Tekstslide

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

Slide 4 - Open vraag

Spreadsheets!

Slide 5 - Tekstslide

Slide 6 - Tekstslide

Slide 7 - Tekstslide

Slide 8 - Tekstslide

Slide 9 - Tekstslide

Slide 10 - Tekstslide

What cell is this?

Slide 11 - Open vraag

Slide 12 - Tekstslide

What cell is this?

Slide 13 - Open vraag

Slide 14 - Tekstslide

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 - Tekstslide

Slide 16 - Tekstslide

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 - Tekstslide

Slide 18 - Tekstslide

Link to extension worksheet

Slide 19 - Tekstslide