Use Devon’s “rubbish” data as part of maths and ICT lessons!

The downloadable spreadsheet below includes data from each Devon district (East Devon, Exeter, Mid Devon, North Devon, South Hams, Teignbridge, Torridge, West Devon and the Unitary Authorities of Plymouth and Torbay) showing what materials are currently recycled, and how the local recycling rate has changed in the last ten years. The data can be used by pupils in a variety of ways, such as creating pie and line charts.

Download Devon Waste Figures by District Spreadsheet

NOTE the different districts are on separate tabs at the bottom of the spreadsheet.

Consider combining a maths and ICT lesson and encourage pupils to work in pairs on the spreadsheet!

Some ideas to try:

  • Make a graph showing the changes in recycling rate
  • Plot a bar chart of the materials recycled in Devon
  • Calculating the % change in districts recycling rate and materials recycled
  • Is there a positive or negative correlation between population count and waste produced?

National Curriculum Links

Y3 Maths: Interpret and present data using bar charts, pictograms and tables

  • Solve one-step and two-step questions, such as ‘How many more?’ and ‘How many fewer?’ using information presented in scaled bar charts and pictograms and tables

Y4 Maths: Interpret and present discrete and continuous data using appropriate graphical methods, including bar charts and time graphs.

Y5 Maths: Complete, read and interpret information in tables, including time-tables.

Y6 Maths:  Interpret and construct pie charts and line graphs, and use these to solve problems.

KS2 Computing: Select, use and combine a variety of software.

KS3 Computing: Undertake creative projects  that involve selecting, using and combining multiple applications, to achieve challenging goals, including collecting and analysing data.

A colourful doughnut pie chart showing the proprtion of recycling belonging to different material types in Devon from 2013 to 2019
A line graph showing the history of the rate of recycling in Devon from 1998 to 2019