Biology: Data Analysis and Interpretation

Presenter: Dr Gurion Ang, The University of Queensland

Overall description of mini-MOOC:

This mini-MOOC about basic data analysis and interpretation for science is delivered in the context of the senior Biology syllabus but may also be applicable to other subjects, such as Agricultural Science, Earth and Environmental Science, and Marine Science. Topics covered in these 16 videos include data analysis using Microsoft Excel tools (with separate videos for Mac users and Windows users), uncertainty, figure construction, t-tests, P-values, and regression analysis.

  • Video 1:

Title: Biology – Data Analysis and Interpretation – Introduction

Description: This video introduces this mini-MOOC about basic data analysis and interpretation for science.

Filename: Biology_Data-Analysis_1_Introduction.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/Rp04i3czEGQYzyK

  •  Video 2A:

Title: Biology – Data Analysis and Interpretation – Installation of ToolPak – Mac

Description: This video explains how to install the Data Analysis Toolpak in Microsoft Excel for Mac users.

Filename: Biology_Data-Analysis_2A_Installation-of-Toolpak-Mac.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/myUb2bOFbo2zaG1

  • Video 2B:

Title: Biology – Data Analysis and Interpretation – Installation of ToolPak – Windows

Description: This video explains how to install the Data Analysis Toolpak in Microsoft Excel for Windows users.

Filename: Biology_Data-Analysis_2B_Installation-of-Toolpak-Windows.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/wZnOdq39MawnlAw

  • Video 3A:

Title: Biology – Data Analysis and Interpretation – Data Summary – Mac

Description: This video explains how to create a data summary using the Data Analysis Toolpak in Microsoft Excel for Mac users.

Filename: Biology_Data-Analysis_3A_Data-Summary-Mac.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/cTSBMwM3eCka3NT

  • Video 3B:

Title: Biology – Data Analysis and Interpretation – Data Summary – Windows

Description: This video explains how to create a data summary using the Data Analysis Toolpak in Microsoft Excel for Windows users.

Filename: Biology_Data-Analysis_3B_Data-Summary-Windows.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/XySfHDKP2KLDer6

  • Video 4:

Title: Biology – Data Analysis and Interpretation – Uncertainty

Description: This video discusses standard error and standard deviation.

Filename: Biology_Data-Analysis_4_Uncertainty.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/JzcHcAHGY9fh8dF

  • Video 5:

Title: Biology – Data Analysis and Interpretation – Figure Construction

Description: This video explains how to add error bars to graphs in Microsoft Excel.

Filename: Biology_Data-Analysis_5_Figure-Construction.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/czjK0ay6jpIDdHA

  • Video 6:

Title: Biology – Data Analysis and Interpretation – Confidence Intervals

Description: This video discusses confidence intervals.

Filename: Biology_Data-Analysis_6_Confidence-Intervals.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/hdObQT6ny57j7gP

  • Video 7:

Title: Biology – Data Analysis and Interpretation – Paired vs Unpaired t-Tests

Description: This video discusses paired and unpaired t-tests, and looks at examples of situations in which these should be used.

Filename: Biology_Data-Analysis_7_Paired-vs-Unpaired-t-Tests.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/mf0XUzMvNLb6gz4

  • Video 8A:

Title: Biology – Data Analysis and Interpretation – t-Tests – Mac

Description: This video explains how to carry out t-tests using the Data Analysis Toolpak in Microsoft Excel for Mac users.

Filename: Biology_Data-Analysis_8A_t-Tests-Mac.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/GGtxUo9wpCLgrA7

  • Video 8B:

Title: Biology – Data Analysis and Interpretation – t-Tests – Windows

Description: This video explains how to carry out t-tests using the Data Analysis Toolpak in Microsoft Excel for Windows users.

Filename: Biology_Data-Analysis_8B_t-Tests-Windows.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/OKNEevwwroJNIhn

  • Video 9:

Title: Biology – Data Analysis and Interpretation – P-value Interpretation

Description: This video discusses P-vales and their interpretation.

Filename: Biology_Data-Analysis_9_P-value-Interpretation.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/bmK7j4LonTPpdRJ

  • Video 10A:

Title: Biology – Data Analysis and Interpretation – Regression – Mac

Description: This video explains how to carry out regression analysis in Microsoft Excel for Mac users.

Filename: Biology_Data-Analysis_10A_Regression-Mac.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/15zA9WSDIFDB4Vy

  • Video 10B:

Title: Biology – Data Analysis and Interpretation – Regression – Windows

Description: This video explains how to carry out regressions in Microsoft Excel for Windows users.

Filename: Biology_Data-Analysis_10B_Regression-Windows.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/9PRXWl4FPhUQFJB

  • Video 11:

Title: Biology – Data Analysis and Interpretation – Interpreting Regressions

Description: This video discusses regression analysis and interpretation.

Filename: Biology_Data-Analysis_11_Interpreting-Regressions.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/Gu9bVwRj1Vz6pFb

  • Video 12:

Title: Biology – Data Analysis and Interpretation – Conclusions

Description: This video provides concluding remarks for this mini-MOOC on basic data analysis and interpretation for science.

Filename: Biology_Data-Analysis_12_Conclusions.mp4

CloudStor link: https://cloudstor.aarnet.edu.au/plus/s/IBAXkim5fmPeh9I