Classroom Management Spreadsheet
Category: Education / Teacher Resources
Give every student a fair turn, make groups and seating charts in seconds, and keep behavior and hall pass notes that add up, in one spreadsheet for Google Sheets and Excel.
Spend your class time teaching instead of juggling name sticks, sticky notes and a paper hall pass log. This classroom management spreadsheet gives every student a fair turn, builds new groups in seconds while keeping chosen pairs apart, and draws a fresh seating chart without the eraser. Behavior points and hall passes add up week by week, so parent meetings start with clear notes. It is a ready-to-use teacher toolkit for Google Sheets and Excel.
WHAT'S INCLUDED (1 ZIP download with 3 files)
• Quick Start Guide (PDF) with 2 Google Sheets make-a-copy links: Blank + Example
• Classroom Management Spreadsheet - Blank (.xlsx) for Excel
• Classroom Management Spreadsheet - Example (.xlsx) with a sample class of 28 students
• 10 tabs, up to 40 students per copy
INSIDE THE SPREADSHEET (10 tabs)
• Today - students present and absent, this week's behavior total, hall passes today, who is out right now, picker progress, this week's jobs, shout-outs and students to check in with.
• Setup - class name, first day of school, how names are shown, your behaviors and their points, hall pass places and alert limits, and up to 20 class jobs.
• Roster - paste the same student list you use in your planner or gradebook (up to 40). Type A for absent today and Y for a front seat. Each student's group, seat, job, behavior points and passes this week fill in.
• Name Picker - a fair, random order: nobody is picked twice until everyone present has had a turn. Type 1, 2, 3 and a big name appears for the projector. If an absent student comes up, it says so; just type the next number.
• Group Maker - random groups of 2, 3, 4 or 5 with balanced sizes, and a keep-apart list of up to 15 pairs: the tool tries 20 shuffles and keeps the first that separates every pair, and tells you if one is still together.
• Seating Chart - rows, paired rows, groups of 4, groups of 6, a U-shape or a double U. Random or manual, with names or seat numbers, front-seat students up front, and a seat list for a substitute.
• Behavior Log - date, student and behavior from lists; points fill in from Setup; add a note.
• Behavior Points - weekly plus, needs-work and net points, last week, trend, year total, last note, a 10-week heat map, shout-outs, check-ins and counts for each behavior.
• Hall Pass - time out, time back and minutes, pass number this week and alerts for students still out, long passes and frequent passes, plus a summary for every student.
• Class Jobs - jobs rotate every Monday by themselves, so everyone gets a job before anyone repeats. See this week and the next five.
WHY IT WORKS
• Random, but steady: a shuffle number decides the order, so results do not change while you type. New number, new shuffle.
• Works with your planner: copy the name column, paste, done.
• Clear at a glance: yellow cells are for typing, everything else is automatic.
• No add-ons, no macros, no sign-ups.
PERFECT FOR
• Elementary, middle and high school teachers
• The first week of school, group projects, class discussions and substitute days
• Teachers who want simple behavior and hall pass notes for parent meetings
HOW TO USE
1. Download the ZIP and open the Quick Start Guide.
2. Fill in Setup and paste your class list into the Roster (about 5 minutes).
3. Use the tools every day; Today keeps the overview.
HOW TO MAKE A COPY
1. Download the ZIP from Etsy and open the Quick Start Guide PDF.
2. Google Sheets: tap MAKE A COPY (Blank or Example) and click Make a copy. You need a free Google account; a computer or tablet is easiest.
3. Excel: open the Blank .xlsx file. Works in Excel 2010 or newer, Microsoft 365, Excel for Mac and Excel on the web.
PLEASE NOTE
• This is a digital download. No physical item will be shipped.
• Colors may look slightly different on different screens and printers.
• Designed by Printivora: an exclusive spreadsheet for our shop, built from our own original ideas and prompts, with the help of AI tools.
• For personal use by one teacher. Please do not resell or share the files or the make-a-copy links.
• Points, minutes and alerts are worked out from what you type. They are notes to help you, not official school records.
• Google Sheets is a trademark of Google LLC and Excel is a trademark of Microsoft Corporation. This spreadsheet is not affiliated with or endorsed by Google or Microsoft.
Questions before you buy? Send me a message on Etsy. I'm happy to help.