Spreadsheet Task with Chocolate Treat Theme

Year 7: This spreadsheet uses nutritional information as the basis for a spreadsheet designed to compare popular chocolate treats. The theme interests many students and the spreadsheet task contains hints as well as instructions for completion. The task includes some extension tasks and can be extended further in terms of the kind of charts can they could come up with. This resource test their ability to decide between when simple arithmetic formulas are used and when a formula containing a function is required. It focuses more on arithmetic operators in formulas and only uses the average function. However, as an exercise used after the introduction of spreadsheet it certainly tests the practical application of formulas to a set of actual data.