Google Sheets Teacher Planner Automated Lesson Planner Spreadsheet Gradebook & Attendance Tracker Sub Plan Template Teacher Dashboard

Love the idea of an all-in-one teacher planner, but prefer the familiarity and power of spreadsheets over learning new software? The Google Sheets Teacher Planner is designed specifically for educators who want a highly functional, automated, and familiar spreadsheet environment. This template does the heavy lifting for you. No complex databases to set up - just open, customize, and let the automated formulas organize your entire school year.

✨ WHY CHOOSE GOOGLE SHEETS?

While digital planners are great, sometimes you just want a reliable spreadsheet. This Teacher Planner is perfect for teachers who prefer Spreadsheets, need robust gradebook formulas, and want the flexibility to easily print out physical copies of their lesson sub plans.

📋 WHAT’S INCLUDED IN YOUR SPREADSHEET?

Everything you need to manage your classroom, students, and administrative tasks in one centralized hub:

➤ Instructions: Step-by-step guide to the entire spreadsheet, with tutorials on how to edit dropdowns and how to use the slicers.

➤ Settings: Easily customize your grades, assignments, class periods, and subjects to fit your specific school schedule.

➤ Automated Dashboard: Your central command center. Includes seamless navigation, a calendar view, upcoming important events, meetings, grade distribution charts, today’s lessons, and quick notes.

➤ Students Info Hub: Keep a detailed roster, track IEP/504 accommodations for special education, and log parent contact information securely.

➤ Lesson Planner & Automated Weekly Calendar: Plan your weeks with ease. The automated calendar pulls your lessons directly into your dashboard.

➤ Event Calendar: A fully automated monthly calendar to track school-wide events, holidays, and grading periods.

➤ Sub Plan Generator: Life happens! Create and print beautiful, automated substitute teacher plans in seconds so you can take a sick day stress-free.

➤ Gradebook: A powerful, formula-driven gradebook that automatically calculates averages, missing assignments, and overall student progress.

➤ Attendance Record: Track daily attendance effortlessly and view trends over time.

➤ Communication Log: Keep a detailed, organized record of all emails, calls, and meetings with parents and administration.

🔍 PERFECT FOR:

- Middle School Teachers (grades 6-8)

• High School Teachers (grades 9-12)

• AP / Honors / General Education Teachers

• Special Education Teachers (IEP/504 tracking)

• Department Heads (overview of multiple sections)

• Tutors and Academic Coaches

✨ WHY TEACHERS LOVE THIS GRADEBOOK:

✅ VISUAL DASHBOARD

See today's meetings, today's lessons, students "At Risk", class average and grade distribution (A/B/C/D/F) at a glance. Know your class inside out.

✅ AT-RISK STUDENT ALERTS

The attendance record will change color once the student's attendance drops below 90%. See exactly who needs help before parent-teacher conferences. No more digging through rows of data.

✅ IEP/504 TRACKING BUILT-IN

Mark students with IEPs, 504 plans, or ELL status in the Students Info. The cells turn yellow/orange so you never miss an accommodation. Stay IDEA-compliant without extra paperwork.

✅ MOBILE-FRIENDLY

Enter grades and track absent students from your phone, tablet, or laptop. Your data syncs automatically across all devices. Update it in the classroom, at home, or on the bus.

✅ BEGINNER-FRIENDLY

No spreadsheet experience required. Step-by-step setup guide included. Formulas are locked so you can't accidentally break them.

✅ CUSTOMIZABLE

Change the grading scale, add assignment categories, adjust weights, set your periods — all without breaking the formulas. Works for any middle school or high school course.

📥 HOW IT WORKS:

1. Purchase the listing and complete the checkout.

2. Download the PDF instruction file from your Etsy Purchases tab.

3. Click the link inside the PDF to access your Google Sheets template.

4. Click "Make a Copy" to save it to your personal Google Drive.

5. Follow the quick setup instructions and start planning!

⚠️ PLEASE NOTE:

• This is a DIGITAL PRODUCT. No physical item will be shipped.

• You will need a free Google account to access and use this template.

• Due to the digital nature of this product, refunds are not accepted, but please contact us if you have any issues! We are here to help.

© MintCanvas Studio. For personal and classroom use only. Please do not resell, share, or distribute this template.