Rate this resource

This series of interactive excel sheets investigate models involving collisions.

The first sheet simulates two particles colliding. Initial velocity, mass and resulting velocity of the two particles can be set, or a random set-up can be generated.

The second sheet contains six questions. The mass and initial velocity of two perfectly elastic particles are given, and students are to find the velocities after collision, as well as the impulse of the second particle.

The following sheet contains another six similar questions, however this time the coefficient of restitution, e, is less than one. A new set of questions can be generated each time.

In the fourth sheet the initial velocity and the value of e can be varied in order to investigate the velocity of rebound, the impulse, and the loss of kinetic energy when a particle collides with a vertical wall. The next sheet contains six questions on this model. Missing variables from a table are to be calculated. Answers can then be revealed.

The sixth sheet investigates the dropping and rebounding of a particle. The height and elasticity of the mass can be adjusted. The velocity at impact and rebound as well as the rebound height can be shown. The next sheet contains six questions in which missing variables from the table are to be calculated. The answers can be revealed one at a 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