| |
 |
UNIVERSITY OF BUCHAREST
FACULTY OF PHYSICS Guest
2024-11-22 2:14 |
 |
|
|
|
Conference: Bucharest University Faculty of Physics 2015 Meeting
Section: Physics Education
Title:
Exploring Excel spreadsheets to simulate the projectile motion in the gravitational field
Authors:
Ionel GRIGORE(1,2), Cristina MIRON(1), Emil Ștefan BARNA(1)
Affiliation:
1) Faculty of Physics, University of Bucharest, Bucharest-Măgurele, Romania
2) “Lazăr Edeleanu” Technical College, Ploieşti, Romania
E-mail
grigore_1965@yahoo.com
Keywords:
spreadsheets, projectile motion, drag force, terminal velocity, safety parabola, asymptote of the trajectory, Physics education
Abstract:
This paper describes an interactive learning tool created with Excel spreadsheets to simulate the projectile motion in the gravitational field taking into account air resistance. The body thrown is considered as point mass and the drag force linear in the speed. The tool allows the analytical and graphical comparison between motion in vacuum and motion in air, in the gravitational field, with the same input data. The trajectory of the body can be viewed in vacuum and in air, separately, for an easier highlight of certain particular aspects, and also comparatively, on the same graph, for a simultaneous observance of differences. For the motion in vacuum, the safety parabola and the ellipse of the points of maximum height have been graphically rendered. For the motion in air, the vertical asymptote of the trajectory has been graphically rendered. For both the motion in vacuum and in air there have been marked on the graphs the maximum height reached by the body and the horizontal distance corresponding to the maximum height. Using the spreadsheet facilities there is provided an approximate method of determining the flight time and the maximum horizontal range for the motion in air. Furthermore, there are comparative presentations of the graphs of velocities and the horizontal and vertical displacements in relation to time. Given the importance of the addressed topic both for ballistics and for various ball sports, the use of the tool in the classroom with the students can be an attractive and motivating factor for the study of Physics. With the rapid graphical feedback to changes in the input data, students can better understand the influence of various parameters on the trajectory and clarify significant concepts such as terminal velocity or the asymptote of a trajectory.
Acknowledgement:
Grigore Ionel was supported by the strategic grant POSDRU/159/1.5/S/137750, ”Project Doctoral and Postdoctoral programs support for increased competitiveness in Exact Sciences research” cofinanced by the European Social Found within the Sectorial Operational Program Human Resources Development 2007 – 2013.
|
|
|
|