Become a data master!
Slide deck
Download slide deck
Lesson details
Key learning points
- 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
Loading...
5 Questions
Q1.
What is the meaning of a formula?
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.
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.
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
Radio show
Q5.
What is a secondary source?
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.
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?
ADD
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
Q6.
Which one of these can data be analysed by?
Blocks
Picture