NotesFAQContact Us
Search Tips
Back to results
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ1059626
Record Type: Journal
Publication Date: 2015-May
Pages: 6
Abstractor: As Provided
Reference Count: 13
ISSN: ISSN-0031-9120
Spreadsheet Application Showing the Proper Elevation Angle, Points of Shot and Impact of a Projectile
Benacka, Jan
Physics Education, v50 n3 p342-347 May 2015
This paper provides the formula for the elevation angle at which a projectile has to be fired in a vacuum from a general position to hit a target at a given distance. A spreadsheet application that models the trajectory is presented, and the problem of finding the points of shot and impact of a projectile moving in a vacuum if three points of the trajectory are known is solved and modelled by another interactive application. A Gaussian elimination method is used to solve the system of linear equations that gives the trajectory parameters. These applications were developed with 30 high-school students, who were given a questionnaire to find out their opinion of the lessons.
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: Secondary Education; High Schools
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A