Use NotebookLM to Analyze Data and Design Interventions

Part 3 of the AI for ELA Teachers Series

This is the moment where AI stops being “interesting” and starts being life-changing.

Up until now, we’ve:

Exported student writing and used Brisk to give rubric-based feedback
Organized everything by in Google NotebookLM
Generated suggested holistic scores

But this is the step that actually changes how I plan instruction.

Instead of guessing:

“Who needs help with reasoning?”
“Should I reteach introductions or conclusions?”
“How do I group kids without rereading everything?”

…I just ask NotebookLM.

Here’s exactly how I do it — and how you can, too.

What NotebookLM Can Do at This Stage

Once your notebook contains:

Student writing (with feedback)
Your rubric
Suggested scores

NotebookLM can:

Create teacher-ready spreadsheets
Summarize student strengths
Identify class-wide trends
Recommend small groups
Suggest mini-lessons
Track growth over time (by genre!)

And yes — it really is that helpful.

Step 1: Ask NotebookLM to Create a Spreadsheet

Start with this prompt… it’s quick and simple:

“Create a spreadsheet with the following columns: student name, holistic score, a short summary of what the student did well, and three specific tips for improving next time.”

NotebookLM will generate:

A clean table
Clear, student-friendly language
Feedback aligned to your rubric

You can then:

Copy/paste into Google Sheets
Download as a CSV
Use it for conferences, grading, or planning

**Spreadsheets are perfect for mail-merging or using the Bulk Create feature in Canva. However, if that seems like too much, you can just use this prompt: “Create a feedback report with the following information: student name, holistic score, a short summary of what the student did well, and three specific tips for improving next time.” Then you can copy and paste in the information it gives you into a Google or Word Doc and print a report for each student.

Step 2: Use Canva Bulk Create to Turn Data into Feedback Forms

This step is TOTALLY OPTIONAL!! As I said, you can just ask NotebookLM to provide a list of the information that you can copy and paste into a Doc or Word Doc and create a feedback “page” to give to each student. But Bulk Create is one of my favorite features in Canva and it is definitely one of my favorite teacher hacks.

Once you have the spreadsheet:

Open Canva.
Create a simple feedback form template or download mine to use:
- Student name
- Score
- “What you did well”
- “Next steps”
Use Bulk Create to auto-generate a personalized feedback page for every student.

Now students get:

Consistent feedback
Clear next steps
A format they actually read

And you didn’t type it 120 times.

Step 3: Identify Class-Wide Writing Trends

Now comes the instructional gold.

Try prompts like:

“What are the most common strengths across this class?”
“What skills are students struggling with the most?”
“Which rubric categories show the weakest performance overall?”

NotebookLM will summarize patterns such as:

Weak reasoning in CER
Strong ideas but poor organization
Voice improving, conventions lagging

This replaces:

Sticky-note guessing
Spreadsheet sorting
Re-reading every essay

Step 4: Create Small Groups Automatically

This prompt saves me hours:

“Group students by similar writing needs and suggest the focus skill for each group.”

NotebookLM will:

Create logical groupings
Explain why students are grouped together
Align groups directly to rubric categories

Example groups:

Group 1: Evidence selection
Group 2: Organization & flow
Group 3: Elaboration & detail

You now have purposeful small groups, not random ones.

Step 5: Ask for Mini-Lesson Ideas

Once groups are identified, ask:

“Suggest short mini-lesson ideas for each group based on their needs.”

NotebookLM will generate:

Skill-specific lesson ideas
Clear teaching focuses
Language you can adapt for slides or anchor charts

This is where planning becomes reactive to student needs instead of generic.

Step 6: Reuse the Notebook All Year

Because you created one notebook per genre, you can:

Add new writing pieces later
Ask for growth over time
Compare early vs. late assignments
Bring real data to team meetings
Walk into conferences confident and prepared

Your notebook becomes a living record of student growth.

NOTE: The free version of NotebookLM will only support 50 sources at a time. But, there are some workarounds so that you can find trends over time and across multiple assignments, without buying the pro version. What I like to do is create a new NotebookLM for each class period and upload the spreadsheets of scores and feedback from each assignment. Then I can give NotebookLM the following prompt to track trends over time: “Look at the feedback from (name your assignments) and tell me about the growth patterns for each student.”

Why This Workflow Actually Works

AI didn’t replace:

Your rubric
Your feedback
Your judgment

It replaced:

Repetitive typing
Manual sorting
Guesswork
Late-night grading spirals

You’re still the expert. You just finally have help.

Download the Print-and-Go NotebookLM Setup Guide

Download the 1-page Quickstart Sheet to Analyze Data and Design Interventions ⬇️