Attendance Tracker // Automated Attendance Tracker using Google Form and QR Code 2022

[@lisandrariveraramos5889]

I AM A NEW TEACHER AND I AM SO THANKFUL TO GOD THAT I FOUND YOU!! BLESSINGS TO YOU AND YOUR FAMILY! I JUST DID MY FIRST GOOGLE FORM FOR ATTENDANCE! THANK YOU!!!! :)

[@MrsPTarleton]

@lisa welcome to the fun world of teaching. So glad you found this helpful. Thank you for the blessings. Blessings to you and yours also.

[@nguyenphongvo9092]

First of all, thank you for your useful instructions, I have a question regarding this QR code attendance tracker: 1) Do we have to create a new link for every new lessons (because if we use the same QR code for future lessons, there might be too much overlapping data of the responses) 2) In case we use the same form and QR code throughout all classes, is there anyway to seperate the responses based on dates (because the class will take place on multiple dates)? Thank you so much in advance!

[@MrsPTarleton]

@nguyenphongvo Thank you for watching. All entry are time and date stamped in the spread sheet so you can easily see when the person logged in. You could change QR code for each class if that helps you feel more comfortable.

[@jenniferlewis3895]

Great tips! Anything to make attendance go more quickly! BUT - if I post it on Google Classroom, is there a way to keep them from completing the form if they're not actually in class? The QR code involves their phones, which we're trying to do away with.

[@MrsPTarleton]

@jenniferlewis3895 I've tried posting QR code in class, so they have to scan in person, but I still get the occasional slick one who has a picture of it that they scan from home. That's why I count to be sure the same number checking in are also in class. Cell phones are a constant battle. We have a no cell policy also, and I have them put away after they check in. Most comply. I already had to use the behavior tracker because after multiple warnings about cell to class there was one who insisted on sneaking it out. Luckily I just made a copy of last year's and made a couple edits.

[@cristinaiftode9421]

@@MrsPTarleton Sharing QR images with absent students concerns me too. Hopefully, not too many present students are helping their pals cheat like this.

[@PescesKitchen]

What about tracking students that aren’t in class? How do you go about that. I have 43 kids per class.

[@MrsPTarleton]

@PescesKitchen You can do a Vlookup which would probably be the best way to mark absent students.

[@Niknou11]

I have a few questions was trying to do something like this for our bus monitors , to scan the kids school ID (which already has a barcode) when they get on the bus and scan it when they get off, and then look at the google sheet to show , well little johnny never sign out he must fell asleep on the bus... so more like a sign in/sign out google sheet?? any suggestions >

[@MrsPTarleton]

I'm not sure how you could scan the barcode. I'm wondering if the students can enter their student ID number as the entered and exited. Would that work?

[@marlonyoingco]

Very useful thank you for making this video. 👏👏👏

[@MrsPTarleton]

@marlonyoingco Thank you for watching and sharing your positive feedback...I appreciate you.

[@mohamedali-tx4sb]

Please tell me if I setup in mobile fake gps program This form will read which location ?

[@MrsPTarleton]

@mohamed not sure I completely understand your question. If you are asking if it will show person logging in location, I do not believe it would.

[@ariahkali7392]

Does this work even if for example we do not have internet connection for that specific day?

[@MrsPTarleton]

@ariahkali7392 Unfortunately, Google Forms is cloud based and needs internet to work. My students all seem to have cells so I'd have them do that if ok with parents, and I'd log in the 1 or 2 who do not have cells.

[@SanjayKapoorDelhi]

Brilliant!! Thank you

[@MrsPTarleton]

@Sanjay Thank you. So glad you enjoyed.

[@KristofferFrey]

great turtorial😊 Thanks! is their a easy way to see who is missing in class in Google sheets??. I have over 100 student in a week in different class’. I need a quick view who i have to follow up on- thx🙏

[@MrsPTarleton]

@kristoffer You could do conditional formatting to color code Google Sheets to help you see who is absent. Or another option is to sort the sheet based on who is absent.

[@PescesKitchen]

I’m looking for the same. No response yet. I have 260 per day day. I think this is great; but not being able to track who isn’t in class will make this form incomplete

[@PescesKitchen]

