Rubbish recording and reduction: Part 1
In this lesson sequence students survey and collect data concerning what is brought to school each day and subsequently becomes rubbish. They then use Excel to present that data in a variety of different ways.
Additional details
Year band(s) | 3-4 |
---|---|
Content type | Lesson ideas |
Format | Web page |
Core and overarching concepts | Data acquisition, Abstraction |
Australian Curriculum Digital Technologies code(s) |
AC9TDI4K03
Recognise different types of data and explore how the same data can be represented differently depending on the purpose
AC9TDI4P05
Discuss how existing and student solutions satisfy the design criteria and user stories
AC9TDI4P06
Use the core features of common digital tools to create, locate and communicate content, following agreed conventions
AC9TDI4P07
Use the core features of common digital tools to share content, plan tasks, and collaborate, following agreed behaviours, supported by trusted adults |
Keywords | Graphs, Excel, Spreadsheets, Data collection, Environment, Sustainability |
Integrated, cross-curriculum, special needs | Science, Mathematics, Digital Literacy |
Organisation | ESA |
Copyright | Creative Commons Attribution 4.0, unless otherwise indicated. |
Related resources
-
Water Water everywhere!
In this lesson, students are presented with the challenging problem of measuring a volume of water using containers that are not the exact measurement size.
-
Schoolyard biodiversity detectives
Collect data on the biodiversity in garden beds around your school to measure the biodiversity (that is the different types of plants and animals).
-
Data in 3-4
Ideas for teaching about patterns in data, representing data as pictures, symbols and diagrams as well as ideas for teaching about collecting, sorting and using digital systems to present data.
-
Have fun with flowcharts
Create a flowchart to represent a sequence of (branching) steps and decisions needed to solve a mathematical problem.
-
Create a board game that uses an Ozobot
Create a game board where the player is provided with a number of decisions.
-
How can AI recognise what it sees?
This lesson is an introduction to the way in which a computer sees.
-
Note the music
We can program a computer to play music.
-
Fun projects with language translation
Natural language processing is growing in importance.