ICCT logo

Internal academy

ICCT Training Library

Data & Automation

Data Science with Python Lab

Use Python analysis libraries to clean data, explore patterns, build charts, and explain what the numbers mean to decision-makers.

Intermediate 3 credits 50+ guided hours 6 weeks Modules: 3 Projects: 2

Easy Interactive curriculum

Data Arcade for short, easy-to-digest learning

This course breaks big data & automation ideas into short missions, plain-language definitions, and interactive practice rounds. Use Python analysis libraries to clean data, explore patterns, build charts, and explain what the numbers mean to decision-makers.

Class missions: 3 10 minutes per topic Lab + quiz + homework + game

Class mission

Shaping messy data

Minutes: 20

Big idea: Turn incomplete or uneven records into something trustworthy enough to analyze. We keep it simple, hands-on, and easy to explain back.

10 min

Loading, inspecting, and cleaning data

Data Science means using data to ask questions, test ideas, and explain what is happening In this topic we use it for null handling, naming cleanup, and field normalization.

Quick picture: imagine using this in admissions funnel analysis.

Mission: use Data Science to practice null handling, naming cleanup, and field normalization.

Data Science Python NumPy Pandas
10 min

Filtering, sorting, and combining sources

Data Science means using data to ask questions, test ideas, and explain what is happening In this topic we use it for basic wrangling patterns for real reporting tasks.

Quick picture: imagine using this in attendance trend review.

Mission: use Data Science to practice basic wrangling patterns for real reporting tasks.

Data Science Python NumPy Pandas

Word wall

Terms made easy

Data Science

using data to ask questions, test ideas, and explain what is happening

Python

a language used for automation, data work, and many kinds of apps

NumPy

a Python tool for fast number arrays and math operations

Pandas

a Python tool for cleaning, grouping, and analyzing table data

Lab mission

Lab Mission

Clean and combine two school operations files into one analysis-ready table.

  1. Look at one example from admissions funnel analysis and point to where Data Science shows up.
  2. Build one tiny version that uses Data Science and Python in the right place.
  3. Tell a teacher or partner what you changed, what worked, and what you would improve next.
Homework

Homework: teach Data Science in your own words, then create notebook analysis with one example, one picture, or one tiny screenshot.

Quick quiz

Check understanding in a friendly way

Game mode

Term Match Sprint

Matches: 0 / 4

Match each word to the right meaning as fast as you can.

Words
Meanings

Pick a word, then pick the matching meaning.

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.