Data Analytics Workshop


AS.110.100, Johns Hopkins pre-college program. Developed Spring 2023; taught Summers 2023–2026

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
Day 1 - Sets, Functions, and Sigma Notation
Day 2 - Data, Sampling, and Statistics
Day 3 - Distributions and Outliers
Day 4 - Center, Spread, and Standard Error
Day 5 - Questions, Hypotheses, and Correlation
Week 2: Probability, Visuals, and Expected Value Days 6–8
Day 6 - Probability and Conditional Probability
Day 7 - Visualizing Results
Day 8 - Expected Value
Collected Notes
All Lecture Notes (Days 1–8)
Excel Notes

Discussions


Discussion boards run alongside the project. Each asks for an initial post and replies to classmates a day later.

Day 2 Data Visualization A photo is a grid of red, green, and blue values. Histograms, bar charts, and scatter plots of those pixel values introduce what each kind of chart is good for.
Day 8 Back-Breaking Straws and Expected Value Straws weighing 0 to 20 lb go on a camel until the load passes 100 lb. How much does the final straw weigh on average?

Simulations


Interactive tools built for the course's discussions. They run in the browser; nothing to install.