Listen! There are so many other videos that are so long, and drawn on out! However, this is one of the best videos that I have ever seen! Straight to the point, and the video does and says exactly what it needs to be done.
I just wasted 43 minutes watching multiple you tube videos that made no sense until I reached yours. Clear directions, visuals, easy to follow. Thank you! I will contact you if I have further questions that arise.
Finally a U Tube channel by an educated Pakistani. I am a retired teacher and I firmly believe on the use of modern day technology in education. I myself is learning a lot from you and referring your channel to other people known to me, especially the young teachers.
This is a wonderful tutorial. I have been searching for an attendance option that will simply the process for me as I have over 300 middle school students to keep track of. Thank you for the information; much appreciated.
Hi! Thanks for this, but i was hoping if you could help me know who (from a list of expected responders) did not respond to a survey in google form from a specific date?
Hi MaryJane! For a specific date, there are two things you can do. Within Forms, you can go to the responses section and sort by the Date to see the responses on each day. Second, you can go to the Sheets link that this generates, and filter the form by that date. Then, sort by the name of the students and you should know who has not submitted on a specific day. I have a more detailed video on response sorting if you are interested: ruclips.net/video/ZRLgAp0u9Tg/видео.html. If you have any questions, let me know and thank you for watching!
Hello, I'm a teacher. I use Google Forms every day for parent pick- up. I need to keep all past info saved. However 300 answers later I want to start a new sheet without losing answers. How do I keep all the information in the same Google sheet but just on a new tab going forward? Thank you, Teresa
Hi Teresa! Since it is necessary for you to keep the replies, you basically have two options. The first is to edit your existing worksheet-so you can hide the current cells up to row 300, and then the worksheet will look fresh the next time you access it. To hide cells, select all the rows you wish to hide, Right click, and click “Hide Rows.” This will of course mean you have 300 hidden rows. A way to keep the data *separate,* however, is to unlink the form, delete all responses from the Form [this will not delete them from the Spreadsheet, but instead just restart count on the form itself], and then link the form again to a new Google Sheet. Step by step instructions for this are on a blog I found that I am including here: wafflebytes.blogspot.com/2016/09/google-reset-form-for-reuse-with-new.html. Hope that helps and thank you for watching Teresa! Let me know how it goes :)
This is very helpful. I have been struggling recording the attendance. Really like your tutorial as it gives clear direction and really easy to follow. Thanks a lot.
Glad to hear Khadijah! Hope it proves useful to you and best of luck! I know teaching is extremely overwhelming in these times, although I guess teachers have to be used to being overwhelmed haha. :)
Awesome job presenting, I know you are a phenomenal teacher from this video. Is it possible to add them manually incase they forget to sign in, but I know they were there?
Hi Oscar! Thank you for your kind comments. Yes, you can manually input them. You can input them directly on the Google Sheet or the option I recommend-click on the link you sent them to fill out, and just fill out the form as if you were one of the students. That will still show a submission, and you can do it without messing with the Sheets file that has all your data. Thanks for watching and commenting Oscar!
I truly appreciate it Oliver! Wishing you all the best for the new year and feel free to reach out with a new comment if you ever have any questions! (I don’t always get notifications for replies to earlier comments) :)
Thank you so helpful I was going to ask if I can have the from create a new sheet daily within the responses workbook, but I guess with the filters that won't be an issue! Thanks!
Thanks very much, Abdul for such a nice video. Just one thing I want to ask. So say you take attendance for 1 month and each class have say, 60 students. Is there any function that would count how many days the student was absent?
Hi Bhavin! Glad you found it helpful! So the function I use is the “CountIF” function with the student’s name. So for a student named Andy, it would be something like =COUNTIF(A2:B60, “Andy”) which would calculate how many times he is present. To get the number absent, you would just subtract that from the total days of attendance. So for a 30 day cycle, it could be something like =30-(COUNTIF(A2:b60, “Andy”)). I have another video where I sort out some formulas if you would be interested. ruclips.net/video/ZRLgAp0u9Tg/видео.html. Thanks for watching Bhavin!
Welcome! I would like to ask for your help, unfortunately the question is not simple: I would like to be able to apply for trainings in several languages, for example, can only one e-mail address be set? And is it going to apply in all languages? Is there a way to set up multiple email addresses? So everyone can write / apply through the same Google Form, but e.g. if you write in German, will the letter go to a given mailing address, if you write in English or Spanish, can you send mail to another mailing address or even to several mailing addresses in one language? Is there an exact description of this somewhere? Thank you very much for your answer, your help in advance!
Hi József! Thank you for watching! So, if I understand your question correctly, you wish to collect responses from multiple sources in Multiple Languages, correct? I did not find a video with this, but there are two ways you can do this. The first, as you mentioned, is to make multiple Google addresses and make forms in each language. As a result, each email address will only receive the results from its language. The other option , which will result in all responses in ONE place and can be filtered, is to create a form with multiple SECTIONS. You can make a drop down question in the start that says "Select Language" and then based on the answer, the person can be jumped to the section you have created in English, Spanish, etc. That will allow you to make ONE lengthy form in multiple languages, and people can pick based on what language they use. Would you be interested in that? I can provide further info if you would like. Thanks for watching József!
As a teacher, Is it possible for me to take the attendance of my class for the whole month in a single sheet using Google Forms. Students names in rows and dates in columns with either P or A entered into respective cells for "Present" and "Absent"
Hi Venu! Yes-you can format it that way but you will have to do it manually. The Google Sheet will only capture subsequent student responses vertically-meaning one row for each response. To make them each where it is only one row for the student and all their responses appear in a line, you would have to take that month-long sheet of answers, and copy and paste each individual student’s answers into their row. Hope that helps and thank you for watching!
i look for a way to relate a form which auto-appear everyday (workday) to fill a sheet for a months or even a year (or unlimitited), NOT just a single sheet every form made. And that form only can fill with the correct student ID in classroom ( email address). Maybe its gonna be like a script-form to fill a cell which relate to email and date in a google sheet. For the attendance , now i prefer using an ungraded-assignment, then i use "gear" icon-menu at the assigment to save it as csv, and then copy it (just the completion column) to my attendance collector sheet in excel. Its more simple and easier for student, since they just need to click the submit button. And not necessarily worrying about date like if using google form. But it has to be done every day and I have to delete the task because it's going too messy.
Hi Siput! I completely see your point; that's why I use the system of keeping one link as I showed in the video above--it allows me to re-share the link every day and all the responses go into one sheet. It's a bit of a hassle counting all of them (a lot of filtering required) but at least all responses go on one sheet. But yes--I totally see your point and I have several colleagues who are also preferring the daily ungraded assignment for attendance. Some of them even make it fun (like asking students if they prefer pizza or pasta!) Thanks for watching and sharing your method as well Siput! :)
HI Juhi! You can use the same link every time as long as you are fine with all responses going to the same Form and Sheet. I personally used the same Sheet all year, keeping it organized by date and student name so I knew who was signing in. Thanks for watching and commenting Juhi!
@@PakistaniPepper this is really sweet and short. i have one doubt .... can student again fill with the same link on next day? may be it will say that your response is recorded?? is it possible??
@@harshavardhansingh1749 Hi Harshavardhan! Yes--students can use the same link to fill it out as many times as needed. It will always say something like "click here to submit another response" at the end. Each response will have its own timestamp, so you will know when the student submitted it. Thanks for watching! :)
Hello Abdul, Thank you for the tutorial. Maybe you know if there any way to use numbers of days that your students filled in to represent their attendance on calendar which was also created in spreadsheets?
Good evening! Thank you for your kind words. My apologies as I'm not too familiar with using a calendar in Sheets. The only way I can think of is perhaps you could sort by day, and then paste the attendance at the end of each day into the Calendar? The functions I know are mostly with standard Sheets files so not too familiar with calendars. Please let me know if I can help with anything when you attempt it and wish you the best! Thank you for watching!
Hi! Sorry I just saw a notification about your other comment! Unfortunately, it doesn't let me expand the full comment because my YT marks comments with emails as spam for some reason and I can't seem to figure out how to turn it off. If you still have any questions, you can send them to me on the email in my about page on the channel (if I put the email here, it might mark it as spam again). Happy to help!
Do I need to create seperate forms if I want spreadsheets for each class? Also, on the form do I need to keep the box under presentation, show link to submit another response, checked? Thanks this is great.
Hi Sherri! Thank you for kind comments; glad you found it helpful. Yes-you will need separate forms to keep separate spreadsheets for each class. Also, you can leave the “show link to submit another response” unchecked; in my opinion, it’s not necessary for this type of form because students don’t immediately need to submit another right after they have submitted it once (as they should only be doing it once a day). Just make sure to allow people to submit multiple responses, as they will be answering on the same link/form multiple times. Do let me know if you have any other questions and thank you for watching and commenting Sherri!
Hi! Google Forms automatically collects the time someone submits the form-you will see it in the first column when you look at your results, and by default, that is how the Sheet will be sorted. You can choose to sort it by time stamp again by just clicking Sort By after selecting the column. Do let me know if you have any questions and thank you for watching! :)
I have a question sir !!!! I am having online classes in zoom and they send the google form for attendence at specific time. Now, if i am not in the class for some reasons and my friends share me the link inmediately and I fill it at the same time from outside the class will it be valid ?? Pls reply.....
Hi Hatake! So yes, if the attendance is in Google Form it doesn’t matter whether you are in the zoom or not. Although your teacher might notice you’re not there if there are not too many students and I always recommend popping into class to learn :)
Salaam Muhammad! Click on the Settings button (gear icon on the top right). Then, find where it says, "Requires sign in." Below that, there is a checkbox that says, "Limit to 1 response. Respondents will be required to sign in to Google." Make sure that checkbox is NOT CHECKED. If it is not checked, they will be able to submit multiple answers with the same form link, no matter how many times you share it. Thanks!
Hello , i'm a teacher . I want to make the daily attendance sheet using excel in combining with the class log(different period) in order to record attendance for students and want to link to the google drive so that every class teacher and subject teacher can access the attendance and update accordingly. But i don't know how to proceed properly. I would be grateful if sir could give me few suggestion and guidelines. Thank you.
Hi Chimi! Doing a single sheet for every teacher in a school might be a bit cumbersome, as that would mean a lot of responses. I would recommend doing only one sheet per teacher, and I would set that up as a simple form. If the students are signing in to their own attendance, you can just have each teacher create a form like one above, and share with the students. If you want teachers to take the attendance, I would recommend a form with the following questions (in the parentheses I'll include the type of question you want to give): Date, Period (let the teacher list the period they are taking attendance for) and then a checklist with all the students from that section. The teacher can check (present) or uncheck (not present) and fill this out for each subject. This would require the teacher know their full roster. Again, if you want to do it schoolwide, I would recommend students also have a question with "Teacher Name" and "Teacher Period" or else it can get really difficult to filter that many responses. Hope that makes some sense and please let me know if you have any questions! Abdul
Hi Abdul. Am not able to use the form in same date for different subject. can you please show me how can I use the form in same date for different subject?
Hi! If I understand correctly, Forms doesn't show up on your main page? It doesn't always appear in the default apps--have you tried typing in manually forms.google.com? Thanks for watching and commenting!
Hi Mark! Unfortunately, built into Google Forms, that is not an option. I read online that you can use a script called “Form Ranger,” but to me personally, it seemed like more trouble setting it up. For that reason, you might be better off just letting the students know not to enter future dates, or even just getting rid of the date-it would then only show you the time stamp when the student submits the form, and you can still see what date they submitted it with that. Hope that helps and thank you for watching Mark! :)
Hi Carmella! Yes! The timestamp does appear on Google Sheets! It’s the first category and will be automatically generated by Google Forms. Hope that helps; thank you for watching!
Can I create a google form for each teacher and class period with their students marked present already? That way they just would have to mark only the student absent.
Hi! Yes you can. Basically, you can design the form however you wish. In my opinion, the easiest would be a Checkbox Grid where you have each Row as a different student and columns with Present and Absent. Then, you can prefill the form (instructions here: support.google.com/a/users/answer/9308781?hl=en) so that each of the students are marked present by default and then send that prefilled link to teachers. Then teachers would just have to fill who was absent, and they can either submit the form or just mark the correct kids absent and email you a PDF of their responses. Hope that helps and do let me know if you have any questions!
Hi! Yes! You can add a question about "time in" or "time out," then share the same link and it will capture people's time out as well! Use the timestamps from the time out entry to see when they timed out :) Thanks for watching!
Sir You mentioned about having one response for one day but how is it done..can you please educate me on that as I am a teacher too and I am dealing with this problem. Note: I use android phone
Hi Najmus-happy to help. So, let’s take it one step at a time. 1) Look at 4:05 in the video. Notice how I clicked on “Send” to get a link. 2) That link is what I need to send to students so they can fill out the form I have created. 3) I can send this link via email, Google Classroom, etc.-whatever system I use to communicate with students. 4) Clicking on this link allows students to fill out the form. 5) I count each time the student fills the form as one entry of attendance (each fill has the date and time, so I know when they filled it out). 6) So the student clicks on the form on January 1, and then fills it out. 7) I go to the Responses page on the form to check his response (see 5:48 in the video). I now know that is his attendance for January 1st because his response has date and time. 8) On January 2nd, the student clicks on the SAME link and fills it out. That is his attendance for January 2nd and I know it is his attendance for January 2nd because it has the date and time. That is why students need to fill out the form every day, and they can do it on their computer or their Android phone as well. Does that clarify things? Do let me know if you have any questions and thank you for watching Najmus!
Hi Mrs. Khalid! You would basically have to filter by student (select the top row, and then click the Filter button). Then, when you have filtered only that student for the month, go to any column, select all entries, and in a new cell, enter the formular "=COUNT(range)," with the range being the cells. Hope that helps and thank you for watching Mrs. Khalid! :)
Happy to, Mrs. Khalid! I have a lot of work after school tomorrow but will hopefully be able to do it on Wednesday or Thursday; will share the link with you then :)
Hi Mrs Khalid-I just wanted to let you know I haven’t forgotten about your request. School has just been really busy so it’’s been a bit difficult. But I will work on your request this weekend and get the video up as soon as possible. Sorry for the wait!
Hi! Thank you for watching! An easy QR code generator that I have used in the past is Bitly. So what I would recommend is first make a Google Form attendance you are comfortable with (for example, like the one in the video) and then you can follow the steps on the Bitly blog to generate a QR code here: support.bitly.com/hc/en-us/articles/360030557072-How-do-I-create-a-QR-Code-in-Bitly- This will allow you to create a QR code that takes people right to your form. Please let me know if you have any questions and I would be happy to help out! :)
سلام. کیسے ہیں آپ. میری مشکل ھے. وہ یہ کہ. میری کلاسیں اکتوبر میں غلطی سے میں نے آن لائن پڑھایا. اپنی کلاس کو. لیکن ھم کو پابند کیا گیا تھا کہ ھم صرف ویڈیو رکاڈ کر کے ٹیمیز میں اپنی کلاس میں بھیج دیں. بچے خود سے دیکھیں گے. خیر میں نے پندرہ دن تک آن لائن پر پڑھایا. جو ممنوع تھا. پھر میں ویڈیو بنا کر بھیجا. لیکن میں ان طالب علموں کی حاضری لینا بھول گئ. 4،10،2020 سے لے کر 13،1،2021 کی حاضری چاہیے. خدارا بتانا کہ یہ کیسے میں یہ لے سکتی ھوں
Hi Afsheen! My apologies for the late reply. If you want students to fill in attendance from several days (or months), you will have to ask them to fill out the Google Form multiple times. Each time, the students will have to pick a different date for the question that says "date." That way, your records will demonstrate attendance for each of those days, for each time they fill out the form. So you would say they have to fill out the form once every school day from 10-4-2020 to 13-1-2021. Then, as I showed in the video, you can sort by date or name and get all of the responses. Please let me know if you have any questions and I understood your question; my apologies as my Urdu is a little bit weak.
Hi! Yes--you can definitely use it to both clock in and clock out without having to create two forms. Just make one form and make one of the questions, "are you using this to clock in our clock out," then make it multiple choice or dropdown and make one of the options Clock In and one of the options Clock Out. That will keep it all in the same link and when you receive responses, you can filter by Clock in and Clock out. Hope that helps and thank you for watching! :)
@@PakistaniPepper tq for your reply... Currently im using 2 checkboxs in my question which is one for clockin and the other is clockout. The user will choose either one and just click submit after that. The problem is when it comes to csv report. Once user clockin, the data will create new row, then clockout is also create a new row. So i can't calculate how many hours the user was worked on that day.. Cause the timestamp for clockin & clockout stack under one column. Im not sure excel will allow us to calculate in column. Any advice for this? Hope u understand. . 😁
Happy to help I think I understand--so there are two different submissions, with two different columns. One has a time stamped punch in and the other has a time-stamped punch out. Would it work for you to create a new column with the function =(Cell 2 - Cell 1), where Cell 2 is punch out time and Cell 1 is Punch In time?
Yes. Cell 2 - Cell 1 is my plan. But both of it is currently in the same column. Can we make a formula to calculate item in the same column in excel? For eg: B2-B3. Imagine i have a thousands of rows to calculate.
I see your point. I think sadly, I think that is the way it will have to be: B2-B3, with quite a bit of playing with the cells because after multiple submissions, the cells might not even line up as cleanly. I am asking my tech friend what he does; if he tells me anything useful, I will definitely share with you :)
How can I maintain one month's of class attendance in one attendance sheet.because every i make new.forms for students. if I give them same link every day is their any problem for particular one class?
Hi Priyanka! It's not a problem but it does require some organizing. Basically, as long as you're using one form and one link, all the responses go to the same Google Sheet. Therefore, you need to set tabs for each class, and filter and organize the responses. I made a more detailed video on how to do that here, that I'll link at the end of this message. Do let me know if you have any questions and thank you for watching Priyanka! ruclips.net/video/ZRLgAp0u9Tg/видео.html
Hi again Debora! Yeah--that's just an additional step I take because I like having a "clean" date to sort with--the timestamp has too much information and doesn't look the cleanest to me. But yes--it's just an additional date on top of the timestamp so unnecessary. Thanks for watching and commenting Debora!
Hi Gayathri! In order to make sure they are required to use their email, notice how in the video above at 1:54, I made sure "Collect Email Addresses" was checked in settings. This forces the user to login before they can respond and the system will automatically collect their email address. That also helps with issues of security because then only the person using that email can fill in responses, and you can always see the email in your list of responses. Hope that helps and thank you for watching and commenting Gayathri!
Hi Sara! Yes! I am using the same link as well. In that case, the most important thing is to make sure you have one question about WHICH class. That way, when you open the responses, you can filter via class rather than having all the students in one big block all the time. Otherwise, the sheer amount of students will become overwhelming very quickly. Thank you for watching! :)
Hi Debora! You can totally keep it separate; I just like them all together because then I am only referring to one file (and I can filter via Periods). But I know for some, it is definitely more straightforward to just have separate links. Thank you for watching and commenting! :)
Hi Jo! I share the same link with my class every day, and make sure there is a required question for "date." That way, I know when and what day they are submitting for every single day. Hope that helps and do let me know if you have any questions! :)
Hi Romika! Yep! I shared the same link with my students every day and with each submission, I made sure they were required to fill out the question for date--that way, I always knew what day they were submitting it for and it all came into one file so I could edit as I needed. Thanks for watching and do let me know if you have any questions! :)
There is a simpler method i use where i easily export all the attendence to MS Excel for record keeping and submission. Wish i had to time and skill to make an instructional video for fellow teachers to see.
That's a great idea Mikael! I think if you can share it, it would benefit a lot of teachers. If you have any questions on how to set up recording, feel free to ask and thanks for watching and sharing!
Hi Sankar! Tracking who hasn't attended is a bit trickier! Since someone would not be signing themselves in as present, the only way to note that is as the teacher. So I like to create a form with my entire roster, and then just add one checkbox of "Absent." Then I just click off the ones who are Absent, and note that in the responses. Hope that helps and let me know if you have any questions!
Hi Durgesh! You can trace absent students by doing a "COUNTIF" function where it says the student's name "COUNTIF(Student)." That will let you know how many times they are there. If you want to take attendance on your own, you can make a form that has the daily date and then a checklist of each student. That way, you can check off which students are present each day, and easily also trace which are absent. Let me know if you have any questions and thank you for watching!
Hi Frazia! You can add a question that just asks for email. Or, the option I like more: go to Settings on the top right, and click "Collect Email Addresses." that will require an email for submission and automatically record it :)
Haha that is definitely a risk! That's why I always recommend being very careful about watching students and comparing with the form! Thanks for watching David!
Listen! There are so many other videos that are so long, and drawn on out! However, this is one of the best videos that I have ever seen! Straight to the point, and the video does and says exactly what it needs to be done.
I really appreciate your kind words Jared! Glad you found it helpful.
I just wasted 43 minutes watching multiple you tube videos that made no sense until I reached yours. Clear directions, visuals, easy to follow. Thank you! I will contact you if I have further questions that arise.
Thank you for your kind words Joanne and I'm glad you found it helpful. Happy to help and wish you all the best!
BEST VIDEO FOR TAKING VIRTUAL ATTENDANCE! Clear, and simple! Thanks!
Thank you Joanna! I truly appreciate your kind comment and wish you all the best! 😁
Finally a U Tube channel by an educated Pakistani.
I am a retired teacher and I firmly believe on the use of modern day technology in education. I myself is learning a lot from you and referring your channel to other people known to me, especially the young teachers.
Glad you enjoyed it Riaz! Thank you for watching and do let me know if you have any questions!
This is a wonderful tutorial. I have been searching for an attendance option that will simply the process for me as I have over 300 middle school students to keep track of. Thank you for the information; much appreciated.
My pleasure Rachelle! Glad it was helpful and best of luck with the school year! :)
This was such a good video. It was brief and clear. Thank you.
Glad it was helpful! I really appreciate your kinds comments; thank you.
Hi! Thanks for this, but i was hoping if you could help me know who (from a list of expected responders) did not respond to a survey in google form from a specific date?
Hi MaryJane! For a specific date, there are two things you can do. Within Forms, you can go to the responses section and sort by the Date to see the responses on each day. Second, you can go to the Sheets link that this generates, and filter the form by that date. Then, sort by the name of the students and you should know who has not submitted on a specific day. I have a more detailed video on response sorting if you are interested: ruclips.net/video/ZRLgAp0u9Tg/видео.html. If you have any questions, let me know and thank you for watching!
Hello, I'm a teacher. I use Google Forms every day for parent pick- up. I need to keep all past info saved. However 300 answers later I want to start a new sheet without losing answers. How do I keep all the information in the same Google sheet but just on a new tab going forward? Thank you, Teresa
Hi Teresa! Since it is necessary for you to keep the replies, you basically have two options. The first is to edit your existing worksheet-so you can hide the current cells up to row 300, and then the worksheet will look fresh the next time you access it. To hide cells, select all the rows you wish to hide, Right click, and click “Hide Rows.” This will of course mean you have 300 hidden rows. A way to keep the data *separate,* however, is to unlink the form, delete all responses from the Form [this will not delete them from the Spreadsheet, but instead just restart count on the form itself], and then link the form again to a new Google Sheet. Step by step instructions for this are on a blog I found that I am including here: wafflebytes.blogspot.com/2016/09/google-reset-form-for-reuse-with-new.html. Hope that helps and thank you for watching Teresa! Let me know how it goes :)
Sir thank you so much, it is very much useful with a clear explanation in an easy way, once again thank you
Thank you Swapna! I am glad you found it helpful! Wishing you well!
This is very helpful. I have been struggling recording the attendance. Really like your tutorial as it gives clear direction and really easy to follow. Thanks a lot.
Glad to hear Khadijah! Hope it proves useful to you and best of luck! I know teaching is extremely overwhelming in these times, although I guess teachers have to be used to being overwhelmed haha. :)
Very Useful. Great job and easy to follow.
Much appreciated Wayne! Glad it was helpful! :)
It is an amazing video. Thanks for making remote learning so effective, efficient and user friendly!
Thank you Aaron! Glad you liked it :)
Abdul Rehman Siddiqui of course
Awesome job presenting, I know you are a phenomenal teacher from this video. Is it possible to add them manually incase they forget to sign in, but I know they were there?
Hi Oscar! Thank you for your kind comments. Yes, you can manually input them. You can input them directly on the Google Sheet or the option I recommend-click on the link you sent them to fill out, and just fill out the form as if you were one of the students. That will still show a submission, and you can do it without messing with the Sheets file that has all your data. Thanks for watching and commenting Oscar!
@@PakistaniPepper thank you for replying, you earned a subscriber. My administrators and myself thank you! haha
I truly appreciate it Oliver! Wishing you all the best for the new year and feel free to reach out with a new comment if you ever have any questions! (I don’t always get notifications for replies to earlier comments) :)
Thank you so helpful I was going to ask if I can have the from create a new sheet daily within the responses workbook, but I guess with the filters that won't be an issue! Thanks!
You're very welcome Jennifer! I'm glad you found it helpful and thank you for your kind words!
Thanks very much, Abdul for such a nice video. Just one thing I want to ask. So say you take attendance for 1 month and each class have say, 60 students. Is there any function that would count how many days the student was absent?
Hi Bhavin! Glad you found it helpful! So the function I use is the “CountIF” function with the student’s name. So for a student named Andy, it would be something like =COUNTIF(A2:B60, “Andy”) which would calculate how many times he is present. To get the number absent, you would just subtract that from the total days of attendance. So for a 30 day cycle, it could be something like =30-(COUNTIF(A2:b60, “Andy”)). I have another video where I sort out some formulas if you would be interested. ruclips.net/video/ZRLgAp0u9Tg/видео.html. Thanks for watching Bhavin!
@@PakistaniPepper Thanks a lot Abdul. That was very informative. Continue a wonderful work.
Thanks a million. Take respect from Bangladesh.
Thank you! Glad you found it helpful :)
I so wish I had seen this prior to the end of the school year. Lovely video regardless.
Thank you so much Kamele! Have a wonderful summer break! :)
Welcome! I would like to ask for your help, unfortunately the question is not simple: I would like to be able to apply for trainings in several languages, for example, can only one e-mail address be set? And is it going to apply in all languages? Is there a way to set up multiple email addresses? So everyone can write / apply through the same Google Form, but e.g. if you write in German, will the letter go to a given mailing address, if you write in English or Spanish, can you send mail to another mailing address or even to several mailing addresses in one language? Is there an exact description of this somewhere? Thank you very much for your answer, your help in advance!
Hi József! Thank you for watching! So, if I understand your question correctly, you wish to collect responses from multiple sources in Multiple Languages, correct? I did not find a video with this, but there are two ways you can do this. The first, as you mentioned, is to make multiple Google addresses and make forms in each language. As a result, each email address will only receive the results from its language. The other option , which will result in all responses in ONE place and can be filtered, is to create a form with multiple SECTIONS. You can make a drop down question in the start that says "Select Language" and then based on the answer, the person can be jumped to the section you have created in English, Spanish, etc. That will allow you to make ONE lengthy form in multiple languages, and people can pick based on what language they use. Would you be interested in that? I can provide further info if you would like. Thanks for watching József!
As a teacher, Is it possible for me to take the attendance of my class for the whole month in a single sheet using Google Forms. Students names in rows and dates in columns with either P or A entered into respective cells for "Present" and "Absent"
Hi Venu! Yes-you can format it that way but you will have to do it manually. The Google Sheet will only capture subsequent student responses vertically-meaning one row for each response. To make them each where it is only one row for the student and all their responses appear in a line, you would have to take that month-long sheet of answers, and copy and paste each individual student’s answers into their row. Hope that helps and thank you for watching!
Thank you so much Sir..I use this for my talk today..God Bless..
You're very welcome Rolando! Glad you found it helpful and wish you all the best! :)
i look for a way to relate a form which auto-appear everyday (workday) to fill a sheet for a months or even a year (or unlimitited), NOT just a single sheet every form made. And that form only can fill with the correct student ID in classroom ( email address). Maybe its gonna be like a script-form to fill a cell which relate to email and date in a google sheet.
For the attendance , now i prefer using an ungraded-assignment, then i use "gear" icon-menu at the assigment to save it as csv, and then copy it (just the completion column) to my attendance collector sheet in excel. Its more simple and easier for student, since they just need to click the submit button. And not necessarily worrying about date like if using google form.
But it has to be done every day and I have to delete the task because it's going too messy.
Hi Siput! I completely see your point; that's why I use the system of keeping one link as I showed in the video above--it allows me to re-share the link every day and all the responses go into one sheet. It's a bit of a hassle counting all of them (a lot of filtering required) but at least all responses go on one sheet. But yes--I totally see your point and I have several colleagues who are also preferring the daily ungraded assignment for attendance. Some of them even make it fun (like asking students if they prefer pizza or pasta!) Thanks for watching and sharing your method as well Siput! :)
Thank you for the consise video.
Do I need to generate the link every time I edit the form or the same link will work??
HI Juhi! You can use the same link every time as long as you are fine with all responses going to the same Form and Sheet. I personally used the same Sheet all year, keeping it organized by date and student name so I knew who was signing in. Thanks for watching and commenting Juhi!
@@PakistaniPepper this is really sweet and short. i have one doubt .... can student again fill with the same link on next day? may be it will say that your response is recorded?? is it possible??
@@harshavardhansingh1749 Hi Harshavardhan! Yes--students can use the same link to fill it out as many times as needed. It will always say something like "click here to submit another response" at the end. Each response will have its own timestamp, so you will know when the student submitted it. Thanks for watching! :)
Hello Abdul,
Thank you for the tutorial. Maybe you know if there any way to use numbers of days that your students filled in to represent their attendance on calendar which was also created in spreadsheets?
Good evening! Thank you for your kind words. My apologies as I'm not too familiar with using a calendar in Sheets. The only way I can think of is perhaps you could sort by day, and then paste the attendance at the end of each day into the Calendar? The functions I know are mostly with standard Sheets files so not too familiar with calendars. Please let me know if I can help with anything when you attempt it and wish you the best! Thank you for watching!
Hi! Sorry I just saw a notification about your other comment! Unfortunately, it doesn't let me expand the full comment because my YT marks comments with emails as spam for some reason and I can't seem to figure out how to turn it off. If you still have any questions, you can send them to me on the email in my about page on the channel (if I put the email here, it might mark it as spam again). Happy to help!
Hmm, can't find any links in "about" tab. Only twitch.
@@АндрейШандабыла oh wait--let me try this: abdul(.)siddiqui(@)baruchmail(.)cuny(.)edu (remove the "(" ")" from the address)
That will work)
I will write you in a couple of days
Do I need to create seperate forms if I want spreadsheets for each class? Also, on the form do I need to keep the box under presentation, show link to submit another response, checked? Thanks this is great.
Hi Sherri! Thank you for kind comments; glad you found it helpful. Yes-you will need separate forms to keep separate spreadsheets for each class. Also, you can leave the “show link to submit another response” unchecked; in my opinion, it’s not necessary for this type of form because students don’t immediately need to submit another right after they have submitted it once (as they should only be doing it once a day). Just make sure to allow people to submit multiple responses, as they will be answering on the same link/form multiple times. Do let me know if you have any other questions and thank you for watching and commenting Sherri!
Tremendously helpful... thanks a ton
Thank you Omina! Glad you found it helpful :)
This video is really satisfying and helpful!
Thank you Kristen! Glad you found it useful! :)
Thank you for sharing sir. How do I get the Time stamp in Google sheet?
Hi! Google Forms automatically collects the time someone submits the form-you will see it in the first column when you look at your results, and by default, that is how the Sheet will be sorted. You can choose to sort it by time stamp again by just clicking Sort By after selecting the column. Do let me know if you have any questions and thank you for watching! :)
Nice content,thanks mate
Glad you found it helpful Anik!
I have a question sir !!!!
I am having online classes in zoom and they send the google form for attendence at specific time.
Now, if i am not in the class for some reasons and my friends share me the link inmediately and I fill it at the same time from outside the class will it be valid ??
Pls reply.....
Hi Hatake! So yes, if the attendance is in Google Form it doesn’t matter whether you are in the zoom or not. Although your teacher might notice you’re not there if there are not too many students and I always recommend popping into class to learn :)
Thank you !!
You're welcome Zahra!
Thank you sir for this tutorial, you did really help me in organizing the attendance of my class.
I'm glad it helped Niecole and thank you for your kind comments! Do let me know if you ever have any questions and best of luck! :)
how can we used the same link for daily classes ? what should we do ? Someone please help
Salaam Muhammad! Click on the Settings button (gear icon on the top right). Then, find where it says, "Requires sign in." Below that, there is a checkbox that says, "Limit to 1 response. Respondents will be required to sign in to Google." Make sure that checkbox is NOT CHECKED. If it is not checked, they will be able to submit multiple answers with the same form link, no matter how many times you share it. Thanks!
Hello , i'm a teacher . I want to make the daily attendance sheet using excel in combining with the class log(different period) in order to record attendance for students and want to link to the google drive so that every class teacher and subject teacher can access the attendance and update accordingly. But i don't know how to proceed properly. I would be grateful if sir could give me few suggestion and guidelines.
Thank you.
Hi Chimi! Doing a single sheet for every teacher in a school might be a bit cumbersome, as that would mean a lot of responses. I would recommend doing only one sheet per teacher, and I would set that up as a simple form. If the students are signing in to their own attendance, you can just have each teacher create a form like one above, and share with the students. If you want teachers to take the attendance, I would recommend a form with the following questions (in the parentheses I'll include the type of question you want to give): Date, Period (let the teacher list the period they are taking attendance for) and then a checklist with all the students from that section. The teacher can check (present) or uncheck (not present) and fill this out for each subject. This would require the teacher know their full roster. Again, if you want to do it schoolwide, I would recommend students also have a question with "Teacher Name" and "Teacher Period" or else it can get really difficult to filter that many responses. Hope that makes some sense and please let me know if you have any questions! Abdul
Hi Abdul.
Am not able to use the form in same date for different subject. can you please show me how can I use the form in same date for different subject?
Got it!, "Limit to one response" need to kept unchecked.
Glad to hear you were able to figure it out Varsha! Thank you for watching and I hope this helps! If you ever have any questions, do let me know :)
thank you so much sir........ great tutorial...
Thank you Ronald! Glad you found it helpful :)
Thank you so much for this tutorial, this was very helpful!!
Thank you Leslie! I'm glad you found it helpful and truly appreciate you watching and commenting :)
google forms option not showing in that tab. what to do?
Hi! If I understand correctly, Forms doesn't show up on your main page? It doesn't always appear in the default apps--have you tried typing in manually forms.google.com? Thanks for watching and commenting!
Just one question: Is there a way to disallow a student being able to enter a date that is in the future?
Hi Mark! Unfortunately, built into Google Forms, that is not an option. I read online that you can use a script called “Form Ranger,” but to me personally, it seemed like more trouble setting it up. For that reason, you might be better off just letting the students know not to enter future dates, or even just getting rid of the date-it would then only show you the time stamp when the student submits the form, and you can still see what date they submitted it with that. Hope that helps and thank you for watching Mark! :)
@@PakistaniPepper does the time stamp come out on the google sheets?
Hi Carmella! Yes! The timestamp does appear on Google Sheets! It’s the first category and will be automatically generated by Google Forms. Hope that helps; thank you for watching!
Can I create a google form for each teacher and class period with their students marked present already? That way they just would have to mark only the student absent.
Hi! Yes you can. Basically, you can design the form however you wish. In my opinion, the easiest would be a Checkbox Grid where you have each Row as a different student and columns with Present and Absent. Then, you can prefill the form (instructions here: support.google.com/a/users/answer/9308781?hl=en) so that each of the students are marked present by default and then send that prefilled link to teachers. Then teachers would just have to fill who was absent, and they can either submit the form or just mark the correct kids absent and email you a PDF of their responses. Hope that helps and do let me know if you have any questions!
thank you, could we add time-out ??
Hi! Yes! You can add a question about "time in" or "time out," then share the same link and it will capture people's time out as well! Use the timestamps from the time out entry to see when they timed out :) Thanks for watching!
best video
thank you.......
Glad you found it helpful Mahesh!
Asalamualaikum
Too good and simple steps for creation.
Thank you
W'Alekum Salaam Roohi! I'm glad you found it helpful. Do let me know if you ever have any questions and thank you for watching and your kind words! :)
Sir You mentioned about having one response for one day but how is it done..can you please educate me on that as I am a teacher too and I am dealing with this problem.
Note: I use android phone
Hi Najmus-happy to help. So, let’s take it one step at a time.
1) Look at 4:05 in the video. Notice how I clicked on “Send” to get a link.
2) That link is what I need to send to students so they can fill out the form I have created.
3) I can send this link via email, Google Classroom, etc.-whatever system I use to communicate with students.
4) Clicking on this link allows students to fill out the form.
5) I count each time the student fills the form as one entry of attendance (each fill has the date and time, so I know when they filled it out).
6) So the student clicks on the form on January 1, and then fills it out.
7) I go to the Responses page on the form to check his response (see 5:48 in the video). I now know that is his attendance for January 1st because his response has date and time.
8) On January 2nd, the student clicks on the SAME link and fills it out. That is his attendance for January 2nd and I know it is his attendance for January 2nd because it has the date and time.
That is why students need to fill out the form every day, and they can do it on their computer or their Android phone as well. Does that clarify things? Do let me know if you have any questions and thank you for watching Najmus!
Keep up the good work brother.
Thank you Murtaza! Appreciate it as always :)
Excellent video... Plz tell me one month attendance of students in one sheet.. automatically sum operation perform
Hi Mrs. Khalid! You would basically have to filter by student (select the top row, and then click the Filter button). Then, when you have filtered only that student for the month, go to any column, select all entries, and in a new cell, enter the formular "=COUNT(range)," with the range being the cells. Hope that helps and thank you for watching Mrs. Khalid! :)
@@PakistaniPepper plz demo
Happy to, Mrs. Khalid! I have a lot of work after school tomorrow but will hopefully be able to do it on Wednesday or Thursday; will share the link with you then :)
@@PakistaniPepper JazakAllah... and plz tell me how many present and absent total number of Students I mean automatically sum operation perform
Hi Mrs Khalid-I just wanted to let you know I haven’t forgotten about your request. School has just been really busy so it’’s been a bit difficult. But I will work on your request this weekend and get the video up as soon as possible. Sorry for the wait!
Please can you help with making a QR code for attendance?
Hi! Thank you for watching! An easy QR code generator that I have used in the past is Bitly. So what I would recommend is first make a Google Form attendance you are comfortable with (for example, like the one in the video) and then you can follow the steps on the Bitly blog to generate a QR code here: support.bitly.com/hc/en-us/articles/360030557072-How-do-I-create-a-QR-Code-in-Bitly- This will allow you to create a QR code that takes people right to your form. Please let me know if you have any questions and I would be happy to help out! :)
سلام. کیسے ہیں آپ. میری مشکل ھے. وہ یہ کہ. میری کلاسیں اکتوبر میں غلطی سے میں نے آن لائن پڑھایا. اپنی کلاس کو. لیکن ھم کو پابند کیا گیا تھا کہ ھم صرف ویڈیو رکاڈ کر کے ٹیمیز میں اپنی کلاس میں بھیج دیں. بچے خود سے دیکھیں گے. خیر میں نے پندرہ دن تک آن لائن پر پڑھایا. جو ممنوع تھا. پھر میں ویڈیو بنا کر بھیجا. لیکن میں ان طالب علموں کی حاضری لینا بھول گئ. 4،10،2020 سے لے کر 13،1،2021 کی حاضری چاہیے. خدارا بتانا کہ یہ کیسے میں یہ لے سکتی ھوں
Hi Afsheen! My apologies for the late reply. If you want students to fill in attendance from several days (or months), you will have to ask them to fill out the Google Form multiple times. Each time, the students will have to pick a different date for the question that says "date." That way, your records will demonstrate attendance for each of those days, for each time they fill out the form. So you would say they have to fill out the form once every school day from 10-4-2020 to 13-1-2021. Then, as I showed in the video, you can sort by date or name and get all of the responses.
Please let me know if you have any questions and I understood your question; my apologies as my Urdu is a little bit weak.
Can we use google form to clock in and clock out from the same form? I try to avoid building multiple links for this purpose.. Tq..
Hi! Yes--you can definitely use it to both clock in and clock out without having to create two forms. Just make one form and make one of the questions, "are you using this to clock in our clock out," then make it multiple choice or dropdown and make one of the options Clock In and one of the options Clock Out. That will keep it all in the same link and when you receive responses, you can filter by Clock in and Clock out. Hope that helps and thank you for watching! :)
@@PakistaniPepper tq for your reply... Currently im using 2 checkboxs in my question which is one for clockin and the other is clockout. The user will choose either one and just click submit after that.
The problem is when it comes to csv report. Once user clockin, the data will create new row, then clockout is also create a new row. So i can't calculate how many hours the user was worked on that day.. Cause the timestamp for clockin & clockout stack under one column. Im not sure excel will allow us to calculate in column. Any advice for this? Hope u understand. . 😁
Happy to help I think I understand--so there are two different submissions, with two different columns. One has a time stamped punch in and the other has a time-stamped punch out. Would it work for you to create a new column with the function =(Cell 2 - Cell 1), where Cell 2 is punch out time and Cell 1 is Punch In time?
Yes. Cell 2 - Cell 1 is my plan. But both of it is currently in the same column. Can we make a formula to calculate item in the same column in excel? For eg: B2-B3. Imagine i have a thousands of rows to calculate.
I see your point. I think sadly, I think that is the way it will have to be: B2-B3, with quite a bit of playing with the cells because after multiple submissions, the cells might not even line up as cleanly. I am asking my tech friend what he does; if he tells me anything useful, I will definitely share with you :)
How can I maintain one month's of class attendance in one attendance sheet.because every i make new.forms for students. if I give them same link every day is their any problem for particular one class?
Hi Priyanka! It's not a problem but it does require some organizing. Basically, as long as you're using one form and one link, all the responses go to the same Google Sheet. Therefore, you need to set tabs for each class, and filter and organize the responses. I made a more detailed video on how to do that here, that I'll link at the end of this message. Do let me know if you have any questions and thank you for watching Priyanka! ruclips.net/video/ZRLgAp0u9Tg/видео.html
@@PakistaniPepper thank you very much ,, if I face any problem I will let you know
My pleasure Priyanka! Happy to help and do let me know if you ever have any questions:)
Abdul Rehman Siddiqui sure sir😇
If it's time stamped, why do students need to enter date?
Hi again Debora! Yeah--that's just an additional step I take because I like having a "clean" date to sort with--the timestamp has too much information and doesn't look the cleanest to me. But yes--it's just an additional date on top of the timestamp so unnecessary. Thanks for watching and commenting Debora!
Sir I need to know like they can put any e mail address and do know sir so any one can put the students attendance
Hi Gayathri! In order to make sure they are required to use their email, notice how in the video above at 1:54, I made sure "Collect Email Addresses" was checked in settings. This forces the user to login before they can respond and the system will automatically collect their email address. That also helps with issues of security because then only the person using that email can fill in responses, and you can always see the email in your list of responses. Hope that helps and thank you for watching and commenting Gayathri!
Thanks!
Glad you found it helpful Zarina!
Very helpful
Thank you Crissy!
Can I use the same link for different classes?
Hi Sara! Yes! I am using the same link as well. In that case, the most important thing is to make sure you have one question about WHICH class. That way, when you open the responses, you can filter via class rather than having all the students in one big block all the time. Otherwise, the sheer amount of students will become overwhelming very quickly. Thank you for watching! :)
This was great thank you!
Glad it was helpful! Thank you for watching and commenting! :)
Thank you so much!!!!
Thank you for watching and commenting Linda! Glad you found it helpful :)
Thank you
You're very welcome Dennis!
Why not make one form for each period?
Hi Debora! You can totally keep it separate; I just like them all together because then I am only referring to one file (and I can filter via Periods). But I know for some, it is definitely more straightforward to just have separate links. Thank you for watching and commenting! :)
HOW TO RECEIVE DAILY ATTENDANCE, BECAUSE I WANT TO TAKE CLASSES EVERY DAY, AND I HAVE TO RECEIVE ATTENDANCE
Hi Jo! I share the same link with my class every day, and make sure there is a required question for "date." That way, I know when and what day they are submitting for every single day. Hope that helps and do let me know if you have any questions! :)
@@PakistaniPepper Thank you sir
Can I take daily attendance on one link
Hi Romika! Yep! I shared the same link with my students every day and with each submission, I made sure they were required to fill out the question for date--that way, I always knew what day they were submitting it for and it all came into one file so I could edit as I needed. Thanks for watching and do let me know if you have any questions! :)
There is a simpler method i use where i easily export all the attendence to MS Excel for record keeping and submission. Wish i had to time and skill to make an instructional video for fellow teachers to see.
That's a great idea Mikael! I think if you can share it, it would benefit a lot of teachers. If you have any questions on how to set up recording, feel free to ask and thanks for watching and sharing!
Please can you share your method 🙏?
Thank you. 😊
How to track who has not attended?
Hi Sankar! Tracking who hasn't attended is a bit trickier! Since someone would not be signing themselves in as present, the only way to note that is as the teacher. So I like to create a form with my entire roster, and then just add one checkbox of "Absent." Then I just click off the ones who are Absent, and note that in the responses. Hope that helps and let me know if you have any questions!
Watching here from Balon Elementary School Mariveles District
Thank you for watching and commenting Jessica! Wish you all the best :)
How can we trace absent students
Hi Durgesh! You can trace absent students by doing a "COUNTIF" function where it says the student's name "COUNTIF(Student)." That will let you know how many times they are there.
If you want to take attendance on your own, you can make a form that has the daily date and then a checklist of each student. That way, you can check off which students are present each day, and easily also trace which are absent. Let me know if you have any questions and thank you for watching!
How to add email?
Hi Frazia! You can add a question that just asks for email. Or, the option I like more: go to Settings on the top right, and click "Collect Email Addresses." that will require an email for submission and automatically record it :)
Sooo, I only have a few classes 😐
Thankyouu for thisss❤️
You're very welcome Franchesca! Thank you for watching!
👍👍
Thank you for watching and commenting! :)
student can just copy the link and answer the question at somewhere without attend the class loll
Haha that is definitely a risk! That's why I always recommend being very careful about watching students and comparing with the form! Thanks for watching David!
thank you
You're welcome Anisah!