GUST Google: 2015

Google Race

Mission 1

If someone else is logged into Google Chrome, go to Settings & disconnect, then log in to Chrome with your Gmail account and password.

Mission 2

The starting point for all of the directions below will be your Google Drive. Go ahead and open a new tab. Then go to drive.google.com

Mission 3

You need a place to put all your thoughts, ideas, light bulb moments, etc. that you have during today’s workshop.
In drive, go to Create/New > Google Docs to create a document and title it appropriately. Start brainstorming!
Keep this page open so you can go back and add more ideas throughout our workshop.

Mission 4

In a new tab or new window, click Create/New and from the drop down menu, click Google Forms.
When prompted, title the form “Your last name + Mission 4” and choose a theme.

Create a 2 question survey that would allow you to get to know me a little better (or ask me a question?).

Click Send form (upper right corner) and type in my email address (pamelagbruce@gmail.com). Click Send.
Go to Drive in order to view the responses to your survey.
In your responses sheet, click Share (upper right corner). Under Invite people, type the email address for one other participant. Allow him/her to edit. Click Share & save.

Mission 5

Go to Create/New > Google Drawings.
Click File > Rename.
Name the document “Your last name + Mission 5.”
Go to Insert > Image > Search. Search for and insert a picture of your favorite place in the world.
Insert a text box with the name of the place.
Click Share (upper right corner). Next to Private, click Change… Select Anyone with the link then Save.
Copy the link to share then click Done.
Insert a text box with the link to your drawing.
Go to Edit > Web clipboard > Copy entire drawing to web clipboard.

Mission 6

Go to Create/New > Google Docs.
Click Untitled Document in order to rename it.
Name the document “Your last name + Mission 6.”
On the first line of the document, tell me your name and write a sentence about your favorite place in the world.
Insert your drawing from Mission 3 by clicking Edit > Web clipboard > Drawing.
Click Share. Under Invite people, type my email address and the email address for one other participant. Allow us to comment. Click Share & save.

Mission 7

Click File > Publish to the web then click Start publishing and OK.
Copy the Document link and paste it in a new window to view the published version.

Mission 8

Go to Create/New > Folder
Title your folder “1st initial, last name, Google Workshop.”
Highlight all of your mission documents (there should be 5 of them).
Select More Actions (three vertically aligned dots), click Move to and select the folder you just created.
Right click on the your folder. Click Share and type my email. Give me permission to view only. Click Share & save.

CONGRATULATIONS! (click on the link <--)

BONUS MISSION

Click here and then click Use this template.
Rename the spreadsheet “Your last name + Bonus mission.”
Go to Data > Sort the sheet A -> Z by column C (Class Level).
Hide column A (Student Name).
Go to Data > Pivot table report. A new tab named "Pivot table 1" will open.
In the Report Editor to the right of your spreadsheet, check that the detected data range is correct. It should read 'Class Data'!A1:F31.
In the Rows category of the Report Editor, click the Add field link and select Major.
In the Columns category of the Report Editor, click the Add field link and select Class level.
In the Values category of the Report Editor, click the Add field link and select Major.
Under Display: Major, click the drop-down arrow next to Summarize by: and select COUNTA.
Voila!
Use this template to mess around with different chart types.

Anchor activity: Go back to your brainstorm document and dump what’s going through your head :)

Sunday, September 6, 2015