Lesson 5 - Calculating nutritional content

Keywords - label, column, row, cell, number, formula, result

Starter

Teacher to show the students how to create a spreadsheet with the prices and calorie components of each food item.

Main Activity

Students to create their own spreadsheet with prices and calorie components of each food item.  Spreadsheet extended to include formulae to calculate overall nutritional content.

Plenary

Discuss spreadsheets, demonstrating how to create graphs to present the information in other ways.

Homework

Plan next week’s presentation in terms of layout, colours, fonts and images.