Teacher Planner and Gradebook Spreadsheet, Attendance, Lesson Plans, Seating Chart, Teacher Organizer, Excel Google Sheets

Teacher Planner and Gradebook Spreadsheet for Microsoft Excel and Google Sheets, instant digital download. Run your classes from one file: a weighted gradebook with automatic letter grades, attendance with % per student, lesson plans, a parent contact log, seating charts and a class dashboard that flags at-risk students. Perfect for middle and high school teachers with several periods.

🎥 WATCH THE FULL WALKTHROUGH VIDEO before you buy, every tab explained: https://youtu.be/j3NP2p7pruk

✨ NOW INCLUDES 4 FILES: Excel + Google Sheets, each in a SAMPLE version (filled in so you can see exactly how it works) and a BLANK version (cleared and ready for your own info).

★ WHAT'S INCLUDED ★
• 12 tabs with a clickable Start Here cover page and a How To Use + FAQ tab
• Class Dashboard: pick a class to see students, class average, attendance, at-risk count, missing work, assignments, A/B share and parent contacts, with a grade distribution chart, average score by assignment, an at-risk student list and a grade vs. attendance chart for all classes
• Setup: up to 6 classes or periods, 5 grading categories with weights, an editable grade scale and at-risk thresholds
• Roster: up to 200 students with class, seat number, parent contact and support plan (IEP, 504, ELL, Gifted)
• Gradebook: up to 40 assignments with category, course, date and points. Weighted category scores, final %, letter grade and missing count are calculated for you. Type M for missing or EX for excused
• Attendance: 90 school-day columns with P / A / T / E codes and an attendance % per student
• Lesson Plans: 600 rows with unit, standard, objective, activities, materials, homework and status
• Week View: any week in a grid with every class, green when taught
• Parent Contact Log: 400 rows with method, reason, summary and follow-ups
• Seating Chart: pick a class and see a 36-seat room with each student's current grade, at-risk students in red
• Progress Report: pick a student for a one-page summary of grades, attendance, missing work and every assignment
• Sample data for 4 classes and 90 students so you can see how it works

★ PERFECT FOR ★
✓ Middle and high school teachers with several periods
✓ Elementary teachers who want a simple weighted gradebook
✓ Tutors and co-op teachers

★ COMPATIBILITY ★
• Microsoft Excel (desktop, Mac, web)
• Google Sheets (upload to Google Drive and open with Google Sheets)
• 2 files included: an Excel version + a Google Sheets edition
• Not designed for Apple Numbers

★ HOW IT WORKS ★
1. Download and open the file in Excel, or upload it to Google Drive and open with Google Sheets.
2. On Setup, add your classes, category weights and grade scale.
3. Add students on the Roster, then enter assignments, scores, attendance and lesson plans.
4. Check the Dashboard, Seating Chart and Progress Reports as grades update.

★ PLEASE NOTE ★
• This is a digital download. Nothing will be shipped.
• Follow your school's own grading and privacy policies when storing student information.
• Because it's a digital file, returns aren't accepted, but if you have any trouble with the file, message me and I'll fix it or help you right away.