# Teacher Lesson Planner — Product Summary

**Price:** $15  
**Type:** Google Sheets template  
**Category:** Education  
**Status:** ✅ Built
**Sheets:** 7 tabs

---

## What It Is

A complete Google Sheets lesson planning system designed by a teacher, for teachers. Seven interconnected sheets cover everything from daily lesson grids to year-long curriculum mapping — all in one beautiful, intuitive file.

## Sheet Breakdown

| # | Sheet | Purpose |
|---|-------|---------|
| 1 | **Weekly Lesson Grid** | Period-by-period planner (Mon-Fri, 8 periods). Objectives, activities, materials, homework column. Pre-filled with sample lessons. |
| 2 | **Unit Planner** | Unit overview (essential questions, standards, duration) + week-by-week breakdown with assessments, resources, and reflection space. |
| 3 | **Grade Tracker** | 15-student roster with 10 assignment columns, auto-calculated averages, and color coding: green (90%+), amber (70-79%), red (below 70%). Pre-filled with sample scores. |
| 4 | **Attendance Log** | Monthly grid (31 days) with P/A/T dropdown codes, auto-counts per student. Pre-filled with sample attendance data. |
| 5 | **Parent Communication Log** | Date, student, parent, method (dropdown), direction (incoming/outgoing), topic summary, follow-up tracking. 5 sample entries included. |
| 6 | **Curriculum Map** | Year-long pacing guide with quarters, units, weeks, standards, assessments, cross-curricular links, and resources. Pre-filled with sample ELA curriculum. |
| 7 | **Instructions** | Step-by-step guide for every sheet plus tips for Google Sheets protection, dropdowns, and freezing panes. |

## Design

Sage green and cream with warm gold accents. Professional but friendly — the "calm organized teacher" aesthetic. Quarter-color-coded curriculum map, green/yellow/red grade coding, all print-friendly.

## Key Features

- **Dropdown menus** for attendance codes, parent contact methods, direction, and follow-up tracking
- **Auto-calculated averages** in Grade Tracker
- **Auto-counts** for Present/Absent/Tardy in Attendance Log
- **Color-coded grading** — green/amber/red conditional formatting
- **Freeze panes** on all sheets for easy scrolling
- **7-sheet tab design** — everything connected, nothing cluttered
- **100% Google Sheets compatible** — no macros, no VBA

## Target Customer

- K-12 classroom teachers (all subjects, all grades)
- Student teachers building their planning systems
- Homeschool educators
- Department heads sharing planning tools with their teams

## Pricing

$15 — mid-tier education template. Pairs well with the Teacher AI Prompt Library ($19) for the complete teacher toolkit.

## Packaging

- `Teacher_Lesson_Planner.xlsx` — spreadsheet (7 sheets)
- `thumbnail.png` — product image (1024×1024)
- `PRODUCT_SUMMARY.md` — this file
