Drive Apps

Session: Using Google Drive in the Classroom
Description: Google Drive is a user-friendly suite of online collaborative tools that comes with tremendous potential for use in the classroom. 
During this section we will dive into the classroom and professional use of documents, spreadsheets, presentations, drawings and forms. 

Objectives:
-Learn how to set up a document with comment rights
-Learn how to set up a document with anchor points (bookmarks)
-Learn how to use the 'research' feature
-Learn how to set up the visibility settings 
-Learn how to take advantage of the insert image options
-Learn how to leverage the use of sheets and the web




STEP ONE: Log in to your Google Account
1-Go to https://drive.google.com

Resources:
For beginners, please visit the GAFE Online Course for video tutorials and how to steps. Also see Getting Started with Google Drive document. 
Google Drive YouTube Playlist
Google Docs YouTube Playlist



Docs Activity: Using Comments with Current Events
Comments are a handy way of adding notes to your regular document text and are visible to viewers and collaborators. These can be invaluable for communicating with collaborators about specific parts of the document, as well as making notes about changes you've made or would like to make. Add comments without having editing rights to the document is a useful feature when you are concerned with students editing your copy. Simple share the file with comment rights only, and students will only have access to add a comment. 

App: Document
Resources: How To Instructions
Activity Link: Comments on Current Event
Feature: Comments
Tips:
1-Set up notifications to alert you when comments are added.
2-Use the 'Comment' button to view all comments including and resolved ones

Instructions:
1-Go to the Comments on Current Event document
2-Read the article 
3-Post your comment as instructed in the document

Drive_Comments.mp4



How else can you use comments?




Drawing Activity: Using Drawings to Create Paperless Worksheets

Activity Link: Historical Timeline

Activity Link: Venn Diagram
Feature: Shapes, Text

Activity Link: Sequence of a Story
Features: Shapes, Text, Images



Sheets Activity: Using Sheets: Power Sources and Renewable Energy

Sheets in Google Drive allows teachers and students to easily aggregate, organize, and analyze information in one place. With advanced tools for sorting, formatting, creating and visualizing information with charts, pivot tables, and entering formulas, shared, online spreadsheets can be used in a variety of settings.


App: Sheets
Resources: How To: Visibility Settings
Activity Link: Power Up Group Results
Feature: Sharing/Visibility Options

Tips:
1-Make sure you change the sharing settings from: "editors are allowed to share" to only "editors are allowed to share"

Instructions:
1-Go to: http://sciencenetlinks.com/media/filer/2011/10/07/powerup.swf
2-Complete the interactive two times
3-Keep track of your choices
4-Post your best result


Need help with the PowerUp Game?

PowerUp_HowTo.mp4



Docs Activity: Research
Google docs comes a research feature that allows you to Google search for sites, photos, and more. You can link and cite directly from the tool.

Tools > Research


Drive_Research.mp4





Sheets Activity: Custom Generating QR Codes
Google Spreadsheets are located in the cloud (on the web) allowing you to use formulas that can aggregate information from the web on to your spreadsheet. This feature will allow users to generate spreadsheets with data from the web without having to search the web for this content.

Step One: View the Video Tutorial on Google Spreadsheets

Title: Using Codes to Auto Generate QR Codes in a Google Spreadsheet
Video Length: 3:38
Source: TCEA

Note-
When pasting the code next to the new information the reference box needs to be changed from "A2" to the box with the new information. 

Step Two: Access the MASTER QR Code 4 Sharing Template
This form has been shared with everyone and does not require you to sign in.

If you are having trouble with the code, copy and past it from the code listed below:
=image("https://chart.googleapis.com/chart?chs=150x150&cht=qr&chl=" & A2)

Also, check out Tammy Worcester's QR Codes with Spreadsheets

Step Three: Customize the Template for Your QR Codes
-Download the template and upload to your Google docs account
-Rename the template according to what your QR Codes are for
-Edit the template with your text or URL


Sheets Activity: Data Scraping with Google Spreadsheets

What is data scraping? Simply put, the process of importing a table from a site into a spreadsheet. A more detailed explanation and as it might be explained in computer science terms, data scraping is a technique in which a computer program extracts data from human-readable output coming from another program.

While the process for most data scraping is complex,  
the ImportHTML function in a Google spreadsheet imports the data in a particular table or list from an HTML page quite easily.  

Note: The limit on the number of ImportHtml functions per spreadsheet is 50.


Definitions:

-URL is the URL of the page (between quotation marks)

-“table” is the element to look for
-
num is the number of the element, in case there is more than one table on the same page (counting starts at 0)

