Robotizing for Better School Bureaucracy: Using Apps Scripts to automate workflows, data feeds, communications, and document management for schools and classrooms that work better.
This workshop is aimed at the Google Apps power user who wants to be able to leverage the GAFE platform beyond the basics for organizational workflows, automated communications, data-driven decision-making, and document management. The session will focus on learning to solve everyday organizational challenges using a suite of Google Apps Scripts authored by the presenter to allow Google Spreadsheets to perform templated document merges, relational data lookups, form-triggered, conditionalized, and bulk merged emails, form-triggered calendar events, and automated text messages. Though participants will get a basic introduction to the Apps Script code editor, the intention of this clinic is not to teach coding skills. Participants will gain the most if they already have intermediate Spreadsheet skills, and can expect to walk away with a set of practical, menu-driven power tools for the GAFE platform that they can immediately put to use in their schools
The Google Apps Scripting in Education workshop is led by Andrew Stillman, a 10 year veteran NYC public school science educator and administrator, the founder of a successful urban STEM school, and passionate builder of online spaces and tools for schools.