An individual grade book for tracking one student's assignments, tests and results across all school subjects during a term. It suits teachers, class advisors, tutors, homeschooling parents and students who want a clear record of academic progress. The header holds the student's name, student ID, class, school year, term and teacher or advisor. Each graded item is entered on its own row with the date, subject, assignment, category, points earned and points possible, and up to 300 entries fit on the sheet. Subjects and categories are chosen from drop-down lists, and the points fields accept only numbers of zero or more. The percentage and letter grade of every entry are calculated automatically, and results below the passing level or at A- and above are highlighted in colour. The Summary sheet calculates a weighted average for each subject by category, together with the letter grade, GPA points and the number of graded items. Categories without grades are excluded and their weight is redistributed automatically. The overall average, overall letter grade and GPA are shown both on the Summary sheet and in the grade book header. A column chart compares the weighted averages of all subjects. On the Settings sheet you can edit up to seven categories with their weights, the letter-grade scale with GPA points and a list of up to twelve subjects.
Prism Point, Blue Horizon, Bold Beacon, Citrus Clean, Classic Ledger, Evergreen Edge, Fresh Current, Luminous Lines, Midnight Pop, Mint Offer, Nocturne, Skyline Blue, Soft Touch, The Ledger, Violet Standard
Excel template, printable, spreadsheet, education, automatic calculations, skyline blue, teacher template, school, blue horizon, bold beacon, citrus clean, classic ledger, evergreen edge, fresh current, luminous lines, midnight pop, mint offer, nocturne, prism point, soft touch, the ledger, violet standard, student, drop-down lists, grade book, gradebook template, student grades, grade tracker, report card, GPA calculator, weighted average, letter grades, grading scale, academic progress, homeschool, assignments, tests and quizzes, subject summary, grade chart, semester, classroom management