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

To stop corruption of officers, IGP bans POS machines from police stations

To stop corruption of officers, IGP bans POS machines from police stations

Herbert Wigwe is an Isale Eko boy, Lagos will immortalise him - Sanwo-Olu

Herbert Wigwe is an Isale Eko boy, Lagos will immortalise him - Sanwo-Olu

Obasanjo wants African youths to resolve conflicts with love

Obasanjo wants African youths to resolve conflicts with love

FG to begin distribution of grains nationwide this week to address hardship

FG to begin distribution of grains nationwide this week to address hardship

Governor Bago denies banning movement of food items to other states

Governor Bago denies banning movement of food items to other states

Wike won't allow contractors rest until they deliver quality Abuja projects

Wike won't allow contractors rest until they deliver quality Abuja projects

FCT minister says criminals, not hungry Nigerians, looted warehouse

FCT minister says criminals, not hungry Nigerians, looted warehouse

Nigerian lawmakers feel insulted because Binance CEO refuses to appear before them

Nigerian lawmakers feel insulted because Binance CEO refuses to appear before them

Betty still goes by Ondo Gov's wife on Instagram 2 months after Akeredolu's death

Betty still goes by Ondo Gov's wife on Instagram 2 months after Akeredolu's death

Pulse Sports

Above Rohr and below Keshi: Where does Jose Peseiro rank among Nigeria’s Super Eagles' greatest-ever managers?

Above Rohr and below Keshi: Where does Jose Peseiro rank among Nigeria’s Super Eagles' greatest-ever managers?

Look away Man United fans, funny stat shows onesidedness of Manchester Derby

Look away Man United fans, funny stat shows onesidedness of Manchester Derby

Popular TV host Kate Abdo makes it official with boyfriend, cuddles up with him on Instagram post

Popular TV host Kate Abdo makes it official with boyfriend, cuddles up with him on Instagram post

Sha'Carri Richardson's Nike falls to New Balance in revenue growth for 2023

Sha'Carri Richardson's Nike falls to New Balance in revenue growth for 2023

Ex-Arsenal midfielder rushed to hospital following brain-related injury

Ex-Arsenal midfielder rushed to hospital following brain-related injury

I don't want him punished — Greenwood opens up on feelings after Bellingham's alleged name-calling

I don't want him punished — Greenwood opens up on feelings after Bellingham's alleged name-calling

ADVERTISEMENT
ADVERTISEMENT