Students use of the actual objects or the pictures of the objects in order to predict the order in which they will decompose
Students view the fact sheet from the Department of Environment and Conservation and compare their predictions to what is shown.
Explain to students that the learning intention of this lesson is to use Excel to analyse and interpret our data surrounding rubbish output. We are going to be using Excel and the data that we have entered earlier to allow us to figure out the answers these questions:
We are going to be learning three main concepts in this lesson:
Students participate in a whole class discussion surrounding some of the key concepts that they will be exploring throughout this learning sequence.
Students respond to questions relating to the learning intentions for this lesson and develop a deeper understanding of what they are learning about and why.
Explain that Excel can be used as a big calculator to solve multiple problems at once. It does this through the use of 'formulas'.
Formulas are mathematical equations that tell Excel what to work out.
Students consider the guiding prompt and Think, pair, share their responses to it.
Students participate in a discussion in order to deepen their understanding of the type of mathematical equations required to complete this problem.
Students develop an understanding of the term 'formula'.
Students watch the modelled demonstration of what a formula is and how to enter one into Excel. They learn about the importance of the '=' sign in this process.
Students consider and discuss how they could change the modelled formula to meet the prompt requirements. They share their ideas with the class.
Students attempt to complete the challenge of multiplying three columns together.
Students view possible solutions to the challenge and become familiar with how the coordinates in Excel correspond with the data that is entered into particular cells.
For a list of Key terms and Excel vocabulary download this PDF.
Once students have had the chance to become familiar with the basics of how Excel functions work and how to have Excel calculate answers for them, then it is time to get them using their previously entered data to answer questions for them.
Students consider the questions that they need to answer in relation to the concepts they have just learnt and the data they have previously collected. They ask any questions that they feel they need clarification on before the task has been started.
Students work on attempting to find solutions to calculating the questions that have been provided.
Once students have finished working out their waste production and the length of time that it will take for their waste to decompose, ask them to print out their graphs along with the calculations (Simply go to 'File' and then 'Print).
Students print out their graphs and calculations. They then mount these on coloured paper and display them. They then view each other's work and look for similarities and differences.
After the students have finished looking at each other's work, pose these questions for them to answer in their books (one sentence each):
Students complete both reflection questions in their book.