GAFE Vermont Summit 2014



Speaking Schedule  (All 3 Venues are in the Library)


Saturday, March 29
 

10:00am


Ron's SLAM: Edit Images in Google Slides or Drawings after Capturing them with Snagit



Google Presentation Link for Ron's SLAM



On March 25, Google added the ability to edit images right in Google Slides and Drawings.


Edit Images in Google Slides or Drawings after Capturing them with Snagit




Here is a preview of the SLAM topics for today:

Use Google Drive and Blogger to host a podcast - no external services required -«Brian Gray»
Pivot Reports with Synergyse -«Varun Malhotra»
LucidCharts Add-on in Google Docs -«Lee Webster»
Change over Time --> Google Earth Engine -«Donnie Piercey»
Google Add Ons --> HelloFax, Mindmeister, and EasyBib -«David Salmon»
3 Ways to Screencast with a Chromebook or Chrome Browser -«Jonathan Wylie»
Color Picker Extension -«Nick Cusumano»

Example Demo Slam Encrypt Email with a Password



1:15pm




Fusion Tables: Geo-mapping my Guests !


Fusion Table Feeds Map in a Google Site

BONUS:  Record a cool Video with Snagit and Save it to YouTube ( I will Demo)

Copy the YouTube Embed Code in the Video field  of the Attendance.

Fusion Table Guest List




(Intro to Fusion Tables / Google Forms / Script to Auto-Grade the Quiz)

«CREATION» -The Build !


PHASE 1: Map Creation in a Fusion Table

1-Google Spreadsheet (Input data) --Google Form is optional

2-Create a Fusion Table by importing the Spreadsheet (step 1)

3-Modify the Fusion Table to Produce a Map with Coordinate info

4-Publish (Embed) the Map in a Google Site



PHASE 2: Create a Form to Collect Student Responses

5-Create an online Questionnaire (Google Form)

6-Link the Form to another Google Spreadsheet

7-Insert the Form (or link) into a Google Site Page 


PHASE 3: Optional - Adv

8-Use a Google Script to «Auto Grade» the Questionnaire (Form Responses)

 


 

Sunday, March 30
 

11:40am





-Steps to Create a Pivot Table Report

Pivot Tables Intro


- Normalize Data (unpivot)


03-Fusion Pivot Tables


-Demo of an Excel Pivot Table/Chart






Comments