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
Tables
Students, Scores
Fields
17
Views
grid, dashboard
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.
7 fields · 4 sample rows
| StudentText | Roll noNumber | SectionSingle select | GradesLink to another table | AssessmentsCount | Average %Rollup | Overall gradeFormula |
|---|---|---|---|---|---|---|
| Aditya Verma | 1 | 9A | Unit 3 test – Quadratics, Photosynthesis lab report | 2 | 87.0% | B |
| Emma Wilson | 2 | 9A | Unit 3 test – Quadratics, Photosynthesis lab report | 2 | 87.0% | B |
| Ishani Roy | 3 | 9A | Unit 3 test – Quadratics, Persuasive essay | 2 | 73.0% | C |
| Lucas Ferreira | 4 | 9A | Unit 3 test – Quadratics, Persuasive essay | 2 | 66.3% | D |
10 fields · 8 sample rows
| AssessmentText | StudentLink to another table | SubjectSingle select | TypeSingle select | DateDate | ScoreNumber | Max scoreNumber | PercentageFormula | LetterFormula | FeedbackText |
|---|---|---|---|---|---|---|---|---|---|
| Unit 3 test – Quadratics | Aditya Verma | Mathematics | Unit test | 13 Nov 2026 | 42.0 | 50 | 84.0% | B | |
| Unit 3 test – Quadratics | Emma Wilson | Mathematics | Unit test | 13 Nov 2026 | 47.0 | 50 | 94.0% | A | |
| Unit 3 test – Quadratics | Ishani Roy | Mathematics | Unit test | 13 Nov 2026 | 28.0 | 50 | 56.0% | F | Revisit factorisation |
| Unit 3 test – Quadratics | Lucas Ferreira | Mathematics | Unit test | 13 Nov 2026 | 38.0 | 50 | 76.0% | C | |
| Photosynthesis lab report | Aditya Verma | Science | Assignment | 16 Nov 2026 | 18.0 | 20 | 90.0% | A | |
| Photosynthesis lab report | Emma Wilson | Science | Assignment | 16 Nov 2026 | 16.0 | 20 | 80.0% | B | |
| Persuasive essay | Ishani Roy | English | Project | 18 Nov 2026 | 27.0 | 30 | 90.0% | A | Strong arguments |
| Persuasive essay | Lucas Ferreira | English | Project | 18 Nov 2026 | 17.0 | 30 | 56.7% | F |
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.
Log who showed up to each class, club or session with arrival and departure times and hours on site.
1 table · 9 fieldsBack to School Supplies ChecklistList every supply each child needs for the new term, price it, and tick items off as you buy them so nothing is missed.
1 table · 11 fieldsClass Attendance SheetA class register: mark each student per period and see every student's attendance rate update automatically.
2 tables · 15 fieldsClass List TemplateRegister students into classes, see enrolment against capacity per class, and keep guardian details and comments together.
2 tables · 18 fieldsClass Sign In SheetStudents sign in to each lecture or lab from their phone with a signature; arrivals after the start time are flagged late.
1 table · 10 fieldsCollege Budget TemplateSet a monthly budget per category for college life, log every expense, and see what is left before the money runs out.
2 tables · 15 fields