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.