Easy Daily Attendance for Remote Learning (Before You Lose Your Mind)


When school started I was not prepared for how stressful attendance would be! Trying to figure out who logged in and when was just a lot of work, especially when you have kids sitting in front of you.  After trying a few different things, this method is the easiest one that I was able to find.

I saw different ideas about using different forms for each class and it started to get too complicated.  Instead, I created one form.  If you want a copy of my google form, click on the link and make a copy.

https://docs.google.com/forms/d/1yGnyiiKeTDRaE-53n-Bb6lDX89-kokdXCJdpwEAN4Lk/copy

If you take the form and edit it so that it fits your class, then you can just click share and copy the link on your learning management system.  I decided to keep my form short and sweet.  My first form I created had different questions and I decided it was too much and it took the students too long. I decided to simplify my form and ask only for the student's first and last name and period.  When the form gets uploaded into an excel sheet, you will also be provided a time stamp.

After the students have taken the google form, you need to go to responses and click the excel sheet button.  The student answers will populate on the excel sheet. 

Now this was the game changer.....

 Download the chrome extension called toTabs. To download, open excel. Click on add-ons. Then, get add-ons.  Then search for toTabs.  To read more on chrome extensions, go to the link below.

https://teachthrivetriumph.blogspot.com/2020/05/basic-one-click-chrome-extensions-every.html

The beautiful part of this chrome extension is that you can arrange the data by the different excel headings.  So when I am ready to take attendance, I sort by the period.  This will create a new spreadsheet for each period.  Once you have the students from the same period on one sheet, you can sort the names in alphabetical order. Highlight the last name row and go to the menu bar and click on data.  Then click on the sort sheet by column ____ from a to z.  This will make it easy to do a quick attendance reading. 

I wish I would have figured this out a few days ago, but I used this for my last in-person class and got so much instructional time back. :D

Comments

Post a Comment

Popular posts from this blog

Zoom- I finally figured you out! :D

Image
                          Week Three of school and I finally figured out a good, workable flow to zoom!  I have been getting so many questions on how to structure live video classes.  Below is my zoom schedule for my 85 minute classes. Attendance, Wellness Check and Goal Setting (5 minutes)                         During the initial first five minutes of zoom, I login to zoom.  I have them wait in the waiting room, until they are done with their attendance poll, wellness check and goal setting discussion board.  I give the students five minutes to do all of these things.  In the meantime, I am seeing who showed up live to my zoom class and doing the attendance through the zoom waiting room. Below is a picture of what my wellness check and goal setting looks like for my class.  Add caption For more ideas on how I do...
Read more

Mr. Wong in APRIL! Zoom Expectations and Routines

Image
This guy fills my month of August.  Every educator knows that every school year must start with the routines and procedures that Harry Wong outlines in his classroom management books.  When the year starts off strong with routines and procedures in place, they become normalcy.  However, this year had a completely different turn of events.  This is the first year that I had to revisit Mr. Wong in APRIL! After my first week of zoom sessions, I realized that something needed to change quickly.  As I was turning my wheels, I realized that I needed to re-set my classroom environment, culture, procedures and expectations.  In this whole new environment, students no longer understood the behavioral expectations that were required of them.  I quickly had to re-outline what those expectations were and have the students practice their online routines.  Below I came up with a couple quick steps to quickly place some routines and expectations into your zoo...
Read more