Forces 2020

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.

 

Forces powerpoint (unmodified)

Forces iop (forces specs only)

 

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 PieceWk NoS2 Physics Homework Tasks
11Complete a title page called FORCES
21In 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 .
32Forces Walk
4Hookes Law table & Hookes Law graph (this is an assessment piece)
5Literacy Task
6Answering the mass and weight questions
1st June 2019AllRevise 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.

WeightExtension (cm)Extension (cm)
(N)‘/1‘/2
000
12.42.3
24.84.8
37.27.3
49.69.6
51212.1
614.414.2
716.816.5
819.219.1
921.621.5
102423.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.

Signature
May 2020

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.

Hooke’s Law 2016 version (updated 16/6/20)

Excel Tables Hookes Law 2020   word

Excel Tables Hookes Law 2020 pdf

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).