IEP Insight Icon
Official How-To Guide

Complete How-To Guide: IEP Insight for Google Sheets

IEP Insight transforms Google Sheets into a fast, professional, and FERPA/HIPAA-compliant Special Education progress monitoring system. It replaces clunky binder logs, scattered papers, and rigid enterprise software with an intuitive, automated application that lives entirely inside your secure Google Drive.

🎓
Caseload Creation Wizard

Build and edit student caseloads quickly using a guided step-by-step interactive wizard.

📝
Rapid Digital Logbook

Track quantitative and qualitative probe data in seconds with instant validation.

📊
Visual Progress Reports

Generate visual reports complete with goal mastery gauges, trendlines, and print-ready parent summaries.

🗄️
Multi-Year Archiving

Archive historical school years to keep active sheets clean while preserving complete compliance audit trails.

100% Free Forever for 1–3 Students
No license key or upfront purchase required to run setup or track your first 3 students. Upgrade to Pro ($30/year or $2.50/month) only when expanding your caseload to 4 or more students.
Section 1

1. Initial Installation & First-Time Setup

Step 1 Open Your Template or Install the Add-On

Open your copy of the IEP Insight spreadsheet template or install the add-on from Google Workspace Marketplace. Once loaded, the custom menu IEP Insight will automatically appear under Extensions in your Google Sheets top navigation bar.

Step 2 One-Time Google Authorization

Because IEP Insight manages data across your tabs, Google requires a standard one-time permissions grant:

  1. Click IEP Insight in the top menu and select Setup IEP Insight (or open the Homepage / Quick Guide).
  2. A Google dialog will appear stating: "Authorization Required". Click Continue.
  3. Select your Google Workspace or personal Google account.
  4. Review the requested spreadsheet permissions and click Allow All.
Step 3 Run the Automated Setup

From the top menu, select Extensions > IEP Insight > Setup IEP Insight. The script automatically creates and organizes all database tabs in the correct order:

  • Homepage — Your central dashboard & privacy shield
  • Students — Active caseload roster & review dates
  • IEPGoals — Mastery targets and benchmark criteria
  • IEPProgress — Raw measurement logbook database
  • Progress Reports — Saved narrative summaries
  • Teachers / Settings — User preferences and Pro licensing

✨ Once initialized, the Caseload Creation Wizard launches automatically so you can add your first student immediately!

Section 3

Step 1: Setting Up & Managing Your Caseload

To add a student to your caseload, select IEP Insight > Caseload Creation Wizard (or click Caseload Wizard from the pinned sidebar).

IEP Insight Caseload Creation Wizard Screen 1
Figure 2: Caseload Creation Wizard — Screen 1: Student Information.

Screen 1: Student Information

  • Student Name / Identifier: Enter the student’s name, initials, or student ID (e.g., Jordan M. or Student 104).
  • IEP Start Date: The date the current IEP cycle began.
  • Annual Review Date: The annual meeting or expiration date.
  • Status: Select Active (default) or Inactive.
  • Click Next: Goals & Benchmarks →.

Screen 2: Goals & Objectives

Every student must have at least one goal. Click Add Another Goal to track multiple annual goals (e.g., Reading Fluency, Math Calculation, On-Task Behavior).

Adding a Goal and Benchmarks in IEP Insight
Figure 3: Caseload Wizard — Configuring Goal Mastery Criteria and Short-Term Benchmarks.

For each goal, specify:

  1. Goal Short Name / Area: A concise descriptor used in dropdowns and chart titles (e.g., Reading Fluency or Task Initiation).
  2. Full IEP Goal Description: The verbatim annual goal text from the student's IEP document.
  3. Mastery Criteria Toggle:
    • Keep "Require Goal Mastery Criteria" checked if the goal is measured directly with numeric probe trials.
    • Uncheck it if the goal uses Benchmark-Driven Mastery (where the annual goal is considered met once all of its short-term objectives are met).

Measurement Types & Mastery Criteria

IEP Insight supports four flexible measurement models tailored to modern IEP goals:

Measurement Type Common IEP Examples Target Value Example
Percentage (%) Accuracy on comprehension probes, math worksheet accuracy 80 (representing 80%)
Numerical / Frequency Correct words per minute (WPM), discrete behavioral counts 115 (words/min) or 3 (reminders)
Duration (Minutes) Sustained attention, independent reading time, latency 20 (minutes on task)
Rubric / Score Writing scale (1–4), social interaction rating rubric 4 (score on rubric)

Defining Consecutive Trials

Set your exact threshold for mastery consistency:

  • Trials Required: How many successful probes are needed (e.g., 4).
  • Out of Total Trials: The consecutive trial evaluation window (e.g., 5).
  • Resulting Rule: The goal will be automatically flagged as Met when the student achieves the target score in 4 of 5 consecutive probes.

Adding Short-Term Objectives / Benchmarks

If an IEP goal includes intermediate milestones, click Add Benchmark under that goal card:

  • Assign a benchmark code (e.g., Obj 1.1, Benchmark A).
  • Enter the objective description.
  • Set an individual target value and required trials specific to that benchmark (e.g., Target: 60% for Marking Period 1, advancing to 80% on the overall annual goal).

Screen 3: Review & Save

  1. Click Next: Review & Confirm → to inspect the summary of your student's profile.
  2. Choose your save action:
    • Save & Add Next Student: Commits the student to your sheet and clears the form for the next student.
    • Save & Finish: Commits the student and closes the wizard.
Editing Caseloads & Renaming Students Safely

Important Rule: Never manually edit or delete rows inside the raw IEPGoals or Students sheets. Manual spreadsheet changes can break relational IDs and historical links.

Always use the built-in Edit Mode:

  1. Open IEP Insight > Edit Caseload & Goals (or switch to Edit Existing Student inside the wizard).
  2. Choose the student from the Select Student to Edit dropdown.
  3. The wizard automatically loads all existing annual targets, trial settings, and benchmarks.
  4. Renaming a Student: If you edit the student's name in the form, IEP Insight automatically executes a synchronized update across all sheets (Students, IEPGoals, IEPProgress, and Progress Reports), preserving every single historical data point!
  5. Click Save Changes to Caseload.
Section 4

Step 2: Recording Probe Measurements (The Logbook)

The Digital Logbook is your daily/weekly data collection tool. It is engineered for ultra-fast, friction-free data entry on laptops, Chromebooks, iPads, or interactive classroom panels.

📱 Note on Mobile & Tablet Devices: If accessing IEP Insight on a tablet or phone (iPad/iOS or Android), you must open the spreadsheet through a mobile web browser (Chrome or Safari). The native mobile Google Sheets app does not launch Workspace Apps Script add-ons.

How to Record a Probe Measurement:

  1. Open IEP Insight > Open Logbook (or click Open Logbook in the sidebar).
  2. Select Student: Choose your student from the dropdown.
  3. Select Goal: The goal dropdown dynamically updates with only the active goals assigned to that student.
  4. Select Benchmark:
    • Choose "Overall Goal (Annual Target)" to record a probe toward the annual target.
    • Or select a specific quarterly benchmark objective.
  5. Enter Measurement: Type the raw numerical score (e.g., 82 for 82%, 110 for words per minute, 15 for minutes).
  6. Enter Observation Notes (Optional): Add qualitative context (e.g., "Prompting required on question 3", "Completed independently with noise-cancelling headphones").
  7. Click Record Measurement.
IEP Insight Rapid Logbook Modal
Figure 4: Rapid Logbook with cascading dropdowns, numeric entry, and qualitative teacher observation notes.
Instant Validation & Automated Logging

The logbook checks your values, displays a green confirmation badge, records the exact timestamp and teacher email in the background IEPProgress sheet, and resets the input field ready for your next entry in under one second.

Section 5

Step 3: Generating Visual Progress Reports & PDFs

When it's time for quarterly progress updates, annual reviews, or parent-teacher conferences, IEP Insight creates presentation-grade visual reports.

Interactive Report Dashboard

  1. Open IEP Insight > Open IEP Report (or click IEP Report in the sidebar).
  2. Select your student from the Select Student dropdown.
  3. The report immediately compiles all longitudinal data into high-impact interactive visuals:
IEP Insight Visual Goal Report
Figure 5: Annual Goal Report featuring mastery doughnut chart, longitudinal trendline, trial progress bar, and history table.

What Each Section Displays:

Goal Mastery Doughnut Chart:

Shows the cumulative percentage and ratio of goals currently marked as Met vs. In Progress.

Longitudinal Progress Line Charts:

Plots every historical probe over time. A dashed horizontal line indicates the IEP target score, while the linear trendline illustrates the student's true growth trajectory.

Trial Mastery Progress Bar:

Evaluates the most recent probe window against your consecutive trial rule (e.g., 3 of 4 Trials Met). When the threshold is reached, the badge turns vibrant green and updates the goal to Met.

Measurement History Table:

Complete chronological table listing probe dates, scores, benchmark identifiers, and teacher observation notes.

IEP Insight Benchmark Level Report
Figure 6: Granular Benchmark Report displaying intermediate objective milestones and targeted trendlines.

Adding & Saving Teacher Narratives

IEP Insight lets you write and store formal quarterly summaries directly within the interactive report window:

  1. Scroll to the Teacher Narrative Comments section beneath any goal card.
  2. Type your qualitative evaluation or meeting comments.
  3. Click the green Save / Load Comments button at the top of the report.
  4. Your notes are saved to the Progress Reports database tab with a timestamp. The next time you open this student's report, your saved notes load automatically.
Benchmark Report with Saved Teacher Narrative Comments
Figure 7: Visual Progress Report showing integrated qualitative teacher narratives and saved timestamped notes.

One-Click Printing & PDF Export

IEP Insight features built-in print CSS engineered specifically for clean distribution to parents and IEP teams:

  1. In the IEP Report window, click the blue Print / Save PDF button.
  2. Your browser’s native print dialog will open:
    • Destination: Select Save as PDF or choose your printer.
    • Layout: Portrait.
    • Paper Size: Letter (8.5" × 11").
    • Margins: Default.
  3. Optimized Print Styling: The tool automatically strips out sidebars, action buttons, and scrollbars, resizing charts into high-resolution vector graphics and formatting cards so they fit neatly across pages without awkward breaks.
Optimized Print to PDF Preview in IEP Insight
Figure 8: Printer-optimized letter format stripping UI chrome for clean, professional PDF distribution.
Section 6

Step 4: Year-End Rollover & Multi-Year Archiving

At the end of a school year, special educators often struggle with managing bloated spreadsheets or losing historical data. IEP Insight includes a dedicated Year-End Archiving engine that keeps your spreadsheet lightweight while maintaining a 100% compliant audit trail.

How to Archive a Completed School Year:

  1. Select IEP Insight > Archive & Start New Year from the top menu.
  2. Enter a school year label when prompted (e.g., 2025-2026 or 2026-2027).
  3. Click OK, then review and confirm the dialog.

What the Archiving Process Does Automatically:

  • Copies all data from Students, IEPGoals, IEPProgress, and Progress Reports into dedicated archive sheets (e.g., Archive_Students_2025-2026).
  • Applies formatting protections and automatically hides the archive sheets to keep your tab bar clean.
  • Clears the active sheets so you can enter your new caseload from a completely clean slate.

Viewing Past Archived Years

You never lose access to historical records:

  • In Google Sheets: Select IEP Insight > View Past Archives or right-click any sheet tab and choose Show sheet to inspect historical data directly.
  • In the IEP Report Viewer: Open IEP Insight > Open IEP Report. Use the Year dropdown at the top of the screen to switch between the Current Year and any previously archived year. All charts, graphs, and teacher narratives from previous years will render on demand!
Section 7

7. Understanding Your Spreadsheet Tabs

IEP Insight organizes your caseload into specialized database tabs. The Homepage serves as your mission control and screen-sharing privacy shield:

IEP Insight Homepage Dashboard Tab
Figure 9: Homepage Navigation Dashboard with compliance badges, feature shortcuts, and setup status.
Tab Name Purpose How It Is Managed
🏠 Homepage Central navigation board, quick roadmap, compliance badges, and licensing overview. Acts as a privacy shield when projecting. Protected reference hub. Do not delete.
🎓 Students Roster of active students, IEP start dates, and annual review dates. Managed automatically by the Caseload Wizard.
🎯 IEPGoals Stores annual goal descriptions, measurement types, mastery targets, and benchmark criteria. Managed automatically by the Caseload Wizard.
📈 IEPProgress The central database of all timestamped probe measurements and qualitative teacher observation notes. Logged automatically through the Logbook.
📄 Progress Reports Saved quarterly summaries, meeting notes, and formal teacher narratives. Managed automatically by the Report Viewer.
⚙️ Settings Stores user email permissions, active configurations, and Pro license key. Managed via Setup and License dialogs.
⚠️ Best Practice Rule: Never manually delete columns, rename headers, or re-order columns in the database sheets. The automated scripts rely on this schema to calculate progress metrics and chart trendlines accurately.
Section 8

8. Free vs. Pro Plans & License Activation

Every feature of IEP Insight is available on the Free Tier for your first 3 students. Upgrading to Pro removes caseload restrictions:

Feature Free Plan Pro Plan
Caseload Capacity Up to 3 Students Unlimited Students
Goal Tracking & Benchmarks Unlimited Goals Unlimited Goals
Logbook Data Collection Unlimited Probes Unlimited Probes
Visual Charts & Trendlines Included Included
PDF Progress Reports Included Included
Year-End Multi-Year Archiving Included Included
Pricing Free Forever $30 / Year ($2.50/mo)

How to Activate Your Pro License:

  1. Purchase a license key from SmartClassScripts on Gumroad.
  2. In your spreadsheet top menu, click IEP Insight > Enter License Key.
  3. Paste your license key into the prompt and click Verify & Activate.
  4. The system validates your key and immediately unlocks unlimited caseload capacity across your spreadsheet.
Section 9

9. Frequently Asked Questions & Troubleshooting

Yes. Unlike third-party SaaS cloud platforms where student records are hosted on external vendor servers, IEP Insight operates 100% within your school Google Drive account. No student names, goals, or probe scores are ever shared or transmitted externally.
Simply refresh your browser tab (or close and re-open the spreadsheet). When Google Sheets finishes loading, Google Apps Script will automatically restore the custom menu under Extensions.

Free Tier Access (Included): Anyone you share the sheet with (as an Editor) can open the Logbook and record probes, operating under the Free Plan (limited to your first 3 students).

Pro Tier Access (Requires Additional License): For colleagues or co-teachers to access, view, and log data across your entire unlimited caseload, they must have their own Pro license key activated under their school Google email address.

Open IEP Insight > Edit Caseload & Goals. Select the student from the dropdown, make your edits, and save. The tool automatically propagates the updated name or target across all related sheets without breaking your historical progress logs.
Yes. When accessing your sheet via Chrome or Safari on an iPad or tablet, open the Logbook or IEP Report modal. The responsive design adapts seamlessly for touch controls and quick classroom logging.

Ready to Transform Your Caseload Tracking?

Install IEP Insight from the Google Workspace Marketplace today. 100% free forever for up to 3 students — no credit card required.