{"id":13006,"date":"2026-09-19T15:07:19","date_gmt":"2026-09-19T15:07:19","guid":{"rendered":"https:\/\/templacity.com\/?post_type=product&#038;p=13006"},"modified":"2026-11-09T09:55:11","modified_gmt":"2026-11-09T09:55:11","slug":"assignment-tracker-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/nl\/product\/assignment-tracker-spreadsheet\/","title":{"rendered":"Assignment Tracker Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p><span class=\"eyebrow\">\u2116 \u00b7 How the grade is worked out<\/span><\/p>\n<h2 id=\"an-assignment-tracker-spreadsheet-that-weights-every-class-the-way-its-syllabus-does\">An assignment tracker spreadsheet that weights every class the way its syllabus does<\/h2>\n<p>The Assignment Tracker is for students with several classes, each graded its own way. At the start of term, add your classes on Classes, up to ten, with the code, teacher, credits, room or link, and the weights from each syllabus for homework, quizzes, exams, projects, papers, labs and participation, adding to 100. Then copy every deadline onto Assignments: class, title, type and due date.<\/p>\n<h3>Grades that are fair from the first quiz<\/h3>\n<p>Type the score and what it was out of when work comes back. Each class&#8217;s grade counts only the kinds of work that have a score so far, so one early quiz does not stand in for a whole term. The grade scale on Settings turns the percentage into a letter and GPA points, A from 93 for 4.0 down to F, and your GPA is weighted by credits. If your school uses a different scale, change the letters and cut-offs and every grade follows.<\/p>\n<h3>Nothing slips past its date<\/h3>\n<p>Anything past its due date and not marked Done, Submitted or Graded shows as Late on Assignments, This Week and the Dashboard. Set how many days counts as due soon, and check This Week on Sunday night: seven columns of everything due, coloured by class.<\/p>\n<p>The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, plus the same workbook as blank and example Excel files.<\/p>\n<p>Planning on a tablet or on paper instead? <a href=\"\/find-your-planner\/\">Find your planner in 60 seconds<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Every assignment in one list, a week view coloured by class, and each class&#8217;s grade weighted the way its syllabus says, with your GPA.<\/p>\n","protected":false},"featured_media":13007,"comment_status":"open","ping_status":"closed","template":"single-product-bundle.html","meta":{"rank_math_title":"Assignment Tracker Spreadsheet for Google Sheets and Excel | Templacity","rank_math_description":"A student assignment tracker for Google Sheets and Excel: deadlines by week, late flags, weighted grades per class and GPA.","rank_math_seo_score":"13","_templacity_copy_live":"1","_templacity_faq":[{"q":"How is each class's grade weighted?","a":"By the weights you copy from its syllabus onto Classes, for homework, quizzes, exams, projects, papers, labs and participation, adding to 100. Only the kinds of work with a score so far count, so the grade is fair from the first result."},{"q":"My school uses a different grading scale. Can I change it?","a":"Yes. Edit the letters, the cut-off percentages and the GPA points on Settings. It starts on A from 93 (4.0), A- from 90 (3.7) and so on down to F, and every grade follows your changes."},{"q":"Is the GPA weighted by credits?","a":"Yes. Each class's points are weighted by the credits you give it on Classes."},{"q":"How many classes does it hold?","a":"Ten per term. For a new term, make a fresh copy and set the new term dates on Settings."},{"q":"When does an assignment show as late?","a":"When its due date has passed and it is not marked Done, Submitted or Graded. It shows on Assignments, This Week and the Dashboard."},{"q":"Does it work in Excel?","a":"Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable."},{"q":"Is there a year printed in it?","a":"No. No year is printed anywhere in the files, so it starts the day you do and keeps working next year."}]},"niche":[337],"template_type":[],"templacity_topic":[],"product_brand":[],"product_cat":[24],"product_tag":[44],"class_list":["post-13006","product","type-product","status-publish","has-post-thumbnail","niche-spreadsheets","product_cat-spreadsheets","product_tag-google-sheets","first","instock","downloadable","virtual","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product\/13006","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/comments?post=13006"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media\/13007"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media?parent=13006"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/niche?post=13006"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/template_type?post=13006"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/templacity_topic?post=13006"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_brand?post=13006"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_cat?post=13006"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_tag?post=13006"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}