Starter quiz
- Which two options below are examples of spreadsheet software?
- Google Sheets ✓
- Google Docs
- Microsoft Excel ✓
- Microsoft Power Point
-
- Which type of graph is a visual representation for bivariate data?
- bar chart
- pictogram
- pie chart
- scatter graph ✓
-
- Which is another term to describe the response variable in bivariate data?
- dependent variable ✓
- independent variable
- explanatory variable
-
- Which two terms describe a measure in bivariate data whose value is predicted to affect the other measure?
- dependent variable
- explanatory variable ✓
- independent variable ✓
- response variable
-
- Which variable should be represented on the horizontal axis of a scatter graph?
- dependent variable
- independent variable ✓
-
- A set of bivariate data measures hours of daylight in a day and maximum temperature for each day. Which variable is most likely to be the independent variable?
- hours of daylight ✓
- maximum temperature
-
Exit quiz
- Google Sheets and Microsoft Excel are examples of ______ software.
- 'spreadsheet' ✓
- Which is a correct description for a scatter graph?
- A circular graph where sectors represent different groups proportionally
- A graph consisting of bars to representing the frequency of objects or groups
- A graph consisting of pictures to represent the frequency of objects or groups
- A graph consisting of two axes to visually represent bivariate data ✓
-
- Which keyboard short cut allows you to copy data that has been highlighted in a spreadsheet?
- ctrl + c ✓
- ctrl + v
- shift + c
- shift + v
-
- When plotting a scatter graph on a spreadsheet, what do you need to select to edit the vertical axis?
- dependent
- series ✓
- -axis
- -axis
-
- What steps do you need to take to plot a scatter graph in Desmos, after you have inputted a set of bivariate data?
- Click on 'insert' on the ribbon menu and then select 'chart'.
- Nothing - Desmos will plot a scatter graph automatically. ✓
- Right click on the workspace and select 'insert graph'.
- Type 'scatterplot' into the next empty cell and then select your data.
-
- Look at the scatter graph. Which of the two towns tends to be warmer?
- Town A ✓
- Town B
-
Worksheet
Loading worksheet ...
Presentation
Loading presentation ...
Lesson Details
Key learning points
- Scatter graphs can be constructed quickly using spreadsheets.
- Scatter graphs can be constructed quickly using Desmos.
- Changing which axis is used for which variable affects how the scatter graph appears.
Common misconception
Pupils may struggle to assign the correct variable to the y-axis when graphing on a spreadsheet.
Explain that the word "series" is used to mean the y-axis in this software.
Keywords
Scatter graph - A visual representation for bivariate data. It can be useful when determining the nature of the relationship between the two variables
+