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 1
How 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 2
How to colour your tables How to save time with excel formulas |
GRAPHS - Part 1
How to choose the correct graph How to format graphs correctly Where to find special characters on a Mac or PC (e.g. °, µ, θ, π). GRAPHS - Part 2
How to put Character Viewer on the Mac toolbar. Where to find Character Map on the PC GRAPHS - Part 3
When to graph a scatter plot Basic trend line analysis GRAPHS - Part 4
The 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 5
How 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. |