Spreadsheets & Graphing
To try to help students understand spreadsheets and graphing, I’ve put together an IBDP Bio Excel StatBook. It is simply an Excel document with lots of pages to allow students to choose which tests to use and to set up and format graphs and tables appropriately.
Almost all lab investigations could be carried out using Excel or another spreadsheet software. My advice to students is to always work first in the spreadsheet: perform calculations, create and format graphs and tidy everything up before moving to the Word document.
Students do need to have graphical calculators for their exams. You can also get some emulators online for free. Here is GraphPad’s QuickCalcs resource.
The tutorial videos below show how to perform some of the tasks in Excel.
Excel Tutorial Videos
More will be added to my YouTube channel.