Classroom 2.0 LIVE webinar "Building Efficiency with Google Forms" with special guest presenter, Jenn Judkins.

August 19, 2017


00:17 - Peggy George
Link for our Livebinder today: https://www.livebinders.com/play/play?id=2233576

00:37 - Peggy George
all of Jenn's presentation slides are in the Livebinder with clickable links :-)

00:56 - Peggy George
We are so excited to have Jenn Judkins here to share with us today!!

01:18 - Peggy George
Follow Jenn on Twitter: https://twitter.com/TeachingForward

01:29 - Peggy George
Jenn's blog: Blog: http://teachingforward.net/

01:51 - Susie @shighley
I'm also a former science T

02:28 - Peggy George
I think Jenn could talk non-stop for days and never run out of things to share about tech tools and their uses! I always learn so much from her!!

02:37 - Jenn Judkins
Woohoo - welcome Suzie!

02:51 - Peggy George
Awesome introduction Maureen! Thanks so much!

03:35 - Peggy George
I didn't realize how many powerful ways we could use Google Forms for beyond quick surveys or assessments!

03:54 - @bcdtech Maureen
I could listen to Jenn and learn new things every day- so practical!

03:56 - Peggy George
Handout / Reference Doc: https://docs.google.com/document/d/1D7WjQooJMZVlUCRrBY-KQewu6SH6smjZRJi5wrqdTmQ/edit?usp=sharing

05:08 - Peggy George
we use autocrat to send out our PD certificates for these webinars! makes it so efficient!!

05:11 - @bcdtech Maureen
I offered to make a walk thru form for our admin and they said it was a "union" thing and it would have to go thru then

05:13 - @bcdtech Maureen
them

05:16 - Peggy George
Hi Sawa! Welcome!

05:26 - Peggy George
that's really interesting Maureen!

05:28 - Sawa
Hi Peggy!

05:50 - Eileen
I would like to use forms for the National Geograhic Geography Bee with all of my 4th graders and 5th graders.

06:14 - stidmama
good morning!

06:17 - Peggy George
I wish I had this when I was a principal! I just created an Excel spreadsheet but it wasn't efficient at all!

06:31 - Peggy George
Hi Stidmama and Bella! So happy you could join us!!

07:13 - Bella
Happy to be here

07:15 - Peggy George
timeliness is so important with discipline management so this is an awesome process!

07:34 - @bcdtech Maureen
How can you get admin buy in on using digital tools? I get pushback from admin who are not comfortable with digital forms.

07:53 - Peggy George
Jenn created this Form Template to Copy for users who want to replicate what we are doing: https://docs.google.com/forms/d/1Yhdch4LKdcL57eIDjazKBkrpgaqyBV7AnDm9Mjb8Xc4/copy

08:06 - Peggy George
you can make a copy of it and save it to edit for your own purposes :-)

08:15 - Susie @shighley
Being able to add notes via voice can be so handy

08:19 - Peggy George
Hi Maria b and Suzana! Welcome!

08:25 - Peggy George
great point Susie!!

08:55 - Peggy George
this is the form for the template I just share

08:57 - Leigh Zeitz from Univ of Iowa
The key to getting administrators interested in Google Forms is to make sure their secretaries are knowledgeable in it.

09:05 - @bcdtech Maureen
Question for later- I get asked all the time about security on google online forms. Can we use google forms for sped?

09:07 - Suzana Lazarevic Petrovic 2
Greetings from Serbia!

09:11 - Peggy George
Form Template to Copy for users who want to replicate what we are doing: https://docs.google.com/forms/d/1Yhdch4LKdcL57eIDjazKBkrpgaqyBV7AnDm9Mjb8Xc4/copy

09:39 - Peggy George
everything is also in the Livebinder: https://www.livebinders.com/play/play?id=2233576

10:01 - @bcdtech Maureen
Jenn- can you tell people how to force others to make a copy?

10:19 - @bcdtech Maureen
:-)

