Teacher Planner & Gradebook

Description

1 SPREADSHEET · 14 TABS · 9 LANGUAGES · 16 CURRENCIES · 5 THEMES ✦ Type the marks once. The reports write themselves. 🎓 Pick a student from a dropdown and the whole report card assembles itself: overall grade, weighted percentage, class rank, attendance, a category-by-category breakdown, behaviour notes, parent contacts and their support plan — on one printable page. You typed marks in a grid. It wrote the report. Available in ENGLISH, SPANISH, GERMAN, ITALIAN, FRENCH, TURKISH, POLISH, PORTUGUESE and DUTCH. Pick your language once in Settings and every tab, header and dropdown switches instantly. WHAT’S INSIDE — 14 CONNECTED TABS (one-click navigation) ✦ DASHBOARD — 8 tiles: students, classes, class average, attendance, marks entered, AT RISK, support-plan reviews due and budget left — with 3 live charts (average by class, grade distribution, attendance by class) ✦ CLASSES — up to 15 classes: subject, year group, period, room and timetable, with student count and class average filling in automatically ✦ STUDENTS — 500 students: contact details, guardian, support plan — then the sheet adds the weighted %, the letter grade, their CLASS RANK and an at-risk flag for anyone under 60% or under 90% attendance ✦ GRADEBOOK — 20 assignments. Name it, tag its category, set max points, type the marks. You get the WEIGHTED grade and the POINTS grade side by side, and assignments a student didn’t sit are excluded automatically ✦ ATTENDANCE — a real month register: 31 columns, ✅ present ❌ absent ⏰ late 📄 excused from a dropdown. Weekends shade themselves, days outside the month grey out, and anyone under 90% turns red ✦ REPORT CARD — the good part. One dropdown. The page writes itself. Print it, email it, hand it to a parent ✦ LESSONS — a week view (5 days × 8 periods) that pulls from a 200-row lesson log: unit, learning objective, activities, homework and a done tick ✦ YEAR PLAN — terms, holidays, exams, training days and events with a countdown ✦ BEHAVIOUR — 200 rows: student, positive or concern, what happened, action taken, parent informed. Feeds straight onto the report card ✦ CONTACTS — every parent conversation: method, reason, summary, follow-up date ✦ SUPPORT PLANS — IEP, 504, EAL/ESL and gifted: goals, accommodations and a REVIEW DATE that counts down and turns amber at 30 days ✦ BUDGET — what you spend on your own classroom, in your currency, by category ✦ SETTINGS — language, theme, currency, your school year, and a fully editable GRADE SCALE and CATEGORY WEIGHTS ✦ HOME — a branded dashboard that links to every tab in one click GRADING THAT FITS YOUR SCHOOL, NOT AMERICA’S The grade scale is a table you edit, not something hard-coded. A–F, 1–6, 1–20, 0–100, A*/A/B — type your own bands and every grade in the workbook follows. The category weights are yours too: Tests 40%, Quizzes 15%, Homework 15%, Projects 20%, Participation 10% out of the box, and the sheet warns you if your weights don’t total 100%. MAKE IT YOURS • UNDATED — set the day your school year starts and reuse it every year • 9 interface languages — all dropdowns and category names included • 16 currencies ($ € £ ₹ ¥ R$ ₺ zł + more) for the classroom budget • 5 deep-colour themes: Scholar Indigo, MIDNIGHT DARK, Emerald Green, Deep Ocean, Burgundy Wine — one dropdown restyles the whole workbook • YELLOW cells are yours to fill. GREY cells calculate themselves • Formulas protected (no password) so nothing breaks by accident • A full sample term is pre-filled — 15 classes, 500 students, 20 assignments, a month of registers, behaviour notes and parent contacts. Delete it and start WHAT YOU RECEIVE • 1 .xlsx file — works in Microsoft Excel AND Google Sheets (File → Import) • Quick-start guide • Instant download — no physical item will be shipped • No subscription, no app, no account beyond a free Google login PERFECT FOR primary and secondary teachers, form tutors, supply and substitute teachers, homeschool parents, tutors and heads of department — and anyone who has ever rebuilt the same gradebook from scratch in September. PLEASE NOTE • This is a DIGITAL product; nothing will be shipped. • Requires Microsoft Excel 2016+ or a free Google account. • The attendance tab is a MONTH register — duplicate the tab for each new month (right-click the tab → Duplicate). Everything else runs the full year. • Digital sales are final — but if anything is wrong with your file, message me and I’ll fix it fast. • Personal & classroom use for the buyer only. No resale or redistribution. Designed with care by SheetClub ✦