skip to main content

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