Outcomes
What students should leave with
- Use Python tools to clean, join, summarize, and visualize data sets.
- Explain trends with evidence instead of only producing raw tables.
- Prepare notebook-style analysis that can be reviewed and repeated.
Reference map
Core topics to cover
Series and data frames
Cleaning data
Grouping and aggregation
Statistics basics
Visualization
Notebook workflow
Analysis storytelling
Module sequence
ICCT lesson flow
Module 1
Shaping messy data
Lessons: 2
Turn incomplete or uneven records into something trustworthy enough to analyze.
Loading, inspecting, and cleaning data
null handling, naming cleanup, and field normalization
Filtering, sorting, and combining sources
basic wrangling patterns for real reporting tasks
Checkpoint lab
Clean and combine two school operations files into one analysis-ready table.
Module 2
Analysis and visual reading
Lessons: 2
Move from raw data into patterns people can act on.
Aggregations, trends, and comparisons
grouping and summarizing without losing detail
Charts that explain rather than decorate
matching chart type to the decision being made
Checkpoint lab
Build a chart set that explains inquiry volume, follow-up pace, and conversion movement.
Module 3
Telling the story responsibly
Lessons: 2
Present analysis clearly without overstating what the data can prove.
Statistical caution and context
avoiding weak claims and misunderstood averages
Notebook-to-brief handoff
communicating method, limits, and next steps
Checkpoint lab
Write a short decision memo based on a notebook analysis and include the limits of the data.
Capstone prompts
Projects students can actually ship
Admissions Trend Notebook
Analyze inquiry and enrollment flow over time, then surface the highest-priority operational follow-ups.
Attendance Risk Review
Identify patterns that may signal intervention needs and explain the reasoning in a small insight pack.