How To Create QR Attendance for Teachers in 2020 !! (Google Sheets and Google Forms)
Вставка
- Опубліковано 6 чер 2024
- I've updated this video! Check it out here: • How to Create a QR Cod...
The digital age calls for contactless solutions, and QR codes are a fantastic answer. In this video, we're back with an updated, secure method for creating QR codes for attendance in 2020, leveraging the power of BeaconStac. Whether for school, work, or events, this system offers a more secure and user-friendly approach to attendance tracking. Dive in and learn how to modernize your attendance system with increased security.
If you want to see the completed Google Sheet from this video click here
► docs.google.com/spreadsheets/...
----------------------------------------------------------------------------------------------------------------
📼CHECK OUT THE OTHER VIDEOS IN THIS SERIES
----------------------------------------------------------------------------------------------------------------
📼Struggling to determine why your QR codes aren't working? Try this: • Your QR Attendance Qs ...
📼Need to get some management process once things have been scanned? See here: • How to filter your QR ...
📼Prefer a Microsoft product, or want to prevent people from scanning the wrong person? Give this a shot: • How to Create QR Atten...
📼Check out the rest of the QR series! • QR Attendance
----------------------------------------------------------------------------------------------------
💬 GOT A QUESTION?
↓↓↓ Leave a comment down below ↓↓↓
This is fabulous! So well conceived, so clearly explained, so on point for a specific need for the times we are in. I just implemented your technique to print ID cards with QR codes for 800+ students after testing. Flawless. We already were using google forms on a shared Chromebook to take attendance prior to COVID, and were 100% remote last year using the same form, but this year we needed a touchless alternative on site which could also be self-serve for remote students. This was perfect. Thank you so very much on behalf of our staff and students. Bravo.
Thank you so much for spending the time to write such a supportive message. I really appreciate it, Bud. Good luck with your new approach!
Sir please explain me..how it can be done
Wow, It's an amazing system Man. Your explanation is so detail. Thanks a lot for the tutorial.
Hope it helps. Thanks!
This is exactly what I needed! I am using this to track my students office visits. My assistant can scan the code of the student coming to the office and we have instant timestamped documentation!
Very clear instruction and a perfect result. Impressed. Following avidly from this point.
Great to hear!
The instructions are so clear and easy to understand. You helped me a lot, sir. Thank you so much!
Glad it helped!
Great video! So easy to follow and so clearly explained. Thank you for sharing!
Extremely clear in explanation, very detailed & helpful! Thank you so much
Thanks!
I used your "old" method for the 20th anniversary event of our highschool. It was quick and reliable. I see now that you have a better version of it. Can't wait to see how it works. Thanks a lot!
Excellent! It's got updated formulas to take into account a bunch of different text types and even different alphabets!
Learnt a lot of things in very less time 👍
Please make more and more videos like this .
Thank you, I will
Thank you!!! You just saved me so much time this evening. I wanted to create something like this for contract tracing with seats, followed the instructions, and they look perfect. Thank you again!
Glad it helped!
@@HashAliNZ this is a great help. I too want to use this method for contract tracing. Except I plan to assign qr codes on seats and have students scan the seat when they sit down. I can't get the form prefill option to appear if I opt to collect email addresses? Any ideas there? We want to track what student sits in what seat (date, time, etc).
@TheMathLab NZ Thanks ! Please tell us how to resolve it.
Thank you so much, please do continue making contents like this. I was able to create one for my class because of your concise explanation in this video. 👏👏👏
Have a great day ahead!
Will do!
This is perfect! Exactly what I thought of making, but hadn't a clue where to begin... Thank you sooo much :)
You're very welcome!
Thanks for this! It's absolutely brilliant and elegantly done. Can't wait to see how easy attendance is going to be:-)
Can't wait!
Good for first day until kids start scanning each other’s codes. Cool concept though. Better if they have the code and teacher scans.
@@TheJcperla Yeah, that's the way a lot of people have implemented it. But there's downsides to that too - for example students scanning the code at home. Check out this video for a more secure version: ua-cam.com/video/maIarmhtfcY/v-deo.html
@@HashAliNZ that is an awesome solution. Could the Google form be set up so only certain people could access it? This would prevent students from scanning?
You make it look so easy!!! Thank you for a great tutorial. Now I know what I will be trying for the next 24 hours!!
Good luck!
@@HashAliNZ hi can ask how to make qr code for organization thank you in advanced i will wait for your reply
@@purpleheart8491 Just follow the same steps as in the video, but the URL will be the URL for your organization
i havent seen someone this thorough in google sheets & forms. Appreicated!
No problem!
Awesome Man, never knew you could do such things with Google Sheets and Forms!
Thanks for the knowledge my man!!
Happy to help!
Yoooo, it was a nice system. i will come back later if theres more update.. thanks a lot more sharing
No problem 👍
this channel is underrated
Thanks!
agree
Really awesome video. Thank you for teaching me how to create bulk QR codes without going through a sketchy site!
Thanks! There are some good sites out there, it's just tolling to research which ones are good
this is such a great video! I did not know of the Google API we can use for this. I have been wanting a static code to print on my business cards and on stickers but didn't want to pay for it. Now with your tips and explanation I can code a QR code. Thanks for making this even if it was for a different audience.
Glad it was helpful!
Excellent video. I'm surprised you don't have more followers. You explain everything in a concise and logical way.
I've followed your video and adapted it slightly. My students here in Seoul have both English and Korean characters in their 'name' field. This morning I tested QR attendance with the students and everything worked, except that only 3 (out of 10 or so) responses had names attached to them. The timestamps showed all of the students were able to submit their attendance using QR codes though. Is there anyway that Korean characters could be screwing something up, or is there another issue that I'm not aware of? I'd be happy to share the spreadsheet with you or anyone else who is willing to take a look.
From one Kiwi to another.
I've never tried with Korean characters. My email is themathlabnz@gmail.com if you wanna send it to me
Can you create a video dedicated to shortkeys for Google Docs, Sheets, etc.?
Interesting idea!
My boss gave me a task and was expecting me to spend $4000 to solve it. Your video was the answer. So well put together. Explained so perfectly. I think I love you
Keep sharing that love, Alex!
Dude you are a genius! You deserve more subs than what you currently have. Keep it up.
Appreciate that!
Well explained! Quick Q: Where does the student access the QR code? Do you share the Google Sheet with the class and they scan in each time with the same QR code?
Hi Dan,
Yes it's the same QR code each time, but each person gets their own QR code.
At the end of this video I have a quick clip showing how I did it for my students.
Thank you. A clear as glass explanation! Subscribed! Though I am not a teacher, never the less appreciated this work very much. We were able to create the attendance sheet as per video first time correct (including the part of printing, laminating and producing the QRCodes!). I wonder if you could help someones in further need and expand the functionality of this sheet. I noticed on the last segment of your video...Create A New Spreadsheet - it is able to detail the timestamp of who attended, and at what date and the time. Could you create a formula that is able to pull the data and identify who was a little late (ie 15mins) or very late (ie 30mins) or didnt make it (not checked-in) at all for class or work (ie >60mins) ? And send out and email reminder(s) to the student/worker and/or Supervisors? Thanks. Tajuddin
Absolutely. I have an old video somewhere that goes through latenesses. I'll see if I can find it
Here you go! ua-cam.com/video/oYW1TYir9nQ/v-deo.html
It's an older video so the quality is not so great, but it has the basic details. Let me know if you get stuck
Thank you. Will look into this
Just used the "join" formula on MS excel. Works exactly the same. Thank you.
You got QR codes in Excel?
Thank you so much TheMathLab NZ! I really like your presentation and the clear explonations you provide. Well done sir. Sure it'b be great to limit the ability to flash to one single account, to prevent anybody to flash their code when they please. Yet it's a usefull method you gave the world ;-) Cheers!
Thanks, Lazare! Yeah, it would be good to do that. There are ways to create apps specifically for that, but that's beyond my capability!
@@HashAliNZ Yours seem fine enough to me ;-) The check out would be nice too. Thanks again, hope to read more exiting tricks from you soon.
Thanks. It's amazing!
However, is there any way to restrict students to scan multiple times such as some students will scan the QR for their friends?
And what if they scanned wrong? Just delete it in Google Sheet Response Form?
Hi Jax,
Yes you can restrict to just one scan per student, but that means they would have to select their name because the Form won't autosubmit.
Some people may scan for their friends. You do need to teach the students this is a trust-based model.
If scanned wrong, you can delete from either the Responses Sheet or from the Google Form itself.
Alternatively, you could give the students printed qr codes and get them to scan a webcam to register attendance. That way it doesn’t rely on them having internet/data and you can watch them so they don’t scan multiple cards.
Great! Is it possible to add the location where de scanned was made? To know where the person is in the Moment of the scan
You have a few options.
Option 1: Make a new QR code for each student for each location.
Option 2: One QR code but then have another question which is manually filled out before clicking Submit
Option 3:
Add 1 random Quiz Question only teacher got there answers.
Each get the one word/code answer for there question from the teacher as they attendance approve physically!
Whoever scanned and didn't answer the quiz is a skipper tried to cheat attendance.
Basically it's the basic 2 Key Auth. Semi manual, based on military standards.
No fancy gps required or biometrics!
Always simplist methods works the best...
By the way... Special Tip!
You could make questions of Auth. IQ or Equations like SAT hardest Questions that would challenge them if they answered it they may have late entry for the effort once a month!
the video was super great and strait-forward. well done
I enjoy how the "student names" are characters from the Rugrats show. Awesome!
Superb video! I followed all the steps but the QR Image wont show-Up. Any solution. The space looks blank where the QR image is supposed to appear. Appreciate your efforts.
Same problem with mine appears to be blank
Heya, Check if there's any spaces in the names. If there are, get rid of them.
Heya, Check if there's any spaces in the names. If there are, get rid of them.
Also having the same problems. Checked and there are no spaces in URL
@@minirollsrule Feel free to share with me and I can take a look: themathlabnz@gmail.com
Thanks, Very useful and time saving. What if any student scanned some other students QR by mistake or How can we stop proxy attendance?
Yeah, that's the challenge here. Otherwise it's just cool
Can try requires log in. That way can cross reference
Exactly !!! that's what I thought when he 4 times scanned the QR code from his single phone itself. By this way 1 student can apply fake attendance for their classmates. How do we counter this hiccup???
You can restrict to just one scan per student, but that means they would have to select their name because the Form won't autosubmit.
Some people may scan for their friends. You do need to teach the students this is a trust-based model.
You could also try giving/sending each student only their own codes. Requires a bit more effort and still isn't fool-proof, but it might discourage scanning others' codes!
brilliant idea and love the simplicity on it, cool bro, thanks for sharing these!
No problem 👍
Wow im gonna do that to our staff since we have a new company thank you🙏🏻🙏🏻🙏🏻🙏🏻 more power
Brilliant! Make sure you check out this video for a different method: ua-cam.com/video/maIarmhtfcY/v-deo.html
This is an outstandingly well thought out and detailed tutorial. I followed everything exactly and was able to generate a full attendance tracker for my students.
I am having an issue though where some scans are coming in without the students' names, and therefore they are being marked as absent. I'm not sure why this would be happening, and it isn't always the same students that are coming in scanned without names. I verified that the names match the Google Form perfectly (I copied them and pasted so everything matches), and if I personally scan each QR code myself, it comes in with the names as expected. I just can't seem to figure out what to do to solve the blank name problem. Any help would be greatly appreciated. Thanks so much for putting this video out. I'd have been lost without it.
Thanks for the kind words.
Just so I'm on the right track:
- Student A signed in but it scanned without a name attached
- On a different day, Student A was able to scan no problems but Student B signed in with a similar issue
- The names on the Google Form match exactly the names on the Google Sheet and you have tested each one
The next step would be making sure the URLs are correct. Find a student whose name did not scan but their scan did register. Go to that student's URL that's next to their QR code in the Google Sheet. Read the URL to make sure it's correct and then click on it to make sure it registers properly.
@@HashAliNZ Thanks so much for the reply. That's correct. I just checked what you suggested and it registered as expected when clicking their link, also I can personally scan these students' QR codes using my own phone and it will register perfectly fine when I do it, so based on that I can't seem to understand what the issue could be.
@@BeLikMike23 That's a new issue for me. I haven't come across that one before. It's possible the QR scanner being used has a problem. I recommend using BinaryEye for the scanner
@@HashAliNZ I appreciate the recommendation. I'll suggest it to the students and hope it solves the issue. Thanks so much for your replies and for your superb video.
Excellent and amazing.....simple and robust.
Thank you.
You are welcome!
Thank you sir. BIG HELP. God bless you .
Glad it helped
Thank you. Remarkable! I enjoyed following along. It worked on the first try.👍
Thanks Patricia!
Awesome tutorial keep it up bro. That goes a long way. Thank you very much.
Thanks!
Thanks for all the continued views and comments. I've updated this method, so check out this video that has better and more efficient formulas: ua-cam.com/video/_6-ZDGNtcRg/v-deo.html
How to add those alignment patterns on QR
@@rajibthaosen2591 Alignment patterns?
Subbed already 6min in and im learning more than my entire high school
Thanks for the sub, but no need to put down your high school - there's no reason for them to teach this stuff.
If you wanna go more in depth, I've updated this video with better and more efficient formulas: ua-cam.com/video/_6-ZDGNtcRg/v-deo.html
Thanks a lot, man. I'm really appreciated it.
Really very helpful , it will lessen the burden of a teacher as well student also
Thanks!
Insanely great yet simple.
Thanks!
GREAT KUDOS Math Masters ... Thanks!!!
all in ONE GOOGLE indeed
Glad it was helpful!
This is honestly the best tutorial
Thanks!
Thanks for sharing this knowledge. You're a hero.
I appreciate that!
Thanks for sharing!!! I apologize for the simplicity of my question but when putting this into use in class, does the professor use their own phone to read the student's QR codes or doe sit work differently? Thanks!
very big help sir.. thank you so much!!
Glad it helped
Thank you so much for this. really amazing...I am a teacher here in thePhilippines. I can use this..Thank you
Glad it was helpful!
You explained that very well. I thank you for that.
I'm glad it helped
Excellent Informative Videos, & Very nice person I have ever seen in my life. Thank you again TheMathLab NZ...😊
My pleasure!
great video; i m wondering if the in and out time could be implemented thank you
Great video, looks like you are master of Google products. Thank you for sharing.
Thanks for watching!
Just amazing sir 💪
Thank you so much, you made my day
Thank you so much for the video, Sir! It's really helpful.
I've a question. From the video, it shows the students that is present on that day. Would it be possible for me to see who's absent on that day from the name list?
Well explained and it's work fine 100% thank you for your efforts ❤
Glad it helped
This has been great! I've been trying to streamline attendance for 138 students for ages and this might just work. I have followed all your intstructions and some rows are not filling in the QR code. Most have filled automatically but some are empty. Any advice? Also any idea when you might do another useful video on how to take this attendance for multiple weeks in a course? separate response collections?
Fantastic! I'll be making a video that covers all of this today. Hopefully I will have it ready to be released this week!
Excellent video and very easy to follow
Glad it was helpful!
Thank you for a great tutorial !
Thanks
Many many thanks 🙏 you’re very kind!
You are very welcome
Fantastic work!
Thank you! Cheers!
That was well done. Thank you.
Thanks Sam!
Thanks for sharing this!
Glad you enjoyed it!
Fantastic video really easy to follow. This may have already been asked but is there away where we can track students signing out as well as signing in.
this is SO GREAT!!! new subscriber here!!! and i liked your video so i can go bank to it anytime!!!
Awesome! Thank you!
Thank you.. looks amazing. can you track down like in and out time also?
Sure. Here's an example: docs.google.com/spreadsheets/d/1Rf3YOD7ly8Jz_TdFISUBDQImTRjo5xIkOpRj3hW9IOo/copy
Great Video...Very Helpful...expect more like this...thanks ...Subscribed
Thanks for the sub!
Nice, thank you
hi its a great video. very informative. i would like to ask that is it possible to create staff automatic location detect attendance during check in via the scan code? means that staff will check in attendance using their location.
Subscribed. Thanks for this new knowledge
Awesome, thank you!
Thanks for the Clarity Brother
Any time
@@HashAliNZ Sure I will ask
Once again Thanks Brother
think you for the new updated video and files its a it grate what you do thank you
You are very welcome
sophisticated tutorial . Thanks
So nice of you
Excellent job 👍🏼👍🏼👍🏼
Thanks!
Thanks and very useful video for us the create the sheet using QR doces.
Glad it was helpful!
thanks for this video, i really enjoy google platform to work on i going to enroll in classes to boost my knowledge i already have carried on knowledge form excel but google is the future and we need to keep up
Best of luck! If you need any help, I'm a regular helper in reddit for r/googlesheets and r/sheets
Brilliant. Thankyou
Thank you for sharing. What application did you use to scan the QR code? Thank you
Binary Eye
That's so awesome. Can you suggest how we can use this to organize an attendance for multiple days or even a month. Perhaps just by incorporating another variable field to specify a date?
No need. The Google Forms automatically collect the date, so when we've collected the info we can filter by whatever date we want. It'll work for years with no need to update it (unless someone changes their name, but maybe that just means we should be using student IDs instead of names?)
Thank you for your help! This was so informative. My predicament is as follows, I would like to assign and provide participants in my program 1 QR code. I would like to scan the QR code for their attendance as you explained in your video but I would also like the option to somehow scan their code to keep track of their meal pick ups as well as for a linen exchange system. I would like to use separate google forms for the meal and linens. How would I go about expanding the access to the multiple forms with one QR? thank you for any and all advice.
You'll need two QR codes per person. One will be for meal picks, the other for linen exchange.
If you really need just one QR code, then you'll have the person scan then select either meal pick up or linen exchange then submit.
@@HashAliNZ I also have similar problem. One QR code need be able to distinguish Task 1 or Task 2 or Task 3. Print out end result who are in each Task at end of day. I was thinking add a question in Google form prior to pull up google Lens, then select Task 1, 2 or 3 before scan.
How to do about doing this ? Is this too much coding ?
@@harutanaka3647 What if you set up each student on their task first, then give them the QR code that autofills both the task number and their name? You can semi-automate the setup process using some more advanced techniques in Google Sheets. Here's a big project that someone on Reddit was working on that allows you to select the information first, and then you can create a QR code based on the final URL
docs.google.com/spreadsheets/d/1Jm71h1zWXim8rds4-mytnU4V5jifwDCxeG9uw5AcGbw/edit?usp=sharing
Hi! Great video! one question: is there a quick way for me to see only those that are absent instead? I am looking for a way to eliminate counter-checking against a physical name list instead.
Absolutely. You'll need to have a full of students in one tab of your Google Sheet, and a filter to select the correct date.
Then we can use a query that might look something like this:
=query({B2:B,StudentList!A2:A}, "select Col1 where Col1Col2")
where B has your form responses and C has your list of students. Email me with your spreadsheet if you want additional help
Thank you so much I just wanted to what if I want to make for my students along the whole semester.. Am I gonna use the same link or what?
Yes, the same link. You can then use the data and some spreadsheet magic to filter your data depending on which date you want to see. See here on how to do that: ua-cam.com/video/upH5SSxkwOU/v-deo.html
Great video. I am thinking how can we use this to rate subjects in a study by just scanning the QR code. Any idea of how can this be set up? I wonder if adding another layer to the form would help.
Interesting idea. Is there any reason you want to do a QR system instead of a basic push button?
Good effort! love it
Thanks a lot!
love it thanks man
Thanks!
Thanks a lot. Great video.
Thanks Kazi!
Pls any tips on doing 3-5 Multiple choices with radio buttons, checkboxes. Every time I create it, and click submit form I created it only allow first two option to go through, but 3rd, 4th, 5th and so on option just wont go through for both multiple choices and checkboxes. In affition if you have any tips on file upload would be amazing!!!
Keep it up, bro!!!
Thanks
Many thanks ♥
Hi thanks for the wonderful informative video, could you help me with one idea, if I have QR already will it be possible to get the data in Google form?
What does your QR do?
Interesting. Nice project!!
Thanks!
Thank you for your quick response sir. Is it the same even for macbook laptop user?
It should be. But every time I say Ctrl, switch it out for Cmd.
Also, if you're in Europe use ; instead of ,
Is this translatable through new classes? For instance can you just edit the form and change a name or add/remove a name and it’ll auto update to the sheet and make a new QR code?
Thank you for this very informative discussion on using QR code in tracking attendance of students. I just got a problem with my MacBook it wont show all of the qr code. i don't know why? what should I do?
Hi Cindy,
The most common reason that QR codes don't show up is due to spaces before, within, or after the person's name. Here's an easy fix:
Select the column(s) with the names
Press Ctrl+H
In the Find box, type a space
Leave the Replace With box empty
Click the Replace All button.
You should now see your QR codes
simply amazing, pls share with us creating vcard qr code. thanks again
Do you mean something like this? imgur.com/a/hUtBXXd
Hi @TheMathLab NZ ! This is a very good video. The only problem I had was the 1st Row QR Code image did not show up. When i copied to the rest of the rows, they all showed up. I'm not sure why this is happening.
Also, is there a way to register and recognise the phones IMEI to ensure that friends don't cover for each other to scan on their behalf?
I'm not sure whether you are still replying to comments. I hope so.
Thank you.
David
Hi David,
Thanks for the question. I've replied to your email.
Cheers!