Lesson 1 - Spreadsheet basics

Lesson 1 - Modelling Data

1 / 19

Slide 1: Slide

ComputingLower Secondary (Key Stage 3)

This lesson contains 19 slides, with interactive quizzes and text slides.

Lesson duration is: 50 min

Items in this lesson

Lesson 1 - Modelling Data

Slide 1 - Slide

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 question

Slide 3 - Slide

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

Slide 4 - Open question

Spreadsheets!

Slide 5 - Slide

Slide 6 - Slide

Slide 7 - Slide

Slide 8 - Slide

Slide 9 - Slide

Slide 10 - Slide

What cell is this?

Slide 11 - Open question

Slide 12 - Slide

What cell is this?

Slide 13 - Open question

Slide 14 - Slide

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

Slide 16 - Slide

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

Slide 18 - Slide

Link to extension worksheet

Slide 19 - Slide