Teacher Planner Spreadsheet — Automatic Gradebook, Attendance & Lesson Planner

Imagine opening one spreadsheet and seeing your entire classroom already organized.

Your students, your grades, your attendance, your lesson plans, your important dates — all connected, all calculating for you, all in one beautiful digital teacher planner.

You already know the Sunday feeling: papers everywhere, a gradebook that never adds up, and a grade report due by 5 PM. As you set up this planner, something shifts — the moment you type a student's name once, it flows into your gradebook, your attendance sheet, everywhere it needs to go. You never type it again.

That's because this isn't a stack of printable pages. It's a fully automated Teacher Planner System built by Gram and Me Printables, with real formulas working behind every tab.

What's inside your Teacher Planner Spreadsheet

• Class Setup — Enter your class info and grading category weights once (homework, quizzes, tests, projects, participation). The whole system follows your rules.
• Student Roster — Names, IDs, guardian contacts, birthdays, and notes in one place. Type each student once and watch every other tab fill itself in.
• Assignment Tracker — Log assignments with points, due dates, and status dropdowns. A live "days until due" countdown keeps you ahead of every deadline.
• Automatic Gradebook — This is where teachers fall in love. Columns build themselves from your Assignment Tracker. Enter scores and watch weighted category averages, overall percentages, and letter grades calculate live as you type. No formulas to write. Ever.
• Attendance Tracker — Mark P, A, T, or E and get instant monthly totals and attendance rates for every student. Perfect for report cards and parent conferences.
• Weekly Lesson Planner — Objectives, activities, materials, and homework notes for every period, Monday through Friday, with dates that update from a single cell.
• Important Dates — Holidays, deadlines, field trips, and exams with an automatic "days away" countdown so nothing sneaks up on you.
• Welcome & Help Tab — A step-by-step getting-started guide, so even if spreadsheets aren't your thing, you'll be set up before your coffee cools.

Why teachers choose this digital gradebook

Because grading time is your time. When your weighted grade calculator does the math, you get your evenings back. When attendance rates total themselves, report card season stops being a scramble. And when parent conference night arrives, you'll pull up one clean, color-coded planner and feel completely prepared. Picture yourself in October, calm at the end of Quarter 1, grades already done — because the system did the heavy lifting all along.

Perfect for

Elementary, middle, and high school teachers • homeschool parents tracking multiple kids • tutors and co-op instructors • student teachers building their first classroom system • back-to-school and new-school-year organization.

How it works

• Buy once and get instant access — no waiting, no shipping.
• You'll receive a one-page PDF with a private link to copy the planner into your own Google Drive.
• Prefer Excel? From Google Sheets you can download your copy as an .xlsx file.
• Open the Welcome tab, enter your class, and start planning.

Details

• Instant digital access — delivered as a Google Sheet you copy to your own Drive (also works in Excel)
• Sample data included so you can see exactly how everything works, then clear it and make it yours
• Cheerful purple, turquoise, and green design that makes planning feel like a treat
• Reusable year after year, class after class

This is a digital product. No physical item will be shipped. Due to the instant nature of digital downloads, all sales are final. Personal use only.

From our family to your classroom — Gram and Me Printables ♥