Legacy Resources‎ > ‎

Google Drive

Goal: 1) To create, edit, share, and collaborate on Google Documents.
2) To upload, share, and convert files and folders via Google Drive.

Assessment
• Create a folder that is shared with me
• Create and modify documents based on level of experience (see below) 
• Upload existing content (file or folder) and download 1 item as a converted file

Why

State K-12s using Google Apps: Oregon, Colorado, Iowa, Wisconsin, New York


Local Schools using Google Apps: Bellevue Public Schools, Westside, Bennington Public, Council Bluffs Public, Jesuit Academy, St. Joan of Arc, St. Gerald, Marian, St. Margaret Mary, St. Mary (Bellevue), St. Cecilia, MOQ, Sacred Heart, St. Patrick's Elkhorn, Omaha Catholic Schools Consortium, UNO, Doane, MCC 


Businesses Using Google Apps: Google, Motorola, McClatchy Group (newpapers and magazines), Roche, Jason's Deli, Konica, Virgin Atlantic, National Geographic, Diversy, and thousands more


Government Entities: Entire state of Wyoming, City of Des Moines, City of Los Angeles, City of Orlando, NOAA, Holocaust Museum

About Google Docs                         10 Things You Didn't Know                               Class Spreadsheet                   Complete Google Drive Guide
 

Google Drive Organization Tips


 Helpful Tips
1. Set preferences for common phrases using the strategy here.

2. Highlight a word or phrase and click the link button to get a list of likely links

3. Go to File-->Page Setup to change the doc style to landscape, the color of the page, or the margins

4. To make columns, insert a multi-column table in your doc.  Right click on the table and select Table Properties.  Change the border to 0 pt and the table becomes invisible, but you've still got columns.

5. Want to share with people who don't have GDocs.  Go to File-->Email as attachment and send it as a Word or PDF to whomever
Examples
The Hearing Test Spreadsheet               Lesson Plan Doc (tables galore)                 Tech In Schools Form                   Weebly Guide Drawing
Beginner

Folder - Create a folder named 2014ST Your Name and share it with me (place all docs created for this class in this folder)

Document - Write a paragraph on how use tech currently or how you'd like to incorporate more tech. Adjust fonts, colors, and spacing in the doc.

Spreadsheet - Add your tags to the class spreadsheet then copy the text from your doc paragraph and add it to the correct column.

Form - Create a form with two questions, change the theme, email it to me.

Presentation - (see here)

Drawing - Create a drawing with shapes, text, and a free hand drawing.
Intermediate

Folder - Create a folder named 2014ST Your Name and share it with me (place all docs created for this class in this folder)

Document - Write a couple sentences about how you use tech currently.  Below this add a 2x4 table with a "year 2000" column and a "2013 column".  Under this copy the first paragraph, translate it to a new language and, on the last period, link to translate.google.com.

Spreadsheet - Add your tags to Sheet 1, write formulas to sum and average your totals on sheet 2, set the sum and average cells to change colors based on values you choose

Form - Create a form with two questions, change the theme, edit the confirmation to say Your_Name_Rocks and link back to the class wiki, email this to me

Presentation - (see here)

Drawing - Create a drawing with shapes, text, and a free hand drawing.  Change the default size of the drawing, import a pic, and change the background.


Advanced

Folder - Create a folder named 2014ST  Your Name and share it with me (place all docs created for this class in this folder)

Document - complete all intermediate steps, but add headings to each section and create a table of contents.  On a 4th section put in Einstein's energy equation and give citation for where you got it.

Spreadsheet & Form - Complete the intermediate steps, but create a command that  collects all the text from cells in colum M, sheet 1 into a single cell by your name on sheet 3.  Publish this individual cell and send me the link.  Next, create a form and add the FormEmailer script to it so that it emails me whenever someone inputs the code word I give you in class.  Input the code word yourself so it emails me.

Presentation - (see here)

Drawing - Create a new banner for this wiki that is 1000px wide x 200px high.  Export as an svg and upload to openclipart.org with the tag cutech601
Subpages (1): Google Drive II
Comments