11:05 - Peggy George
All of Jenn's handouts/resources are in this doc:https://docs.google.com/document/d/1D7WjQooJMZVlUCRrBY-KQewu6SH6smjZRJi5wrqdTmQ/edit

11:23 - Peggy George
Welcome Rawya!

11:51 - Peggy George
This will definitely be a recording I'll want to watch again so I can pause as we go along and try things out. :-)

12:01 - @bcdtech Maureen
Me too Peggy!

12:42 - Joan Kane
What is the link to the formMule template?

12:52 - Peggy George
really good to know how to require people to make a copy of your document so it can be editable :-)

14:18 - Dejan Kreculj
Hi everyone!

14:26 - Peggy George
cool!!! and so simple! just erase /edit and replace it with /copy!

14:30 - Peggy George
Welcome Dejan!

15:38 - Peggy George
thanks for explaining that Jenn

15:52 - Eileen
Thanks

17:10 - Peggy George
hmm... never heard of FormsBranching

17:32 - @bcdtech Maureen
Peggy- you can use that for choose your own adventure stories

17:50 - Peggy George
brilliant Maureen!!! Good to know!

18:30 - Leigh Zeitz from Univ of Iowa
Have any of you used Google forms to make Choose your own adventure? If so, do you have examples?

18:44 - @bcdtech Maureen
I also like to use it for formative assessment- answer the question- if correct, they move to next question, if not they watch a video, go to a link, etc... to goo over the material again

18:55 - Peggy George
I'm assuming Admins means administrator creating the form and not a Google Drive permission thing. Right?

19:05 - Leigh Zeitz from Univ of Iowa
that is a great idea, Maureeen

19:17 - Peggy George
that would be so helpful Maureen!

19:18 - Leigh Zeitz from Univ of Iowa
Do you have an example, Maureen?

19:47 - @bcdtech Maureen
Not that I can share at the moment, but I will find some to give Peggy to go in the Livebinder

19:56 - Leigh Zeitz from Univ of Iowa
thanks,

20:39 - stidmama
I am really enjoying this presentation! I am one of about three people who regularly use google forms and add-ons in my building. They are really useful sometimes!

21:25 - Peggy George
some great ideas for Google Forms here from DitchThatTextbook http://ditchthattextbook.com/2016/02/12/the-new-google-forms-9-classroom-uses/

21:35 - Peggy George
he includes Choose Your Own Adventure :-)

21:44 - @bcdtech Maureen
Thanks Peggy!

22:00 - Peggy George
thanks Maureen! I'll definitely add it to the Livebinder

22:09 - Leigh Zeitz from Univ of Iowa
Thanks, Peggy

22:44 - Peggy George
There are tons of links for resources for many different examples of Google Forms in our Livebinder today!

22:47 - @bcdtech Maureen
Here's the formative assessment info from Alice Keeler http://alicekeeler.com/2016/05/09/5-steps-to-do-when-using-google-forms-for-formative-assessment/

23:19 - Peggy George
Both of these resources are outstanding for Google Form ideas

23:20 - Peggy George
http://tbarrett.edublogs.org/2008/08/23/10-google-forms-for-the-classroom/
http://edte.ch/blog/2014/03/20/80-interesting-ways-to-use-google-forms-in-the-classroom/
https://www.slideshare.net/GrahamAttwell/79-interesting-waystousegoogleformsinthe-12639979

23:31 - Peggy George
thanks Maureen!

23:47 - Leigh Zeitz from Univ of Iowa
Thanks

23:50 - Bella
thanks Maureen and Peggy

24:42 - Peggy George
in the Livebinder now :-)

24:47 - Joan Kane
what was the Google shortcut for FormRanger?

25:10 - Peggy George
if you have any questions for Jenn please type them in the chat and Lorie will ask her during Q/A if she hasn't already answered them :-)

25:17 - Maria b 1
Get add-ons

26:28 - Joan Kane
Do you have the google shortcut for the FormRanger spreadsheet?

