Timelines in Learning - Lesson 5 - Use the Form Data in your Timeline Spreadsheet

Published: 03 January 2016
on channel: Attechedu.training
303
2

Timelines in Learning - Lesson 5 - Use the Form Data in your Timeline Spreadsheet

TimelineJS is an online website that will import data from a Google Spreadsheet data, images and videos into an interactive timeline.

In this course we will look at an online application that will create interactive timelines using Google Apps. These timelines can be used in any subject and can incorporate most media. We will explore the following:

Enter data into the timeline using a Google Spreadsheet
Giving your images a URL address to embed into the timeline
Using a URL to include videos in the timeline
Create a Google form to gather the data for a class project

This course is aimed at all teachers. A familiarity with Google Forms and Google Sheets would be an advantage.

Below are the resources you will need for these lessons.

TimeLineJS Template - https://drive.google.com/previewtempl...
Click "Use this Template" and rename it.

TimeLine Google Form Template - https://drive.google.com/open?id=1Qit...
Make a copy of this and rename it accordingly.

Lesson 1 - Create a Spreadsheet to gather information
   • Timelines in Learning - Lesson 1 - Cr...  
Kings and Queens of England since 1066
Download the Template from here.
Copy the template, rename it and move this in a folder in your Google Drive
Close the template and open the copy.
Start enter the data into your spreadsheet
Enter an image and a Youtube video

Lesson 2 - Create the Interactive Timeline with the Spreadsheet
   • Timeline in Learning - Lesson 2 - Cre...  
Turn your spreadsheet into a public link
Insert this link into TimeLineJS
Run the Timeline
Submit and embed your timeline

Lesson 3 - Create Public URLs of your photos for your timeline
   • Timelines in Learning - Lesson 3 - Cr...  
Create a Flickr Account
Upload your photos to Flickr and make the photos public
Use the URL in your TimeLineJS Spreadsheet

Lesson 4 - Create a Google Form to gather data for your timeline
   • Timelines in Learning - Lesson 4 - Cr...  
Create a Google Form with the correct fields
Enter some data

Lesson 5 - Use the Form Data in your Timeline Spreadsheet
   • Timelines in Learning - Lesson 5 - Us...  
Add the data from the form to your TimelineJS spreadsheet
Use formulas to gather the data
Send the spreadsheet to TimeLineJS

Other Videos from AtTechedu
The Research Project
   • The Research Project Google Apps - In...  

The Google Arts Project
https://www.google.com/culturalinstit...
Tutorial -    • The Tech Tools for Art Teachers - Goo...  

Other Tech in Art
   • 2 Great ways for teachers to use Spre...  

Other Mapping tools
Google Tour Builder -    • The Maps in Learning - Google Tour Bu...  
Google Arts Project -    • The Tech Tools for Art Teachers - Goo...  
Google Street View -    • The Maps in Learning - Streetview & P...  
Google Maps -    • The Maps in Learning - Using Google M...  

Google My Maps
   • Google My Maps  

Google Classroom Videos -
   • The Google Drive made easy in the cla...  

The Quicktime Series
   • How to create a movie in Apple Mac Qu...  

Other Great Videos from AtTechEdu
Art using Spreadsheets
Lesson 1 -    • The Tech tools for art teachers 1 -  ...  
Lesson 2 -    • The Tech tools for art Teachers Art i...  

Google Forms
Page Based Answers :    • Lesson 1 - Tips using Google Forms in...  
Customising the look :    • Lesson 2 - Tips using Google Forms in...  
Viewing the Data :    • Lesson 3 - Tips using Google Forms in...  
Sorting using Query :    • Lesson 4 - Tips using Google Forms in...  
Flubaroo :    • Lesson 3 - Tips using Google Forms in...  

Google Documents Videos from AtTechEdu
Revision History -    • Teaching Tips using Google Documents ...  
Commenting and Collaborating -    • Teaching Tips using Google Documents ...  
Addons -    • Teaching Tips using Google Documents ...  
The Research Tool -    • Teaching Tips using Google Documents ...  

Gmail Tips -    • 4 Useful Tips for Managing Google Gmail  
Flip the Pen -    • Flip the Pen  
Times Table Quizzes Google Sheets -    • Times tables Quizzes Using Spreadsheets  
Google Drive on the iPad -    • Google Drive on the iPad  
Google My Maps -    • Google My Maps  


Watch video Timelines in Learning - Lesson 5 - Use the Form Data in your Timeline Spreadsheet online without registration, duration hours minute second in high quality. This video was added by user Attechedu.training 03 January 2016, don't forget to share it with your friends and acquaintances, it has been viewed on our site 303 once and liked it 2 people.