Appears in:
Pages: 4509-4517
Publication year: 2017
ISBN: 978-84-697-3777-4
ISSN: 2340-1117
doi: 10.21125/edulearn.2017.0198

Conference name: 9th International Conference on Education and New Learning Technologies
Dates: 3-5 July, 2017
Location: Barcelona, Spain

# SPREADSHEETS IN PHYSICS: DIDACTIC TOOLS FOR LEARNING CONCEPTS OF GEOMETRICAL OPTICS

I. Grigore1, C. Berlic2, V. Barna2

1National College "Ion Luca Caragiale", Ploiesti (ROMANIA)
2University of Bucharest, Faculty of Physics (ROMANIA)
One of the most important tasks in teaching physics is to use a suitable method for understanding and developing of the theoretically acquired knowledge. The Excel spreadsheets increase studentsâ€™ interest in the theoretical subject taught in the class and help their learning. This paper describes two didactic tools made with Excel spreadsheets for an interactive approach of the teaching and learning of certain concepts of geometrical optics. With the first tool, we 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 facilitates the study of light refraction in the optical prism. The graph of the tool renders the angles of refraction, emergence and deviation according to the angle of incidence. Depending on the input data, using the graph, we can visualize the domain of values of the incidence angle that 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 the deviation angle depending on the incidence angle 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 confirmed that the facilities of the spreadsheets may be used in the study of geometrical optics. Starting on these tools, students can build their own Excel applications, in order to study other optics phenomena.
@InProceedings{GRIGORE2017SPR,
author = {Grigore, I. and Berlic, C. and Barna, V.},
title = {SPREADSHEETS IN PHYSICS: DIDACTIC TOOLS FOR LEARNING CONCEPTS OF GEOMETRICAL OPTICS},
series = {9th International Conference on Education and New Learning Technologies},
booktitle = {EDULEARN17 Proceedings},
isbn = {978-84-697-3777-4},
issn = {2340-1117},
doi = {10.21125/edulearn.2017.0198},
url = {https://dx.doi.org/10.21125/edulearn.2017.0198},
publisher = {IATED},
location = {Barcelona, Spain},
month = {3-5 July, 2017},
year = {2017},
pages = {4509-4517}}
TY - CONF
AU - I. Grigore AU - C. Berlic AU - V. Barna
TI - SPREADSHEETS IN PHYSICS: DIDACTIC TOOLS FOR LEARNING CONCEPTS OF GEOMETRICAL OPTICS
SN - 978-84-697-3777-4/2340-1117
DO - 10.21125/edulearn.2017.0198
PY - 2017
Y1 - 3-5 July, 2017
CI - Barcelona, Spain
JO - 9th International Conference on Education and New Learning Technologies
JA - EDULEARN17 Proceedings
SP - 4509
EP - 4517
ER -
I. Grigore, C. Berlic, V. Barna (2017) SPREADSHEETS IN PHYSICS: DIDACTIC TOOLS FOR LEARNING CONCEPTS OF GEOMETRICAL OPTICS, EDULEARN17 Proceedings, pp. 4509-4517.
User:
Pass: