## SKILLS: Excel and Graphs

Having trouble with Microsoft Excel? Want to take advantage of its features to calculate information for you?

Many students have struggled with this and as science teachers we do not have the time to show you how, so I've made a series of videos about how to use excel with a focus on how they are applied in Science.

Many students have struggled with this and as science teachers we do not have the time to show you how, so I've made a series of videos about how to use excel with a focus on how they are applied in Science.

TABLES - Part 1How to build complex tables in excel How to format the table headers correctly How to reduce/increase decimal places How to use excel to perform formulas for you TABLES - Part 2How to colour your tables How to save time with excel formulas |
GRAPHS - Part 1How to choose the correct graph How to format graphs correctly Where to find special characters on a Mac or PC (e.g. °, µ, θ, π). GRAPHS - Part 2How to put Character Viewer on the Mac toolbar. Where to find Character Map on the PC GRAPHS - Part 3When to graph a scatter plot Basic trend line analysis GRAPHS - Part 4The meaning of R² values How to make use of the trend line equation on the graph to make calculations to predict the numerical values that are within the range of your data (interpolation) or beyond the range of your data (extrapolation). GRAPHS - Part 5How to put on Error Bars onto a graph. How to size the Error Bars with Uncertainties (these come from your calculations: year 11-12 stuff) How to calculate Relative Uncertainty & Absolute Uncertainty. |