Using Excel

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!

Part 1
Part 2
Part 3
Part 4

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.

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

June 2020


Making a graph in EXCEL

Here are a couple of items to help you produce a graph in EXCEL. There is the original power point and then a pdf version of the same file.

I hope it helps!

Excel    Excel

Guide to excel 5795

Guide to Excel  664898

How to create a graph in excel

For the really able there is also information in the Advanced Higher section of the website under the project section

Guide to Excel 2010 (AH).

Preferences