Ready for action?
Resources
Downloadable Resources
Tangible Resources
Computers with Excel
Preparation
Establish students’ prior knowledge of graphs. Define the minimum they have to do (Bar chart, pictograph, pie chart etc.)
Goals, messages & concepts
Specific goals
- Analysing data.
- Making graphs by hand.
Specific messages
- Data is a valuable source for getting insights.
- It gets interesting when you combine data from different questions.
Main terms
- data
- graphs
- analysis
- correlation
- conclusion
Practices & skills
STEM practices
- Analysing and interpreting data
- Developing and using models
- Obtaining, evaluating, and communicating information
- Asking questions and defining problems
Soft skills
- Teamwork and collaboration
Management skills
- Planning
- Use of resources
Course of activity
step 1
Introduction – short recap of previous activity
step 2
Brief for the next assignment – analysis of the survey
step 3
Theory – summary of different types of graphs
step 4
Short lesson on combining data in excel
step 5
In groups – working in the same groups as LU5, extrapolate the data from the surveys into Excel
step 6
Evaluation – combine data and outcomes. Each group to identify 3 different correlations to investigate, e.g.:
- the relation between gender and whether a nicer trash can is used more often.
- (for more examples see Example correlations in downloadable resources)
- Analysis of the data
- Developing graphs from Excel data
step 7
Present the results on A4
- Select the right data for your chart
- Choose appropriate title
- Copy the table of data
- Draw the graphs/charts by hand
- Close with an appropriate conclusion
step 8
Plenary - discussion of the outcomes