Here are a few lessons to give you some chance at practicals.

**Let’s try this easy practical and difficult explanation for a bit of light relief during lockdown**

Skip to content
# Category: Physics Notes

## Properties of Matter

## Density

## Forces 2020

## Forces powerpoint and powerpoint pdf file for 2021 onwards

## Using Excel

### Graphs and Tables in Excel

## CREATING TABLES IN EXCEL

### Excel Tables Hookes Law 2020 word

### Excel Tables Hookes Law 2020 pdf

## CREATING GRAPHS IN EXCEL

###### Covering lots of SALs Significant aspects of Learning!

### Excel Tables 2020 word Excel Tables 2020 pdf

## Where to find the materials

## Making a graph in EXCEL

Here are a few lessons to give you some chance at practicals.

**Let’s try this easy practical and difficult explanation for a bit of light relief during lockdown**

Lockerbie Academy’s S2 Forces Unit Material, containing the Assessed Practical and details for plotting graphs in Excel.

Wow! This is an important Physics topic, your first topic in the S2 physics course. All the info you cover in class is given below. We will start at the beginning but can rush through the bits that you’ve covered in primary.

This sheet gives you details of what need to know for this block and for the test.

This is the workbook that you will use in class, get your own copy here, or use it to copy up what you’ve missed.

Here is the copy of the homework booklet, you can make a start on it whenever you’ve time and get ahead. Make sure you hand homework in on time.

Hmwk Piece | Wk No | S2 Physics Homework Tasks |
---|---|---|

1 | 1 | Complete a title page called FORCES |

2 | 1 | In the back of your jotter write a piece “What I learned about myself in S1 Science” This is not the topics that you covered- I know those, but what did you learn about yourself, your ability to think for yourself, try tasks etc. What skills have you learned . |

3 | 2 | Forces Walk |

4 | Hookes Law table & Hookes Law graph (this is an assessment piece) | |

5 | Literacy Task | |

6 | Answering the mass and weight questions | |

1st June 2019 | All | Revise the work you’ve completed this week and previous weeks |

If you haven’t got results for the Hooke’s Law Assessment use the ones below. Copy the results into Excel, find the average extension using the formula =average(range) . Then plot a graph of Weight against average extension.

Weight | Extension (cm) | Extension (cm) |
---|---|---|

(N) | ‘/1 | ‘/2 |

0 | 0 | 0 |

1 | 2.4 | 2.3 |

2 | 4.8 | 4.8 |

3 | 7.2 | 7.3 |

4 | 9.6 | 9.6 |

5 | 12 | 12.1 |

6 | 14.4 | 14.2 |

7 | 16.8 | 16.5 |

8 | 19.2 | 19.1 |

9 | 21.6 | 21.5 |

10 | 24 | 23.9 |

**There is a separate post on EXCEL with details of how to create a table of results and plot a graph in Excel, which is useful for all students studying Physics, and other Sciences too- a useful life skill.**

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.

I’ve done a crude fix! I do know the link between mass and weight!

I’ve broken the videos up, but the third one is still large!

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!

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 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*

If you want to find notes for each section of your Physics course click on the individual sections from the drop down menu. Happy hunting! It is all there!

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!

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