# The True Cost of Eggs: Commercial vs. Local

#### Summary

In this lab activity, students compare nutrient data and the cost of locally produced eggs and commercially produced eggs. They will use Excel for data entry, rudimentary formula writing, and the creation of tables.

## Learning Goals

Key Lesson: The costs of nutrient-dense eggs are lower per nutrient, even if they are more expensive per egg.

Goals include:Health promotion

Promoting creative visioning around sustainable futures

Improving skills in data analysis## Context for Use

## Description and Teaching Materials

Data is presented for a variety of nutrients for different types of eggs.

Students will put these data into an Excel file, use those data to compare with the cost (formula writing), and organize the data in a consistent form (indices). They will first make a table without using indices, and find that that table doesn't represent the data very effectively. They will then see the motivation behind using indices, or relative values, and see that table using modified data is much more effective. Cost of Eggs Worksheet (Microsoft Word 2007 (.docx) 149kB Jul25 13)

Egg Datasheet (Excel 2007 (.xlsx) 47kB Jul25 13)