The Smart Teacher Planner | Automated Google Sheets Teacher Planner, Gradebook, Attendance & Dashboard | Editable K-12

THE SMART TEACHER PLANNER

Automated All-In-One Google Sheets Teacher Operating System

Stop rebuilding your planner every August. Set this up ONCE and it runs your

entire school year for you.

This isn't another pretty template collection — it's a connected system.

Enter your school info, dates, bell schedule, and roster one time, and that

information automatically flows into every calendar, tracker, and dashboard

in the workbook. No re-typing student names. No manually updating dates

every month. No juggling six different spreadsheets that don't talk to

each other.

WHAT'S INSIDE (22 connected tabs):

✔ Command Center Dashboard — see today's schedule, tasks, and next event at a glance

✔ Quick-Setup Wizard with a live "setup complete" tracker

✔ Master School Calendar + auto-generated monthly calendars (holidays and PD days shade themselves in)

✔ Weekly Lesson Planner — pick a Monday, Mon–Fri dates fill in automatically

✔ Unit Planner + Standards Tracker (editable for YOUR state standards)

✔ Master Student Roster that feeds every other tab automatically

✔ Attendance Tracker with auto-calculated percentages

✔ Gradebook with auto-averaging and low-grade alerts

✔ Assessment Tracker with instant class average, high/low, and % mastery

✔ Parent/Guardian Communication Log with auto-filled contact info and overdue-follow-up alerts

✔ Behavior Documentation Log with automatic repeat-incident counts

✔ Student Support/Accommodation + Intervention (MTSS) Trackers

✔ Student Data Dashboard — pick a student, see their grades, attendance, behavior, and communication history in one place

✔ Task Manager with automatic overdue highlighting

✔ Meeting & PD Notes log

✔ Weekly Teacher Reset dashboard for Friday/Sunday planning

✔ Substitute Teacher Quick View (schedule only — no student data exposed)

WHY TEACHERS LOVE THIS SYSTEM:

- 100% editable — change colors, labels, categories, and grading systems freely

- Built with native Google Sheets formulas (no Apps Script required, nothing to "authorize")

- Works for elementary, middle, and high school — self-contained or multi-period classrooms

- Designed so you type each piece of information exactly once

WHAT YOU NEED:

A free Google account. This is a Google Sheets file (not Excel or a printable PDF) —

make a copy to your Drive and it's yours to customize forever.

TERMS OF USE: For single-classroom/personal use. Please do not resell, redistribute,

or share this file outside your own classroom. District/school-wide licensing available

on request — message me!