Year 9 Science · Unit 4 · Lesson 11
Apply Worksheet
Learning Goals
True or False? Fix the false ones
Circle T or F for each statement. If the statement is false, rewrite it correctly on the line below.
In a dataset, each column is a variable and each row is a record.
Correct it:
You can ask a question about a variable even if no column for it exists in the dataset.
Correct it:
A temperature of 310 degrees in a weather column is almost certainly an error to clean.
Correct it:
If two columns rise together, one must always cause the other.
Correct it:
Dataset
A student downloads a beach dataset with these columns: date, daily maximum temperature (°C), rainfall (mm), wind speed (km/h), and number of beach visitors. There is one row for every day of the summer.
(a) Write one investigable question this dataset can actually answer, using two of its columns.
(b) For your question, name the independent variable and the dependent variable.
(c) Write one question that this dataset cannot answer, and explain why not.
1. A rainfall column in a dataset contains one value of -8 mm and three blank cells. Explain why each of these is a problem, and what you would do about them when cleaning the data.
2. A friend says "this dataset is from the government, so I do not need to check anything before I use it." Explain why this is risky, referring to metadata and cleaning.
Wrap Up
In one sentence, what was the main idea of this lesson?