The True Cost of Eggs: Commercial vs. Local
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.
Key Lesson: The costs of nutrient-dense eggs are lower per nutrient, even if they are more expensive per egg.Goals include:
Promoting creative visioning around sustainable futuresImproving 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)