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:

1. creating a spreadsheet
2. formatting columns, rows and cells
3. auto-fill (auto fill down a row or multiple formulas across columns)
4. simple formulas of AVERAGE, MIN and MAX
5. sharing options
6. Charts
7. Add-ons

1. 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

Flippity Flashcard Review

Resources ideas for using Google Docs in Lesson Plans

Link to this doc: bit.ly/googleclassideas

Let’s Get up and Move Around. Time for Differentiated Learning for us!

password-  Guess word

Reviews:

https://jeopardylabs.com/play/gmail-and-google-drive

Working with Forms Activities

Take the following Assessment Survey on Forms:

Google Forms Workshop Survey

How does using a Form like the Google Forms Survey provide information on students' prior knowledge and teach them key tools they need at the same time?

Now take the "Getting to Know You Survey" and then click the link "See previous responses" to learn more about the people in the class.

How could an activity like this be used in class? What are some different ways to use such a form with your students (think of how you can add in pictures)?

Create a form either as an exit ticket or a getting to know you survey. Do all of the following

• Duplicate an answer and make at least one mandatory
• set a data validation on one question
• Custom set your response with either "Next steps" or your website link.
• When to allow for editing, post another and publish responses
• set notifications rules in the attached spreadsheet to notify when the form is submitted

Creating a Blogger Blog

Create a Blogger Blog by scrolling down to the slide show found on this site

https://sites.google.com/site/learnaboutgafe/Home/blogger

Now create a Blog by going to Google.com and choosing Blogger.

Using Blogs with Students to Elicit Feedback on Chromebooks

Using Blogs with Students to Elicit Feedback

Directions:
This project, you're going to be given a task or worksheet to complete. 

1. You will open up either the chrome app WeVideo or extension Screencastify
2. You will then create a recording where you will either show a picture of taken of your task with the camera of your iPad or draw out your task or problem. 
3.  You will also record yourself explaining how you did your task and why you chose to do it that way. 
4. When done, upload the video or link to your video and include your name in response to this post. 

To see a video on how to use WeVideo click here

You can reply to the post or upload with email: jllowton.classblog@blogger.com

Lilly Lowton's post on Thursday, January 16, 2014

Testing out The app blogger jr Where do the pics go?

Josh L's photo on Thursday, January 16, 2014

Video Feedback Assignment

Directions:
This project, you're going to be given a task or worksheet to complete.

1. You will open up either the app ScreenChomp (PK-4 or SPED) or Explain Everything
2. You will then create a recording where you will either show a picture of taken of your task with the camera of your iPad or draw out your task or problem. 
3.  You will also record yourself explaining how you did your task and why you chose to do it that way. 
4. When done, upload the video or link to your video and include your name and the name of the assignment in response to this post. 
5. Here is the link to the direction