{"product_id":"assignment-tracker-weighted-grades","title":"Assignment and Homework Tracker Spreadsheet","description":"\u003cp\u003eThis assignment tracker knows that a small quiz and a major paper are not worth the same evening. It is for college and university students who want their deadlines and their weighted grades in one place, so they can see where they stand before results day.\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 your coursework, and you can show all courses or pick just one.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eDue today and due tomorrow, by name, with the next 7 days and the next two weeks\u003c\/li\u003e\n\u003cli\u003eUpcoming deadlines, soonest first, with late work in red\u003c\/li\u003e\n\u003cli\u003eOverdue and active work counts\u003c\/li\u003e\n\u003cli\u003eCurrent grade: your weighted average against target, with your GPA\u003c\/li\u003e\n\u003cli\u003eGrades by course, current percentage against each target\u003c\/li\u003e\n\u003cli\u003eWorkload by course: overdue, due soon and ahead\u003c\/li\u003e\n\u003cli\u003eThe term week by week, and marks by week and by type of work\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWeighted grades, not just dates\u003c\/h2\u003e\u003cp\u003eMost homework trackers stop at sorting by due date. This one weights the work.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eUp to 200 pieces of coursework, each with a weight percentage\u003c\/li\u003e\n\u003cli\u003eYour weighted average calculated per course and overall\u003c\/li\u003e\n\u003cli\u003eLetter grade and points from your own scale, so it doubles as a GPA calculator\u003c\/li\u003e\n\u003cli\u003eA target per course, with the number of courses on target counted\u003c\/li\u003e\n\u003cli\u003eHow much of each course is actually marked so far, because an average built on a third of the course can mislead\u003c\/li\u003e\n\u003cli\u003eDue in 7 days, overdue and days left on every piece, in red when late\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eCourses, Today and Tasks\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eCourses:\u003c\/strong\u003e 12 courses with credits, instructor and room\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eToday and Tasks:\u003c\/strong\u003e a student planner for everything that is not coursework\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eStart Here and Setup:\u003c\/strong\u003e setup in a few minutes\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 edition. Every tab is restyled, not only the dashboard, and both use the same formulas. Each comes filled with a worked example and as a blank copy, in Excel and in Google Sheets. The worked semester has six courses, 27 pieces of coursework, a 76.8% weighted average and six items overdue, making it a full grade tracker example to learn from.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you copy, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no 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 as soon as payment clears. The tracker is for personal and business use on your own devices, so please do not share or resell the files. Questions? Reach us through our contact page.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDo I need Excel, or can I use Google Sheets?\u003c\/h3\u003e\u003cp\u003eEither. The download has Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to copy the Google Sheets versions with a free Google account.\u003c\/p\u003e\u003ch3\u003eHow are my grades weighted?\u003c\/h3\u003e\u003cp\u003eEvery piece of coursework has a weight percentage. The tracker calculates your weighted average per course and overall from those weights and your marks.\u003c\/p\u003e\u003ch3\u003eDoes it work with my school's grading scale?\u003c\/h3\u003e\u003cp\u003eLetter grades and points come from your own scale, which you set up, so it can follow the scale your school uses.\u003c\/p\u003e\u003ch3\u003eHow many courses and assignments does it hold?\u003c\/h3\u003e\u003cp\u003eUp to 12 courses and 200 pieces of coursework.\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 seven tabs and formulas, and both come in every download.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597866827870,"sku":"OPX-127","price":25.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/assignment-tracker-weighted-grades-01.jpg?v=1790832651","url":"https:\/\/opxviashop.com\/products\/assignment-tracker-weighted-grades","provider":"OPXVIA","version":"1.0","type":"link"}