School Attendance Sheet

A whole-school daily register: each class teacher submits headcounts so the office sees attendance by class at a glance.

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

Classes, Daily register

Fields

16

Views

grid, form, 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.

Classes

6 fields · 4 sample rows

  • Classes (Grid)
ClassTextClass teacherTextStageSingle selectEnrolledNumberDaily reportsLink to another tableAvg attendanceRollup
Grade 3-AMrs. PillaiPrimary3219 Nov 2026, 18 Nov 202696.9%
Grade 5-BMr. ThompsonPrimary3019 Nov 202693.3%
Grade 7-AMs. BanerjeeMiddle3619 Nov 202680.6%
Grade 10-CMr. HaddadSecondary4019 Nov 2026, 18 Nov 202696.2%
Field details
Class · Text
Class teacher · Text
Stage · Single select
Primary, Middle, Secondary
Enrolled · Number
Daily reports · Link to another table
Links to Daily register
Avg attendance · Rollup
avg of Attendance % via Daily reports

Daily register

10 fields · 6 sample rows

  • Today first (Grid)
  • Submit register (Form)
  • School dashboard (Dashboard)
DateDateClassLink to another tableEnrolledNumberPresentNumberLateNumberOn leaveNumberAbsentFormulaAttendance %FormulaSubmitted byTextRemarksText
19 Nov 2026Grade 3-A323010196.9%Mrs. Pillai
19 Nov 2026Grade 5-B302621193.3%Mr. Thompson
19 Nov 2026Grade 7-A362902580.6%Ms. BanerjeeFive out for district football trials
19 Nov 2026Grade 10-C403810197.5%Mr. Haddad
18 Nov 2026Grade 3-A323101096.9%Mrs. Pillai
18 Nov 2026Grade 10-C403530295.0%Mr. Haddad
Field details
Date · Date
Class · Link to another table
Links to Classes
Enrolled · Number
Present · Number
Late · Number
On leave · Number
Absent · Formula
IF({Enrolled}, {Enrolled} - {Present} - {Late} - {On leave}, BLANK())
Attendance % · Formula
IF({Enrolled} > 0, ({Present} + {Late}) / {Enrolled}, BLANK())
Submitted by · Text
Remarks · Text

Form view “Daily attendance report” asks for: Date, Class, Enrolled, Present, Late, On leave, Submitted by, Remarks.

School Attendance 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