Skip to content

The IEP Season Pipeline: Process All Your Annual Reviews in Half the Time

For Occupational Therapists ·

Tools:Claude Projects + Google Sheets
Time to build:2 hours
Difficulty:Intermediate-Advanced
Prerequisites:Comfortable using Claude for IEP goal writing. See the Level 3 guide: "Survive IEP Season with an AI Writing Workflow."

What This Builds

A systematic pipeline that lets you process your entire IEP annual review caseload in a structured, repeatable workflow: batching students by review date, generating draft documentation for each in under 10 minutes, and tracking completion with a Google Sheet dashboard. School OTs managing 40-60+ students who adopt this pipeline typically complete their spring reviews 2-3 weeks earlier with significantly less burnout.

Prerequisites

  • Claude Pro ($20/month). Projects feature required for persistent assistant context
  • Google Sheets (free), for the student tracking dashboard
  • A list of all your students with their upcoming annual review dates
  • 2 hours to build the system before IEP season starts (build in January/February)

The Concept

The IEP pipeline turns a chaotic, deadline-driven process into an assembly line. Instead of each student's review being a one-off project you start from scratch, you process students in batches through a consistent workflow: collect data → generate draft documentation → review and edit → enter into IEP software → mark complete. The Claude Project serves as your consistent documentation engine, loaded with your district's standards, goal format preferences, and your own professional style, so the 5th student you process is just as easy as the first.


Build It Step by Step

Part 1: Create Your IEP Season Claude Project

Follow the Level 3 guide "Survive IEP Season with an AI Writing Workflow" to set up your basic Claude context. For this advanced version, add these enhancements to your Project Instructions:

Copy and paste this
## IEP Annual Review Pipeline Mode

When I say "Pipeline mode: [student name/ID]," I will provide a structured data form. Output three documents in this exact format:

--- DOCUMENT 1: PRESENT LEVEL OF PERFORMANCE ---
[3-4 sentences describing current performance in OT areas, written for IEP documentation]

--- DOCUMENT 2: ANNUAL GOALS ---
[2-4 goals in this format:
Goal [#]: Given [condition], [student] will [observable behavior] with [criteria] in [context] as measured by [method] by [annual review date].]

--- DOCUMENT 3: PROGRESS SUMMARY ---
[1-2 paragraphs summarizing progress on previous year's goals, appropriate for the Annual Review meeting]

After outputting these three documents, say "Ready for next student" so I know to proceed.

## My District's Goal Format Requirements
[Paste an example of a well-accepted goal from a previous IEP: this trains Claude on exactly what your district expects]

## Service Eligibility Language
When educational impact needs to be stated, always connect OT needs to: [describe your district's typical framing, e.g., "access to and participation in grade-level curriculum" or "school-based activities of daily living"]

Part 2: Build Your Student Data Dashboard

Create a Google Sheet with these tabs:

Tab 1: Master List

ColumnContent
Student IDYour initials system (e.g., JD-4)
GradeCurrent grade
DisabilitySpecial ed category
Review DateAnnual review due date
Days Until Review=DATEDIF(TODAY(), review date column, "D")
PriorityFormula: =IF(days<30, "URGENT", IF(days<60, "SOON", "OK"))
Draft StatusNot Started / Draft Generated / Reviewed / Entered
NotesAny special considerations

Tab 2: Student Data Forms For each student, maintain a form with the fields Claude needs:

  • Grade, disability, placement
  • Current performance observations
  • Previous goals
  • Progress on previous goals
  • Target areas for next year
  • Teacher/parent priorities

You'll fill these out as you see students in the weeks before review season. The more complete these forms are, the faster the Claude pipeline runs.


Part 3: Set Up the Processing Workflow

Once your Project and spreadsheet are ready, here's your session workflow during IEP season:

Monday Planning Session (15 minutes):

  1. Sort your spreadsheet by "Days Until Review"
  2. Identify students with reviews in the next 2 weeks
  3. Mark those as this week's batch

Processing Session (2-3 hours, 1-2 times/week):

  1. Open Claude to your IEP project
  2. Start with: "I'm starting an IEP season processing session. I'll give you 8 students to process."
  3. For each student, paste: "Pipeline mode: [Student ID]: [complete data form]"
  4. Claude produces all 3 documents → copy each into a temp document for review
  5. After each student: mark "Draft Generated" in your spreadsheet

Review Session (separate, not same session):

  1. Read each draft carefully for accuracy
  2. Edit anything that doesn't match the student's actual performance
  3. Mark "Reviewed" in spreadsheet

Entry Session:

  1. Copy approved text into your IEP software
  2. Mark "Entered" in spreadsheet

Part 4: Process Your First Batch

Let's test with your next 3 students. In your Claude Project:

Copy and paste this
I'm starting IEP season processing. I'll provide 3 students. Output all three documents for each student before moving to the next.

Pipeline mode (Student JD-4):
Grade: 4th
Disability: Autism Spectrum Disorder
Placement: General education with resource support
OT services: 30 min direct weekly
Current performance: [your data]
Previous goals: [list]
Progress: [describe]
Target areas: [describe]
Parent/teacher priorities: [any]
Annual review date: [date]

Review the output. Does it match your district's format? Adjust Project Instructions as needed.


Real Example: School OT with 48 Students

Setup: OT has 48 students, 22 with annual reviews in April and May. Without a system, this would mean 22 individual writing sessions totaling 12-15 hours of documentation during the school day.

With the pipeline:

  • Week 1 (Feb): Build spreadsheet, enter all student data forms during prep periods
  • Week 2-6 (Mar-Apr): Three processing sessions of 8 students each (90 min per session)
  • Each session: 22 minutes per student → 3 hours per session → all 22 students processed in 9 hours
  • Review sessions: 5 min per student → 2 hours total for all reviews
  • Entry into IEP software: 8 min per student → 3 hours total

Total time: ~14 hours (vs. 12-15 hours under the old system, but now spread over 6 weeks with no deadline crunch)

The real benefit isn't total hours. It's the elimination of the March/April documentation crisis.


What to Do When It Breaks

  • Claude's goals don't match district format → Paste 3 examples of perfect goals from previous IEPs into the Project Instructions; this is the fastest calibration method
  • PLOP language is too clinical for IEP document → Add to Instructions: "Write PLOP language that parents can easily understand. Avoid technical OT assessment terminology. Describe function in plain language"
  • Processing sessions take too long → Your student data forms are incomplete; the more complete the input, the faster the output
  • Goals are too challenging or too easy → Add specific guidance to your Instructions: "For students with [disability type], goals should focus on [approach]; typically achievable in [timeframe]"

Variations

  • Simpler version: Use the basic Level 3 workflow (no Project) but batch process 5 students per Claude session using the same session context
  • Extended version: Add a Zapier integration that emails you a reminder 45 days before each student's annual review date, automatically triggered by your Google Sheet's review date column

What to Do Next

  • January (before IEP season): Build the spreadsheet and Claude Project; run 2-3 test students
  • February: Complete all student data forms while seeing students; update forms as you collect data
  • March-April: Process reviews in weekly batches; aim to have all drafts complete 3 weeks before the last review date
  • May: After season, review what worked; update your Claude Project Instructions for next year

Advanced guide for occupational therapist professionals. Requires Claude Pro ($20/month) for Projects feature.