ICCT logo

Internal academy

ICCT Training Library

Data & Automation

Python Automation

Teach scripting for cleanup tasks, simple data transformation, reporting helpers, and repetitive internal workflows.

Beginner to Intermediate 3 credits 50+ guided hours 5 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. Teach scripting for cleanup tasks, simple data transformation, reporting helpers, and repetitive internal workflows.

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

Class mission

Core scripting habits

Minutes: 20

Big idea: Start with small programs that read clearly and solve one job well. We keep it simple, hands-on, and easy to explain back.

10 min

Variables, inputs, and reusable functions

Python means a language used for automation, data work, and many kinds of apps In this topic we use it for breaking work into simple steps.

Quick picture: imagine using this in roster cleanup.

Mission: use Python to practice breaking work into simple steps.

Python Automation Terminal Variables, Inputs,
10 min

Lists, dictionaries, and branching logic

Python means a language used for automation, data work, and many kinds of apps In this topic we use it for organizing records and handling cases.

Quick picture: imagine using this in reminder generation.

Mission: use Python to practice organizing records and handling cases.

Python Automation Terminal Lists, Dictionaries,

Word wall

Terms made easy

Python

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

Automation

making a computer repeat a task so people do less manual work

Terminal

the window where command-line work happens

Variables, Inputs,

one part of the lesson that helps students notice what the tool, page, or process is doing

Lab mission

Lab Mission

Write a script that groups students by completion status and prints clean summaries.

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

Homework: teach Python in your own words, then create cleanup script 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

  • Write readable scripts that process text, files, and structured data.
  • Use loops, functions, and data structures for routine automation tasks.
  • Generate reports or alerts from local exports and simple datasets.

Reference map

Core topics to cover

Variables Lists and dictionaries Functions Files CSV handling Conditionals Simple reporting

Module sequence

ICCT lesson flow

Module 1

Core scripting habits

Lessons: 2

Start with small programs that read clearly and solve one job well.

Variables, inputs, and reusable functions

breaking work into simple steps

Lists, dictionaries, and branching logic

organizing records and handling cases

Checkpoint lab

Write a script that groups students by completion status and prints clean summaries.

Module 2

Files and data cleanup

Lessons: 2

Use Python for repetitive operational tasks.

Reading and writing files

plain text, CSV input, and structured output

Cleaning inconsistent records

normalizing names, dates, and missing values

Checkpoint lab

Clean a CSV export of student records and output a normalized file for import review.

Module 3

Reporting and automation routines

Lessons: 2

Turn processed data into useful daily or weekly outputs.

Building summary reports

counts, totals, and meaningful messages

Planning repeatable scripts

inputs, outputs, logs, and handoff expectations

Checkpoint lab

Generate a weekly follow-up list for incomplete student onboarding steps.

Capstone prompts

Projects students can actually ship

Roster Cleanup Utility

Normalize names, emails, and expected completion dates from a messy export.

Reminder Generator

Create a script that outputs targeted follow-up messages for missing paperwork or unpaid tasks.