Rate this resource

This series of interactive excel sheets look at projectiles, either on or above the horizontal plane.

The first sheet defines the symbols and units used the remaining sheets.

The second sheet investigates how changes to the angle of a projectile effects the maximum height, range and time of the flight. In the following sheet the effects of adjusting the initial velocity can also be investigated.

In the fourth interactive sheet the angle and speed of the projection can be varied in order to clear a wall. The position and height of the wall can be adjusted. The maximum height, range and time of the flight are also calculated.

In the next model a projectile is fired from a raised platform. The angle, initial velocity and height of the platform can all be adjusted.

The final interactive sheets investigates the trajectories of particles exploding from a point on or above the ground. The speed with which each particle starts its journey can be varied.

The last sheet contains questions on five different projectiles for which students are to complete missing values from a table. Answers can be revealed and a new set of questions can be generated each time.

This program was designed by be viewed on a screen with a resolution of 1024 x 768. Users may have to adjust the resolution of their screen for the pages to display as was originally intended. The program uses macros which need to be enabled on users’ machine.

Show health and safety information

Please be aware that resources have been published on the website in the form that they were originally supplied. This means that procedures reflect general practice and standards applicable at the time resources were produced and cannot be assumed to be acceptable today. Website users are fully responsible for ensuring that any activity, including practical work, which they carry out is in accordance with current regulations related to health and safety and that an appropriate risk assessment has been carried out.

Show downloads

Published by


Share this resource

Lists that tag this content