Google Apps Script Workshop

Help 2Sigma Education by running a workshop to teach them how to use Google Scripts to automate tasks and processes in various Google Apps.
2Sigma Education
New York, NY, USA
Unfollow
Log in to follow
2Sigma Education
New York, NY, USA

0

Live Projects

4

Matched Projects
0 Followers

Posted May 27th

Project details

What we need
  • A workshop that teaches users how to write and troubleshoot a script connecting multiple Google products
  • One functional prototype of an Apps Script, such as mail merge, form automation, etc. by the end of the workshop
  • Resources for learning further about the topic as well as existing ready-to-use scripts built by other developers
What we have in place
  • We currently have sources of robust data, which should make it easy for you to get started. We also have extensive use of Google Apps and gmail, and the ability to provide any other information you need.
How this will help
This project will save us $2,752 , allowing us to bring personalized learning experiences to 1000 elementary school students.

The success of our organization depends on being able to automate our reporting. Without your help, we cannot set up this important system. Your skills will empower us to change the way teachers operate.

Project plan

P
Prep: Goals & Format
  • Volunteer Manager outlines Organization’s current Google Apps setup and shares challenges faced by staff in using Google Apps
  • Volunteer Manager to share logistical information such as number of workshop attendees and current workflows that involve Google Apps
  • Professional suggests format of workshop (Skype/in person/web conference)
1
Milestone 1: Logistics & Communications
  • Volunteer Manager and Professional agree on time and date for workshop
  • Volunteer Manager and Professional agree on one specific functional Apps Script prototype that will be covered in the workshop (e.g. mail merge, form automation, etc.)
  • Professional creates detailed agenda for workshop outlining topic as well as structure of training
  • Professional works with Volunteer Manager to create a functional prototype of an Apps Script to be covered during training
  • Professional shares agenda, Apps Script prototype and preparatory materials (if any) with Volunteer Manager
  • Volunteer Manager communicates opportunity and shares agenda and preparatory materials with staff, and collects RSVPs
2
Milestone 2: Workshop & Resource Sharing
  • Volunteer Manager informs the professional of the number of RSVPs along with any questions that surface
  • Professional conducts workshop, answers any questions and provides recommendations for finding assistance going forward
Show more

About the org

2Sigma Education
Unfollow
Posted by
Jeff K.

Volunteer manager

Our mission

To help schools maximize student learning while reducing costs

What we do

2Sigma Education is a nonprofit organization that helps schools maximize student learning while reducing costs. Experts agree that the most effective form of education is 1 on 1 instruction for each student. Unfortunately, 1 on 1 instruction is also impractical and unaffordable at scale. At 2Sigma, we’ve developed an education model that combines teachers, technology, and data to replicate the effectiveness of 1 on 1 instruction in a traditional classroom setting.

(Note: We are in the midst of a rebranding effort and do not yet have a new website. Our old brand does have a website, and so we have provided the links to that site. Sorry for the confusion!)

The pixel