Building the Distance Formula in Spreadsheets
Students will build the distance formula in a spreadsheet to create a sort of "calculator." Students begin by comparing standard math notation with spreadsheets, then practice programming simple math functions. Students then create a "Pythagorean Theorem" calculator. They then build on this understanding to determine the distance between two points.
This lesson is intended for students who are already familiar with both the Pythagorean Theorem and the distance formula. The goal is to learn how to manipulate values and formulas in spreadsheets, as well as improve understanding of the distance formula.
Lesson Plan Link/URL
https://docs.google.com/presentation/d/1Hj-qGsDqLwGSHejfbtgljPIacSXAldCB/edit?u…Related Content
In this lesson, students use the Kepler’s Laws PhET Simulation to collect data on the period and average radius of the planetary orbits. They graph and analyze that data to derive Kepler’s 3rd Law.