with mr mackenzie
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;
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.
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.
