Learn the basics of descriptive statistics, bivariate data analysis, and inferential tests with Excel. Learn how to manipulate Excel charts to make data analysis in depth studies pop.

Course Curriculum

  • 1

    Session 1 - Foundational statistics and data representation

    • Foundation statistics - course notes

    • Who am I?

    • Task 1: Reaction time survey

    • Frequency histogram using Excel

    • Task 2: Frequency histogram task - My reaction time

    • Syllabus References

    • Why you should love statistics - Alan Smith

    • Ogive and Pareto charts using Excel

    • Matt Parker - spreadsheets
  • 2

    Session 2a - Foundation statistics measures of central tendency

    • Foundation statistics 2 (Measures of central tendency)

    • Box and whisker plot

    • Outliers

    • Five number summary

    • Task 3: Five number summary and box and whisker plot of Reaction time data

    • Task 3a alt: Five number summary and box and whisker plot of Darwin's finches data

  • 3

    Session 2b - Bivariate Analysis

    • Bivariate analysis course notes

    • Bivariate Analysis

    • Bivariate Analysis Part 2 Line of best fit (trendline) in Excel

    • Bivariate P3.pdf

    • Task 4: Hooke's Law experiment - the elasticity of materials

    • Task 4a: My Bivariate analysis (optional)

    • Mathematics Year 12 Standard 2 MS-S4 BIVARIATE DATA ANALYSIS

    • Finch data - bivariate analysis
  • 4

    Session 3a - The normal distribution

    • The normal distribution Notes

    • Task 5 2020 HSC Biology Q25

    • The Bell Curve

    • Standard deviation and Z-score

    • Effect size (optional)

    • A random walk on Wall Street
  • 5

    Session 3b - Uncertainty, error and confidence in data

    • Uncertainty, error and confidence in data: notes

    • Syllabus reference

    • Uncertainty (A) What is uncertainty?

    • Uncertainty (B) Estimating the experimental uncertainty for a single measurement

    • Uncertainty (C) Estimating the experimental uncertainty for a repeated measure

    • Task 6: My reaction time

    • Task 7: Cycle challenge 95% confidence prediction

    • Mean and standard deviation using Excel

    • Uncertainty (D) Standard deviation of the means

    • Task 8: Standard Error of means (SE)

    • Processing and analysing data using Excel

    • Uncertainty, error and confidence in data - Notes and syllabus links

    • Additional: The standard deviation video

    • CLT and Standard Error - Gavin video

    • Central limit theorem
  • 6

    4a Binomial distribution (optional)

    • Syllabus

    • Notes: Binomial theorem

    • Coin toss simulator and Desmos graphics

    • The Bell Curve

    • Bernoulli trials and binomial distributions

    • Continuous Random Variables.pdf

    • Mathematics specific links and resources
  • 7

    4b All about pi (optional)

    • Buffons Needle.pdf

    • Using a random variable to generate Pi
  • 8

    4c Statistical difference: t-test AND F-test (optional)

    • Inferential statistics notes

    • Evolution in action: Data analysis

    • Z-test and SEM

    • Z test on Excel www.StatisticsHowTo.com

    • F-test

    • F-test -Finch masses

    • t-test for tarsus length.pdf

    • Chi-square test "Hypothesis analysis"

    • Chisq test on Excel

    • Student's t-test - Eugene O'Loughlin

    • F-test on Excel - www.StatisticsHowTo.com

    • Statistics 101: Hypothesis testing - Brandon Foltz
  • 9

    Course notes, research and datasets

    • Online statistical tools and tutorials

    • Public data sets

    • Course notes

    • Works cited

    • Mathematics demonstrations and simulations

About the instructor

Curriculum and assessment advisor

Jim Sturgiss

Jim is an educational researcher and independent educational consultant. A recipient of the NSW PTC Distinguished Service Award for leadership in delivering targeted professional learning to teachers, he works with schools to align assessment, reporting and learning practice. He has been a DoE Senior Assessment Advisor where he developed many statewide assessments, (ESSA, SNAP, ELLA, BST) and as Coordinator: Analytics where he developed reports to schools for statewide assessments and NAPLAN.

What others have been saying about this course:

Want to know more about uncertainty, the analysis of data and statistics? 

Do you want to know how to address the statistics in the Science Extension course? 

Do you want to rub shoulders with Mathematics teachers? 

Learn all this and how its done on Excel.

Sign up now!

You may also be interested in...