Blog Archives

Excel Graphing Screencasts

These two videos are for my classes, made using the free screencast tool ScreenCast-O-Matic.

The first is for my IB Bio group for setting up a graph for a complex set of data, adding extra datasets, error bars and formatting. The second is a similar video for a simple Physics investigation in Grade 10.

Hopefully they are helpful as you can go back and re-watch important bits as you do the write-ups.

If anyone knows of a decent way to add best-fit curves (lines are easy) to datasets, please let me know!

Statistical Analysis 2009

Here is the updated presentation for 2009, with more information on Excel and a worked set of examples with hummingbirds, to tie in with the natural selection topics.

And Geoff Browne kindly gave permission to upload his t-test powerpoint to slideshare:


Updated Essential Biology 01 – Statistical Analysis (word)

Click4Biology statistical analysis page, with great help for calculators and excel

Excellent Handbook of Biological Statistics from John MacDonald

Sumanas statistics animations

Field Studies Council stats page, including the t-test

Open Door Website stats page and help with graphs and tables

Gapminder awesome human population stats tool

And this enlightening talk from Han Rosling: No More Boring Data!

Using your calculator:

Using the TI GDC (from Click4Biology)

Using the Casio pdf download (from

%d bloggers like this: