[et_pb_section fb_built=”1″ module_class=”sheetgo-post” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Working from home isn\u2019t easy for anyone, but for teachers, it poses a major organizational challenge. As one of the most interactive jobs in the world, teaching involves personal communication with up to 30 students at any one time. Multiply that for all your classes, and it\u2019s not uncommon to be working with several hundred students every week.<\/p>\n
Although technology can never replace the physical experience of standing at the front of a classroom or lecture hall, online teaching, collaboration, and video software are improving all the time.<\/p>\n
One of the most popular online educational tools is Google Classroom<\/a>. Dubbed \u201cMission Control for Teachers\u201d, Classroom enables educators to share materials, set assignments, grade work, and give feedback to students all from one central platform.<\/p>\n It has loads of great features but one downside is that there’s no inbuilt Google Classroom attendance tracking function.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/04\/classroom-workflow.png” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As well as checking whether students are up-to-date with the course material, attendance monitoring can help teachers keep an eye on students’ development, health and wellbeing. When a school goes remote, teachers often become the only point of contact for students. As a result, tutors may need to take on a safeguarding and support role, checking on vulnerable students and communicating any concerns to managers.<\/p>\n While teachers need to track their own students, administrators have the complex task of collating information from across the entire school. Again, Google Classroom doesn\u2019t contain an inbuilt function to help with this. But if your school uses Google Classroom, you\u2019re probably already using other G Suite tools such as Google Docs, Slides, and Sheets.<\/p>\n It\u2019s possible to build a custom attendance management system yourself using everything that\u2019s included in Google Workspace for Education<\/a>. In this article, I\u2019ll show you how to set up an automated attendance tracking system using Google Classroom, Google Sheets and Google Forms.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ make_equal=”on” _builder_version=”4.22.2″ _module_preset=”default” background_color=”#F6F8F9″ custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” locked=”off” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” background_color=”RGBA(255,255,255,0)” text_font_size_tablet=”17px” text_font_size_phone=”17px” text_font_size_last_edited=”on|phone” header_4_font_tablet=”” header_4_font_phone=”” header_4_font_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”center” text_orientation_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_button button_url=”https:\/\/app.sheetgo.com\/templates\/attendance” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/04\/classroom-workflow-usecase.png” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Sheetgo\u2019s attendance management template is a pre-built system for monitoring students. Although it\u2019s based in Google Sheets, it\u2019s a little different from a standard spreadsheet template.<\/p>\n With this system<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/ATTENDANCE-MANAGEMENT-GOOGLE-SHEETS-MASTER-SHEET.png” alt=”ATTENDANCE MANAGEMENT GOOGLE SHEETS MASTER SHEET” title_text=”ATTENDANCE MANAGEMENT GOOGLE SHEETS MASTER SHEET” align=”center” module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Click on the blue button below to sign up for Sheetgo and install Sheetgo’s attendance workflow template.<\/p>\n [\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/templates\/attendance” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|30px|0px|false|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” locked=”off” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The template is designed for face-to-face lessons, but it\u2019s easy to adapt to online teaching and Google Classroom attendance monitoring.<\/p>\n Normally, each teacher opens their spreadsheet at the start of the lesson on their laptop or tablet. They manually enter whether each student is P: present, T: tardy (late), E: excused or U: unexcused (absent) using the dropdown menu. If you want to use the template for face-to-face classes, get full instructions here<\/a>.<\/p>\n To adapt the template for remote classes, you use Google Forms instead. At the start of each online class, the teacher shares a special link with students via Google Classroom. All students participating must \u201ccheck in\u201d to class by submitting the form. Instead of the teacher having to manually register which student showed up to class, the data flows into the teacher\u2019s spreadsheet automatically from the forms.[\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Sheetgo\u2019s attendance management template contains one master spreadsheet which consolidates attendance data from every class. It summarizes the data in charts to give managers an overview of attendance across the school.<\/p>\n This central spreadsheet is connected to three Class<\/strong> spreadsheets. The files included in the template are named History, Math and Science. They contain sample data, just to show you how the system works.<\/p>\n Teachers use these\u00a0Class<\/strong> files to record student attendance. The data is transferred to the master sheet via Sheetgo connections. This creates a \u201cworkflow\u201d that can be automated by scheduling regular updates.<\/p>\n To adapt the workflow for remote classes, you simply need to replace each pre-connected Class spreadsheet with a different file. Click this link to copy the new <\/a>Remote Class<\/a> spreadsheet.<\/a><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AB-1.png” alt=”google-classroom-attendance-copy-template” title_text=”AB 1″ module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Make as many copies as you need for different classes and rename the files accordingly.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/remote-mathematics.png” alt=”google-classroom-copy-class-sheet” title_text=”remote mathematics” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The Remote Class<\/b> spreadsheet comes with two Google Forms attached. First of all, let\u2019s check if these forms are configured correctly.<\/p>\n Open the spreadsheet and go to the Attendance form<\/b> tab. Go to\u00a0Tools\u00a0<\/b>in the menu bar at the top of the screen.<\/p>\n Click Manage form<\/b> > Edit form<\/b>. Within the form itself, click on the link\u00a0“Change settings”.<\/b><\/p>\n Within Settings, click on Responses and make sure that the Collect email addresses<\/b> and\u00a0Restrict to users in [name of your organization] and its trusted organizations<\/b> boxes are both checked.<\/p>\n By ticking these two options, the form will automatically obtain the email address from the user\u2019s Google account (in this case, that\u2019s the student who is logged in).<\/p>\n Your students will use this form to confirm that they are present in an online class. Note that this form doesn\u2019t contain any fields to fill out. Your students simply have to click the Submit <\/b>button to register their presence in the class.<\/p>\n At the beginning of each online session, you need to share the form link with your students via Google Classroom. I\u2019ll show you how to do that later, but first, let\u2019s set up the template.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AB-3.png” alt=”google-classroom-folder-in-drive” title_text=”AB 3″ _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In addition to the Attendance form, you will see that the spreadsheet also contains an Absence excuse form.<\/b> You can use this form to register an approved absence. This form can also be used by parents to communicate when and why their child will be absent from class. It\u2019s much easier than emails and everything is logged in the spreadsheet allowing administrators to check the information.<\/p>\n Unlike the Attendance form, the Absence excuse form<\/b> contains a couple of fields to be filled out. These include the student\u2019s email address, date of absence, justification, and a file upload field to attach files (such as medical appointment receipts, photos, videos, etc). This form is ready to use; you don\u2019t need to check or adjust the settings.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ make_equal=”on” _builder_version=”4.22.2″ _module_preset=”default” background_color=”#F6F8F9″ custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” locked=”off” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” background_color=”RGBA(255,255,255,0)” text_font_size_tablet=”17px” text_font_size_phone=”17px” text_font_size_last_edited=”on|phone” header_4_font_tablet=”” header_4_font_phone=”” header_4_font_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”center” text_orientation_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_button button_url=”https:\/\/app.sheetgo.com\/templates\/attendance” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As outlined before, Sheetgo\u2019s attendance management template contains three pre-connected Class spreadsheets (History, Math and Science) for face-to-face classes. You now need to swap these for Remote Class<\/b> spreadsheets.<\/p>\n Go to Google Drive, open the folder that Sheetgo created with the old Class files. You will find this folder under Google Drive<\/strong> > Sheetgo Templates<\/strong> > Attendance management<\/strong>.<\/p>\n Delete the 3 Class spreadsheets.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AB-4.png” alt=”google-classroom-attendance-folder-in-drive” title_text=”AB 4″ module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Open Sheetgo, locate and click on the Attendance management<\/b> workflow in the bar on the left of the screen.<\/p>\n Click on the\u00a0Connections<\/b> tab in the right top corner. You will see there are three connections: Overview per student<\/b>, Overview per month <\/b>and Attendance complete check.<\/b>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AB-5.png” alt=”google-classroom-attendance-view-connections” title_text=”AB 5″ module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n First of all, delete the connection Attendance complete check<\/b>.<\/p>\n This connection is not required if you\u2019re adapting the template for remote classes.<\/p>\n To delete the connection, click on the menu (\u22ee<\/strong>) next to the connection and click Delete<\/b>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AB-6.png” alt=”delete-attendance-check-connection” title_text=”AB 6″ module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Overview per student<\/b> and\u00a0Overview per month<\/b> are Consolidate<\/strong> connections. This means they pull data from multiple spreadsheets\u00a0<\/b>(the Class files) into one file (the Attendance Management master sheet).<\/span><\/p>\n Sheetgo works by moving data from a source tab (sheet) to a destination tab (sheet) so when you connect the Remote Class<\/b> files, you need to pay attention to the tab name. The tab name is the same as the connection name.<\/span><\/p>\n To start with, let\u2019s connect the first new Remote Class<\/b> file. In this example, the spreadsheet I want to connect to the template is called Remote French Class<\/b>.<\/p>\n Next to the first connection, Overview per student,<\/b> click on the menu (\u22ee<\/strong>) then Edit Connection<\/strong>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AB-7.png” alt=”google-classroom-attendance-edit-overview-connection” title_text=”AB 7″ module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The connection editor opens. At the top of the screen, <\/span>Source Data: Multiple Files <\/b>indicates that this is a Consolidate connection.<\/span><\/p>\n You will also see that Sheetgo displays the old files (History, Math and Science), although you have deleted them from your Google Drive. This is just so you can see the connections and replace them with new files.<\/span><\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AB-8.png” alt=”google-classroom-attendance-edit-connection” title_text=”AB 8″ _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Click on the first file in the list: History.<\/b><\/p>\n Now click on the Google Drive icon Change file<\/b>.<\/p>\n Select the first of your new remote Class spreadsheets and click Done<\/strong>.<\/p>\n Here you can see I have selected my file\u00a0Remote French Class\u00a0<\/b>and it appears in Sheetgo.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AB-9.png” alt=”google-classroom-edit-connection” title_text=”AB 9″ _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Now for the important step: select the correct file tab<\/b>. This is the source tab in my Remote French Class<\/strong> spreadsheet that contains the data I want to pull into the master sheet.<\/p>\n In this case, that\u2019s\u00a0Overview per student<\/b>.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AB-10.png” alt=”google-classroom-edit-connection-4″ title_text=”AB 10″ _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]Click Done<\/b> and repeat the same steps to connect your other source files.<\/p>\n Here, I will replace the Science and Maths files with two further remote spreadsheets for my\u00a0German and Spanish classes.<\/p>\n Click Save changes.<\/b>[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AB-11.png” alt=”google-classroom-edit-connection” title_text=”AB 11″ _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You have now replaced the files for one of the connections:\u00a0Overview per student<\/b>. Now it\u2019s time to connect the files for the other connection:\u00a0Overview per month<\/b>.<\/p>\n From the workflow connections list, go to Overview per month<\/b>, click on the menu icon (\u22ee<\/strong>) then Edit<\/strong>.<\/p>\n As before, replace each file in the list with your new remote files and select the correct source tab. This time, the correct source tab is Overview per month<\/b>.<\/p>\n Click Save changes<\/b>.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AB-12.png” alt=”google-classroom-edit-connection” title_text=”AB 12″ module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Inside each of your new Remote Class spreadsheets, go to the Attendance form<\/b> tab. In the top menu bar, click on Form<\/b> > Go to live form<\/strong>.<\/p>\n A new tab opens in your browser with the live form. Copy the URL and publish it in the Google Classroom page for that specific subject.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=”3_5,2_5″ make_equal=”on” _builder_version=”4.22.2″ _module_preset=”default” background_color=”#F6F8F9″ custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” locked=”off” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”3_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” background_color=”RGBA(255,255,255,0)” text_font_size_tablet=”17px” text_font_size_phone=”17px” text_font_size_last_edited=”on|phone” header_4_font_tablet=”” header_4_font_phone=”” header_4_font_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”center” text_orientation_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][\/et_pb_column][et_pb_column type=”2_5″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_button button_url=”https:\/\/app.sheetgo.com\/templates\/attendance” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n When you want to share the Absence excuse form, <\/b>do\u00a0it in exactly the same way.<\/p>\n Open the Absence excuse tab, then click on Form<\/b> >Go to live form<\/b>. Copy the URL and share it with parents or administrators so they can register and provide a reason for a student\u2019s absence.<\/p>\n These forms are independent of Google Classroom, so you can publish them on your school intranet or send them by email or group chats.<\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This remote attendance tracking template works in a similar way to Sheetgo\u2019s original template. As you read before, normally teachers manually select P (present) T (tardy) E (excused) and U (unexcused) for every student.<\/p>\n In this adapted workflow, these inputs are automatically filled out by in-cell functions. These functions retrieve data from the Attendance form<\/b> and the Absence excuse form<\/b>.<\/p>\n It\u2019s important to note that this adapted template requires both the student\u2019s name and their email address (unlike the original template).<\/p>\n The student\u2019s email address is used by the functions to cross reference information and verify which student has logged in and attended the class.<\/p>\n For this reason, you must fill out all student names and email addresses in the Instructions<\/b> tab of each Remote Class spreadsheet.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/haha.png” alt=”google-classroom-attendance-enter-student-names” title_text=”AB 12B” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Here\u2019s how it works:<\/p>\n The function searches the Attendance form<\/b> to see if the student checked in that day. If so, the cell will display a P (present) for that date.<\/p>\n When the student is not found in the Attendance form<\/b> responses, the function will search the\u00a0Absence excuse form<\/b>. If the function finds an excuse for the student on that specific date, the cell will display an E (Excused) otherwise it will display a U (Unexcused).<\/p>\n Unlike the original template, this template does not include the T (Tardy – or late) status.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AB-R.png” alt=”google-classroom-attendance-function-display-formulas” title_text=”AB R” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you\u2019re an administrator and you haven\u2019t already done so, share the new Remote Class spreadsheets with each teacher responsible, using Google Sheets\u2019 sharing function.<\/p>\n Once everything is set up and you and your colleagues start using the template, it\u2019s time to update the workflow. Each time you update the workflow, fresh data is pulled from the source spreadsheets (in this case, the teachers\u2019 Remote Class files) into the destination spreadsheet (your attendance management master sheet).<\/p>\n You can do this manually by opening Sheetgo, clicking on the Attendance Management workflow and clicking\u00a0Run<\/b> in the left bottom corner .[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AB-13.png” alt=”google-classroom-attendance-workflow-run” title_text=”AB 13″ module_class=”sheetgo-post-no-shadow-img” _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]To ensure you\u2019ve always got the latest student attendance data from your team of teachers, you can automate the entire workflow. In the left bottom corner, click Automate<\/b> and choose how often you want the data to be updated.[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/05\/AB-14.png” alt=”google-classroom-attendance-automate” title_text=”AB 14″ _builder_version=”4.22.2″ width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To add more source files to the workflow, copy one of your Remote Class<\/b> spreadsheets and connect it using Sheetgo.<\/p>\n Open Sheetgo, click on your Attendance Management workflow then go to the Connections<\/b> list. Click the menu icon (\u22ee<\/b>) next to each connection then Edit connection<\/b>.<\/p>\n Under Source Data> Multiple Files, you will see your current list of connected files.<\/p>\n Scroll down and click +Add another source file.\u00a0<\/b><\/p>\n Locate the new file in Google Drive and click Done<\/b><\/p>\n Select the correct File tab, then click Done.<\/b><\/p>\n Repeat this for further files, then click Save changes.<\/b>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row make_equal=”on” _builder_version=”4.22.2″ _module_preset=”default” background_color=”#F6F8F9″ custom_padding=”30px|30px|30px|30px|true|true” border_radii=”on|12px|12px|12px|12px” locked=”off” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.22.2″ _module_preset=”default” custom_css_main_element=”margin:auto” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” background_color=”RGBA(255,255,255,0)” text_orientation=”center” text_font_size_tablet=”17px” text_font_size_phone=”17px” text_font_size_last_edited=”on|phone” header_4_font_tablet=”” header_4_font_phone=”” header_4_font_last_edited=”on|tablet” text_orientation_tablet=”center” text_orientation_phone=”center” text_orientation_last_edited=”on|phone” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n [\/et_pb_text][et_pb_button button_url=”https:\/\/app.sheetgo.com\/templates\/attendance” url_new_window=”on” button_text=”INSTALL FREE TEMPLATE” button_alignment=”center” _builder_version=”4.22.2″ _module_preset=”default” custom_button=”on” button_text_size=”16px” button_text_color=”#ffffff” button_bg_color=”#2979ff” button_border_width=”0px” button_border_radius=”6px” button_font=”|700|||||||” button_use_icon=”off” custom_margin=”0px|0px|0px|0px|true|true” custom_margin_tablet=”10px||||false|false” custom_margin_phone=”10px||||false|false” custom_margin_last_edited=”on|phone” custom_padding=”15px|16px|15px|16px|true|true” saved_tabs=”all” global_colors_info=”{}” button_bg_color__hover_enabled=”on|hover” button_bg_color__hover=”rgba(41,121,255,0.7)” button_bg_enable_color__hover=”on” theme_builder_area=”post_content”][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" Working from home isn\u2019t easy for anyone, but for teachers, it poses a major organizational challenge. As one of the most interactive jobs in the world, teaching involves personal communication with up to 30 students at any one time. Multiply that for all your classes, and it\u2019s not uncommon to be working with several hundred […]<\/p>\n","protected":false},"author":39,"featured_media":254722,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"2880","footnotes":""},"categories":[49],"tags":[35],"class_list":["post-24269","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-education-templates","tag-education"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/24269","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/users\/39"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/comments?post=24269"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/24269\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/254722"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=24269"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=24269"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=24269"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}Monitor Google Classroom attendance<\/b><\/h3>\n
A system for teachers and admin staff<\/h5>\n
Sign up for Sheetgo and start recording and analyzing student attendance<\/span><\/span><\/h4>\n
\u00a0Why use Google Sheets to track Google Classroom attendance?<\/h3>\n
\n
What\u2019s a spreadsheet-based workflow?<\/h3>\n
\n
Track Google Classroom attendance with a template<\/h3>\n
\n
How to get the Google Sheets attendance template<\/h3>\n
How the template works<\/b><\/h3>\n
Step 2: Adapt the template for remote classes<\/b><\/h3>\n
2.2 Copy the new Class spreadsheet<\/b><\/h4>\n
2.3 Check the Google Forms<\/b><\/h4>\n
How to register absences<\/h4>\n
Start recording and analyzing student attendance<\/span><\/span><\/h4>\n
2.4 Replace the Class spreadsheets with the Remote Class spreadsheets<\/b><\/h4>\n
2.5 Replace the connections in the workflow<\/b><\/h4>\n
Select the file tab<\/h4>\n
Repeat for the other connection<\/h4>\n
Step 3: Publish the forms<\/b><\/h3>\n
Start recording and analyzing student attendance<\/span><\/span><\/h4>\n
Step 4: Complete the set-up of your remote attendance system<\/b><\/h3>\n
Step 5: Start and automate the Google Classroom workflow<\/b><\/h3>\n
Want to expand the template?<\/b><\/h3>\n
Start recording and analyzing student attendance<\/span><\/span><\/h3>\n