How To Create QR Attendance for Teachers in 2020 !! (Google Sheets and Google Forms)
Vložit
- čas přidán 26. 06. 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!
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: czcams.com/video/_6-ZDGNtcRg/video.html
How to add those alignment patterns on QR
@@rajibthaosen2591 Alignment patterns?
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!
The instructions are so clear and easy to understand. You helped me a lot, sir. Thank you so much!
Glad it helped!
Extremely clear in explanation, very detailed & helpful! Thank you so much
Thanks!
Great video! So easy to follow and so clearly explained. Thank you for sharing!
Very clear instruction and a perfect result. Impressed. Following avidly from this point.
Great to hear!
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.
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!
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: czcams.com/video/maIarmhtfcY/video.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!
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!
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
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!
Awesome Man, never knew you could do such things with Google Sheets and Forms!
Thanks for the knowledge my man!!
Happy to help!
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
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.
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
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!
Can you create a video dedicated to shortkeys for Google Docs, Sheets, etc.?
Interesting idea!
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
I enjoy how the "student names" are characters from the Rugrats show. Awesome!
Thank you sir. BIG HELP. God bless you .
Glad it helped
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! czcams.com/video/oYW1TYir9nQ/video.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
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!
Excellent and amazing.....simple and robust.
Thank you.
You are welcome!
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.
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!
Just used the "join" formula on MS excel. Works exactly the same. Thank you.
You got QR codes in Excel?
Dude you are a genius! You deserve more subs than what you currently have. Keep it up.
Appreciate that!
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.
brilliant idea and love the simplicity on it, cool bro, thanks for sharing these!
No problem 👍
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: czcams.com/video/_6-ZDGNtcRg/video.html
the video was super great and strait-forward. well done
You explained that very well. I thank you for that.
I'm glad it helped
Thank you. Remarkable! I enjoyed following along. It worked on the first try.👍
Thanks Patricia!
Many many thanks 🙏 you’re very kind!
You are very welcome
Thanks for sharing this knowledge. You're a hero.
I appreciate that!
Awesome tutorial keep it up bro. That goes a long way. Thank you very much.
Thanks!
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: czcams.com/video/maIarmhtfcY/video.html
Thank you for a great tutorial !
Thanks
That was well done. Thank you.
Thanks Sam!
Thanks a lot, man. I'm really appreciated it.
Thank you so much, you made my day
Really very helpful , it will lessen the burden of a teacher as well student also
Thanks!
This is honestly the best tutorial
Thanks!
very big help sir.. thank you so much!!
Glad it helped
Insanely great yet simple.
Thanks!
Nice, thank you
Fantastic work!
Thank you! Cheers!
Thanks for sharing this!
Glad you enjoyed it!
Thanks and very useful video for us the create the sheet using QR doces.
Glad it was helpful!
Well explained and it's work fine 100% thank you for your efforts ❤
Glad it helped
Just amazing sir 💪
GREAT KUDOS Math Masters ... Thanks!!!
all in ONE GOOGLE indeed
Glad it was helpful!
think you for the new updated video and files its a it grate what you do thank you
You are very welcome
Brilliant. Thankyou
Thanks for the Clarity Brother
Any time
@@HashAliNZ Sure I will ask
Once again Thanks Brother
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
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!
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!
great video; i m wondering if the in and out time could be implemented thank you
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?
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.
Excellent video and very easy to follow
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
Excellent Informative Videos, & Very nice person I have ever seen in my life. Thank you again TheMathLab NZ...😊
My pleasure!
Subscribed. Thanks for this new knowledge
Awesome, thank you!
Hello, I really liked your video, I'm one of your subscribers too, this update is so smooth and well explained. Thank you very much for the sharing of knowledge. By the way, is it a way to create data, for instance, if I, as a teacher take down the attendance every single day, and wanted to gather all the information by month, or by year, what should I do?
Short answer: That's absolutely doable!
Long answer: You're going to have to figure out the specifics of what you want to show/look at in your data. Do you want number of scans per month/year? That's the easiest.
Do you want the number of non-duplicated scans each month/year? That's a bit tougher.
Do you want to be able to select the student and a date range? Definitely doable but might take an extra hour or three to set up.
Let me know what ideas you have and I'll see what I can come up with!
@@HashAliNZ Hello Sir, Hope you are well, Thank you once again for your video. So sorry, I didn't realize that you answered back...
What I really need exactly is to be able to know " to and also want to know "
@@mouhamadouelaminendiaye1150 Hi Mouhamadou! Sorry, I think there might have been some error with your reply. Let me know what you want to happen and we'll figure out how to do it. Thanks!
sophisticated tutorial . Thanks
So nice of you
Great Video...Very Helpful...expect more like this...thanks ...Subscribed
Thanks for the sub!
Gracias! Me sirvió mucho!!
You're very welcome, Lucas!
Excellent job 👍🏼👍🏼👍🏼
Thanks!
Thanks a lot. Great video.
Thanks Kazi!
this is SO GREAT!!! new subscriber here!!! and i liked your video so i can go bank to it anytime!!!
Awesome! Thank you!
simply amazing, pls share with us creating vcard qr code. thanks again
Do you mean something like this? imgur.com/a/hUtBXXd
Thank you for a great tutorial please make a 2nd video for the end of the class time recorder
Will do! It's in the works! Me and my baby are just a bit sick at the moment. Will make it once I'm up and running again!
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!
Thank you!!
Happy to help!
Great video, looks like you are master of Google products. Thank you for sharing.
Thanks for watching!
Many thanks ♥
love it thanks man
Thanks!
Thank you so much 🙏
You're welcome 😊
this is very helpful thamks
You're very welcome!
Thank you so much! :)
Glad it helped!
Good effort! love it
Thanks a lot!
Dill Pickles haha. I love your subtle humor.
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.
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
I looked at your methods. They are very good and can learn a lot. Thank you.
Everything related to this video of yours has been done properly.
I want to know how to send the QR code you made in Excel to the relevant students. I look forward to your kind reply.
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?)
Excellent bro 👌👍👍👍
Thank you so much 😀
THANK YOU BROTHER!
You're welcome!