Gradebook Template

A teacher’s gradebook: students, assignments and scores linked together, with percentages, class averages and letter grades worked out automatically.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Trackers

Tables

Students, Assignments, Grades

Fields

26

Views

grid, kanban, calendar, form

Tables, columns and sample rows

The 3 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Students

9 fields · 4 sample rows

  • Class list (Grid)
  • By section (Kanban)
StudentTextRoll no.NumberSectionSingle selectEmailEmailGuardian phonePhoneGradesLink to another tableAverageRollupLetter gradeFormulaMissing workRollup
Aarav Mehta18A[email protected]+91 98100 11221Aarav – Algebra quiz 1, Aarav – Photosynthesis project89.0%A
Isha Banerjee28A[email protected]+91 98300 22332Isha – Algebra quiz 1, Isha – Photosynthesis project84.5%A
Noah Williams38A[email protected]+91 99000 33443Noah – Algebra quiz 1, Noah – Photosynthesis project52.5%D
Sara Qureshi48B[email protected]+91 98200 44554Sara – Algebra quiz 1, Sara – Essay: My hero95.0%A+Yes
Field details
Student · Text
Roll no. · Number
Section · Single select
8A, 8B
Email · Email
Guardian phone · Phone
Grades · Link to another table
Links to Grades
Average · Rollup
avg of Percentage via Grades
Letter grade · Formula
IF({Average}, IF({Average} >= 0.9, 'A+', IF({Average} >= 0.8, 'A', IF({Average} >= 0.7, 'B', IF({Average} >= 0.6, 'C', IF({Average} >= 0.5, 'D', 'F'))))), '–')
Missing work · Rollup
sum of Missing via Grades

Assignments

8 fields · 4 sample rows

  • Assignments (Grid)
  • Due dates (Calendar)
AssignmentTextTypeSingle selectSubjectSingle selectDue dateDateMax pointsNumberGradesLink to another tableGradedCountClass averageRollup
Algebra quiz 1QuizMathematics5 Nov 202620Aarav – Algebra quiz 1, Isha – Algebra quiz 1, Noah – Algebra quiz 1, Sara – Algebra quiz 1476.3%
Photosynthesis projectProjectScience14 Nov 202650Aarav – Photosynthesis project, Isha – Photosynthesis project, Noah – Photosynthesis project380.7%
Essay: My heroHomeworkEnglish17 Nov 202625Sara – Essay: My hero1
Unit test – Linear equationsUnit testMathematics25 Nov 2026400
Field details
Assignment · Text
Type · Single select
Homework, Quiz, Project, Unit test, Exam
Subject · Single select
Mathematics, Science, English
Due date · Date
Max points · Number
Grades · Link to another table
Links to Grades
Graded · Count
Class average · Rollup
avg of Percentage via Grades

Grades

9 fields · 8 sample rows

  • All grades (Grid)
  • Enter a grade (Form)
EntryTextStudentLink to another tableAssignmentLink to another tablePointsNumberOut ofLookupPercentageFormulaLateCheckboxMissingCheckboxFeedbackLong text
Aarav – Algebra quiz 1Aarav MehtaAlgebra quiz 118.02090.0%
Isha – Algebra quiz 1Isha BanerjeeAlgebra quiz 115.02075.0%
Noah – Algebra quiz 1Noah WilliamsAlgebra quiz 19.02045.0%Review sign rules for negatives.
Sara – Algebra quiz 1Sara QureshiAlgebra quiz 119.02095.0%
Aarav – Photosynthesis projectAarav MehtaPhotosynthesis project44.05088.0%
Isha – Photosynthesis projectIsha BanerjeePhotosynthesis project47.05094.0%Excellent diagrams!
Noah – Photosynthesis projectNoah WilliamsPhotosynthesis project30.05060.0%Yes
Sara – Essay: My heroSara QureshiEssay: My hero25Yes
Field details
Entry · Text
Student · Link to another table
Links to Students
Assignment · Link to another table
Links to Assignments
Points · Number
Out of · Lookup
Max points via Assignment
Percentage · Formula
IF(AND(SUM({Out of}) > 0, NOT({Missing})), {Points} / SUM({Out of}), BLANK())
Late · Checkbox
Missing · Checkbox
Feedback · Long text

Form view “Enter a grade” asks for: Entry, Student, Assignment, Points, Late, Missing, Feedback.

Gradebook Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates