Streamline your school year with this fully automated Google Sheets Teacher Planner and interactive digital dashboard hub—the ultimate customizable lesson plan template.

With an auto-populating school calendar and digital dashboard, this workspace puts prep on autopilot so you can reclaim your weekends. Plan once, and let automation sync your year everywhere.

WHAT MAKES THIS PLANNER MAGIC: AUTOMATED TABS

1. Setup Engine (Set Up Once, Automate All Year)
Configure parameters on a master page to build all 14 interconnected tabs:

• Color-Coding: Subject colors sync across calendars and widgets.
• Calendar Integration: Input holidays and INSET / staff days; the engine bypasses non-teaching dates automatically.
• Day Tags: Color-code rotating timetables (e.g. Red/Blue days, Week A/B) for weekly plans and dashboard headers.

2. Interactive Lesson Planner

• Auto-Scheduling: Select your class from a dropdown; calculates next valid date, day, and period.
• Curriculum & Standards: Preloaded options (CCSS, NGSS, TEKS, VA SOL) or add your own National Curriculum / Exam Board topics.
• Clickable Links: Paste URLs to turn them into clickable links on dashboard and weekly views.
• Shared Plan Automation: Separate classes (1A, 1B, 1C) by commas to duplicate lesson plans across timetable dates automatically.

3. Dynamic Weekly Layouts (Horizontal & Vertical)
Switch layouts instantly. Pulls plans automatically with zero double-typing. Printable in B&W or minimal color.

4. Macro Planning Views

• Monthly & Yearly Subject Plans: Map units, schemes of work, and macro pacing by subject.
• Year-at-a-Glance: 12-month calendar overview of units across all subjects.

5. Interactive Monthly Calendars
Add notes, school events, or trips to calendar blocks. Single-page printable.

6. Daily “Today’s Outlook” Dashboard
Live widgets for current lessons, task lists, notes, birthdays, and quick resource links.

7. Integrated Help Tab
Setup tips directly inside your planner.

WHAT IS INCLUDED

• Google Sheets Teacher Planner Link (via secure PDF Access Link).
• 3-Page Welcome Guide: Video link, setup tips, and printing guide.
• Direct Customer Support Email Access.

SAFETY ASSURANCE

Protected with warning pop-ups to prevent accidental formula deletion. 100% beginner-friendly!

System Requirements: Free Google account required. Runs in Google Sheets (not Excel).

Simplify prep, focus on students, and get your weekends back!