Lowton Classroom Training Blog: Google Drive Scavenger Hunt and Fun With Spreadsheets

First go to bit.ly/lowtonpdroster
or
bit.ly/lowtonwhspdroster (if from SAU 21)

to sign in and receive a certificate of attendance

Now go to bit.ly/drivescavenger

and do the Google Drive Scavenger hunt with a second tab open to get to your Google Drive while doing the scavenger hunt. Do this activity with a partner or group!

When done, create a Blank Spreadsheet and open in a separate tab to complete the spreadsheet part of this session filled in with the table info below. Then try the steps while waiting for the group.

Working with Google Spreadsheets

Google spreadsheets allows for manipulation of data, creation of informational charts and tables from that data as well as great gadgets (now called Add-ons) like flashcards, Wordle clouds and more. You can also do mail merges with Google Document using a very cool script called autocrat. There are size limits though as each spreadsheet can only have up to 400,000 cells spreading across 256 columns. For more on size limits for the Google Exam click here.

In this session we will cover:

creating a spreadsheet
formatting columns, rows and cells
auto-fill (auto fill down a row or multiple formulas across columns)
simple formulas of AVERAGE, MIN and MAX
sharing options
Charts
Add-ons

type the following info into your spreadsheet:

Student	Gender	Race Test Codes	Necap Fall	NWEA Fall	NWEA Spring	Days Absent
Adam Baum	M	W	742	224	228	3
Polly Esther	F	H	750	240	242	0
Dore Matt	M	W	735	218	222	4
Uwanna Swim	F	B	746	249	250	1
Amanda Reckonwith	F	B	730	209	210	7
April Showers	F	W	751	236	236	1
Barbie Que	F	H	748	239	241	1
Barbie Dahl	F	A	742	248	246	2
Rick O'Shea	M	W	738	242	240	4

center data in columns for Gender and Codes
Make “Race Test Codes” two lines (2 ways to do this)
Get the Average of NECAP FALL, then then MIN or lowest score beneath that and the MAX below that.
Autofill these formulas across the next two columns in one step
Filter for Females only
Sort Range A-Z for student names but not including the formula rows
create a bar chart of the NWEA Spring versus NWEA Fall scores in NH