Digital Teacher Planner | 28 Tabs, Auto-Dated Calendars, Lesson Plans, Attendance & Gradebook

Lesson Plans • Daily Attendance • Gradebook • Homework • Monthly Calendars • Family Contacts — 28 connected tabs in one editable digital planner

Take your everyday teacher organization out of separate notebooks, spreadsheets, and calendars and bring it together in one easy-to-use planner.

Set your school year start date once, then use the built-in schedules and monthly calendars to organize your teaching year. Record attendance, plan lessons, enter grades, manage homework, keep family contact notes, organize field trips, and track your personal to-do list.

The planner is designed for practical daily use, with light-yellow input cells, dropdown menus, automatic calculations, connected class information, and protected formulas.

📅 What's Included: 28 Ready-Made Tabs 1. Setup

Enter your:

• School information
• Teacher information
• School year start date
• Class information
• Up to 14 subjects

Your subject list feeds the appropriate dropdown menus throughout the planner.

2. Dashboard

Get a quick overview of your school year, including:

• Calendar
• Today's information
• Open tasks
• Subjects
• Birthdays
• Family contacts

3. Roster

Organize up to 30 students across 3 class blocks.

Track:

• Student name
• Student ID
• Birthdate
• Class information
• Key student details

4. Student Info

Keep additional information organized for each student in one convenient grid.

5. Birthdays

Automatically organize student birthdays so you can quickly see upcoming birthdays throughout the school year.

6. Contacts

Record family communication with:

• Student
• Contact date
• Reason
• Contact method
• Outcome
• Notes

7. Schedule

Create your weekly teaching schedule with dates generated from your school-year setup.

8. Lesson Planner

Plan lessons by week and class block.

Use subject dropdowns and organized planning fields to keep your weekly instruction in one place.

9. Attendance

Record daily attendance using:

P / T / U / E / O

The tracker automatically calculates attendance totals and percentages.

10. Gradebook

Record assignment grades for your students and let the workbook calculate averages automatically.

11. Homework

Track:

• Assignment
• Subject
• Assigned date
• Due date
• Status
• Marks
• Notes

12. Assignment Calendar

View homework and assignments in an organized calendar-style layout.

13. Field Trips

Record:

• Destination
• Date
• Location
• Cost
• Permission
• Notes

14. To-Do

Keep your personal teacher tasks organized with:

• Task
• Week
• Priority
• Status
• Notes

Use High / Medium / Low priority options.

15. Notes & Meetings

Record:

• Meeting date
• Agenda
• Decisions
• Follow-ups
• Notes

16–27. January–December Calendars

Includes 12 monthly calendars that automatically generate dates based on the school-year start date entered in Setup.

Use them for:

• Important dates
• Lessons
• Assignments
• Meetings
• Events
• Teacher reminders

28. How to Use / My Info

Quick-start instructions plus a dedicated area for your teacher information.

⚙️ Built for Everyday Teacher Use Auto-Dated Calendars

Enter your school-year start date once and the planner automatically updates its date-based sections.

Dropdown Menus

Use dropdowns for subjects, attendance codes, priorities, statuses, and other recurring fields.

Connected Information

Your class and subject information feeds into relevant sections, reducing repetitive typing.

Automatic Calculations

Let the workbook handle calculations such as:

• Attendance percentages
• Grade averages
• Task counts
• Calendar dates

Protected Formulas

Formula cells and important layout areas are protected to help prevent accidental changes.

Clear Input Areas

Light-yellow cells indicate areas where you enter information.

👩‍🏫 Perfect For

This digital teacher planner is useful for:

• Elementary teachers
• K–2 teachers
• Classroom teachers
• New teachers
• Long-term substitute teachers
• Teachers who want one organized planning system
• Teachers moving from paper planners to digital planning

💻 Excel + Google Sheets Excel

Use the complete editable workbook in Microsoft Excel.

Google Sheets

A Google Sheets version is also available for teachers who prefer browser-based planning.

Important: Make your own copy of the Google Sheets file before entering personal or classroom information.

📦 Files Included

✔ Digital Teacher Planner Excel workbook

✔ 28 ready-made tabs

✔ 12 monthly calendars

✔ Auto-dated school-year sections

✔ Lesson planning pages

✔ Attendance tracker

✔ Gradebook

✔ Homework tracker

✔ Assignment calendar

✔ Family contact log

✔ Field-trip tracker

✔ To-do list

✔ Notes & meeting log

✔ Student roster

✔ Student information pages

✔ Dashboard

✔ Dropdown menus

✔ Automatic calculations

✔ Protected formulas

✔ Sample data for demonstration

✔ Google Sheets version/access

⭐ Why Use One Planner?

Instead of keeping separate files for:

Planning + Attendance + Grades + Homework + Calendar + Contacts + Tasks

keep your everyday teacher organization together in one connected digital workbook.

Set up your class once, enter your school-year date, and then use the planner throughout the year.

Important Information

• This is a digital resource. No physical product will be shipped.
• Excel is required for the full Excel workbook experience.
• Google Sheets functionality may differ from desktop Excel for certain formulas or features.
• Enter your school-year start date in the Setup tab before using the date-based sections.
• Sample data is included to demonstrate how the planner works.
• License: Single classroom use only.
• Do not resell, redistribute, or publicly post the files.

by Koco Kyo | Practical digital resources for organized teaching.