View Contributions
Lens Equation Experiment using Excel
Download Files
- Lens Equation Lab.xls - 26 KB
Or you may download all files as a compressed archive (ZIP).
Submission Information
Ed Chomka
authors
chomkae@suttonschools.net
contact email
Sutton (MA) High School
school/organization
1/09
submitted
1/09
updated
Contribution Description
Lens Equation Experiment using Excel
title
Geometric Optics
simulations
Students should be able to derive the lens equation:
1/f = 1/do + 1/di
(not usually an easy task)
using data collected in class with lenses or online with the simulation.
(IMPORTANT NOTE: clicking "download" is the best choice because the other option gives you a document format, not an Excel file.) description
1/f = 1/do + 1/di
(not usually an easy task)
using data collected in class with lenses or online with the simulation.
(IMPORTANT NOTE: clicking "download" is the best choice because the other option gives you a document format, not an Excel file.) description
High School
level
Lab
type
Physics
subject
90 minutes
duration
No
answers included
standards compliance
| Content Level | |||
| Content Standard | K-4 | 5-8 | 9-12 |
| Science as Inquiry - A | |||
| Physical Science - B | |||
| Life Science - C | |||
| Earth & Space Science - D | |||
| Science & Technology - E | |||
| Science in Personal and Social Perspective - F | |||
| History and Nature of Science - G | |||
Nominations for Gold Star

Gold Star contributions are high quality inquiry-based activities that follow the PhET design guidelines (PDF) and that teachers find useful.
Nominate this contribution as a Gold Star Activity
Comments
What do you think about this activity? How did you use it or change it for your class? Professionally constructive comments welcome.
There are no comments for this activity yet

National Science Foundation