App Icon
Michael Bollati
•  10,000,000+
Overview
A tool for schools to take student attendance when remote learning!
*Update: 8/24/20 fixed timezone in response sheet and tracker for accurate time of student submission of attendance. 
Changed the ID Number question to reflect NYCDOE student OSIS number (includes validation of id number as number between 199999999 and 300000000)

This is a tool that was developed because of the need to take student attendance during Remote Learning of the COVID-19 Pandemic.  This is a tool that will allow you to automatically create an attendance tracker, create daily attendance forms for the days that you would like to capture daily attendance, schedule announcements in a Google Classroom class from your choice.  When  the tool is functioning, using Google Classroom students will get an announcement at 8:00am on the date that the form was created for.  Students will have one choice to mark their attendance, and the forms used to collect attendance will capture student g-suite accounts, then using a series of importrange and vlookup formulas you will be able to have a running list with percentages of who is present or who is absent from remote learning!
Reviews
Language:
Sort by:
Profile Picture
Academic Nice ITI
April 7, 2021
good
Is this review helpful?
Yes
No
Profile Picture
Belinda Highful
February 17, 2021
How do you check to see what is causing the continuous spinning when attempting to announce to class? I got it to work on 1 out of 3 of my separate sheets (one for each grade level with each Google sheet having about 100 students.). I see no duplicate dates and the only thing that didn't work is the automatic announcing for those 2 grade levels. I'm not an IT person. Just an administrator that is a Math Geek. Please give additional advice and talk to me like I'm a 3rd grader. lol
Is this review helpful?
Yes
No
Profile Pciture
Michael Bollati
February 21, 2021
Hi! thank you for using the add-on. If you are able to create the tracker, then there are no duplicate dates. If you are able to announce to class for one of your attendance trackers there are most likely one of two causes: 1. The account running the tracker must be listed as a teacher on the class (I don't think this is the case) 2. you are trying to announce to class on a date that has already passed or is current. (could be this one) Announce to class button will schedule an announcement at 8 am in your time zone for the date listed. If you are trying to announce the day of, after 8am, or a date in the past it will not work. if you find dates like these, you will just have to go to the date in question on the link sheet and scroll to the column that says "scheduled announcement in google classroom" That should be blank for the date that is causing the error, then type in that cell something like Skip or bypass. This will then not use this date and move everything forward for the next days. Please keep me updated on your progress, I would like to ensure that we are able to address the issue that you are having. If this does not work, you can share the sheet with me to address the issue. thanks again
Profile Picture
Mrs Smith
January 4, 2021
I am trying to create a register for 31 children for 4 days. I get to step 4 but is just keeps spinning. II have checked that I am listed as the teacher but it just isn't working.
Is this review helpful?
Yes
No
Profile Pciture
Michael Bollati
January 11, 2021
We have found that if there are duplicate dates the script will not run. This is something that is easy to check / fix.
Profile Picture
Monchai SOPITKAMON
December 20, 2020
i got stuck at step 3 where the circle dots keep spinning forever and never finished.
Is this review helpful?
Yes
No
Profile Pciture
Michael Bollati
December 21, 2020
You have to make sure that you are listed as a teacher in a google classroom class. Otherwise the script will not finish and lead to an error. Also make sure there are no duplicate dates listed, that will also create an error and prevent the script from finishing
Profile Picture
Theresa Trapp
December 16, 2020
Really great tool! I just was wondering how you add new dates to it
Is this review helpful?
Yes
No
Profile Pciture
Michael Bollati
December 17, 2020
You will be working from the links tab. If you would like to add new dates, just add them to bottom of column A of the links tab. Then you will be able to open the sidebar, and make attendance tracker again. Just make sure that you are using the same method for identifying students, Email or OSIS. hope this helps!
Profile Picture
ABIGAIL LIKENS
December 14, 2020
It will help me do good on Google classroom to keep up
Is this review helpful?
Yes
No
Profile Picture
Marilyssa Trujillo
December 10, 2020
Good afternoon, I'm attempting to use this with our distance education we are doing. It seems like it would be a great tool but it never loads. I've submitted all the data as I was supposed to and did what some did in previous comments. Though, it still doesn't work.
Is this review helpful?
Yes
No
Profile Picture
VicHeart On the Road
November 20, 2020
Timely useful
Is this review helpful?
Yes
No
Profile Picture
rosdi ab latiff
November 12, 2020
OrganizationIdentity
Is this review helpful?
Yes
No
Profile Picture
DANIELA PAVEL
November 8, 2020
It is working
Is this review helpful?
Yes
No
1-10 of 43
Additional information
Michael Bollati
Support
Terms of Service
Search
Clear search
Close search
Google apps
Main menu