1 of 20

Lesson 4: Become a data master!

Year 7 – Modelling data - Spreadsheets

2 of 20

Which treat to bake? Vote now!

Starter activity

  • Open the spreadsheet “Starter - Cake popularity”

​

  • Follow the instructions to cast your vote

​

2

3 of 20

How does it work?

Starter activity

3

4 of 20

How does it work?

Starter activity

  • Pie chart

4

5 of 20

How does it work?

Starter activity

  • Pie chart
  • Function

5

6 of 20

Lesson 4: Become a data master!

Objectives

In this lesson you will:

  • Analyse data
  • Use the functions SUM, MAX, MIN, and COUNTA in a spreadsheet
  • Create appropriate charts in a spreadsheet

​

6

7 of 20

Analysing data

Activity 1

  • With functions, you can become a data master in no time!
  • Each function is like a different superpower.

​

7

8 of 20

The SUM function

Activity 1

Superpower: superfast totals!

8

9 of 20

The SUM function

Activity 1

Superpower: superfast totals!

=SUM(B2:B15)

9

10 of 20

The MAX function

Activity 1

Superpower: find the largest value with your eyes closed!

10

11 of 20

The MAX function

Activity 1

Superpower: find the largest value with your eyes closed!

=MAX(B2:B15)

11

12 of 20

The MIN function

Activity 1

Superpower: ???

12

13 of 20

The MIN function

Activity 1

Superpower: find the smallest value without looking!

13

14 of 20

The MIN function

Activity 1

Superpower: find the smallest value without looking!

=MIN(B2:B15)

​

14

15 of 20

The COUNTA function

Activity 1

Superpower: count non-blank cells

15

16 of 20

The COUNTA function

Activity 1

Superpower: count non-blank cells

=COUNTA(B2:B15)

=COUNTA(B2:B)

​

16

17 of 20

Visualising data

Activity 1

  • A chart represents data visually.
  • With spreadsheets, you can create all kinds of charts in just a few clicks!

​

17

18 of 20

Over to you

Activity 2

18

19 of 20

Quiz time!

Plenary

19

20 of 20

Next lesson

Summary

In this lesson you...

Analysed data

Created charts

Used functions

Next lesson you will…

Analyse data

Use a spreadsheet to sort and filter data

Use the functions AVERAGE, COUNTIF, and IF in a spreadsheet

​

​

20