26:43 - Peggy George
Joan, not sure what you mean. Was it using the 3 dots on top right to select the add-on?

27:12 - Peggy George
Get formRanger Add On
3 dots top right corner
“dd Ons” search
Launch from “uzzle Piece”con

27:29 - Peggy George
Welcome Peg A!

27:39 - Leigh Zeitz from Univ of Iowa
thanks for the presentation, Jenn. I have to go but will return to watch the recording soon.

28:13 - Peggy George
Jenn has included all of these steps in her slides today

28:16 - Joan Kane
No, it was a link at the start of the presentation. There were 2 Google shortcuts, one to form that was copied and 1 to the FormRanger spreadsheet she s using now. Hard to follow along without it.

28:50 - Joan Kane
It's the spreadsheet with the values for the form.

28:50 - Peggy George
https://docs.google.com/presentation/d/1AFTeBxBRy_uNPIy9d9SUodY2IgJvf4AFt_PzINn9vSc/edit?usp=sharing

28:56 - Peggy George
that's the link to her slides

29:40 - @bcdtech Maureen
Do you have a way to auto-update the spreadsheets that you use in your formranger... hooked to SIS? or?

29:41 - Peggy George
Copy these template Files to Google Drive:
Form template: goo.gl/WN7Hbr
formRanger Lists template: goo.gl/pqZnMC

30:37 - Peggy George
so handy to have those reasons for referral already provided!!! some are very common :-)

30:44 - Joan Kane
Found it on slide 7

31:23 - Peggy George
great Joan! Those are the links I posted just above :-)

32:01 - @bcdtech Maureen
Our school uses PBIS and some online data collection thing- is there a way to hook this info to that sort of thing?

32:05 - Peggy George
If you're not an administrator you might want to share this recording and resources with your principal. :-)

34:23 - Peggy George
although Jenn is focusing her demo on a disciplinary referral example you will find tons of other ways to use Google Forms as a teacher in the Livebinder

35:05 - Peggy George
haha Bart Simpson!!

35:21 - Peggy George
I imagine he might have quite a few referrals :-)

35:42 - stidmama
I really like this. Far better than paper slips that can get lost!

35:53 - @bcdtech Maureen
Can you make it so that you can have more than one reason for referral, but that would be checkbox...hmm

36:08 - Peggy George
absolutely @stidmama!! and it so efficient with immediate access

38:35 - Peggy George
wow! automatically emails the response with formRanger!

38:47 - Peggy George
I mean formMule :-)

39:25 - Peggy George
that is soooo helpful for teachers to know what action the admin took

40:32 - Peggy George
her slides show how to set up and build the email template

41:56 - Peggy George
would you use that email form to send responses to parents?

43:37 - Peggy George
https://chrome.google.com/webstore/detail/formmule-email-merge-util/kabhamaiihmaphgpijdolgcihofefajn?hl=en (FormMule email merge utility for Google sheets)

43:50 - Peggy George
https://chrome.google.com/webstore/detail/formranger/faepkjkcpnnghgdhiobglpppbfdnaehc?hl=en (formRanger add-on-formRanger allows you to populate multiple choice, list, checkbox, and grid options from columns in any Sheet or Doctopus roster.)

44:00 - Peggy George
https://support.google.com/docs/answer/2942256?co=GENIE.Platform%3DDesktop&hl=en (Use Add-ons and Apps Script Google Help)

44:23 - Peggy George
amazing!!!

44:53 - @bcdtech Maureen
So you (or some IT type person) makes the forms and then the teachers and admin just use them...or do they do their own set ups?

45:11 - Peggy George
great question Maureen!

45:45 - @bcdtech Maureen
I love the way Jenn simplifies work flows

46:46 - Peggy George
yes! and once it's created it's so easy to use by teachers and admins!

47:55 - Bella
thanks Jenn for sharing. Have to leave now

48:10 - Peggy George
Can you do all of this if you're not a GAFE school (Google Apps for Education)? As long as all teachers and admins are using Google and have Google accounts?

