| |
 |
UNIVERSITY OF BUCHAREST
FACULTY OF PHYSICS Guest
2024-11-23 18:28 |
 |
|
|
|
Conference: Bucharest University Faculty of Physics 2016 Meeting
Section: Physics Education
Title:
Spreadsheets in physics: didactic tools for learning concepts of geometrical optics
Authors:
Ionel GRIGORE(1),Cristina MIRON(2)
Affiliation:
1)“Nichita Stănescu” National College, Ploieşti, Romania
2)Faculty of Physics,University of Bucharest, Bucharest-Măgurele, Romania
E-mail
grigore_1965@yahoo.com; cmiron_2001@yahoo.com
Keywords:
spreadsheets, reflection, refraction, total internal reflection, optical prism, didactic tools, physics education
Abstract:
This paper describes two didactic tools made with Excel spreadsheets for an interactive approach to the teaching and learning of certain concepts of geometrical optics. With the first tool we can simulate the phenomena of reflection and refraction of light at the interface between two different optical media. There is a graphic representation of the path of light rays in the two optical media and the dependence of the angles of reflection and refraction on the angle of incidence. The tool also allows the simulation of the phenomenon of total internal reflection, highlighting the critical angle on the graph rendering the angle of refraction according to the angle of incidence. The second tool helps in the study of light refraction in the optical prism. The graph of the tool renders the angles of refraction, of emergence and deviation according to the angle of incidence. Depending on the input data, on the graph, we can visualize the domain of values of the incidence angle to satisfy the condition of emergence. Moreover, the graph helps to determine the conditions for the minimum deviation of the light beam through the optical prism. The graphic representation of deviation of angle depending on the angle of incidence is used as an alternative to the analytical method for determining the angle of minimum deviation. With the help of these two tools students can easily understand the phenomena of reflection and refraction of light and clarify a number of concepts, such as the critical angle, the emergence or minimum deviation. It is thus demonstrated that the benefits and facilities of spreadsheets can be used in the study of geometrical optics. Based on these two tools students can build their own Excel tools to study other phenomena from optics.
|
|
|
|