-parse error or syntax error: refers to an error in the syntax of a sequence of characters or tokens that is intended to be written in a particular programming language


Instructions
Example: Data Scraping Activity 1

Example of how the function should look: =ImportHtml("http://www.fdic.gov/bank/individual/failed/banklist.html", "table",0)




Docs Activity: Bookmarks in Documents
Ever find yourself scrolling down the page and not being able to find a section or top of the page? Bookmarking your section can help you find your way around the page. 


To create a bookmark in your document, follow these steps:
  1. Click where you want to place the bookmark in your document.
  2. Click the Insert drop-down menu.
  3. Select Bookmark.
A bookmark is only useful when you can link to it, otherwise there’s no way for anyone to jump to your bookmarked section.

To create a link to a bookmark in your document, follow these steps:
  1. Highlight the text you'd like to link from. You can also just click anywhere in your document to create a link there.
  2. Click the Insert drop-down menu and select Link..., or click the link icon in the toolbar.
  3. In the 'Edit Link' window, select the 'Bookmark' option to see the bookmarks you've created.
  4. Click the bookmark you'd like to link to.
  5. Click OK.

If you need to edit or remove the link, click on the bookmark link and the 'Go to link' window appears. In this window, you can see the bookmark you're linking to, and the Change and Remove links.


Drawings Activity: Stock Photography
Google docs comes equipped with a photo library from LIFE and Stock Images. Access hundreds of photos within documents, spreadsheets, presentations and drawings. 

Insert > Image > Search > Google, LIFE, or Stock Images


Drawings Activity: Take A Snapshot
An easy way to submit your assignments or add images to your documents, is to use the 'take a snapshot' feature.

Instructions:
1-Create > Document > Title your Document
2-Insert > Image > Take a Snapshot
3-Allow Google Docs to access your camera (requires you have a web cam or built-in camera)
4-Click on 'Take Snapshot'
5-Click 'Select'
6-Resize to preference



More on Drawings




-Exploring Google Forms

With Google Drive, you can quickly create a form or survey, send it to students, parents, teachers, or staff, and keep track of the answers in one spreadsheet.


Since forms are filled out online, there’s no need to enter in results manually. Responses are collected and displayed immediately in a corresponding Google Drive spreadsheet (Sheets) which allows you to sort, analyze, and visualize the information.


You can send forms to anyone - even those outside of your school Apps domain. Respondents can access the form via email, a published webpage, or embedded on a site.

Forms also generates an automatic summary with charts, graphs, and statistics about your form responses and can notify you when new responses are submitted.


Resources: HOW TO: Creating, Editing and Managing Forms

Tips:
1-Decide whether you want the form to automatically collect the respondents username
2-Decide if you want to require that the user have a domain account
3-Decide if the results are visible by respondents
4-Decide if you want respondents to edit their responses

Examples:


Google Forms Tutorials:
If you are new to Google Forms and need additional instruction, view the videos provided below.



-Google Drive Apps
Drive Apps are available through your Google Drive account. These apps add additional functionality to your Google Drive. Some work with your Drive: sharing, auto saving, storing, etc. 
To access Drive apps: Drive > Create > Get More Apps > Select Your App of Choice >
Or, you can go to: 
Full list of apps for Drive

Below are some of my favorite Drive Apps:


Video Not.es
This Drive app allows you to display a video and takes notes along side it as it plays. The notes are synched with the section of the video of when you typed. The video and the notes are saved in Google Drive and accessible later for viewing and sharing with others. 
Link: http://www.videonot.es/edit/
Tips:

-Once you install VideoNot.es, a 'VideoNot.es' folder will appear in your 'My Drive'

-If someone has shared a VideoNot.es file with you, a 'VideoNot.es' folder will appear in your 'Shared with Me' section.


-To view the file that was shared with you, click on the folder and a list (like shown below) of videos shared with you will appear in your doc list.


-To make your own copy of this VideoNot.es file, select the file and right click (PC)/two finger click (MAC) and select 'Make a Copy'


Note
-You can collaborate together on a VideoNot.es
-You cannot view YouTube for School videos

Formpl.us
Form+ helps you create easy to use forms; easily. Remember, Form+ can be installed to your Google Drive by adding it from the Chrome Web Store. Link: http://www.formpl.us/

Tips: -Sign in with your Google Account -Video tutorial below


More Drive Apps
Hello Fax: You can fax documents from your computer or from your Drive directly from your computer. You get 50 faxes for free for up to six months.
PDFmergy: This is a really cool app that will let you take documents off of your computer or your drive and merge them into one pdf. You can arrange them anyway you want.

Desmos Graphic CalculatorFree online calculator

Comments