{"product_id":"teacher-gradebook-dashboard","title":"Teacher Planner and Gradebook Dashboard Spreadsheet","description":"\u003cp\u003eThis teacher gradebook calculates a weighted average that does not punish a student for work that has not come back yet. It is for classroom teachers who want grades, attendance, standards and parent contacts in one file, with a dashboard that shows who needs attention this week.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eThe dashboard\u003c\/h2\u003e\u003cp\u003eNothing on the dashboard is typed. It fills itself from what you enter, and a week picker lets you view the whole term or any teaching week.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eClass average: the weighted term average, with the change on last week\u003c\/li\u003e\n\u003cli\u003eThe class average on every assessment against the at-risk line\u003c\/li\u003e\n\u003cli\u003eMarking pile: marked against still to mark, for every week of the term\u003c\/li\u003e\n\u003cli\u003eThis week's lessons: class and topic in every period of the timetable\u003c\/li\u003e\n\u003cli\u003eMarked work below your at-risk level, week by week\u003c\/li\u003e\n\u003cli\u003eHomework, quizzes, tests and projects side by side\u003c\/li\u003e\n\u003cli\u003eWeekly attendance against the concern level you set\u003c\/li\u003e\n\u003cli\u003eStudents at risk, lowest averages first, with grade, attendance and flag\u003c\/li\u003e\n\u003cli\u003eComing up: tests, trips and parents' evenings from the Term Calendar\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA weighted average that is fair\u003c\/h2\u003e\u003cp\u003eThe weighted average divides only by the weights of the categories a student actually has work in. Leave a cell empty because the work has not been handed back, and it costs the student nothing. This is the most common fault in gradebooks, and the reason so many first-term averages look like a disaster.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eWeighted averages across six categories, with your own weights\u003c\/li\u003e\n\u003cli\u003eGrade boundaries you set, and can rename if your school uses numbers\u003c\/li\u003e\n\u003cli\u003eAn attendance tracker out of five sessions a week, with the percentage calculated\u003c\/li\u003e\n\u003cli\u003eClass average and lowest score for each assignment\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eAt-risk alerts, standards and parents\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eAt-risk alerts driven by two thresholds you set on Setup, a grade line and an attendance line. Three different signals give three different verdicts, because a child struggling with grades and a child missing school need different conversations.\u003c\/li\u003e\n\u003cli\u003eStandards mastery for twenty outcomes across the whole class, color-coded, so you can tell a parent which skills are secure and which are not yet\u003c\/li\u003e\n\u003cli\u003eA parent log, counted back into the alerts, so the at-risk list tells you whether you have already called home\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eLight and dark editions\u003c\/h2\u003e\u003cp\u003eEvery download includes a light edition and a dark mode template edition. Every tab is restyled, not just the dashboard, and both share the same formulas. Each comes filled with a term already under way and as a blank copy, in Excel and in Google Sheets. Everything reads one marks grid, so nothing is typed twice in this grade tracker.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016 or later, on Windows or Mac\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros and no add-ins, so it behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice\u003c\/li\u003e\n\u003cli\u003eNo subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eLight edition: the Excel workbook filled with a worked example, and a blank one\u003c\/li\u003e\n\u003cli\u003eDark edition: the same two files in the dark design\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, with one-click links to the Google Sheets versions (light and dark, filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. The Excel workbooks run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to the Google Sheets versions for a free Google account.\u003c\/p\u003e\u003ch3\u003eDoes a missing assignment count as a zero?\u003c\/h3\u003e\u003cp\u003eNo. An empty cell is not a zero, and the weighted average divides only by the categories a student has work in.\u003c\/p\u003e\u003ch3\u003eHow are students flagged as at risk?\u003c\/h3\u003e\u003cp\u003eYou set a grade line and an attendance line on Setup. Students below either are flagged, with different verdicts for grades, attendance or both.\u003c\/p\u003e\u003ch3\u003eCan I track standards as well as grades?\u003c\/h3\u003e\u003cp\u003eYes. The Standards tab tracks mastery of twenty outcomes for every student, color-coded.\u003c\/p\u003e\u003ch3\u003eWhat is the difference between the light and dark editions?\u003c\/h3\u003e\u003cp\u003eOnly the look. Both have the same tabs and formulas, and both come in every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597865058398,"sku":"OPX-089","price":25.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/teacher-gradebook-dashboard-01.jpg?v=1790832437","url":"https:\/\/opxviashop.com\/products\/teacher-gradebook-dashboard","provider":"OPXVIA","version":"1.0","type":"link"}