WordPress won’t let me post a spreadsheet here. Instead, here’s the first line of it as an image – you’ll have to create it for yourselves after all. Go from t=0 to t=20s.
Here’s what to do. Click on the images to enlarge them and see how the formulae are created.
The time axis goes to the left. When you’ve put in your u and a data, create the formulae as shown to calculate v and s. Try not to wipe the formulae – you’ll have to do them all over again if you do – that’s the unshaded part. Make sure that the spreadsheet copies any changes down the data set. If you need it all, I’ll put it on a flash drive and we’ll upload it on to your machine in class – as long as your machine is clean!
Use the data to produce a v/t graph and a s/t graph as-is, properly formatted with thin lines. You need to experiment with the scatter function. This will look like the ones on the display board. Change u and a, bearing in mind that I may ask you to explain physically what is happening.
Hand in your data plus graphs.
You are going to need a good hard copy of your s/t graph with constant acceleration.
Click here for a Derivation of Equations of Motion from first principles.