Year 7

Year 7

# Level up your data skills!

## Lesson details

### Key learning points

1. In this lesson, we will introduce three more functions "COUNTIF, AVERAGE, and IF" and to how they can sort and filter a spreadsheet. We will work on a larger data set to get a feel for analysing real-world data using spreadsheets.

### Licence

This content is made available by Oak National Academy Limited and its partners and licensed under Oak’s terms & conditions (Collection 1), except where otherwise stated.

## Video

Share with pupils

## Worksheet

Share with pupils

## Starter quiz

Share with pupils

### 6 Questions

Q1.
Which of these is used to visualise information as a picture?
Apple chart
Circle chart
Pizza chart
Q2.
Which of these would you use to add up a range of numbers?
PLUS
TOTAL
Q3.
You use the MAX function to find:
The first value
The smallest value
The total
Q4.
What function would you use to find the smallest value?
COUNTA
LEAST
MAX
Q5.
What does the COUNTA function tell you?
The average
The largest value
The number of A's
Correct answer: The number of non-blank cells
Q6.
Which one of these can data be analysed by?
Blocks
Picture

## Exit quiz

Share with pupils

### 5 Questions

Q1.
How is data sorted in a spreadsheet?
B-C or Z-A
Only A-Z
Q2.
What does filtering in a spreadsheet allow you to do?
Filtering allows you to add data
Filtering allows you to delete specific data
Correct answer: Filtering allows you to find specific data
Q3.
Which AVERAGE formula is correct?
=AVERAGE(D:D9)