Data was everywhere, scattered across spreadsheets, screenshots, emails, assessment reports, and notes taken during counseling sessions. The team struggled to keep track of attendance check-ins, Response to Intervention (RTI) meetings, behavior huddles, and informal counseling conversations, all of which were happening simultaneously. When the student support team gathered to discuss a child, they found themselves stuck asking fundamental questions: What is actually happening for this student right now? What interventions have we already tried, and for what duration? Who is responsible for which task after this meeting, and did we ever follow up on the plan established last month? Over the last few years, the team has developed a much clearer and calmer system by utilizing shared spreadsheets, simple forms, and predictable routines.
Before implementing changes, the assistant principal brought the student support team together, including administrators, school counselors, psychologists, and a bilingual social worker supporting newcomers. While the team felt they had a solid problem-solving process for MTSS meetings—clarifying concerns, reviewing data, generating supports, choosing plans, and setting dates—they identified four specific pain points. First, there was no single picture of a student; attendance, grades, screener scores, discipline data, and staff observations were siloed in different locations, forcing every meeting to start with a scavenger hunt. Second, there were too many forms but insufficient clarity, with teachers filling out various referrals, sending emails, or raising issues informally. Third, meetings generated ideas but often lacked action, resulting in no clear owners, timelines, or central records. Finally, follow-ups relied on memory, meaning a next step could easily stall if a team member was out sick or overwhelmed by emails.
The team decided to redesign their workflow, starting with a Google Sheets spreadsheet to serve as the MTSS home base where everything links back and is searchable. They then created a “student snapshot” to provide a glanceable summary of necessary information, evolving from earlier experiments with “learner profiles” into a single, shared one-sheet Google Doc template. This template includes basic information like name, pronouns, grade, team, and primary language. It also covers context, such as Newcomer or SIFE status, IEP, 504, or ELL services, and key adult connections. Academic indicators include screening scores, recent grades, and progress monitoring, while behavior or SEL patterns are tracked over time. The snapshot lists interventions to date—specifying what, when, and for how long—along with attendance trends and a brief summary of the current concern. Every student discussed at the MTSS table has a snapshot displayed on the screen, which is updated live with new information and next steps. This approach drastically reduces side conversations and duplicate questions, and a link to the snapshot is added to the MTSS spreadsheet.
Related: Homework Benefits and Drawbacks Revealed in Six Charts
To address inconsistent referrals, the team replaced the old system of long emails, paper forms, and hallway mentions with a short digital referral form via Google Forms. Key fields include the area of concern—academic, behavior, attendance, or SEL—and a brief description in the teacher’s own words. Teachers must list strategies already tried in the classroom and provide relevant context, such as recent moves, caregiving responsibilities, or language considerations. Form responses automatically populate the shared MTSS spreadsheet, allowing the team to filter by grade, content area, or concern type. This capability enables the team to prioritize students for the next meeting and spot patterns. Teachers appreciate the system because it saves time and eliminates excessive back-and-forth emails.
Each grade level has a scheduled 45-to-60-minute problem-solving block attended by an assistant principal, grade-level counselor, psychologist, teachers, and a bilingual social worker or community liaison. The meeting flow begins in the shared spreadsheet, where the team filters for students on the day’s agenda to see the same history of referrals and follow-ups. They then open the student snapshot to highlight trends, such as attendance dipping in November or reading scores remaining flat despite intervention. The team runs the problem-solving process within a defined time limit, clarifying concerns, reviewing data, brainstorming, selecting supports, and defining success for four to six weeks out. Decisions are recorded in real time into the snapshot and spreadsheet, specifying actions, responsible team members, and check-in dates. Before moving to the next student, the team asks, “Is it clear who is doing what, and by when?” to ensure accountability.
To prevent plans from drifting, the spreadsheet is connected to calendar and email routines. Recurring meeting invites include the link to the shared sheet, and a summary email with bullets and a link to the updated sheet is sent after each meeting. The spreadsheet tracks “Check-in date,” “Status,” and “Outcome.” With these simplified tools, MTSS meetings focus less on paperwork and more on understanding students. For schools struggling with similar overwhelm, the process does not require a total rebuild. Starting small is effective: choose one grade level to pilot, create a one-screen student snapshot template, build a digital referral form feeding into a shared sheet, run meetings where the sheet serves as the agenda, and ask the team to identify what helps versus what feels like busywork.
