This zip file contains my entire statistics unit designed for my IB-SL Biology course. It could also be used in a statistics course, undergraduate science course, or any other science course in which you would like to use MS Excel for graphing data.
Not sure how to do simple bar graphs in MS Excel? Not sure how to use MS Excel to calculate averages? Not sure how to explain adding error bars or regression lines to graphs? This zip file includes 14 tutorials (video screen shots with audio) on how to perform basic calculations, graph scatter plots, and design bar graphs in MS Excel. In addition, the excel file used in the tutorials is provided with an answer key. A Powerpoint presentation is included that can be used with students to explain basic statistics principles. A second Excel practice file is included with an answer key.