Year 7

Year 7

# Become a data master!

## Lesson details

### Key learning points

1. In this lesson, we will discover how to use functions to analyse data in a spreadsheet. As well as learning how to automatically create charts from data. We will be introduced to four functions: SUM, MAX, MIN, and COUNTA.

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

### 5 Questions

Q1.
What is the meaning of a formula?
Correct answer: A formula is a calculation, which starts with a = sign.
A formula is when different chemicals are placed together to create a reaction.
A formula never starts with a = sign and involves only numbers with no symbols.
Q2.
What is Data?
Data can be anything.
Correct answer: Data is facts and figures.
Data is just symbols.
Q3.
What is the difference between data and information?
When data is converted into information so that only text words are used.
Correct answer: When data is organised so that it has some meaning to it, it then becomes information.
When you use charts to show only information about females in a class.
Q4.
Which one of these is an example of a primary source?
Newspaper
Q5.
What is a secondary source?
Correct answer: A secondary source is a source which you have found and may decide to use.
A secondary source is the same as a primary source, except it looks prettier, like a chart.
A secondary source is when you decide to carry out a survey.

## Exit 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