Grade Sheet

A gradebook that turns raw scores into percentages and letter grades, with each student's running average and subject breakdowns.

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

Education

Tables

Students, Scores

Fields

17

Views

grid, dashboard

Tables, columns and sample rows

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

Students

7 fields · 4 sample rows

  • Class summary (Grid)
StudentTextRoll noNumberSectionSingle selectGradesLink to another tableAssessmentsCountAverage %RollupOverall gradeFormula
Aditya Verma19AUnit 3 test – Quadratics, Photosynthesis lab report287.0%B
Emma Wilson29AUnit 3 test – Quadratics, Photosynthesis lab report287.0%B
Ishani Roy39AUnit 3 test – Quadratics, Persuasive essay273.0%C
Lucas Ferreira49AUnit 3 test – Quadratics, Persuasive essay266.3%D
Field details
Student · Text
Roll no · Number
Section · Single select
9A, 9B
Grades · Link to another table
Links to Scores
Assessments · Count
Average % · Rollup
avg of Percentage via Grades
Overall grade · Formula
IF({Assessments} = 0, '', IFS({Average %} >= 0.9, 'A', {Average %} >= 0.8, 'B', {Average %} >= 0.7, 'C', {Average %} >= 0.6, 'D', 'F'))

Scores

10 fields · 8 sample rows

  • Gradebook (Grid)
  • By subject (Grid)
  • Results (Dashboard)
AssessmentTextStudentLink to another tableSubjectSingle selectTypeSingle selectDateDateScoreNumberMax scoreNumberPercentageFormulaLetterFormulaFeedbackText
Unit 3 test – QuadraticsAditya VermaMathematicsUnit test13 Nov 202642.05084.0%B
Unit 3 test – QuadraticsEmma WilsonMathematicsUnit test13 Nov 202647.05094.0%A
Unit 3 test – QuadraticsIshani RoyMathematicsUnit test13 Nov 202628.05056.0%FRevisit factorisation
Unit 3 test – QuadraticsLucas FerreiraMathematicsUnit test13 Nov 202638.05076.0%C
Photosynthesis lab reportAditya VermaScienceAssignment16 Nov 202618.02090.0%A
Photosynthesis lab reportEmma WilsonScienceAssignment16 Nov 202616.02080.0%B
Persuasive essayIshani RoyEnglishProject18 Nov 202627.03090.0%AStrong arguments
Persuasive essayLucas FerreiraEnglishProject18 Nov 202617.03056.7%F
Field details
Assessment · Text
Student · Link to another table
Links to Students
Subject · Single select
Mathematics, Science, English, Social Studies
Type · Single select
Quiz, Assignment, Unit test, Project, Term exam
Date · Date
Score · Number
Max score · Number
Percentage · Formula
IF({Max score} > 0, {Score} / {Max score}, BLANK())
Letter · Formula
IF({Max score} > 0, IFS({Percentage} >= 0.9, 'A', {Percentage} >= 0.8, 'B', {Percentage} >= 0.7, 'C', {Percentage} >= 0.6, 'D', 'F'), '')
Feedback · Text

Grade Sheet: 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