Angles and Acid
  • Science Videos
    • Write Better Introductions
    • Write Better Hypotheses and Methods
    • Write Better Discussions
    • Write Better Conclusions
    • Skills - Excel and Graphs
    • Skills - Equations in Excel
    • Turnitin Signup
    • Apparatus Generator
    • Practical Report: Bounce Efficiency
    • Practical Report: The effect of detergents on plants
  • Chemistry
    • Relative Atomic Mass
    • Atomic Mass Units
    • The Mole and Calculations
    • Percentage Composition
    • Dehydrating Copper Sulfate
    • Empirical Formula in Context
    • Magnesium Oxide
    • How to Survive Chemistry
    • Tour of the Lab 1
    • Sulfate in Fertilizer
    • Titrations
    • Gas Properties
    • Kinetic Molecular Theory of Gases
    • Tour of the Lab 2
    • Copper and its compounds
    • Polyatomic Ions
    • Electron Dot Structures and Molecular Shapes
    • Polar and Non-polar Solubility
    • Ionic Bonding
    • Mass Spectrometer
    • Limiting Reagent
    • Corrosion Rates
    • Precipitation Reactions
    • Ionic Bonding Basics Part 1
    • Ionic Bonding Basics Part 2
    • Cracker Combustion
    • Electron Configurations
    • Ionic formulas
  • Physics
    • Convection
    • Comparing Conductivity of Materials
    • Galileo's Water Clock
    • Age of Star Clusters & Red Giants
    • Video Analysis
    • Astronomy basics
  • Biology
    • Heart Dissection
    • Investigating Photosynthesis
  • Earth Sciences
    • Making Volcanoes
  • Store

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.

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.
comments powered by Disqus
Proudly powered by Weebly