Data Analytics Workshop
A two-week, fully online and asynchronous course for high school students. Working in small groups, students choose a real data set of their own (around a thousand rows or more), then clean, hypothesize, visualize it, and finish by presenting what they found. Along the way we will discuss the mathematics underneath: summary statistics, probability, distributions, and the basics of hypothesis testing and regression. All of the hands-on work happens in Microsoft Excel, and no background beyond some algebra is assumed.
- Describing data: sets, functions, and modeling; sigma notation; mean, median, mode, quartiles, variance, standard deviation, and the standard error of the mean; outliers and cleaning a data set.
- Randomness and distributions: data as random variables, sampling, discrete and continuous distributions, the uniform and normal distributions, independence, conditional probability, and expected value.
- Asking questions of data: forming meaningful hypotheses, correlation versus causation, choosing the right visual, regression, and the ethics and misuse of statistics.
- Excel: formatting and formulas, sampling, histograms, bar charts with error bars, and scatterplots, practiced in four guided worksheets and used throughout the group project.
Lecture Notes
Typed notes for each day's lectures.
Week 1: Data, Distributions, and Questions Days 1–5
Week 2: Probability, Visuals, and Expected Value Days 6–8
Discussions
Discussion boards run alongside the project. Each asks for an initial post and replies to classmates a day later.
Simulations
Interactive tools built for the course's discussions. They run in the browser; nothing to install.
