Using Excel

Hooke’s Law

Covering lots of SALs Significant aspects of Learning!

plan investigation word  plan investigation pdf

Mrs Physics is keen to get everyone using modern software, so as part of the forces topic you will complete a Hooke’s Law experiment and write this up like an old National 5 Outcome 1 and use Excel to create your table and graph. The instructions are given in the two booklets below.

Excel Tables     pdf   Excel Tables word

Plotting Graphs  pdf   Plotting Graphs word

If you were absent when doing the experiment you can use this data to plot your own graph.

example Hookes

mass addedlength 1length 2length 3length 4
(grams)(cm)(cm)(cm)(cm)
1005.56.06.05.7
905.05.65.65.1
804.84.85.34.9
704.44.55.04.5
603.94.04.54.1
503.63.64.43.8
403.03.23.43.5
302.72.92.93.0
202.52.52.62.5
102.22.32.12.1
02.12.12.02.0

We are not expecting you to be competent the first time through (as you can see from this student’s data), but hopefully by the time you get to S4 you’ll be quite happy to plot graphs this way.

 

Signature


Leave a Reply

Your email address will not be published. Required fields are marked *