7:30am – 9:00am Registration and Coffee

9:00am – 10:15am Advanced Use of Commonly Used Tools
Speaker: Ravi Ravishanker, CIO, WellesleyCollege

Google provides various tools--Documents, Spreadsheets, Forms, Sites and, most recently, the Drive--that are used by many of us. Each of these tools provide a rich set of features that many users are either not aware of and may find it confusing.

In this talk we will briefly provide a sample of some of the most exciting features that are available and generally useful for teaching and research, such as how to format the data in a spreadsheet to quickly create various charts; get dynamic data from the web such as stock prices and volumes into the spreadsheet with a simple formula; automatically extract a table on a website into a spreadsheet; design a custom form; email the contents of a submitted form to an arbitrary list of recipients; derive new information based on submitted forms automatically; and talk about a new experimental feature called the Fusion Tables that is geared towards Big Data analysis. We will also show how easy it is to create a Google Map from data stored in a spreadsheet, and wrap it up by showing how to pull all of these together into a Google Site. LTS staff will be happy to assist you if you decide to pursue any of these further.

10:15am – 10:30am Break

10:30am – 11:45am How to Use Google Apps Scripts
Speaker: Arun Nagarajan, Senior Developer Advocate, Google

Google Apps Script is a cloud based JavaScript environment which allows you to write powerful applications and workflows around Google Apps such as Gmail, Docs, Drive, Sheets and more. The development is entirely within a browser and its free and easy to get started. Come learn all the capabilities of Google Apps Script and walk away being able to write your first script.

11:45am – 12:45pm Lunch

12:45pm – 2:00pm Google Apps Workflow and Document Management Scripts for Education
Speaker: Andrew Stillman, Program Officer for Digital Instruction, New Visions for Public Schools

This session will provide a walk through deep-dive demonstration of several popular Google Apps Scripts, written by the presenter, in the context of common classroom or institutional management use cases. The session will close with a walk through a range of multi-Spreadsheet/Forms based system diagrams illustrating practices in use within New Visions for Public Schools, a large NYC-based high school support organization undertaking significant systems development work with Google Apps for Education.

2:00pm – 2:15pm Break

2:15pm – 3:15pm Google Apps and Google+ Enhancing Campus Communication
Speakers:
Geoffrey Greene, Director IT Support Services, Brown University
Marion Kennedy, Google+ Community Partnerships- Education

Marion Kennedy from Google will present remotely to show some use cases for Google+ in Higher Ed.

Geoffrey will present on use of Google spreadsheets with app scripting for driving a standardized service outage communication process. He will demonstrate the process of producing internal and external emails and how we generate them to stakeholders. Google is helping us to standardize our entire communication process!

3:15pm – 3:30pm Wrap up and End