GAFE MTL Summit 2013


Sunday, December 8 • 3:00pm - 4:00pm (Room 314)

Treasure hunting and Geocaching finds its way into our curriculum.

The Earth is our extended playground for learning. A single coordinate on a map can act as a catalyst to awesome discussions. In this session I will demonstrate how we are using Fusion Tables to engage students at the Arundel Nature & Science Centre.



Ron Turchyniak

Educational & Assistive Technology Consultant for the Sir Wilfrid Laurier School Board.

Google Apps for Education Admin & Trainer.

01-Fusion Tables: GAFE Montreal

Let's visit the

Arundel Nature and Science Centre (ANSC)

This session is about ...

«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


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

01-SWLSB Schools (Spreadsheet Prep)

Previous GAFE Links

Finding the story in data

Learn How to Publish HTML to Google Sites

Embed Public Data or Fusion Table Visuals

Create Cool Visuals with these Data Sets

List of musical instruments - Wikipedia, the free encyclopedia

List of conflicts in Canada - Wikipedia, the free encyclopedia

List of countries by exports - Wikipedia, the free encyclopedia

List of massacres in Canada - Wikipedia, the free encyclopedia

List of dog breeds - Wikipedia, the free encyclopedia


List of dog breeds-Google Fusion Tables

Model after this

Caterpillars, pupae, butterflies & moths


Search for a Cool Public Fusion Tables

Google Apps Education Community Map - Google Fusion Tables

IPAD Apps - Google Fusion Tables

List of Canadian provinces and territories by population - Wikipedia, the free encyclopedia - Google Fusion Tables

Locations in Ontario - Google Fusion Tables

Election Results - Quebec - Google Fusion Tables

School Boards - Google Fusion Tables

Indigo Schools - Google Fusion Tables

Public_Libraries.csv - Google Fusion Tables

Follow the Flame with Figures Map - 2012 Olympic Torch

Timeline - The Olympic Games - Google Fusion Tables

Timeline - The Olympic Games

Mapped Tennessee Traffic History - Google Fusion Tables

Major Innovations in the History of Biotechnology timeline | Timetoast timelines - Google Fusion Tables

Copy and Share this…

National Parks of Canada - Google Fusion Tables

Map Markers/Icons sets

Map marker or Icon names - Google Fusion Tables

Some Junk I use to Brainstorm !

Classroom- Fusion Tables

Classroom full of student collect data into one spreadsheet and then immediately create a map, chart or graph that represents the data.

Students could then make conclusions and predictions based on the visualization.

Example Gallery

United Kingdom Secondary School Results Mapped

Secondary schools league tables 2012-Dept Of Education

Caterpillars, pupae, butterflies & moths

Hosting a Fusion Tables embedded map in a Google Drive web page

IPad Apps for Kids

Project for local library uses card layout extensively

The Oscars just announced the 2012 Nicholl fellowships in Screenwriting competition, and are mapping the countries sending in applications

National Multiple Sclerosis Society Data Visualization

Activities Summary from

Mapping the Storm Clean-up

Yearly Coffee Consumption

Google Public Data Explorer (Help)

Unemployment in Canada


Fusion Tables Help

Issue Tracker for Google Fusion Tables

Fusion Tables User Community (Google Product Forums)

Advanced Topics

Embed a Fusion Table Chart in a Website or Google Drive Folder

Embed a Map or Chart in Google Sites

Fusion Tables Layer Wizard

Google Fusion Tables API

Syncing a Google Form with a Fusion Table

Canada Boundary Data for Maps

Script It! with Fusion Tables -Streamed live on Apr 4, 2013

Building a Charts Dashboard with Google Apps Script

Upload datasets for visualization and exploration. (DSPL) (DSPL Tutorial)

Android Apps

My Tracks

Fusion Table Buddy (Android App)


Geocoding Tutorial (U of Toronto)

Fusion Tables Intro Video US State Capitals


Managing and visualizing your geospatial data with Fusion Tables

Assignment Google Maps and Google Fusion Tables


Fusion Tables:

New Ways to Collaborate on Structured Data



Geo Education