---
title: "Bell County Coop: SPED Status Reporting in Google Sheets"
canonical: "https://billerickson.com/case-studies/bell-county-coop-sped-status-reports/"
author: Bill Erickson
description: "A Bell County CEC case study: replacing fragile SPED spreadsheets with a guided Google Sheets app, Apps Script workflow, dashboards, and safer data entry."
categories: [Google Apps Script, Workflow design, Reporting dashboards, Google Drive integration]
---

## The problem

Bell County Cooperative for Exceptional Children is a special education shared services arrangement serving Bartlett ISD, Granger ISD, Holland ISD, Rogers ISD, and Troy ISD. Their team works across districts and campuses to support students with disabilities through evaluations, related services, IEP facilitation, instructional support, and family resources.

They needed a better way to manage SPED status reporting without moving sensitive student information into a separate third-party platform. Because FERPA governs student education records, the safest path was to improve the workflow inside the Google Apps for Education environment they already controlled.

The existing process depended on a shared Google Sheets spreadsheet. That kept the data in the right place, but the spreadsheet was not a good interface for daily staff updates. Required fields could be missed, formulas and structure could be damaged, and the SPED director had to spend time every day reviewing entries, filling gaps, correcting errors, and repairing the sheet.

## The solution

We turned the spreadsheet into the database behind a custom Google Sheets application built with Google Apps Script.

Staff no longer need to work directly in raw rows and columns. The app opens inside Google Sheets and guides them through new case intake, existing case updates, milestone tracking, document uploads, and required fields. Forms, buttons, dropdowns, validations, and quick actions match the SPED workflow while the protected backend sheets remain the source of truth.

The result is still a system Bell County CEC owns. Student data stays in Google Workspace, administrators can maintain districts, campuses, evaluators, service contacts, calendars, and settings, and staff get a safer way to do the work.

## What changed

- Guided workflows for new cases and existing case updates.
- Support for Initial and Re-evaluation SPED cases.
- Required-field visibility and validation before saving.
- District-aware due date calculations using instructional calendars.
- Automatic projected dates for response, consent planning, FIIE, and ARD milestones.
- Service-area tracking for psychology, OT, PT, counseling, FBA, speech, VI, DHH, and bilingual or language dominance needs.
- Google Drive upload and link management.
- Protected backend sheets for the database layer.
- Audit logging for creates, updates, document changes, archive actions, and communication actions.
- Dashboard views for overdue cases, due-soon cases, evaluator caseloads, district summaries, statuses, and workload trends.
- Optional Gmail draft and Google Calendar event tools for communication and deadline support.

## The outcome

Bell County CEC moved from a fragile shared spreadsheet to a purpose-built SPED status reporting app inside Google Sheets.

The workflow now matches how the team actually works. Staff get a clear, app-like experience for entering updates. Administrators keep protected access to the underlying data and can see active cases, deadlines, missing milestones, and workload patterns. The spreadsheet remains useful as the database because the app controls how data gets into it.

Most importantly, the solution improved the workflow without asking the organization to give up the privacy and ownership model they already trusted.