Plotting graphs with error bars:
How your practical reports are assessessed:
Plotting graphs
The clip below nicely shows how you should put in best fit lines,maximum and minimum trendlines. Watch it! In VCE you should include a best fit line and error bars. Having maximum and minimum trendlines is also useful as it will help you decide on how confident you can be in your data.
This clip shows how you calculate the maximum and minimum gradients:
Adding error bars to excel. This clip clearly takes you through how to add error bars to your excel graph:
Going a bit further
The clips below give some extra background to manipulating your graphs in excel . They show some useful tips which may sometimes be useful. You can use alternative approaches to drawing a best-fit line, like drawing it on by hand yourself.
Plotting graphs on excel: The clip below shows you how to create a best fit line in excel. It also tells you how to exclude certain data points but YOU SHOULD NOT DO THIS, unless you have a very good reason. excluding data is likely to lead to losing marks, so it is better not to do it.
Adding maximum and minimum line in excel. This is useful if you want to be sure of getting higher marks when analysing your data.
Video showing a more up to date version of excel, with some quick tips of the key ideas: