1 of 11

Get Started

With Apps Script

This session is based on a presentation given by Andrew Stillman at the �California Google in Education Summit, July, 2014. +AndrewStillman @astillman

Wanda Terral

Google Education Trainer

​

Instructional Technology Specialist

Lakeland School System

Lakeland, TN

​

Google+: +WandaTerral

Twitter: @wterral

http://goo.gl/iW1fO6

2 of 11

cloudlab.newvisions.org

3 of 11

Building blocks for data-driven and efficient processes!

FORMS

SHEETS

SITES

CHARTS

SCRIPTS

4 of 11

Can Serve as A Powerful Supplement to eGradebook and District-Level Systems of Record

Bring actionable data into the workflow of your team

LMS

E-Gradebook

SIS

Google Forms �for Data Capture

Your Own

Mashup!

5 of 11

Cool tools for systems tinkerers

6 of 11

Apps Script

  • Javascript-based
  • Code editor in browser
  • Methods give direct access to a large array of Google services
  • Can be...
    • Attached to a spreadsheet, doc, or form
    • A standalone web app or service

​

7 of 11

Add-ons

Store

  • Trusted tester group
  • Domain-only
  • Public

Publishing levels

Add-ons are written in Apps Script!

8 of 11

Having the right mindset

  1. You are “smart” enough
  2. Expect to struggle
  3. Search is your friend
  4. Break problems down into�bite-sized parts
  5. Learn how to use the debugger!
  6. Read the documentation
  7. Do tutorials and take online courses

9 of 11

Resources to Help You Learn

Apps Script Developers’ Site

Great starter tutorials

Codecademy �Javascript Curriculum

Learn the basics of JavaScript, the language that �Apps Script employs.

10 of 11

G+ Communities

Apps Script for EDU - Builders and Users

Google Apps Script

Developing Add-ons for Docs/Sheets/Forms

11 of 11

Let’s write some script together

Details are in this Google Doc. You will be prompted to make a copy of the document. Working from your own copy will make it easier to take notes via the Comments feature.

​

http://bit.ly/StartingAppsScript

​