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.
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.
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
PHASE 3:
8-Insert a Google Script to «Auto Grade» the Questionnaire (Form Responses)
Wildlife Questions Science & Technology Cycle 2-3 (Form)
Wildlife Questions Science & Technology Cycle 2-3 (Responses)
Google Apps Script to «Auto-Grade» the Assignment
THANK YOU
GAFE MONTREAL
My Info on a Map
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
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
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
Mapped Tennessee Traffic History - 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.
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
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
Google Public Data Explorer (Help)
Resources
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
Syncing a Google Form with a Fusion Table
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
Fusion Table Buddy (Android App)
Videos
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
Thesis
New Ways to Collaborate on Structured Data
Course
BRINGING DATA TO LIFE WITH GOOGLE FUSION TABLES
Geo Education