Teacher Planner & Gradebook Spreadsheet (Google Sheets & Excel)
Google Sheets + Microsoft Excel · Light & Dark Modes
Weekly Lesson Plan Matrix, Weighted Gradebook, Attendance Tracker & Student Roster
- Classroom Command Dashboard (Overall class average %, student counts & attendance)
- Student Roster & Profiles (Parent contacts, allergy alerts & IEP accommodation notes)
- Weekly Lesson Plan Matrix (5E curriculum structure across Monday through Friday)
- Automated Weighted Gradebook (Homework, quizzes, exams, overall % & letter grades)
- Companion AI Prompt Pack Included (Lesson differentiation, rubrics & parent emails)
- Light & Dark Mode Included (Google Sheets + Microsoft Excel)
Instant digital download. All sales final. Message us anytime for help.
Take complete control of weekly lesson planning, weighted gradebook calculations, daily attendance, and student academic rosters. The DownloadSuite Teacher Lesson Planner & Classroom Gradebook OS is an all-in-one educational operating system engineered specifically for K-12 teachers, high school educators, and curriculum planners.
Stop feeling overwhelmed by clunky school district software, disorganized grade spreadsheets, and chaotic parent communications. This Google Sheets and Excel system organizes your entire classroom instructional ecosystem — from building weekly Monday–Friday multi-subject lesson plans to calculating automated weighted student grade averages, tracking attendance marks, and documenting IEP/504 accommodations.
What's Included in This System:
- Classroom Command Dashboard: High-contrast KPI cards for Overall Class Grade Average (%), Total Active Students, Weekly Lesson Completion (%), Daily Attendance Rate (%), and Active IEP/504 Counts.
- Student Roster & Academic Profiles: Catalog student names, parent contact numbers, emergency details, medical/allergy alerts, and personalized learning notes.
- Weekly Lesson Plan Matrix: Map Monday through Friday curriculum across periods and subjects (Objectives, Direct Instruction, Guided Practice, Standards, Materials).
- Automated Weighted Gradebook: Track homework, quizzes, unit exams, and participation with automatic weighted percentage formulas and letter grade assignments.
- Companion AI Prompt Guide Included: Complete 15-module prompt guide for 5E lesson planning, differentiated instruction, SMART IEP goal drafting, rubrics, and parent communications.
- Light & Dark Mode Included: High-contrast Dark Mode (Royal Purple & Obsidian) for evening grading sessions plus clean minimalist Light Mode.
How to Use:
- Open the Google Sheets link or native Excel workbook and enter your student roster in the Student Roster tab.
- Build your weekly instructional objectives and activities in the Lesson Plans tab.
- Record student scores in the Gradebook tab to calculate live weighted averages and letter grades.
What's inside
- Start Here Quick-Start & Classroom Organization Guide
- Classroom Command Dashboard Tab
- Student Roster & Academic Profiles Sheet
- Weekly Lesson Plan Curriculum Matrix Tab
- Automated Weighted Gradebook Sheet
- Companion Teacher & Lesson Planning AI Prompt Pack (AI_PROMPT_GUIDE.md)
- Instant Google Sheets Copy Links + Native Excel .xlsx Workbooks
FAQ
Can I customize the gradebook category weights?
Yes! The formula allows you to adjust weights for Homework, Quizzes, Unit Exams, and Participation to match your school syllabus.
Does it work in Excel and Google Sheets?
Yes! Both native Microsoft Excel (.xlsx) workbooks and instant Google Sheets copy links in Light and Dark themes are included.