Please turn on the javascript option.

NSW Department of Education and Communities

Technology KLA

Food design: budgeting planning

Consumer and financial literacy is about having the knowledge and skills to make good decisions about using and managing money.  The Consumer and Financial Literacy Professional Learning Program http://www.financialliteracy.edu.au/ has been designed to build the capacity of teachers in primary and secondary schools to engage students in consumer and financial literacy.

The Technology unit in collaboration with the Technology Educators Association Inc has developed a budgeting planning tool to allow students to cost recipes. Resources to support the use of this tool are listed below.

My Recipe Calculator

An Excel spreadsheet: students can calculate the cost of a recipe on a per serve basis with minimal input of data. Use an online supermarket web site or brochures for prices. A version with space for inserting the method is also provided. Instructions for use are provided as a PowerPoint presentation.

Recipe calculator (xls 41 kb)

Recipe calculator with method (xls 31 KB)

Recipe calculator instructions (ppt 295 KB)

Laptop recipe calculator files

OneNote recipe calculator step-by-step instructions (onepkg 121 KB)

Laptop recipe calculator (xls 28 KB)

Laptop recipe calculator with method (xls 30 KB)

Measurement conversion

A Word document providing conversions for cup and spoon measurements to mass.

Measurement conversion (doc 245 KB)

Recipe calculation document

A Word document: students can manually calculate the cost of a recipe on a per serve basis.

Manual recipe calculation document (doc 221 KB)

Lesson plan: Food product development

The purpose of this lesson is for students to complete the My Recipe Calculator spreadsheet. This allows students to cost their food product on a per serve basis.

Lesson plan (doc 360 KB)

NEAL's logo

Conditions of use | Contact us