ICCT logo

Internal academy

ICCT Training Library

Data & Automation

Spreadsheet Analytics

Build practical spreadsheet fluency for tracking operations, validating entries, and producing quick summaries before deeper database work.

Beginner to Intermediate 3 credits 50+ guided hours 4 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. Build practical spreadsheet fluency for tracking operations, validating entries, and producing quick summaries before deeper database work.

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

Class mission

Reliable data entry

Minutes: 20

Big idea: Set up sheets so staff and students can use them without breaking structure. We keep it simple, hands-on, and easy to explain back.

10 min

Tables, validation, and protected zones

Spreadsheet means a grid of rows and columns used to organize and calculate information In this topic we use it for keeping sheets consistent for teams.

Quick picture: imagine using this in attendance workbooks.

Mission: use Spreadsheet to practice keeping sheets consistent for teams.

Spreadsheet Database Excel Tables, Validation,
10 min

Formatting that communicates status

Spreadsheet means a grid of rows and columns used to organize and calculate information In this topic we use it for conditional formatting, notes, and clean headings.

Quick picture: imagine using this in admissions trackers.

Mission: use Spreadsheet to practice conditional formatting, notes, and clean headings.

Spreadsheet Database Excel Formatting That

Word wall

Terms made easy

Spreadsheet

a grid of rows and columns used to organize and calculate information

Database

a place where information is stored in an organized way

Excel

a spreadsheet tool for tables, formulas, and charts

Tables, Validation,

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

Lab mission

Lab Mission

Create an attendance tracker workbook with drop-downs, protected areas, and late flags.

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

Homework: teach Spreadsheet in your own words, then create validated workbook 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

  • Organize structured sheets with validation rules and protected input areas.
  • Use formulas and lookups to support recurring operational work.
  • Prepare clear spreadsheet dashboards and exports for staff review.

Reference map

Core topics to cover

Structured tables Validation Conditional formatting Lookups Summaries Charts Export hygiene

Module sequence

ICCT lesson flow

Module 1

Reliable data entry

Lessons: 2

Set up sheets so staff and students can use them without breaking structure.

Tables, validation, and protected zones

keeping sheets consistent for teams

Formatting that communicates status

conditional formatting, notes, and clean headings

Checkpoint lab

Create an attendance tracker workbook with drop-downs, protected areas, and late flags.

Module 2

Formulas and lookups

Lessons: 2

Turn sheets into working tools instead of static lists.

Totals, conditions, and summary logic

counts, percentages, and status formulas

Lookups and linked sheets

matching IDs, pulling fields, and reducing duplicates

Checkpoint lab

Build a student follow-up workbook that links status, owner, and next action from multiple tabs.

Module 3

Reporting and handoff

Lessons: 2

Prepare spreadsheet outputs that are useful to decision-makers.

Dashboards and simple visuals

charts, summary blocks, and quick-read layouts

Export readiness and downstream use

clean columns, naming, and import-friendly formatting

Checkpoint lab

Create an admissions dashboard sheet with weekly trend summaries and export-ready detail tabs.

Capstone prompts

Projects students can actually ship

Admissions Dashboard Workbook

Track inquiry volume, follow-up dates, and conversion progress in a clean workbook.

Attendance Monitoring Sheet

Flag risk thresholds and create a one-page summary for advisors or coordinators.