Using Excel for your LO3 and Investigation

We’ll spend the next two lessons in the library learning how to use Excel.  Download the instructions using the link below.  If you have your own LO3 data, feel free to work with those values instead of the numbers I have provided.

By the end of this activity you will be able to;

  • manipulate raw data using formulae in cells
  • plot a graph of your results
  • add error bars to your graph
  • add a line of best fit
  • calculate the gradient and y-axis intercept of your line

AH Outcome 3 diagrams

Here are the diagrams you will need for your LO3 report.  Cick on each link and then save the large image that opens up.  You can rezise them once they have been imported into your report.

turntable

stand

radian sector

turntable and stand

Later this week, we’ll look at how you can use a spreadsheet to process the data you obtained.

ah – particle physics

So we’ve reached the end of unit 2. For those of you interested in finding out more about fundamental particles, here are some ideas to get you started.

AH magnetism revision

We’ve covered all of the magnetism work that you will need for the prelim at the end of the month.  You don’t need to know about inductors for this paper.

Here are some resources to get your revision underway.

We use permanent magnets and electromagnets in class, but to create a really strong magnetic field requires a superconducting magnet like the one in this video.


Disclaimer: I used to work for the company that built that magnet.

I’ve attached a pdf with magnetism notes and questions for you to get some practise at the calculations and proofs you should know.

the Hall Effect

Last week we used Helmholtz coils to demonstrate the Hall Effect in a piece of n-type germanium.  I’ve found a video on the sixtysymbols site, where Prof. Bowley from Nottingham University explains what’s going on.  Enjoy!

Download the attached pdf document if you’d like to learn more about applications and measurement of the Hall Effect.

AH investigations – uncertainties and graphs

Now you have some measurements in your daybook, it’s time to look at the uncertainties in your data.  There will be scale reading uncertainty, calibration uncertainty and randon uncertainty to consider.  I’ve attached a copy of the latest guidance from SQA on uncertainties for AH Physics candidates.  Download a copy and use it to help with number crunching.

Remember that there is help available when you are ready to graph your data.  Start here.