Practicing Unit Conversion with Spreadsheets
Lesson Plans
Grades6, 7, 8Mathematics
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
- This interactive simulation guides students through the process of using spreadsheets to practice unit conversion, a foundational skill in scientific and mathematical reasoning applicable to environmental data analysis.
- Students work through guided exercises, converting between units of measurement to determine which of the three vehicles is the most fuel-efficient.
- This lesson will likely take at least two class periods.
Teaching tips
Preparation:
- Watch the Simulation Video Walkthrough and review the Teaching Guide, available on the right side of the opening screen.
- Consider printing the student worksheets, also available on the right side of the opening screen, so that students don't have to flip between tabs to take notes.
- Gather materials for the prehistoric marketplace activity.
Materials:
- 96 grain items (e.g., dry pasta pieces)
- 24 wool items (e.g., cotton balls)
- 8 copper items (e.g., bottle caps)
- 4 gem items (e.g., marbles)
Prerequisites:
- Ensure students understand different units of measurement, can divide and multiply fractions, and are familiar with spreadsheet applications.
Climate Change Connections:
- Discuss why fuel efficiency is important for climate change. Ask students to consider how knowing a vehicle's fuel efficiency can help consumers shop more sustainably.
• Consider connecting this to climate data contexts: for example, converting global average temperature anomalies from Celsius to Fahrenheit, or converting energy use from kilowatt-hours to joules.
Extensions:
Extensions:
- Challenge advanced students to set up a spreadsheet to convert other units of measurement.
From the scientist review
This resource explains what units are, what unit conversions are, and how to do them manually and in a spreadsheet. After introducing the information, the website includes an interactive spreadsheet tutorial that walks users through solving problems requiring unit conversions. Understanding unit conversions and using spreadsheets are fundamental skills for science and math. The information presented is accurate, and this resource is recommended for teaching.
Ready to use it?
Hosted on labxchange.org
Want this to fit your class?
Add your location for local examples, questions, and action ideas.
