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

AH investigation report – handling uncertainties

I’ve been asked several questions on uncertainties recently.  Many of these have been about graphs and I have discussed the linest function in Excel. However, not everyone uses a spreadsheet and so I thought the attached file from Learning & Teaching Scotland might be useful, especially if you are drawing graphs by hand.