ADVERTISEMENT

How do schools and offices revolutionize their attendance checking means with QR codes?

The use of Google Sheets can help you in executing a working QR code attendance system.

How do schools and offices revolutionize their attendance checking means with QR codes?

As the schools and offices' means of attendance are heavily affected by the COVID-19 outbreak, the use of traditional and biometric means to check their workers' or students’ attendance is not encouraged by the healthcare personnel.

Because of the restrictions schools and offices face when doing their attendance checking, a new system in checking their students' and workers' attendance emerges.

And as QR codes exist for a few years now, many schools and offices are tapping the use of them to prevent instances of spreading contamination between people.

Due to the need to prevent the possibility for the virus to spread at a rapid rate, the QR code attendance system becomes the best attendance system alternative that they can incorporate.

ADVERTISEMENT

Schools and offices incorporate the use of QR codes in their attendance checking means by integrating the use of three technological tools like Google Forms, Google Sheets, and an online QR code generator free platform to make this work.

Through interlinking these technological tools, they were able to seamlessly introduce a faster and safer way to check their attendances by simply tapping their designated QR code attendance into the scanner and successfully recording their time.

To know how they can create their QR code attendance, here are three main segments that you should remember if you plan to integrate the use of it in your classroom or office.

ADVERTISEMENT

Since the best way to record your students' or workers' attendance is by keeping it on an online platform, the use of Google Sheets can help you in executing a working QR code attendance system. In creating your list, you must first open your Google Drive and make a new folder by name as your Institution’s attendance master list.

Afterward, open the folder you created and make a Google Sheets file. In the Google Sheets file use the first three columns in writing your students’ or workers' first name, last name, and full name, and label the fourth column as URL. The URL column will be filled with the link from your Google Forms.

Copy all the data included in the third column in your clipboard and proceed in creating your Google Forms Responses.

To get the Google Forms link of each of the students or workers included in your attendance master list, you can proceed in opening the Google Forms app. After the app loads, proceed in renaming the form as Attendance forms and select the checkboxes as the question type.

ADVERTISEMENT

Go to the menu option beside your Gmail profile and select the get pre-filled link option. Once a new tab loads, select the first option and click on the get link to generate your link and paste it in your URL column in the Google sheet file.

Repeat the steps in generating your worker or student’s prefilled link and place it in your Google sheets file.

Once you have filled all the needed data for your QR code attendance, continue seamlessly creating your attendance QR code by following these steps.

1. Open an online QR code generator with a logo website and create an account.

ADVERTISEMENT

2. Go to the Bulk QR Tab and download the CSV file template.

3. Open the CSV file, fill up the URL column with the pre-filled links you gathered, and put the URL as the qrCategory.

4. Upload the CSV file and generate your QR code attendance.

5. Customize your bulk QR code design.

6. Select the SVG option and download your bulk QR code.

ADVERTISEMENT

With the government’s encouragement for schools and offices to go contactless on most of their operations, here are some of the reasons why schools and offices need to integrate the use of QR codes in modernizing their attendance checking system.

  • Minimizes the risk of in-person contact
  • Fastens attendance checking means
  • Reduces attendance sheet cluttering
  • Provides more time in doing work or classes

Since many schools and offices are looking for a better and safe way to check their students' or workers' attendance during the COVID-19 pandemic, QR codes are one easy way to revolutionize their attendance checking means.

ADVERTISEMENT

As they only need to scan them when they need to get their attendance checked, the waiting time for each student or worker lasts for 10 seconds or less.

JOIN OUR PULSE COMMUNITY!

Unblock notifications in browser settings.
ADVERTISEMENT

Eyewitness? Submit your stories now via social or:

Email: eyewitness@pulse.ng

Recommended articles

Lagos postpones highly anticipated Easter boat regatta indefinitely

Lagos postpones highly anticipated Easter boat regatta indefinitely

Third Mainland Bridge reopens in 1 week, formal ceremony later - Minister

Third Mainland Bridge reopens in 1 week, formal ceremony later - Minister

Sanwo-Olu opens 'Sunday market' on Good Friday for Easter shopping

Sanwo-Olu opens 'Sunday market' on Good Friday for Easter shopping

Wike thanks Tinubu for the opportunity to serve

Wike thanks Tinubu for the opportunity to serve

Tinubu’s aide distributes food items to 1,750 persons in FCT, Kwara

Tinubu’s aide distributes food items to 1,750 persons in FCT, Kwara

Court grants senator accused of forging NYSC certificate ₦50m bail

Court grants senator accused of forging NYSC certificate ₦50m bail

BREAKING: Delta monarch declared wanted by military surrenders to police

BREAKING: Delta monarch declared wanted by military surrenders to police

Renowned Canada-based Nigerian playwright, Oguntokun is dead

Renowned Canada-based Nigerian playwright, Oguntokun is dead

Kaduna Gov grants scholarship to 137 rescued schoolchildren, son of late teacher

Kaduna Gov grants scholarship to 137 rescued schoolchildren, son of late teacher

Pulse Sports

Nigeria vs Mali: Has Finidi George done enough to land Super Eagles job permanently?

Nigeria vs Mali: Has Finidi George done enough to land Super Eagles job permanently?

I want to emulate Keshi and win the AFCON - Finidi George shares ambitious Super Eagles dream

I want to emulate Keshi and win the AFCON - Finidi George shares ambitious Super Eagles dream

Michelle Alozie: I had to do it because of African referees

Michelle Alozie: I had to do it because of African referees

AC Milan star reveals he was named after Super Eagles legend Tijani Babangida

AC Milan star reveals he was named after Super Eagles legend Tijani Babangida

Give him the job! Super Eagles fans beg NFF to make Finidi George permanent coach after Nigeria's win over Ghana

Give him the job! Super Eagles fans beg NFF to make Finidi George permanent coach after Nigeria's win over Ghana

Super Eagles 2-1 Black Stars: Nigerians praise Iwobi, Lookman, Finidi George after friendly victory against Ghana

Super Eagles 2-1 Black Stars: Nigerians praise Iwobi, Lookman, Finidi George after friendly victory against Ghana

ADVERTISEMENT
ADVERTISEMENT