2015
DOI: 10.1088/0031-9120/50/3/342
|View full text |Cite
|
Sign up to set email alerts
|

Spreadsheet application showing the proper elevation angle, points of shot and impact of a projectile

Abstract: 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 giv… Show more

Help me understand this report

Search citation statements

Order By: Relevance

Paper Sections

Select...
2
1

Citation Types

0
2
0
1

Year Published

2016
2016
2022
2022

Publication Types

Select...
3
2
1

Relationship

0
6

Authors

Journals

citations
Cited by 7 publications
(3 citation statements)
references
References 11 publications
0
2
0
1
Order By: Relevance
“…Work from Benacka investigates the motivating effects of using spreadsheet modelling of real-world physics problems [70,71]. For example, 97% of high school students that modelled one of three mechanics problems, that are normally not part of high school physics, with 'Excel' using the Euler Method found the lesson very interesting [72].…”
Section: Research Results On Computational Modelling In Literaturementioning
confidence: 99%
“…Work from Benacka investigates the motivating effects of using spreadsheet modelling of real-world physics problems [70,71]. For example, 97% of high school students that modelled one of three mechanics problems, that are normally not part of high school physics, with 'Excel' using the Euler Method found the lesson very interesting [72].…”
Section: Research Results On Computational Modelling In Literaturementioning
confidence: 99%
“…Die Nutzung von "VPython" half Studierenden außerdem nach eigener Einschätzung dabei, drei verschiedene Probleme zu modellieren und die Physik dahinter besser zu verstehen (Hawkins et al, 2017). Benacka (2015b) untersuchte in verschiedenen Studien die motivierenden Eigenschaften der mathematischen Modellbildung mit Tabellenkalkulationsprogrammen in Oberstufenschulen (Benacka, 2015a(Benacka, , 2015b und kam zu dem Ergebnis, dass 97 % der Schüler*innen die Einheit, in der ein neuartiges Problem mit dem Euler-Verfahren modelliert wurde, sehr interessant fanden (Benacka, 2016).…”
Section: Forschungsergebnisse 11unclassified
“…Some of the shortcomings were explained with difficulties related to the software [15]. Though it is also possible to use spreadsheet software to model movements [16][17][18], there are programs specifically built for the use of computational modeling in mechanics classes in school, like "Newton-II" [19]. These enable students to easily use the software themselves without the need to learn a programming language first.…”
Section: A Computational Modellingmentioning
confidence: 99%