Modelling Projectile Motion (HSC SSCE Physics): Revision Notes
Modelling Projectile Motion
Introduction to modelling in physics
Physicists use different types of models to understand physical systems, solve problems, and make predictions. When studying projectile motion, three main types of models are particularly useful: mathematical models, visual models, and numerical models.
Mathematical models
A mathematical model uses equations to describe the motion. For projectile motion, we treat it as a combination of two simpler types of motion happening simultaneously.
Rectilinear motion is motion in a straight line, or along a single direction. This concept is fundamental to understanding how we break down projectile motion into simpler components.
Projectile motion combines two rectilinear motions:
- Vertical motion: Uniformly accelerated motion due to gravity (acceleration = )
- Horizontal motion: Constant velocity motion (zero acceleration)
The mathematical model uses:
- Constant acceleration kinematics equations for vertical motion
- Constant velocity equations for horizontal motion
This mathematical approach allows us to analyse and predict projectile behaviour precisely.
Visual or graphical models
Visual models provide graphical representations of projectile motion. These models help us see relationships clearly, such as how launch angle affects range. By plotting experimental data alongside the mathematical model, we can create visual representations that make patterns and relationships easier to understand.
Numerical models and computer simulations
A numerical model or computer simulation uses the mathematical equations to calculate the motion step by step over time. This type of model is particularly powerful because it can be easily modified to investigate different conditions, such as varying launch angle, initial velocity, or even gravity.
Investigation 2.3: Computer simulation of the trajectory of a projectile
Aim
To use spreadsheet software to model the trajectory of a projectile.
Materials
- Computer with spreadsheet software
Method
Initial setup:
Open a new file in your spreadsheet software and add a descriptive heading at the top. Save it with a suitable filename.
Remember to save frequently and consider saving multiple sheets for different variations so you can return to earlier versions.
Step 1: Set up the initial conditions
The initial conditions define how the projectile starts its motion. These are:
- Initial velocity ()
- Launch angle ()
- Acceleration due to gravity ()
In your spreadsheet, label cells above the values you enter. The setup should include:
- Cell B4: Launch angle in degrees (e.g., )
- Cell C4: Launch angle in radians using the command =RADIANS(B4)
- Cell D4: Acceleration due to gravity (e.g., m/s²)
Why radians? Excel uses radians (not degrees) when calculating sine and cosine functions, so we must convert the angle. Forgetting this conversion is a common source of errors in spreadsheet calculations.
Calculate the components of initial velocity:
- Horizontal component:
- Cell A6: Use command =25*COS(C4) (where 25 is the initial velocity in m/s)
- Vertical component:
- Cell B6: Use command =25*SIN(C4)
Step 2: Calculate velocity as a function of time
Create three columns labelled: time (), horizontal velocity (), and vertical velocity ().
Time column:
- First cell (A10): Enter (initial time)
- Next cell (A11): Enter command =A10+0.05 to increase time by 0.05 seconds
- Copy this command down the column (use Shift + Page Down to select many cells at once)
You can choose any time increment – smaller values give more detailed results but create larger spreadsheets.
Horizontal velocity column ():
- Cell B10 and all below: Enter command =6
The horizontal velocity is constant throughout the motion and equals the initial horizontal velocity.
The $ signs create an absolute reference that won't change when copied. This is essential for maintaining the correct cell reference as you copy formulas down columns.
Vertical velocity column ():
- Cell C10 and all below: Enter command =6+A10*4
This implements the equation , where the vertical velocity changes due to constant acceleration.
Total velocity column:
- Cell D10 and all below: Enter command =SQRT(B10B10+C10C10)
This calculates the magnitude of velocity using Pythagoras' theorem:

Step 3: Calculate position as a function of time
Add two more columns labelled: horizontal position () and vertical position ().
Horizontal position ():
- Cell beneath the label: Enter command =6*A10
- Copy to cells below
This implements for constant velocity motion.
Vertical position ():
- Cell beneath the label: Enter command =6A10+0.54A10A10
- Copy to cells below
This implements for uniformly accelerated motion.

You now have a complete numerical model of projectile motion! This model can be easily modified to investigate how changing launch angle, initial velocity, or gravity affects the motion.
Investigating different conditions:
To compare different conditions:
- Copy your starting worksheet to create a duplicate
- Modify the copy by changing one variable (e.g., launch angle)
- Compare the results from both models
Results and analysis
Create the following scatter graphs:
- Horizontal, vertical, and total velocity as functions of time
- Horizontal, vertical, and total velocity as functions of position
- Trajectory (vertical position as a function of horizontal position)
Save and/or print these graphs for analysis. These visual representations will help you identify patterns and relationships in the projectile motion.
Discussion
Consider these questions when analysing your results:
- Graph shapes: Comment on the shape of your graphs. Do they match what you expect based on:
- Physical experiments with projectiles?
- The equations used in the simulation?
- Varying initial conditions: What happens when you change the initial conditions?
- If you vary launch angle: What happens to range and maximum height?
- If you vary : What happens to time of flight, range, and maximum height?
- Answer your inquiry question or state whether your hypothesis was supported.
Conclusion
Write a conclusion summarising the outcomes of your investigation. Include what you learned about projectile motion from creating and using the numerical model.
Benefits of computer simulations
Computer simulations offer several advantages:
- Easy to modify variables and test different scenarios
- Can visualise motion that might be difficult to observe experimentally
- Allows investigation of conditions that might be impractical in real experiments (e.g., different gravity values)
- Provides precise numerical data for analysis
- Helps develop understanding by connecting mathematical equations to visual representations
Key Points to Remember:
- Projectile motion can be modelled in three ways: mathematically (using equations), visually (using graphs), and numerically (using computer simulations)
- Projectile motion combines two independent motions: constant velocity horizontally and uniformly accelerated motion vertically
- Computer simulations use step-by-step calculations to model motion over time
- In spreadsheet simulations, use absolute cell references (with $ signs) for constants and relative references for changing values
- Converting angles to radians is essential when using trigonometric functions in spreadsheets
- Numerical models allow easy investigation of how different variables affect projectile motion