{"id":15066,"date":"2020-08-25T18:45:00","date_gmt":"2020-08-25T16:45:00","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=15066"},"modified":"2025-12-18T00:07:02","modified_gmt":"2025-12-17T23:07:02","slug":"modele-de-suivi-de-lassiduite-des-eleves-dans-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/fr\/blog\/education-templates\/student-attendance-tracker-template-in-google-sheets\/","title":{"rendered":"Mod\u00e8le de suivi de l'assiduit\u00e9 des \u00e9l\u00e8ves dans Google Sheets"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; module_class=&#8221;sheetgo-post&#8221; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;54px|0px|1px|0px|false|false&#8221; da_disable_devices=&#8221;off|off|off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221;][et_pb_row _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.24.1&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">If you need a reliable student attendance tracker and a way to analyze attendance over time, you could use something better than your memory and a stack of paper lists.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Luckily the education sector is steadily catching up with other workplaces and adopting new technologies to modernize working practices. Transforming time-consuming manual practices into automated processes. This saves teachers precious time and helps administrators run their schools more effectively.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">However, it can be difficult to find software that\u2019s both affordable for schools and easy for staff to use. Let\u2019s go over Sheetgo\u2019s Student attendance tracker template in Google Sheets.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;sheet&#8221; _builder_version=&#8221;4.27.2&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Why use Google Sheets to create a student attendance tracker?<\/h3>\n<p><span style=\"font-weight: 400;\">With the power of Google Sheets, educational institutions can design a customized attendance system to fit their specific requirements.<\/span><\/p>\n<p><span style=\"font-weight: 400;\"><\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Flexible:<\/b><span style=\"font-weight: 400;\"> Create an attendance system to suit your school. If things change in the future just adapt your spreadsheets, without the need for new software or IT support.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Accessible: <\/b><span style=\"font-weight: 400;\">Access data for all your classes from anywhere in the world on your laptop or smartphone.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Compatible:<\/b><span style=\"font-weight: 400;\"> Many other pieces of software integrate with Google Sheets. If you have data stored in other programs (such as Google Classroom), you can easily download or directly import that data and centralize everything in Google Sheets.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Easy to use:<\/b><span style=\"font-weight: 400;\"> Almost every professional works with spreadsheets at some point during their life. Google Sheets is a very intuitive and user-friendly system, even for spreadsheet novices. This makes maintenance and training easier, and you can be sure that your system is future-proof.<\/span><\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Sign up for Sheetgo and start recording and analyzing <span style=\"background-color: rgba(41,121,255,0.2);\"><span>student attendance<\/span><\/span><\/h4>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/attendance&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text module_id=&#8221;why&#8221; _builder_version=&#8221;4.27.2&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><span style=\"font-weight: 400;\">Why use Sheetgo?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Sheetgo is a powerful tool that transforms how you manage data in spreadsheets. It streamlines collection, organization, and analysis, making it easier for users to simplify tasks.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">This spreadsheet-based template by Sheetgo is a pre-built system for automated attendance management. It brings many benefits to the table:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It can be used by any school, college, or training center.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It offers teachers a simple and reliable way to take roll .<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">It provides administrators with attendance records for every student and class.<\/span><\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/01\/Student-attendance-template-Sheetgo.jpeg&#8221; alt=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF90aXRsZSIsInNldHRpbmdzIjp7ImJlZm9yZSI6IiIsImFmdGVyIjoiLyBDbGFzcyBhdHRlbmRhbmNlIG92ZXJ2aWV3In19@&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _dynamic_attributes=&#8221;alt&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;workflow-template&#8221; _builder_version=&#8221;4.27.2&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><span style=\"font-weight: 400;\">What is a spreadsheet-based workflow template?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">A regular attendance tracker template is a single file containing tables, charts, layouts, and formulas but a Sheetgo workflow template is mucho more. It\u2019s a group of interconnected Google Sheets that exchange data between them. This allows you to share information with colleagues while working autonomously in your own individual file.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">A spreadsheet-based workflow template gives you:<\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Organization and data privacy<\/b>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><b>Each file is task-specific<\/b><span style=\"font-weight: 400;\">, keeping data flows secure and separated. Teachers have their own personal spreadsheets for student attendance tracker.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><b>Authorities can combine confidential data<\/b><span style=\"font-weight: 400;\"> from all professors and classes into one central spreadsheet and dashboard.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Scalability<\/b>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><b>Keep the system running smoothly<\/b><span style=\"font-weight: 400;\"> by dividing data into separate, specialized spreadsheets. Sure, Google Sheets has a powerful sharing function. But if you have too many people working in the same file it can become overloaded and slow.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">To <\/span><b>add new classes or teachers easily<\/b><span style=\"font-weight: 400;\">, simply duplicate one of the spreadsheets and share it with the corresponding person.<\/span><\/li>\n<\/ul>\n<\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Integration<\/b><span style=\"font-weight: 400;\">:\u00a0<\/span>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><b>Easily import and incorporate data<\/b><span style=\"font-weight: 400;\"> from other software, a spreadsheet-based workflow\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><b>Allows authorities to merge data <\/b><span style=\"font-weight: 400;\">from across the institution.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">In a matter of clicks, connect your attendance management workflow with your finance workflow to generate a top-level report for directors.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;get&#8221; _builder_version=&#8221;4.24.1&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2><span style=\"font-weight: 400;\">What do you get with this template?<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">When you install the Sheetgo student attendance tracker template, four Google Sheets files with pre-built Sheetgo connections are saved to your My Drive.<\/span><span style=\"font-weight: 400;\"><\/span><\/p>\n<ol>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Three <\/span><b>Class<\/b><span style=\"font-weight: 400;\"> spreadsheets:\u00a0<\/span><\/li>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Share these attendance sheets for teachers, and make as many copies as you need for additional classes.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Each teacher uses their copy of this spreadsheet to record if students are present, absent, excused, or tardy (late) for class.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">The spreadsheet automatically provides the teacher with averages and totals, so they can keep track of each student.<\/span><span style=\"font-weight: 400;\"><\/span><\/li>\n<\/ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">One <\/span><b>Attendance Management<\/b><span style=\"font-weight: 400;\"> master sheet for the school administrator or head of department:<\/span><\/li>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">Sheetgo connections pull data from all the Class spreadsheets directly into this file. A dashboard displays key information such as attendance rates per class and the top 10 students who are repeatedly absent, in easy-to-read charts.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">An attendance tracker tab allows you to check if roll was taken for every class, each day. It flags up any teachers who have forgotten to take attendance.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"2\"><span style=\"font-weight: 400;\">An automated monthly attendance tracker and an overview per student.<\/span><\/li>\n<\/ul>\n<\/ol>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/01\/Attendance-per-student.jpeg&#8221; alt=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF90aXRsZSIsInNldHRpbmdzIjp7ImJlZm9yZSI6IiIsImFmdGVyIjoiLyBPdmVydmlldyBwZXIgc3R1ZGVudCJ9fQ==@&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.16&#8243; _dynamic_attributes=&#8221;alt&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;how-to&#8221; _builder_version=&#8221;4.24.1&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to install the attendance tracker template<\/h2>\n<ol>\n<li>Login to Sheetgo with your Google, Microsoft, or Dropbox account.<\/li>\n<li>Click <b>Install template<\/b>, and <b>Install on Google Drive.<\/b><\/li>\n<li>Wait a few moments while Sheetgo installs the template and creates the connections.<\/li>\n<\/ol>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/attendance&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|30px|0px|false|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][et_pb_text module_id=&#8221;works&#8221; _builder_version=&#8221;4.24.1&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How the template works<\/h3>\n<p>The attendance management master file opens inside Sheetgo.<\/p>\n<p>To open any of the spreadsheets, double click on the file in the sidebar on the right-hand side.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/08\/Attendance-tracker-install-workflow-1.jpg&#8221; alt=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF90aXRsZSIsInNldHRpbmdzIjp7ImJlZm9yZSI6IiIsImFmdGVyIjoiLyBNYXN0ZXIgZmlsZSBvcGVuIGluc2lkZSBTaGVldGdvIn19@&#8221; _builder_version=&#8221;4.16&#8243; _dynamic_attributes=&#8221;alt&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;use&#8221; _builder_version=&#8221;4.24.1&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>How to use the template<\/h3>\n<h4><strong>Step 1: Share with teachers<\/strong><\/h4>\n<p>Share the Class spreadsheets with the teachers responsible for filling them out. To do this, open one of the files by double-clicking on it.<\/p>\n<p>It opens inside Sheetgo. Move the blue sliding bar to the right of the screen and then open the file in a new browser tab by clicking <b>Open in new<\/b>.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/08\/Attendance-template-open-class-in-new-tab-2.jpg&#8221; alt=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF90aXRsZSIsInNldHRpbmdzIjp7ImJlZm9yZSI6IiIsImFmdGVyIjoiLyBPcGVuaW5nIHRoZSBjbGFzcyBmaWxlIGluIGEgbmV3IHRhYiJ9fQ==@&#8221; _builder_version=&#8221;4.16&#8243; _dynamic_attributes=&#8221;alt&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><span style=\"font-weight: 400;\">Now rename the file as appropriate and click the green <strong>Share<\/strong> button to share the spreadsheet with the teacher responsible for that class.<\/span><\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/08\/Attendance-template-Share-file-green-button-3.jpg&#8221; alt=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF90aXRsZSIsInNldHRpbmdzIjp7ImJlZm9yZSI6IiIsImFmdGVyIjoiLyBTaGFyaW5nIHRoZSBjbGFzcyBmaWxlIHdpdGggdGhlIHByb2Zlc3NvciJ9fQ==@&#8221; _builder_version=&#8221;4.16&#8243; _dynamic_attributes=&#8221;alt&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 2: Enter student data<\/h4>\n<p>The spreadsheets in the template are provided with sample data to show you how the system works. Each teacher can overwrite the data with their own list of students, or if you\u2019re the administrator you can do this for them.<\/p>\n<p>Open a Class spreadsheet and go to the <b>Instructions<\/b> tab. Enter names in the <strong>Students list<\/strong>.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Start recording and analyzing <span style=\"background-color: rgba(41,121,255,0.2);\"><span>student attendance<\/span><\/span><\/h4>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/attendance&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/08\/Attendance-template-enter-student-names.jpg&#8221; alt=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF90aXRsZSIsInNldHRpbmdzIjp7ImJlZm9yZSI6IiIsImFmdGVyIjoiLCBJbnB1dCBzdHVkZW50cyBsaXN0In19@&#8221; _builder_version=&#8221;4.16&#8243; _dynamic_attributes=&#8221;alt&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 3: Register attendance<\/h4>\n<p>During each class, the teacher can quickly take roll directly inside their spreadsheet.<\/p>\n<p>There is a tab for each month of the year. The days of the month run across the top of the screen from left to right.<\/p>\n<p>Using the dropdown menu under each day, the teacher selects whether each student is present (P) tardy or late (T) excused or absent (E) or unexcused (U).<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/SCIENCE.png&#8221; alt=&#8221;STUDENT ATTENDANCE TRACKER GOOGLE SHEETS SCIENCE&#8221; title_text=&#8221;STUDENT ATTENDANCE TRACKER GOOGLE SHEETS SCIENCE&#8221; _builder_version=&#8221;4.16&#8243; _dynamic_attributes=&#8221;alt&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Step 4: Automate the workflow<\/h4>\n<p>Every time you update the workflow, fresh data is pulled from the teachers\u2019 class spreadsheets directly into the management spreadsheet. You can do this manually by clicking <b>Run\u00a0<\/b>but you can also schedule automatic updates to make sure you\u2019ve always got the latest data from all of your classes.<\/p>\n<p>Go to the floating menu bar and click <b>Automate. <\/b>Choose how often you want updates. For monitoring student attendance, once a day is usually frequent enough.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][et_pb_row column_structure=&#8221;3_5,2_5&#8243; make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;3_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Start recording and analyzing <span style=\"background-color: rgba(41,121,255,0.2);\"><span>student attendance<\/span><\/span><\/h4>\n<p>[\/et_pb_text][\/et_pb_column][et_pb_column type=&#8221;2_5&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/attendance&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/08\/Attendance-template-click-automate-menu-bar.jpg&#8221; alt=&#8221;@ET-DC@eyJkeW5hbWljIjp0cnVlLCJjb250ZW50IjoicG9zdF90aXRsZSIsInNldHRpbmdzIjp7ImJlZm9yZSI6IiIsImFmdGVyIjoiLyBBdXRvbWF0aW5nIHRoZSB3b3JrZmxvdyJ9fQ==@&#8221; _builder_version=&#8221;4.16&#8243; _dynamic_attributes=&#8221;alt&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;done&#8221; _builder_version=&#8221;4.24.1&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h4>Your student attendance tracking system is up and running!<\/h4>\n<p>Check out the dashboard tabs in the management master sheet. You can add your school logo to the main dashboard. You can also enter school holidays in the <strong>Daily attendance checker<\/strong> tab.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2021\/05\/ATTENDANCE-MANAGEMENT-GOOGLE-SHEETS-MASTER-SHEET-1.png&#8221; alt=&#8221;ATTENDANCE MANAGEMENT GOOGLE SHEETS MASTER SHEET&#8221; title_text=&#8221;ATTENDANCE MANAGEMENT GOOGLE SHEETS MASTER SHEET&#8221; _builder_version=&#8221;4.16&#8243; _dynamic_attributes=&#8221;alt&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][\/et_pb_column][\/et_pb_row][et_pb_row make_equal=&#8221;on&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;#F6F8F9&#8243; custom_padding=&#8221;30px|30px|30px|30px|true|true&#8221; border_radii=&#8221;on|12px|12px|12px|12px&#8221; locked=&#8221;off&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_css_main_element=&#8221;margin:auto&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; background_color=&#8221;RGBA(255,255,255,0)&#8221; text_orientation=&#8221;center&#8221; text_font_size_tablet=&#8221;17px&#8221; text_font_size_phone=&#8221;17px&#8221; text_font_size_last_edited=&#8221;on|phone&#8221; header_4_font_tablet=&#8221;&#8221; header_4_font_phone=&#8221;&#8221; header_4_font_last_edited=&#8221;on|tablet&#8221; text_orientation_tablet=&#8221;center&#8221; text_orientation_phone=&#8221;center&#8221; text_orientation_last_edited=&#8221;on|phone&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Start recording and analyzing <span style=\"background-color: rgba(41,121,255,0.2);\"><span>student attendance<\/span><\/span><\/h3>\n<p>[\/et_pb_text][et_pb_button button_url=&#8221;https:\/\/app.sheetgo.com\/templates\/attendance&#8221; url_new_window=&#8221;on&#8221; button_text=&#8221;INSTALL FREE TEMPLATE&#8221; button_alignment=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; custom_button=&#8221;on&#8221; button_text_size=&#8221;16px&#8221; button_text_color=&#8221;#ffffff&#8221; button_bg_color=&#8221;#2979ff&#8221; button_border_width=&#8221;0px&#8221; button_border_radius=&#8221;6px&#8221; button_font=&#8221;|700|||||||&#8221; button_use_icon=&#8221;off&#8221; custom_margin=&#8221;0px|0px|0px|0px|true|true&#8221; custom_margin_tablet=&#8221;10px||||false|false&#8221; custom_margin_phone=&#8221;10px||||false|false&#8221; custom_margin_last_edited=&#8221;on|phone&#8221; custom_padding=&#8221;15px|16px|15px|16px|true|true&#8221; saved_tabs=&#8221;all&#8221; global_colors_info=&#8221;{}&#8221; button_bg_color__hover_enabled=&#8221;on|hover&#8221; button_bg_color__hover=&#8221;rgba(41,121,255,0.7)&#8221; button_bg_enable_color__hover=&#8221;on&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_button][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you need a reliable student attendance tracker and a way to analyze attendance over time, you could use something better than your memory and a stack of paper lists. Luckily the education sector is steadily catching up with other workplaces and adopting new technologies to modernize working practices. Transforming time-consuming manual practices into automated [&hellip;]<\/p>\n","protected":false},"author":39,"featured_media":27386,"comment_status":"closed","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":"","footnotes":""},"categories":[49],"tags":[35],"class_list":["post-15066","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\/15066","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=15066"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/posts\/15066\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media\/27386"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/media?parent=15066"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/categories?post=15066"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/fr\/wp-json\/wp\/v2\/tags?post=15066"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}