Lesson 5

This lesson is optional. In this lesson, students gain experience using a spreadsheet program to perform repeated calculations. After exploring how spreadsheets work, students calculate the cost per serving of all the ingredients in a recipe. Students make use of structure (MP7) as they explore the syntax of how formulas are written in spreadsheet programs. Students see that spreadsheets are an appropriate tool (MP5) for organizing and performing repeated calculations. Students reason quantitatively (MP2) while deciding what formula they need for each column in their spreadsheet.

As with all lessons in this unit, all related standards have been addressed in prior units. This lesson provides an optional opportunity to go deeper and make connections between domains. If students have already completed the previous lesson, they can continue using the same recipes in this lesson. However, it is also possible to do this lesson without having completed the previous lesson.

Prepare to provide each student access to a spreadsheet program. It is recommended for them to use a program with which you have previous experience.

If students have not completed the previous lesson or do not still have access to the recipes they used for it, provide access to recipes.