Building the Distance Formula in Spreadsheets
by Emily Bogusch
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
Grades:
8th Grade, 9th Grade, 10th Grade, 11th Grade
In this lesson, students will explore the relationship between current, voltage, and resistance in an electrical circuit. Using a PhET Simulation, they will collect data and graph voltage vs current
Grades:
6th Grade, 7th Grade, 8th Grade, 9th Grade, 10th Grade, 11th Grade, 12th Grade
Students will pick an issue that they think exists in the world and propose a solution via a presentation. This will model a TedTalk.
Grades:
6th Grade, 7th Grade, 8th Grade, 9th Grade, 10th Grade, 11th Grade, 12th Grade
In this lesson students use a Pocketlab Voyager to collect data on a toy car as it goes down a track. Analysing the data, students calculate gravitational potential energy and Kinetic energy of the