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
Tables
Students, Assignments, Grades
Fields
26
Views
grid, kanban, calendar, form
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.
9 fields · 4 sample rows
| StudentText | Roll no.Number | SectionSingle select | EmailEmail | Guardian phonePhone | GradesLink to another table | AverageRollup | Letter gradeFormula | Missing workRollup |
|---|---|---|---|---|---|---|---|---|
| Aarav Mehta | 1 | 8A | [email protected] | +91 98100 11221 | Aarav – Algebra quiz 1, Aarav – Photosynthesis project | 89.0% | A | |
| Isha Banerjee | 2 | 8A | [email protected] | +91 98300 22332 | Isha – Algebra quiz 1, Isha – Photosynthesis project | 84.5% | A | |
| Noah Williams | 3 | 8A | [email protected] | +91 99000 33443 | Noah – Algebra quiz 1, Noah – Photosynthesis project | 52.5% | D | |
| Sara Qureshi | 4 | 8B | [email protected] | +91 98200 44554 | Sara – Algebra quiz 1, Sara – Essay: My hero | 95.0% | A+ | Yes |
8 fields · 4 sample rows
| AssignmentText | TypeSingle select | SubjectSingle select | Due dateDate | Max pointsNumber | GradesLink to another table | GradedCount | Class averageRollup |
|---|---|---|---|---|---|---|---|
| Algebra quiz 1 | Quiz | Mathematics | 5 Nov 2026 | 20 | Aarav – Algebra quiz 1, Isha – Algebra quiz 1, Noah – Algebra quiz 1, Sara – Algebra quiz 1 | 4 | 76.3% |
| Photosynthesis project | Project | Science | 14 Nov 2026 | 50 | Aarav – Photosynthesis project, Isha – Photosynthesis project, Noah – Photosynthesis project | 3 | 80.7% |
| Essay: My hero | Homework | English | 17 Nov 2026 | 25 | Sara – Essay: My hero | 1 | |
| Unit test – Linear equations | Unit test | Mathematics | 25 Nov 2026 | 40 | 0 |
9 fields · 8 sample rows
| EntryText | StudentLink to another table | AssignmentLink to another table | PointsNumber | Out ofLookup | PercentageFormula | LateCheckbox | MissingCheckbox | FeedbackLong text |
|---|---|---|---|---|---|---|---|---|
| Aarav – Algebra quiz 1 | Aarav Mehta | Algebra quiz 1 | 18.0 | 20 | 90.0% | |||
| Isha – Algebra quiz 1 | Isha Banerjee | Algebra quiz 1 | 15.0 | 20 | 75.0% | |||
| Noah – Algebra quiz 1 | Noah Williams | Algebra quiz 1 | 9.0 | 20 | 45.0% | Review sign rules for negatives. | ||
| Sara – Algebra quiz 1 | Sara Qureshi | Algebra quiz 1 | 19.0 | 20 | 95.0% | |||
| Aarav – Photosynthesis project | Aarav Mehta | Photosynthesis project | 44.0 | 50 | 88.0% | |||
| Isha – Photosynthesis project | Isha Banerjee | Photosynthesis project | 47.0 | 50 | 94.0% | Excellent diagrams! | ||
| Noah – Photosynthesis project | Noah Williams | Photosynthesis project | 30.0 | 50 | 60.0% | Yes | ||
| Sara – Essay: My hero | Sara Qureshi | Essay: My hero | 25 | Yes |
Form view “Enter a grade” asks for: Entry, Student, Assignment, Points, Late, Missing, Feedback.
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 contractor hours against projects, approve timesheets and see billable totals per contractor at their own hourly rate.
2 tables · 20 fieldsCookie Order TrackerTake cookie orders, track baking and delivery, and see what is paid and owed for a home bakery or fundraiser drive.
1 table · 16 fieldsCoronavirus Monitoring SheetContact-tracing for an organisation: log confirmed cases, trace their close contacts and monitor isolation and quarantine end dates.
2 tables · 23 fieldsCorrection Tracking TemplateLog copy and content corrections with the original and corrected text, route them to editors and measure turnaround.
1 table · 16 fieldsCOVID-19 Daily Symptom TrackerA daily health self-check for staff or patients: temperature, symptoms and exposure, with an automatic fever flag and clearance status.
1 table · 11 fieldsDebt Tracker TemplateList every loan and card balance, log payments against them, and watch remaining balances and payoff progress shrink.
2 tables · 23 fields