Graphs and Tables in Excel
Mrs Physics is keen to get everyone using software to aid their Physics, so as part of the forces topic you will complete a Hooke’s Law experiment and write this up and use Excel to create your table and graph. The instructions are given in the booklets below. GLOW users and other users of Office 365 will be using the Excel 2016 version, but users of Office 2010 can use the booklets marked 2010.
If you missed the lesson and want to practice use this data here.
Raw data no headings Excel file of data for you to practice with.
CREATING TABLES IN EXCEL
I’ve done a crude fix! I do know the link between mass and weight!
Excel Tables Hookes Law 2020 word
Excel Tables Hookes Law 2020 pdf
I’ve broken the videos up, but the third one is still large!
CREATING GRAPHS IN EXCEL
The video above is a compressed version of the whole video on creating graphs in Excel.
If this is too large for you I’ve broken it down into two sections given below!
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 booklets below. GLOW users and other users of Office 365 will be using the Excel 2016 version, but users of Office 2010 can use the booklets marked 2010.
Excel Tables 2020 word Excel Tables 2020 pdf
Excel Tables 2010 pdf Excel Tables 2010 word
Plotting Graphs 2010 pdf Plotting Graphs 2010 word
If you were absent when doing the experiment you can use this data to plot your own graph.
| mass added | length 1 | length 2 | length 3 | length 4 |
|---|---|---|---|---|
| (grams) | (cm) | (cm) | (cm) | (cm) |
| 100 | 5.5 | 6.0 | 6.0 | 5.7 |
| 90 | 5.0 | 5.6 | 5.6 | 5.1 |
| 80 | 4.8 | 4.8 | 5.3 | 4.9 |
| 70 | 4.4 | 4.5 | 5.0 | 4.5 |
| 60 | 3.9 | 4.0 | 4.5 | 4.1 |
| 50 | 3.6 | 3.6 | 4.4 | 3.8 |
| 40 | 3.0 | 3.2 | 3.4 | 3.5 |
| 30 | 2.7 | 2.9 | 2.9 | 3.0 |
| 20 | 2.5 | 2.5 | 2.6 | 2.5 |
| 10 | 2.2 | 2.3 | 2.1 | 2.1 |
| 0 | 2.1 | 2.1 | 2.0 | 2.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.
June 2020