Spreadsheet simulation

Spreadsheet simulation

Explore this projectile motion simulation.

You can select any projectile. Change the angle of the cannon or the initial velocity. Use the yellow measuring tape to make any necessary measurements, or simply read them from the given boxes.

Image of columns in an excel spreadsheet

Save this spreadsheet (XLSX 21kB) and enter the table of values. Use them to consider a response to the questions below. Write your observations in the spaces provided on the spreadsheet.

  1. How does the angle of inclination affect projectile motion?

  2. How does initial velocity affect projectile motion?

  3. What about the size, shape and weight of the projectile?

Email your completed spreadsheet to your teacher.