Lesson 3: Collecting Data
Year 7 – Modelling Data – Spreadsheets
What’s the formula?
Starter activity
2
What’s the formula?
57 x 143
Starter activity
3
What’s the formula?
57 x 143
= A1 * C1
Starter activity
4
What’s the formula?
544 ÷ 34
Starter activity
5
What’s the formula?
544 ÷ 34
= A2 / C2
Starter activity
6
What’s the formula?
229 + 798
Starter activity
7
What’s the formula?
229 + 798
= A3 + C3
Starter activity
8
What’s the formula?
941 – 47
Starter activity
9
What’s the formula?
941 – 47
= A4 - C4
Starter activity
10
What’s the formula?
99 x 3
Starter activity
11
What’s the formula?
99 x 3
= A5 * C5
Starter activity
12
How did you do?
Starter activity
13
Lesson 2: Collecting data
Objectives
In this lesson you will:
14
Data talk
Activity 1
What is the difference between data and information?
15
What is the difference between data and information?
Activity 1
16
What is the difference between data and information?
Activity 1
17
Sources of data
Activity 1
18
Sources of data
Activity 1
19
Sources of data
Activity 1
20
Sources of data
Activity 1
21
Sources of data
Activity 1
An article in your local newspaper reads:
“Poll results: we asked what readers thought about smartphones in school.”
Is this data primary or secondary?
22
Sources of data
Activity 1
An article in your local newspaper reads”
“Poll results: we asked what readers thought about smartphones in school.”
Is this data primary or secondary?
Answer: primary
23
Sources of data
Activity 1
The weather station publishes a report comparing rainfall this year and last year, based on data they recorded.
Is this data primary or secondary?
24
Sources of data
Activity 1
The weather station publishes a report comparing rainfall this year and last year, based on data they recorded.
Is this data primary or secondary?
Answer: primary
25
Sources of data
Activity 1
A national newspaper publishes an article titled:
“Most popular GCSE subjects this year”
based on data that was published by the government.
Is this data primary or secondary?
26
Sources of data
Activity 1
A national newspaper publishes an article titled:
“Most popular GCSE subjects this year”
based on data that was published by the government.
Is this data primary or secondary?
Answer: secondary
27
Sources of data
Activity 1
Your school website has a page showing the popularity of different subjects based on class sizes in your school.
Is this data primary or secondary?
28
Sources of data
Activity 1
Your school website has a page showing the popularity of different subjects based on class sizes in your school.
Is this data primary or secondary?
Answer: primary
29
Sources of data
Activity 1
The government issues leaflets containing new health and nutrition guidelines published by researchers in France.
Is this data primary or secondary?
30
Sources of data
Activity 1
The government issues leaflets containing new health and nutrition guidelines published by researchers in France.
Is this data primary or secondary?
Answer: secondary
31
Collect data from the class!
Activity 2
32
Is this data from a primary or a secondary source?
Activity 2
33
Match up the words!
Plenary
34
Next lesson
Summary
This lesson you…
Discovered the difference between data and information
Determined whether sources of data were primary or secondary
Collected some data
Next lesson you will…
Analyse data
Create charts
Use functions
35