48:51 - Maria b 1
I don't believe so.

48:51 - Peggy George
Lorie is saving all of our questions to ask Jenn on the mic :-)

50:46 - Peggy George
really easy to use once it's created :-)

51:13 - @bcdtech Maureen
Yah but - what would you fill 3 ring binders with?

51:22 - Peggy George
hahaha Maureen!

52:22 - Peggy George
great tip!

52:23 - Joan Kane
So many ways to use this information! I'll be working on my beginning of year student information and interests forms today. Thanks!

52:53 - Peggy George
awesome Joan!!

53:35 - Peggy George
I'll bet parents would really appreciate such timely feedback!! and it's all documented :-)

53:54 - Peggy George
they can't say they didn't know :-)

54:02 - Joan Kane
Cna Jenn give a quick explanation on how she uses the FormLimited and Autocrat add-ons?

54:17 - Susie @shighley
Even just starting small can help convince people. Use a form for something simple and show results.

54:26 - Peggy George
I would love that too Joan!!!

55:29 - @bcdtech Maureen
Question re student privacy- can we use Google Forms for SPED info?

56:36 - Peggy George
wow! that's really handy to be able to limit the number of signups! That would be great for parents volunteering to bring things for class parties :-)

57:10 - @bcdtech Maureen
@Peggy- we've used it for pot lucks- only so many desserts, etc...

57:16 - Peggy George
https://chrome.google.com/webstore/detail/autocrat/ppgnklghfnlijoafjjkpoakpjjpdkgdj?hl=en-US

57:22 - Peggy George
great idea Maureen!

57:31 - Peggy George
that's the link for Autocrat

57:35 - Susie @shighley
I used autocrat for the certificates for edcampIndy

57:58 - Peggy George
Autocrat instructions: https://docs.google.com/document/d/1fdS09Rb8hayiD_V9ZF_JNp-tUg6spCeiL_g_9-IYasU/edit

58:18 - Joan Kane
Will Autocrate email the mail merge?

58:27 - Peggy George
http://cloudlab.newvisions.org/add-ons/autocrat

58:52 - Joan Kane
Perfect; already answered.

58:56 - Peggy George
great!

58:57 - Susie @shighley
I learned how to use it from a video from Wes Fryer!

59:17 - Peggy George
Susie do you have that link? Would love to add it to the Livebinder :-)

59:24 - Peggy George
Fantastic presentation Jenn!!!!

59:34 - Joan Kane
Loved, loved, loved this presentation, Jenn! One of the best Classroom 2.0 webinars I've attended! (...and we all know that a pretty high bar...)

59:44 - @bcdtech Maureen
Thanks Jenn! Look forward to learning more from you at the next conference!

59:49 - Jenn Judkins
That is so sweet Joan!

1:00:20 - Sharon Gullett
Wow! Love the information you presented. You extended my use of Forms exponentially. :)

1:00:40 - @plnaugle (Paula)
Thank you for such an informative webinar, Jenn.

1:01:01 - Susie @shighley
Thanks so much, Jenn

1:01:22 - Peggy George
http://learningrevolution.com (The Learning Revolution Network created by Steve Hargadon.

1:01:27 - Laura Antichi
Thanks!

1:01:31 - Peggy George
http://tinyurl.com/CR20LIVEFeaturedTeacherNominat (Nominate a Featured Teacher for our shows--you can nominate yourself too if you’ like to present for us)

1:01:42 - Peggy George
http://bit.ly/cr20liveitunesu (This link will open iTunes so you can subscribe to our video podcasts.)

1:01:45 - stidmama
Thank you for reminding me how flexible and useful google forms can be! :-) Time for me to think about how to extend my existing use to this year's "crop" of kiddos!

1:01:49 - Peggy George
http://tinyurl.com/cr20livesurvey (Classroom 2.0 LIVE survey link to request PD certificates for live or recorded webinars)

1:02:30 - Peggy George
Patti Ruffing does an awesome job of managing all of the PD certificates! She uses autocrat :-)