Super This is awesome method. i just did it now for preschool students and they are finding it very easy on 1st day itself in Google classroom! Thank you so much!
I've been doing it with a Google Form set to collect student emails. Then they can fill it in each day and all you need to do is highlight the day and you can use the same form over and over. -- edit I've been working on some formula that will check if students have signed in or not too. Happy to share.
Hi, I’m interested in using google forms as you described. Do I need to have “collect student email” set or is that not necessary? I want to create a form (1 short answer response) where students type their first and last name. I was interested in your method to save time of just changing the day and using the form over and over again. Can you please explain how to “use the form over again” using different words? I just want to make sure I’m doing it the right way. For example, let’s say I have them answering for tomorrow, 4/8/20. Then at the end of the day, do I just edit the title of the assignment “attendance 4/9/20” with the new due date? Also, I have the responses being recorded in a google spreadsheet. Does this all sound about right?
@@bennysherman6734 hey Benny. If you're in a NSW public school, look me up on the staff directory, and send me an email. I'll share the blank one that I'm using.
Daniel Judd Not familiar with nsw. I have the google form ready to go with the spreadsheet attached for me when the students respond to it tomorrow. However, I just want to make sure I can reuse the form by changing the day as you described in your first comment I read. All I need is the google spreadsheet to have students’ responses tomorrow, and then each day following. When I reuse the google form, does it erase all the data on the spreadsheet from previous days?
@@bennysherman6734 OK... So, you're going to create two more tabs in your spreadsheet. One has to be called "QUERYed Sheet" and the other "ROLL CALL". Add several thousand rows to the bottom of QUERYed Sheet. I had it so that there were 10,000 rows (wow I hope this doesn't last that long...). In QUERYed Sheet, go to cell A1 and type this formula: =QUERY('Form responses 1'!A1:C) This will pull all the information from the form so that we can work on it. Then, in cell D2 type this formula: =IFERROR(CONCATENATE(B2," ",DATEVALUE(A2)),".") ...and copy it paste down onto every row of that sheet. This adds a date value to each e-mail so that it can be matched by the roll. In the Roll Class tab, you want two headings: "Student Email" and "Present". Under student e-mail, enter all your students' e-mails, one e-mail address per row. Then, in each cell next to a student's e-mail, type this formula: =IFERROR(IF(MATCH(CONCATENATE(A2," ",DATEVALUE(NOW())),'QUERYed Sheet'!D$1:D$10000,0)>1,"Present"),"ABSENT") ...you will have to change D$10000 so that it's the last row that you have in your QUERYed Sheet. This looks for the students e-mail and the date value for today in the data that QUERYed Sheet has. Sorry, I wish I could help more, but I'm pretty flat out with my work and my own family.
Great video! Is there a way to collapse these days of attendance? For example can we put the old records of month of April together? After a while it has become a long list!
Your issue is with this is that kids will go on and click yes on old days, unless you remove them manually each day. There should be a way for these to expire. Yes you could filter out the kids who have submitted it 'late' but that is time consuming.
We've asked teachers to check each day before the end of the day to be able to record data on our usual attendance system. It won't matter if they click on it later as the teachers would have already recorded the attendance in our normal system.
If you click on the Question, it will take you through to where you can "mark" it (like you would for any other question you set in Google Classroom). There you can see who has or has not answered the question.
Super This is awesome method. i just did it now for preschool students and they are finding it very easy on 1st day itself in Google classroom! Thank you so much!
This is also a great way to do a quick, surprise assessment during these online lesson times. Thanks, Talkin' Chalk
Hey... I love how your video is easy to follow as I am new to google classroom as a teacher.
Thank you so much! I'm glad to hear it was helpful for you 😃
I've been doing it with a Google Form set to collect student emails. Then they can fill it in each day and all you need to do is highlight the day and you can use the same form over and over.
-- edit I've been working on some formula that will check if students have signed in or not too. Happy to share.
OK, done.
It's not really straightforward, however. I'll e-mail you what I have.
Hi,
I’m interested in using google forms as you described. Do I need to have “collect student email” set or is that not necessary? I want to create a form (1 short answer response) where students type their first and last name. I was interested in your method to save time of just changing the day and using the form over and over again. Can you please explain how to “use the form over again” using different words? I just want to make sure I’m doing it the right way.
For example, let’s say I have them answering for tomorrow, 4/8/20. Then at the end of the day, do I just edit the title of the assignment “attendance 4/9/20” with the new due date?
Also, I have the responses being recorded in a google spreadsheet. Does this all sound about right?
@@bennysherman6734 hey Benny. If you're in a NSW public school, look me up on the staff directory, and send me an email. I'll share the blank one that I'm using.
Daniel Judd Not familiar with nsw. I have the google form ready to go with the spreadsheet attached for me when the students respond to it tomorrow. However, I just want to make sure I can reuse the form by changing the day as you described in your first comment I read. All I need is the google spreadsheet to have students’ responses tomorrow, and then each day following. When I reuse the google form, does it erase all the data on the spreadsheet from previous days?
@@bennysherman6734 OK...
So, you're going to create two more tabs in your spreadsheet. One has to be called "QUERYed Sheet" and the other "ROLL CALL". Add several thousand rows to the bottom of QUERYed Sheet. I had it so that there were 10,000 rows (wow I hope this doesn't last that long...).
In QUERYed Sheet, go to cell A1 and type this formula: =QUERY('Form responses 1'!A1:C)
This will pull all the information from the form so that we can work on it.
Then, in cell D2 type this formula: =IFERROR(CONCATENATE(B2," ",DATEVALUE(A2)),".")
...and copy it paste down onto every row of that sheet.
This adds a date value to each e-mail so that it can be matched by the roll.
In the Roll Class tab, you want two headings: "Student Email" and "Present".
Under student e-mail, enter all your students' e-mails, one e-mail address per row.
Then, in each cell next to a student's e-mail, type this formula: =IFERROR(IF(MATCH(CONCATENATE(A2," ",DATEVALUE(NOW())),'QUERYed Sheet'!D$1:D$10000,0)>1,"Present"),"ABSENT")
...you will have to change D$10000 so that it's the last row that you have in your QUERYed Sheet.
This looks for the students e-mail and the date value for today in the data that QUERYed Sheet has.
Sorry, I wish I could help more, but I'm pretty flat out with my work and my own family.
My teacher used this method. It is so innovative
AWESOME! Thank you
Thanks for sharing, this is very helpful
I'm liking that floor plan assignment in math lol
So cool. I have been providing attendance questions each day (silly and fun ones), but I like this to go with them.
Great video! Is there a way to collapse these days of attendance? For example can we put the old records of month of April together? After a while it has become a long list!
That's a great idea, Bec. We have been doing it by getting them to comment under their classwork for the day. I might experiment with your way too.
I found it super easy this way. Then when you click on gradebook you'll see the title attendance with the date and a tick if they submitted 😃
Much appreciated.
You're very welcome 🍎
👌👌👌
Thank you! You explained it so well.
You're very welcome I'm glad you found it helpful 🙂
Your issue is with this is that kids will go on and click yes on old days, unless you remove them manually each day. There should be a way for these to expire. Yes you could filter out the kids who have submitted it 'late' but that is time consuming.
We've asked teachers to check each day before the end of the day to be able to record data on our usual attendance system. It won't matter if they click on it later as the teachers would have already recorded the attendance in our normal system.
Thanks for creating amazing video. But how can we count the total attandance at the end, if we marked points as ungraded.
It is an amazing video. Thanks for making remote learning so effective, efficient and user friendly!
Oh that's such lovelt feedback! Thank you I appreciate that 🍎 hopefully it will help make this time a bit easier ❤
NICE
Can they still answer/reply even after the due time has passed?
Yes they can. It just gets recorded as a late submission so you can still tell when it was done. 👍
@@talkinchalk ok thank you for responding. Great video 👍🏾
Hi, when you use this for attendance, does it generate a list of who answered yes?
Yes in the gradebook you will see it there 😃
If you click on the Question, it will take you through to where you can "mark" it (like you would for any other question you set in Google Classroom).
There you can see who has or has not answered the question.
How to mark attendance via using cell phone
You can still use Google classroom as it a has a free app you can download 😀