Unit 9, Lesson 1
Cost of a Meal (Optional)
Grade 7
Preparation
Lesson Narrative
In this optional 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. This can be a recipe students bring from home or a recipe provided by the teacher. Students make use of structure as they explore the syntax of how formulas are written in spreadsheet programs (MP7). Students reason quantitatively while deciding what formula they need for each column in their spreadsheet (MP2). This lesson relies on skills developed in Unit 2.
- Comprehend the term “spreadsheet” (in written and spoken language) as a computer program in which data is arranged in the rows and columns of a grid and can be manipulated and used in calculations.
- Create formulas in a spreadsheet to perform repeated calculations.
- Use a spreadsheet to calculate the cost per serving of all the ingredients in a recipe.
Let’s explore how much a recipe's ingredients cost.
Required Preparation
For the digital version of the activity, acquire devices that have access to a spreadsheet program.
For the digital version of the activity, acquire devices that have access to a spreadsheet program.
Students will need access to a variety of recipes to choose from. Students can bring in recipes from home, the teacher can provide a variety of recipes, or students can be given time to search the internet for a recipe.
Students will need access to a variety of recipes to choose from. Students can bring in recipes from home, the teacher can provide a variety of recipes, or students can be given time to search the internet for a recipe.