Excel - Part 2

1 / 11
next
Slide 1: Slide
ComputingLower Secondary (Key Stage 3)

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

time-iconLesson duration is: 50 min

Items in this lesson

Slide 1 - Slide

 7 - Excel Recap

Slide 2 - Slide

KO: To refresh your knowledge of Microsoft Excel spreadsheets
All: Understand grid references and how to use them in calculations.
Most: Be able to create calculations with more complex operators (*, /, etc.).
Some: Be able to calculate SUM, MIN, MAX and AVERAGE.

Slide 3 - Slide

Spreadsheets, Excel

Slide 4 - Mind map

The Wizard's Challenge!
Fill out the grid references
Find the magic number.

Slide 5 - Slide

What was the magic number (high score)

Slide 6 - Open question

The Gold Mine

Slide 7 - Slide

Task
Click here to Open your worksheet.

Click the viewing button and then open up in Desktop App. Save the file your Digital Literacy folder, so you can edit it.

Slide 8 - Slide

On the sum page, calculate the sum of the three answers?

Slide 9 - Open question

On the Min Max page, calculate the average of the two answers?

Slide 10 - Open question

On the average page, what is the answer to 1 multiplied by the answer to 2?

Slide 11 - Open question