UNIVERSITY OF BUCHAREST
FACULTY OF PHYSICS

Guest
2024-11-22 1:55

 HOME     CONFERENCES     SEARCH            LOGIN     NEW USER     IMAGES   


Conference: Bucharest University Faculty of Physics 2018 Meeting


Section: Physics Education


Title:
On the simulation of the projectile motion in the gravitational field using Excel VBA


Authors:
Catalin BERLIC(1), Cristina MIRON(1)


Affiliation:
1)University of Bucharest, Faculty of Physics, P.O.BOX MG-11, Magurele, Bucharest, Romania


E-mail
cmiron_2001@yahoo.com


Keywords:
Excel, Visual Basic for Application, projectile motion, gravitational field


Abstract:
The work presents a very simple and interactive instrument created using Microsoft Excel TM to describe the motion of a mass point in constant gravitational field without considering any air resistance. First, we used the very fast, interactive and useful calculations features of the Excel to visually interact with the end user and to presents the results. For the calculations, we used the more sophisticated and flexible calculations features of the Excel Visual Basic for Application. The usefulness of the tool consists in both visual an interactive interaction with the graphical part of the Excel, but, by studying and modifying the Excel macros, the students may increase their knowledge of both physics and computer programming.