Hands on with Google Apps Scripts Part I

It is recommended that attendees have:
  • a basic understanding of creating Google Forms and how Forms & Spreadsheets interact before joining this session. 

  • A laptop. Your mileage may vary on an iPad--or you may not be able to get hands-on. 

In this hands-on one-hour session, we will cover the following:
And the new "Add Ons" for the new version of spreadsheets
Explore these if you have some time

  1. Fill out this form
    After completion of this, we'll take a look at the workflow of Flubaroo before you get started on it yourself. 

  2. Create your own form with the following question fields
    1. Last name
    2. First name
    3. Email address
    4. Question 1 (Multiple Choice)
    5. Question 2 (Multiple Choice)
    6. Question 3 (Multiple Choice)

  3. Create your key by submitting to the form with KEY in the Last name, First name, and Email fields. 

  4. Send the link to your form by email to an elbow partner; have him/her complete the form. 

  5. Install the Flubaroo script and then run through the steps for grading the responses.

  6. Celebrate with a victory dance!


  1. please visit this spreadsheet and make a copy of the spreadsheet
  2. Install the Doctopus script from the script gallery and then run the script
  3. Share a document with your "students"
  4. Install the Goobric plugin (Chrome only) and then make a copy of this rubric
  5. Attach the rubric to the document you shared with your students. Test out using the rubric to give feedback.
Want to read up  more on Doctopus? Then head over here

gClass Folders
  1. Follow me over to the gClass Folders website 
  2. Select Instructions > Teacher Mode

  3. We'll work through the steps together to create and distribute folders to students. If you would like some sample student email addresses & names (that are attached to live email addresses), then please visit this spreadsheet and copy the student information over.
  4. Celebrate with your awesomeness!