Teacher Planner

Most teacher planners are pretty pages you fill in by hand. This one is a working spreadsheet — type a score and the letter grade appears, mark attendance and the rates update, tick a lesson as taught and your week progress climbs. Set it up once and it runs your whole year.

What's inside — 6 linked tabs

• Lesson Planner — Monday to Friday × six periods with your subjects in dropdowns. Set the Monday date and the day headers update. Tick TAUGHT and the row shades green while the chips count lessons planned, taught and % done
• Gradebook — up to 35 students × 10 assignments. Averages, letter grades A–F and a grade-distribution chart compute themselves, with colour-coded scores and a below-70% alert
• Attendance — mark P, L or A and nothing else. Attendance % per student and for the class updates live; set the month and the day grid, weekday letters and weekend shading redraw themselves
• Students & To-Do — type your class list once and the names flow into every tab. Parent emails, phones and notes on one row, plus a teacher to-do list with priorities and due dates
• Schedule — your subjects, which power every dropdown, your weekly timetable, and a school-year countdown that reads "30 days to go" before the first bell and "Day 47 of the year" after it
• Guide — setup steps, your weekly rhythm, and 30-second how-tos for starting a new week and a new month

Why you'll love it

• It does the arithmetic — class average, per-student average, letter grade and attendance rate all recalculate as you type
• A demo class is already filled in — so you see how everything works before you clear it and make it yours
• Undated — not tied to one school year. Duplicate a tab for a new week or month and reuse it every year
• Works anywhere — desktop, phone and tablet with the free Google Sheets app
• Nothing to learn — green cells are yours to edit, everything else computes

Two printable bonuses included

• Back-to-School Master Checklist — 100+ tasks in seven phases, from four weeks before the first day to the end of month one
• Classroom Paper Kit — eight everyday printables: hall passes, missing-homework slips, reading log, All-About-Me first-day form, weekly family newsletter, parent contact log, seating chart and two birthday certificates

Both bonuses come in US Letter and A4.

Made for elementary and homeschool teachers who run one class, and for anyone tired of planners that do not do the math.

Works in Google Sheets · Instant download · Pay once — no subscription, lifetime access.