top of page

Streamlining MTSS Data Interpretation: How to Build Custom Grade-Level Benchmark Sheets in Minutes with NotebookLM

Writer: Chris Birr
Chris Birr
Oct 16
6 min read

In my prior life, I would often say, "If I ruled the MTSS world, I would do X." As districts update MTSS frameworks and adopt new measures (new to them, at least), there can be confusion and lack of efficiency. One of the things I found most useful was to outline data-based decision-making guidelines for K-8 (high school is often Tier 1 and Tier 3- stole that; didn't make it up). Then, make a master doc and then grade-level docs. Teams benefit from seeing the whole continuum of data and then their grade level.


In recent conversations with school professionals, instructional coaches, and MTSS coordinators, a common operational challenge keeps resurfacing: How can we make screening data immediately actionable for grade-level teams and classroom teachers during data meetings?


When triaging student needs during Fall, Winter, or Spring screening windows—whether analyzing NWEA MAP Growth or other universal screeners, teachers are often forced to juggle multiple massive normative tables, state linkage studies, and local diagnostic policy documents just to figure out where a student stands. Or, they have a new assessment and parent-teacher conferences a week after data comes in.


To solve this, many teams use 1-Page Grade-Level Reference Sheets. These quick-reference frameworks consolidate performance tiers, state projections, diagnostic benchmarks, and growth norms into a single sheet per grade level (K-8).


In this post, I’m sharing a complete, generic Reference Sheet Shell alongside a step-by-step workflow using NotebookLM so you can generate tailored reference sheets for your district in minutes. Plus, we'll discuss how incorporating Program Evaluation concepts ensures your decision rules and cut scores remain grounded in real impact.


Why Quick-Reference Benchmark Sheets Matter in MTSS

During Professional Learning Community (PLC) or MTSS team meetings, time is extremely limited. Teachers shouldn't have to spend 15 minutes cross-referencing multi-page norm tables to determine if a student is "On Track."

Having a standardized 1-page reference sheet for each grade level allows teams to:

  • Efficiently Triage Student Data: Quickly locate percentile ranks (10th, 25th, 35th, 50th, and 90th) and projected state performance across Fall, Winter, and Spring.

  • Maintain Standardized Decision-Making: Ensure every team across a school or district uses the exact same operational criteria for intervention placement or screening flags.

  • Account for Standard Error: Remind staff that score cutoffs are guidelines for baseline hypotheses, not rigid rules, by explicitly building in measurement boundaries (e.g.,+ or - 3 points).


While MAP Growth is used as the primary illustration in this template, this exact shell and workflow can be adapted for any universal screening or progress monitoring assessment (e.g., i-Ready, FastBridge, STAR, DIBELS).


Establishing Data-Based Cut Scores via Program Evaluation

When defining cut scores or diagnostic thresholds on your reference sheets, it is vital to avoid arbitrarily setting intervention triggers without evaluating their real-world impact.

By applying a Program Evaluation framework to your MTSS data infrastructure, you can ground your decision-making cut scores in true efficacy:

  1. Evaluate Historical Efficacy: Rather than blindly following vendor default cuts, analyze past intervention outcomes. Did students placed below a specific benchmark cut score actually demonstrate growth when receiving Tier 2 or Tier 3 support?

  2. Refine Intervention Cut Points: Use program evaluation findings to validate or adjust your "On Track" vs. "Not On Track" thresholds. If data reveals that students at the 30th percentile struggle just as much on state summative tests as those at the 25th, your local cut score should reflect that reality.

  3. Monitor System Capacity & Need: Program evaluation helps balance system resources with student risk levels, ensuring teams deploy targeted interventions where they produce the highest measurable impact.


How to Auto-Generate Custom Sheets Using NotebookLM

Rather than manually transferring dozens of numbers from dense PDF reports into tables, you can use NotebookLM (Google’s free AI research assistant) to automate the process accurately.


NOTE: If I ruled the world, I'd set up my initial cut points in this way:

  • 10th (monitor these students weekly if they aren't already in an intensive intervention.)

  • 35th but give or take 3 points- use ORF in Grades 1-3 to verify and see if there is an accuracy, automaticity, or both issue in reading. Do these students need intervention - includes your students on RIMPs (looking at you Ohio)

  • 50th for each season for context.

  • State proficiency target (PLC target)

  • 95th to alert for students who might benefit from enrichment.

    • Disclaimer: This model creates a space between what might be an intervention cut and proficiency. Students in interventions would be monitored using CBM and those who are just below proficient, could be flexibly grouped and classroom assessments could be used in short-cycle PLC-type monitoring. Again, if I ruled the world and had time to dig into all that.


Step 1: Set Up Your Research Notebook

  1. Navigate to NotebookLM and create a new notebook named "Grade-Level Benchmark Generator".

  2. Upload your source reference documents into the notebook:

    • Publisher Norms Document (e.g., NWEA MAP Growth Normative Data Study).

    • State Linkage / Alignment Study (e.g., Linking Assessment Scores to State Summative Assessments).

    • District/State Policy Mandates (e.g., Early Literacy/Math Diagnostic rules, local intervention cut points).

Step 2: Run the Extraction Prompt (I cheated and AI wrote this part-it's the weekend...)

Copy and paste the prompt below into the NotebookLM chat window for each target grade level (K-8), replacing [Grade Level] and [Target State/District]:

NotebookLM Extraction Prompt: "Using only the provided source documents, extract the data required to populate the following template for [Grade Level, e.g., Grade 3] in [Target State / District].Format the output exactly using Markdown tables as specified:Header: Title, Subtitle, and Measurement & Decision-Making Guidance statement including standard error of measurement (±3 RIT) and guidelines on interpreting score cutoffs.Subject Performance Tiers (Math & Reading):Extract 10th, 25th, 35th, 50th (Median), and 95th percentile RIT scores for Fall, Winter, and Spring.Extract state-aligned proficiency projection cut scores for Fall, Winter, and Spring (or mark with an asterisk if estimated).Statutory & Universal Screening Benchmarks:Extract required state or district early literacy and math diagnostic thresholds (On Track vs. Not On Track).Provide concise operational notes outlining compliance requirements without district-specific names.Mean Seasonal Growth Norms:Extract average expected RIT growth for Fall-to-Winter and Fall-to-Spring for both subject areas.High School / Competency Benchmarks (if applicable for Grades 7–8):Extract course-placement or graduation-seal predictive cut scores."

Step 3: Verify and Export

  1. Cross-check the generated RIT scores and percentile ranks against your published publisher norm tables.

  2. Ensure statutory timelines and local operational notes reflect your district's specific evaluation policies.

  3. Copy the formatted text into Word, Google Docs, or your district's resource repository.

Generic Grade-Level Reference Sheet Shell

Below is the customizable shell template. You can copy this structure directly into your local formatting workflow.

[GRADE LEVEL] MAP GROWTH REFERENCE SHEET

A 1-Page Reference to Support Efficient Data Interpretation for Teams

Measurement & Decision-Making Guidance: For all RIT scores, consider using a plus or minus three points ($\pm3$ RIT) margin of error (standard error of measurement). Score cutoffs and percentile thresholds are guidelines or initial hypotheses for team discussion, not rigid or absolute rules.

[GRADE LEVEL] Mathematics Performance Tiers [Year Norms & State Projections]

Season

10th% RIT

25th% RIT

35th% RIT

50th% RIT (Median)

State-Aligned Proficiency Projection

95th% RIT

Fall

[RIT]

[RIT]

[RIT]

[RIT]

[RIT]*

[RIT]

Winter

[RIT]

[RIT]

[RIT]

[RIT]

[RIT]*

[RIT]

Spring

[RIT]

[RIT]

[RIT]

[RIT]

[RIT]*

[RIT]

  • State Mathematics Universal Screener / Diagnostic: On Track = [RIT]+ | Not On Track = [RIT] or below

  • Operational Note: [Insert statutory or state-mandated screening requirement/timeline, e.g., "State guidelines require administering a math universal screener by the fall deadline to measure readiness for grade-level content."].

  • [*Optional Note on Projections, e.g., "Early grade proficiency projections are estimated by working backward from benchmark models and are provided for planning purposes."].

[GRADE LEVEL] Reading Performance Tiers [Year Norms & State Projections]

Season

10th% RIT

25th% RIT

35th% RIT

50th% RIT (Median)

State-Aligned Proficiency Projection

95th% RIT

Fall

[RIT]

[RIT]

[RIT]

[RIT]

[RIT]*

[RIT]

Winter

[RIT]

[RIT]

[RIT]

[RIT]

[RIT]*

[RIT]

Spring

[RIT]

[RIT]

[RIT]

[RIT]

[RIT]*

[RIT]

  • Early Literacy / Reading Diagnostic Benchmark: On Track = [RIT]+ | Not On Track = [RIT] or below

  • Operational Note: [Insert statutory reading requirements, e.g., "Students scoring Not On Track on the fall reading diagnostic must receive an individualized improvement plan within required state timelines."].

  • [*Optional Note on Promotion Cutoff, e.g., "Note: State promotion requirements and proficiency projections represent distinct constructs; verify local promotion policies."].

[GRADE LEVEL] Mean Seasonal Growth Norms [Publisher Growth Standards]

Expected Growth Benchmarks:

  • Mathematics Average Growth: Fall-to-Winter = [X.XX] RIT | Fall-to-Spring = [X.XX] RIT

  • Reading Average Growth: Fall-to-Winter = [X.XX] RIT | Fall-to-Spring = [X.XX] RIT

[OPTIONAL: Grades 7–8 Secondary / Course Benchmarks]

  • High School Course & Competency Benchmarks: On Track for Algebra 1 Proficiency = [RIT] ([Percentile]th percentile). Graduation Competency Benchmark = [RIT] ([Percentile]th percentile).

Next Steps for Your District

Creating clear, accessible data tools is one of the fastest ways to improve team decision-making during MTSS reviews.

  • Try the Workflow: Upload your state's normative and alignment documents into NotebookLM and test the prompt above.

  • Evaluate Your Cut Scores: Review your district's intervention entry/exit criteria against historical student outcome data to ensure your benchmarks are driving real progress.

If you need support establishing data-based decision-making frameworks or evaluating program impact across your MTSS infrastructure, shoot me an email, happy to help.

 
 
 

Recent Posts

See All
Hierarchy of Learning and MTSS

TARGETING INTERVENTION: THE INSTRUCTIONAL HIERARCHY IN PRACTICE PURPOSE Teams often have structures in place for an MTSS framework. But, targeting intervention and matching student need can be a barri

 
 
 
What is our real influence?

There’s a lot of talk right now, especially on LinkedIn, about how educators should use their influence to challenge systems, change curriculum or teaching methods, and advocate for change. I’m glad p

 
 
 
Is Humor Underrated?

The other day, I was talking to an early career professional who shared how they were with a new group and cracked a few jokes that did not land. I nodded. I have vast experience with jokes that do no

 
 
 

Comments


CONNECTEDMTSS

Chris Birr, Ed.D.

birrchr@gmail.com | LinkedIn

​

​

​

cmtss logo.png

The views, frameworks, and content expressed on ConnectedMTSS are solely those of Dr. Chris Birr and do not represent the official positions, policies, or endorsements of any public school district, educational agency, or employer.

​

© 2026 ConnectedMTSS. All rights reserved.

bottom of page