Energy Dimensional Analysis: Appliance Spreadsheet Lab
Worksheet
Grades9, 10, 11, 12, APEarth and Space Sciences, Mathematics
This resource has been reviewed by SubjectToClimate's climate scientists and verified for scientific accuracy and up-to-date information. Learn about our review process →
Provided by LabXchange
What it is
- In this interactive simulation, students take on the role of an energy consultant analyzing the electricity consumption and cost of household appliances in an apartment complex.
- Students use dimensional analysis and unit conversion factors within a spreadsheet to calculate lifetime energy consumption and costs.
- They sort and interpret data to identify which appliances are most and least expensive to operate, compare results against energy benchmarks, and suggest ways to reduce consumption.
Teaching tips
Classroom Implementation:
- The simulation teaches students spreadsheet tools and methods, including cell references and the sort function, that are useful in many applications.
- Introduce the activity by asking students to think about when they use electricity in their house and how much it costs.
- Consider using the reflection questions to discuss the assumptions built into the calculations and how they affect the reliability of results.
Preparation:
- Students will need electronic devices and access to the internet in order to engage in this activity.
- Alternatively, teachers can opt for the worksheet version of the lesson, though the electronic version is recommended.
Interdisciplinary Connections:
- Mathematics:
- Use this simulation to emphasize the importance of using correct units and provide practice performing unit conversions.
- Social Studies:
- Discuss equity dimensions related to energy access and use, tying it to the notion of high-emitting and low-emitting countries.
Ready to use it?
Hosted on labxchange.org
Want this to fit your class?
Add your location for local examples, questions, and action ideas.

