Create Online Class Attendance Sheet
Track student attendance for online or offline classes using Google Sheets.
Three ways to take attendance
| Method | Best for | Effort |
|---|---|---|
| Google Sheets with checkboxes | Teacher marks attendance class-wise every day | Low |
| Google Form filled by students | Online/hybrid classes, events, workshops | Very low for the teacher |
| Meeting report (Meet/Zoom) | Live online classes on paid/education accounts | Low, but needs the right plan |
Method 1: Google Sheets register with totals
- Row 1: Roll | Name | 01-Nov | 02-Nov | … | Present | Total days | %.
- Select the date cells for all students → Insert → Checkbox. Tick = present.
- Present (in column AG for a 30-day month):
=COUNTIF(C2:AF2, TRUE) - Total days:
=COUNTA($C$1:$AF$1)(counts the date headings you added). - Percentage:
=IFERROR(ROUND(AG2/AH2*100, 1), 0) - Highlight below 75%: Format → Conditional formatting → Less than 75 → red fill.
Use one sheet tab per month and a summary tab that adds the months – or keep all days in one long sheet and use a pivot table.
Method 2: Google Form for self check-in
- Create a Form with: Roll number (Dropdown of valid numbers), Name (short answer), Class (dropdown).
- Settings → Responses: Collect email addresses: Verified and Limit to 1 response (students sign in with school accounts).
- Share the link or QR at the start of class and close responses after 10 minutes (Responses → Accepting responses off).
- Responses → Link to Sheets. The timestamp shows who came late.
- In the sheet, count each student’s entries with
=COUNTIF(Responses!C:C, A2).
A form can be filled by a friend on behalf of an absent student. For exams or official records, combine it with a roll call or the meeting attendance report.
Method 3: Meeting attendance reports
- Google Meet: with Google Workspace for Education (eligible editions) or business plans, turn on Attendance tracking in meeting settings; a report is emailed/saved to Drive after the class.
- Zoom: Reports → Usage → Meeting → Participants (available on paid accounts) shows join/leave times.
- Free accounts: take a screenshot of the participant list at the start and end of class.
Monthly report for parents/principal
- Class average attendance:
=AVERAGE(AI2:AI41). - Students below 75%:
=COUNTIF(AI2:AI41, "<75")and use a filter to list them. - Share as PDF (File → Download → PDF) instead of giving edit access to the sheet.
- Keep attendance data private – share individual records with parents, not the whole class list.
Attendance लेने के तीन तरीके
| तरीका | किसके लिए सबसे अच्छा | मेहनत |
|---|---|---|
| Checkboxes वाली Google Sheets | Teacher रोज़ class-वार attendance लगाता है | कम |
| Students द्वारा भरा Google Form | Online/hybrid classes, events, workshops | Teacher के लिए बहुत कम |
| Meeting report (Meet/Zoom) | Paid/education accounts पर live online classes | कम, पर सही plan चाहिए |
तरीका 1: Totals वाला Google Sheets register
- Row 1: Roll | Name | 01-Nov | 02-Nov | … | Present | Total days | %।
- सभी students की date cells चुनें → Insert → Checkbox। Tick = उपस्थित।
- Present (30 दिन के महीने में column AG):
=COUNTIF(C2:AF2, TRUE) - Total days:
=COUNTA($C$1:$AF$1)(आपके जोड़े date headings गिनता है)। - Percentage:
=IFERROR(ROUND(AG2/AH2*100, 1), 0) - 75% से कम highlight: Format → Conditional formatting → Less than 75 → लाल रंग।
हर महीने का एक sheet tab और महीनों को जोड़ने वाला summary tab रखें – या सारे दिन एक लंबी sheet में रखकर pivot table इस्तेमाल करें।
तरीका 2: Self check-in के लिए Google Form
- Form बनाएँ: Roll number (valid numbers का Dropdown), Name (short answer), Class (dropdown)।
- Settings → Responses: Collect email addresses: Verified और Limit to 1 response (students school accounts से sign in करें)।
- Class की शुरुआत में link या QR share करें और 10 मिनट बाद responses बंद करें (Responses → Accepting responses off)।
- Responses → Link to Sheets। Timestamp से पता चलता है कौन देर से आया।
- Sheet में हर student की entries
=COUNTIF(Responses!C:C, A2)से गिनें।
Form अनुपस्थित student की जगह कोई दोस्त भर सकता है। Exams या आधिकारिक records के लिए इसे roll call या meeting attendance report के साथ जोड़ें।
तरीका 3: Meeting attendance reports
- Google Meet: Google Workspace for Education (योग्य editions) या business plans में meeting settings में Attendance tracking चालू करें; class के बाद report email/Drive में आती है।
- Zoom: Reports → Usage → Meeting → Participants (paid accounts पर) join/leave समय दिखाता है।
- मुफ़्त accounts: class की शुरुआत और अंत में participant list का screenshot लें।
Parents/principal के लिए मासिक report
- Class की औसत attendance:
=AVERAGE(AI2:AI41)। - 75% से कम students:
=COUNTIF(AI2:AI41, "<75")और filter से list करें। - Sheet का edit access देने की जगह PDF के रूप में share करें (File → Download → PDF)।
- Attendance data निजी रखें – parents को पूरी class list नहीं, सिर्फ़ उनके बच्चे का record दें।
Frequently Asked Questions
How do I make an attendance sheet in Google Sheets?
Put roll numbers and names in rows and dates in columns, insert checkboxes for each date, then count present days with =COUNTIF(range, TRUE) and calculate the percentage.
Can Google Meet record attendance automatically?
Yes on eligible Google Workspace (including some Education) editions with Attendance tracking turned on. Free personal accounts do not have this feature.
How do I stop students from filling the form for friends?
Collect verified emails with school accounts, limit to one response, keep the form open only for a few minutes, and cross-check with a quick roll call.
