Energy Dimensional Analysis: Appliance Spreadsheet Lab
Provided by: LabXchange|Published on: August 29, 2026
Grades: 9, 10, 11, 12, AP
Type: Worksheets
Subjects: Earth and Space Sciences, Mathematics
Authors: LabXchange
Region: Global
Languages: English
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 →
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 →
Synopsis
- 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 Materials
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.
Teaching Tips
Standards
Resource Type and Format
About the Partner Provider
LabXchange
Harvard University’s LabXchange is a free online platform for science education, created with support from the Amgen Foundation. It makes learning science online flexible and fun, with interactives, lab simulations, and more.
Scientist Reviewed
This resource has been reviewed by SubjectToClimate's climate scientists and verified for scientific accuracy and up-to-date information. Our review process ensures that every resource in our library reflects the current state of climate science.
Learn about our review process →
