[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/09\/campus-min-min.webp” alt=”Sheetgo\u00b4s use cases” title_text=”Sheetgo and Pasadena use case” _builder_version=”4.17.4″ _module_preset=”default” width=”100%” max_width=”600px” max_height=”360px” border_radii=”on|12px|12px|12px|12px” box_shadow_style=”preset1″ box_shadow_horizontal=”6px” box_shadow_vertical=”0px” global_colors_info=”{}”][\/et_pb_image][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Using Sheetgo, Pasadena now saves around 4 days every month thanks to a custom workflow that automatically assigns tutors to a student in need of extra support.<\/p>\n
As a result, Pasadena can provide additional guidance to over 2,500 students within a single, automated workflow.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Assigning tutors to 2,500+ students in one of their 67 schools<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- Huge, complex database full of student information<\/li>\n
- Impossible to manually assign tutors to 2,500 students<\/li>\n
- Too many spreadsheet formulas led to serious errors<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
One of Pasadena\u2019s schools needed a remedial education system to assign students in need of extra support to teachers that could help them out. For a school with over 2,500 students, this would be difficult to do manually, resulting in a lot of human error.<\/p>\n
They tried to organize all of this data into various spreadsheets, using formulas to cross over the information. However, this quickly became impossible due to the sheer amount of data as well as the number of formulas used.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]\u201cWith 2,500 students worth of data to organize and manage, doing this task manually became impossible. We tried using formulas in spreadsheets to do the work for us, but they became too heavy to use.\u201d<\/span><\/p>\n
Michael Kaatz, Technology Specialist| Pasadena Independent School District<\/em>[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Pasadena desperately needed a system that made it easier for teachers to insert student demands to assign tutor support to each student. Software designed for this is too expensive and lacks flexibility for customizations.<\/p>\n
That’s why Pasadena approached Sheetgo to provide a custom tutor management solution that could connect with their existing student database.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
A seamless and secure student reporting system<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- Connect Google Forms to transfer data inputs<\/li>\n
- 1 master sheet to combine all data sources<\/li>\n
- Split data to create a unique report per student<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
With Sheetgo, Pasadena has built a custom workflow that automatically creates reports for their 2,500 students to assign tutor support. Sheetgo turns their once endless database of data into digestible Excel files that contain information about whether a student needs extra support.<\/p>\n
Their new workflow also connects with Google Forms, so that any student who requests extra support can submit a form and the data will be added to the workflow. The Excel files and the Google Forms submissions are then connected to a Google Sheets master spreadsheet, where Pasadena has all of the student data in one place.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]\u201cSheetgo is perfect when you have a restricted budget while needing to create internal customized solutions. It\u2019s easy to use, reliable, and have amazing support.\u201d<\/span><\/p>\n
Michael Kaatz, Technology Specialist| Pasadena Independent School District<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Sheetgo uses the Split feature to then divide the master sheet into separate reports for each student, keeping their personal information private and secure. These unique reports can then be distributed to the students and teachers, detailing their tutoring information.<\/p>\n
With this new system, the school no longer has to manually update their reports or identify students who need support – Sheetgo takes over the entire process to automatically manage the tutoring management.<\/p>\n
[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][et_pb_row_inner _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_column_inner saved_specialty_column_type=”2_3″ _builder_version=”4.16″ _module_preset=”default” global_colors_info=”{}”][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Saving 1 day per week to dedicate to providing quality student support<\/h2>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” background_color=”#efefef” custom_padding=”45px|45px|30px|45px|false|true” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}”]<\/p>\n
- \n
- 4 days saved per month<\/li>\n
- Keeping student data private and secure<\/li>\n
- Managing 2,500 students in one workflow<\/li>\n<\/ul>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Thanks to this new system, Pasadena now saves around 1 day per week or 1.5 hours per day which they can now dedicate to providing the top-quality support needed by their students.<\/p>\n
What’s more, they now have a completely safe process that keeps student data 100% private and confidential to avoid any security issues.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” custom_padding=”20px|20px|20px|20px|true|true” border_width_left=”10px” border_color_left=”#1CE598″ global_colors_info=”{}”]\u201cSheetgo saves us at least 1.5 hours a day and I can keep the data updated even when I take days off for vacations.\u201d<\/span><\/p>\n
Michael Kaatz, Technology Specialist| Pasadena Independent School District<\/em>[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
With this automated workflow, this school from the Pasadena district no longer has to worry about manually updating its tutoring information.<\/p>\n
They now have an affordable, self-sufficient solution that handles their student information securely, generating the reports they need to give their students the best guidance and support they need for the rest of their academic years.<\/p>\n
[\/et_pb_text][\/et_pb_column_inner][\/et_pb_row_inner][\/et_pb_column][et_pb_column type=”1_3″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2019\/10\/customers_pasadena.svg” alt=”Pasadena logo” title_text=”customers_pasadena” align=”center” _builder_version=”4.17.4″ _module_preset=”default” width=”200px” max_width=”200px” global_colors_info=”{}”][\/et_pb_image][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Pasadena Independent School District provides a menu of post-secondary, technical and specialized opportunities that prepare students for higher education and adaptable workplace environments. There are 67 schools in the District and over 55,000 students.<\/span><\/p>\n
[\/et_pb_text][et_pb_icon font_icon=”||fa||900″ icon_width=”16px” align=”left” _builder_version=”4.16″ _module_preset=”default” custom_margin=”|20px|10px||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.27.4″ _module_preset=”default” width=”85%” custom_margin=”||10px||false|false” hover_enabled=”0″ custom_css_main_element=”display: inline-block;” global_colors_info=”{}” sticky_enabled=”0″]United States<\/span>[\/et_pb_text][et_pb_icon font_icon=”||fa||900″ icon_width=”16px” align=”left” _builder_version=”4.16″ _module_preset=”default” custom_margin=”|20px|||false|false” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”][\/et_pb_icon][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” width=”85%” custom_css_main_element=”display: inline-block;” global_colors_info=”{}”]https:\/\/www1.pasadenaisd.org\/<\/span><\/a>[\/et_pb_text][et_pb_divider _builder_version=”4.16″ _module_preset=”default” custom_margin=”||20px||false|false” global_colors_info=”{}”][\/et_pb_divider][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]<\/p>\n
Industry<\/strong>
Education<\/span><\/p>\n[\/et_pb_text][et_pb_text _builder_version=”4.17.4″ _module_preset=”default” global_colors_info=”{}”]Features used<\/strong><\/span><\/p>\n
![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/04\/bs-icon-google-sheets.svg\")
Google Sheets<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/icon-excel.webp\")
Excel<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2020\/05\/icon-connection.svg\")
Connect<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/icon-split.webp\")
Split<\/div>\n![\"\"](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2022\/06\/automatic-updates.webp\")
Automatic updates<\/div>\n[\/et_pb_text][\/et_pb_column][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"
Pasadena: Automating a tutor management process for over 2,500 studentsSheetgo is the no-code spreadsheet automation platform that turns the data your team already keeps in Sheets, Excel, and CSVs into pipelines, dashboards, and AI-ready datasets.Using Sheetgo, Pasadena now saves around 4 days every month thanks to a custom workflow that automatically assigns tutors to a […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":6600,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"difl_page_category":[],"class_list":["post-13194","page","type-page","status-publish","hentry"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/13194","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=13194"}],"version-history":[{"count":1,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/13194\/revisions"}],"predecessor-version":[{"id":260745,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/13194\/revisions\/260745"}],"up":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/pages\/6600"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=13194"}],"wp:term":[{"taxonomy":"difl_page_category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/difl_page_category?post=13194"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}