NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ1174726
Record Type: Journal
Publication Date: 2018-May
Pages: 5
Abstractor: As Provided
ISSN: ISSN-0031-9120
Lens Ray Diagrams with a Spreadsheet
González, Manuel I.
Physics Education, v53 n3 Article 035016 May 2018
Physicists create spreadsheets customarily to carry out numerical calculations and to display their results in a meaningful, nice-looking way. Spreadsheets can also be used to display a vivid geometrical model of a physical system. This statement is illustrated with an example taken from geometrical optics: images formed by a thin lens. A careful mixture of standard Excel functions allows to display a realistic automated ray diagram. The suggested spreadsheet is intended as an auxiliary didactic tool for instructors who wish to teach their students to create their own ray diagrams.
Institute of Physics Publishing. The Public Ledger Building Suite 929, 150 South Independence Mall West, Philadelphia, PA 19106. Tel: 215-627-0880; Fax: 215-627-0879; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Descriptive
Education Level: N/A
Audience: Teachers
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A