@@MrsPTarletonhow do you do this?

[@MrsPTarleton]

@PescesKitchen you need to set up conditional formatting which is ki d of clunky or a V look up and it will show you who is absent.

[@muhdfurqan7157]

Thanks a lot, this is super helpful,

[@MrsPTarleton]

You are so welcome. I'm so glad I could help.

[@thefandomrealm]

So you just log the entire year of attendance in the same sheet.?

[@MrsPTarleton]

@thefandom I generally do it by month. Less data to sift through. I just make sure to name them so I can easily find them.

[@AvelaDudula]

thank you, this is very helpful

[@MrsPTarleton]

@AvelaDudula Thank you for watching and commenting. Put a smile on my face. Glad it's helpful.

[@candicefreedman1249]

Also, if I'm already using GSheets for our existing rosters can I use those instead of creating a new form?

[@MrsPTarleton]

Yes, when you create your sheet you can choose to gather data in new sheet or existing sheet.

[@katgillang]

Do you create a new form every day? Then is there a new QR for each one?

[@MrsPTarleton]

@KatGillang you could use a new QR code each day but you do not have to. The form allows for multiple responses and tracks them showing exact date and time student checked in.

[@oceanphang7494]

thank you so much.. you have made my difficult stuff become easy

[@MrsPTarleton]

Thank you for watching. I am so happy that my video was selected to make difficult things easy. Will you be using this in a traditional classroom? Or for something else?

[@Zeek-Tomo]

I don't understand how this helps with attendance. It seems that with this system I will have a spreadsheet telling me who came to class at what time. But I need to know who did not come to class. So next I would have to check this spreadsheet against a full list of students to determine who did not come. Hence, I believe it would be simpler and faster simply to call roll and mark the absent students as I go. Is there something I have missed about this? If not, does anyone know of an app where I can enter the full class list, and then use a QR code in a similar way as described here, but whereby I can see who did not attend? Thanks in advance.

[@MrsPTarleton]

@daniel for me I sort students by name and period, so it's a quick glance down my roster to see who is missing. You've got me thinking of ways to get the absent students highlighted. I've got some ideas I'll need to try. Thank you for the feedback.

[@MrsPTarleton]

@daniel I've looked into this and the easiest way to do what you are asking is with a VLOOKUP it will be time consuming to set up for 180+ days of school but you'd be able to use it year after year.

[@alexaraya2018]

I tried it but It didn´t save a google sheets spread sheet, does anyone know why?

[@MrsPTarleton]

Under responses click the green icon (sheets) top right to create spreadsheet for data gathered. Hope that answered your question. If I misunderstood let me know and I'll definitely try to help figure it out.

[@dons0308]

Can i use this for everyday attendance or i should create everyday?

[@MrsPTarleton]

You can use it daily as there is a time stamp for each entry. You may want to make a separate one for each week or month depending on the size of your classes and label them with the date range to easily organize.

[@BillM-q7v]

Do I have to change the QR code daily? I tried using the QR code 2-3 times today and it said my attendance was already submitted.

[@MrsPTarleton]

allow multiple responses should fix that

[@cristinaiftode9421]

@@MrsPTarleton I'd like to create a new QR code for each class meeting. Will they be able to use a previous QR code to sign in for the current day's attendance?

[@cristinaiftode9421]

I verified and any of the previous QR codes can be used to sign in the same form used to generate the codes, if multiple answers are allowed. So there is really no justification to create one new QR code for each class meeting, unless the codes are linked to new forms (one per class meeting) with the requirement of 1 response only per form.

[@MrsPTarleton]

@@cristinaiftode9421 Thank you for checking into that.

[@candicefreedman1249]

Is there a way for the teachers to have the QR code on their mobile device as well as printed out in the classroom?

[@MrsPTarleton]

Yes, you could easily have a screenshot of QR code on your mobile device.

[@dons0308]

How to include time in and time out?

[@MrsPTarleton]

Time in is listed on the spreadsheet on the far left. To get time out you'd have to enter a separate question for them to also sign out.

[@lisadunni8892]

tqvm.

[@MrsPTarleton]

@lisadunni8892 you are welcome, glad I could help.