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

    • Why am I here?

    • Task 1: Reaction time survey #2

    • Causation and statistics

    • Syllabus References

    • Why you should love statistics - Alan Smith

    • Matt Parker - spreadsheets
  • 2

    Foundation statistics

    • Foundation statistics - course notes

    • Foundation statistics - frequency histogram

    • Frequency histogram using Excel

    • Ogive and Pareto charts using Excel

    • Task 2: Frequency histogram task - My reaction time

    • Foundation statistics 2 (Measures of central tendency)

    • Five number summary of data using Excel

    • Box and whisker

    • Outliers

    • Task 3: Five number summary and box and whisker plot of my reaction time
  • 3

    Survey design

    • Asking Questions

    • Sampling Techniques
  • 4

    Session 2 - The normal distribution

    • The normal distribution Notes

    • Central limit theorem

    • Standard deviation and Z-score

    • Effect size
  • 5

    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

    • Uncertainty (D) Standard deviation of the means

    • Processing and analysing data using Excel

    • Uncertainty, error and confidence in data

    • Mean and standard deviation using Excel

    • Task 5: My reaction time

    • Task 6: Cycle challenge 95% confidence prediction

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

    • Additional: The standard deviation video
  • 6

    My investigation

    • Human benchmark team effort
  • 7

    Session 3 - Bivariate Analysis

    • Bivariate analysis course notes

    • Hooke's Law - The elasticity of materials

    • Bivariate Analysis

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

    • Bivariate P3.pdf

    • Task7: My Bivariate analysis
  • 8

    Binomial distribution

    • 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

    • Online statistical tools and tutorials
  • 9

    All about pi

    • Buffons Needle.pdf

    • Using a random variable to generate Pi
  • 10

    Statistical difference: t-test AND F-test

    • 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
  • 11

    Research, datasets and contact

    • Works cited

    • Public data sets

    • Course notes

    • 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...