GAFE MTL Summit 2013

Sunday, December 8 • 3:00pm - 4:00pm (Room 314)
Fusion Tables: An Adventure in Discovery & Exploration
https://sites.google.com/a/gafesummit.com/qc/
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.


JOIN ME & LEARN HOW TO BUILD YOUR OWN KNOWLEDGE MAP.
Speakers

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
 

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 


PHASE 3: 

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

 






Learn How to Publish HTML to Google Sites
Embed Public Data or Fusion Table Visuals

Embed gadget


FREE Online HTML Editor



Fusion Table Examples 





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

 

Example
List of dog breeds-Google Fusion Tables

Model after this
Caterpillars, pupae, butterflies & moths 


Search
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 http://blog.urremote.com/2012/04/activity-data.html

Mapping the Storm Clean-up

Yearly Coffee Consumption

Google Public Data Explorer (Help)

Unemployment in Canada


Resources

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)

 

Videos

Geocoding Tutorial (U of Toronto)

Fusion Tables Intro Video US State Capitals

Youtube

Managing and visualizing your geospatial data with Fusion Tables

 

Assignment Google Maps and Google Fusion Tables

Thesis

Fusion Tables: 

New Ways to Collaborate on Structured Data

 

Course

BRINGING DATA TO LIFE WITH GOOGLE FUSION TABLES

 

Geo Education

http://www.snap.uaf.edu/earth/google/