During Distance Learning, our district is required to take attendance every day, every class period. Students can take attendance or “check in” at any time during the school day, meaning my 7th hour students can “attend/check in” at 8:30 A.M. if they choose to. However, all students must have attended/checked in with all of their classes by 3:00 P.M. We, the teachers, are expected to have attendance for all of our classes entered between 3:30-4:00 at the latest. Because our district is 1:1 with Chromebooks and google classroom, to complete attendance in my classroom, students must complete a google form. I post the attendance form daily at 8:00 A.M., giving students the majority of the day to “attend/check in.” (My classes meet asynchronously.) On the google form, the first response students complete is to type their LAST name and first initial: Oelke J. This will help sort students for faster attendance taking as you will see in a minute. This is a required response for students. To make it required, click the toggle switch in the lower left corner when creating the form. Throughout the day, students complete the google form, which verifies their attendance. Honestly, I do not look at these forms until 3:00 P.M. At that time, I open the attendance forms for the day and close the from to new responses. (1) I do this from the “response” tab of the google form using the toggle switch on the right. (2) Then, I link all the responses to an existing google sheet. I do this by clicking the greens sheets icon in the upper right. Now, I can choose to create a new spreadsheet or link to an existing spreadsheet. Choose to link to an existing spreadsheet. Choose the correct spreadsheet, and click Select. I have a different spreadsheet for each class I teach, so I Select the spreadsheet for the correct hour. All of the information the students completed on the google will be imported to the spreadsheet you have selected, and google will create a new tab in that spreadsheet. Rename the tab with the date. This way all the responses for each class are in one convenient location. To change the tab name, simply highlight the name on the bottom tab and type in the name you would like it to be. Near the top of the spreadsheet, find the dropdown option for Column B (Column A is the timestamp noting when the form was completed). Choose “Sort Sheet A-Z.” And just like that *snap,* google will sort your students alphabetically by last name...if students followed directions! Students are now sorted the same as they are in my attendance program, meaning I do not have to cumbersomely peruse the google form to verify who has attended/check in.
PRO TIP: Make a copy of this form each day! Doing so will tell google that a “new” form has been created and therefore a new tab will be created on the spreadsheet. Personally, this works better for me and my organization style. If you do not make a copy of the form, and simply wipe out the responses on the form instead and reuse the form from day to day, when you link the form to an existing spreadsheet, it will not create a new tab, but will add today’s responses onto the same sheet below yesterday’s responses. If that works for your style of organization, go for it!
2 Comments
Vicki
4/11/2020 11:29:06 am
I am a complete “newbie” when it comes to using google forms. My school is in week 4 of the closure so I am trying to make collecting work easier for me. I created a google form for all 7 of my classes which I linked in a slide. I clicked “create a new spreadsheet” but realize all 125 responses will now be on that one sheet! If I want to organize the responses by class period (the first 3 questions are “last name, first name, and class period”, do I create a spreadsheet for each class and then follow the steps you listed??
Reply
4/11/2020 03:37:06 pm
If all of your students are responding to the same google form, all responses will be on one spreadsheet together, and not separated by class
Reply
Leave a Reply. |
Jessie Oelke
#deptofone providing compelling and comprehensible input Enter your email address to subscribe to this blog and receive notifications of new posts by email.
Categories
All
Archives
April 2020
Providing guidance
Aventuras Nuevas
by Bethanie Drew The Language Coach by Amy Lenord Bryan Kandel TPRS by Bryan Kandel Bryce Hedstrom's Blog by Bryce Hedstrom CI Peek by Carol Gaab Creative Language Class by Kara Parker & Megan Smith La Clase de Sra. Dentlinger by Elizabeth Dentlinger The Comprehensible Classroom by Martina Bex Grant Boulanger's Blog by Grant Boulanger Kristy Placido's Blog by Kristy Placido Maris Hawkins' Blog by Maris Hawkins El Mundo de Birch by Sharon Birch Musicuentos by Sara-Elizabeth Cottrell Mis Clases Locas by Allison Wienhold Making Good Mistakes by Courtney Johnson MJ's Comprehensible Input by Michele Whaley My Generation of Polyglots by Mike Peto PBL in the TL by Laura Sexton Somewhere to Share by Carrie Toth Spanish Nobility by Jason Noble Teaching Spanish by Kara Jacobs Todally Comprehensible Latin by Keith Toda Tripp's Scripts by Jim Tripp |