MEGAN WECKER: All right, so welcome to Tech Tuesday.
Before we get too into it, I wanted
to give a shout out to Green County
and tell you that I am incredibly sorry,
but despite much googling, I was not
able to find a way to send your office tacos.
I'll figure it out, though.
There will be tacos.
So for those of you that haven't attended a Tech Tuesday yet,
or that just don't know, I'm Megan Wecker.
I work for educational technology support.
And just a couple of housekeeping things.
On the right side of your screen, you should see Q&A
and you should see Chat Options so the difference is
Q&A is going to be content-based questions that you
would like answered.
The Chat option is going to be quick
little things, or wonderful things, mentioning,
such as Tacocopter, which has just come up in the chat.
Man, unfortunately, they don't deliver to Wisconsin,
so it might be a little bit yet.
Please feel free to use those throughout,
and there will be a time in this Tech Tuesday,
in particular, that will be interactive.
So with no further ado, I want to start talking a little bit
about Google Forms.
And I also want to mention Qualtrics,
because I get this question all the time.
Should I use Qualtrics?
Should I use Google Forms?
I'm not going to go too much into it because there could,
and probably should be, a whole flow chart, as well as it
could be it's own Tech Tuesday.
But I wanted to say that Qualtrics,
which is a tool we have available to us
in cooperative extension, is built from the ground up
as a survey tool.
So if you are doing large scale needs assessmenty,
survey type things, Qualtrics may be a much better option
for you.
Google does a lot of the same things,
but it displays the data a little bit
differently at the end.
So if you ever have questions, feel
free to call Eric at the help desk.
And if he can't help you with your specific project,
he can he can refer you to one of us that can help you.
OK, so then I want to talk a little bit
about the types of way you can organize form data.
I like to kind of think of it--
it all kind of falls under the umbrella of Google Forms,
but there's lots of different types of data you can
choose to collect with Forms.
And I think a lot of times people
get zeroed in on Google Forms is for registration,
and that's not always the case.
So you can obviously use Google Forms as a survey tool,
if you would like to, or if you have quick little surveys
that's not a ton of data.
You can use Google Forms for surveys.
You can easily use Google Forms for registrations.
You can use Google Forms for information tracking
for yourself.
So if you have to, say, track phone calls,
or you have to track information that's coming into you
and you would like to make a form that you then
take yourself, that's a really good way
of keeping track of your data in an organized way
and just always going back and filling out your own form.
So when you think of forms, don't just
think of registration, or surveys, or anything else.
It's all of those things, and then I have, as a fourth thing,
any other reason you deem good enough to use Google Forms.
And that ranges just about all over the place.
I've seen farms use for some truly creative endeavors.
And so today, I want to also use Google Forms
a creative endeavor.
I have, in my head, put together a Taco Tech Tuesday themed
Google Form.
And so I want to take you through that form, what
that form would look like, how you would modify and create
that form.
And then I'm going to send out the link,
or save it, or give it out in chat so that all of you
can actually participate in my Google Form.
So please think about answers as we're working on this form
because, if you don't know, I get
brownie points for creative answers
that are still work appropriate.
OK, so the first thing I want to talk about
is how to get to Google Forms.
So is it its own thing?
Is it next to email?
Where is Google Forms?
And so I'm going to switch my screens
around really quick and screen share with you guys one more
time.
Ooh, Katie has the first good question that Tony answered.
Thanks, Tony.
OK, so I'm going to head over to the screen share.
OK.
Sorry, guys.
I shared the wrong screen.
All right.
So to get to Google Forms, and Eric,
you just want to tell me in Slack am I screen
sharing the correct screen?
So to get to Google Forms, you're
actually going to do, just like you would go to anything
else Google, go to google.com.
And once you are in google.com, we're
going to actually go into Google Drive.
Oh goodness.
Screen sharing is not my friend today.
All right.
Sorry, guys.
There's only two screens, so in theory, I
can only get it wrong once.
I seem to have gotten it wrong three times.
OK, so once you're in Google, you
can click on your dots, which are your Google Apps,
and head over to your Google Drive.
With any luck, yours is a little bit more
organized than mine is, but that doesn't
change where you're going to actually find Google Forms.
So I'm going to go into a test folder,
and let's say this is where I want to actually make my Google
form.
I'm going to go New, More, Google Forms, which
will bring up an entirely blank Google form, just like that.
And they default to purple.
So on the other screen, you just saw--
I actually typed these up ahead of time
to save a little bit of time.
All right, so untitled form.
You can go ahead and title it whatever
you would like to title it.
You can also add a form description.
So this is if you want the person to have
any information, such as please fill out this form,
and if there's too many people on our list,
we'll put you on a waiting list.
So any information that you want to have about what
they're about to fill out.
So then I'm going to take you through the different question
types.
And so to add new questions, you simply
hit the Add Question button.
So this is our very first untitled question
and right now, it's a multiple choice option.
I'm actually going to make it short answer,
and I'm going to do the very basic name.
Quick note, if I had a multiple choice question
and I typed in the word "name," it
will, you'll notice actually, change it
to a short answer for me, which is really nice.
So it will predict what type of question
it thinks you want the computer to ask.
So when this person sees this, they'll see name,
and then this is where they will type their answer.
So we're going to go down.
I want to do a paragraph question next.
And I decided to do, why are you participating in Taco Tech
Tuesday?
I know, they're not very clever, but stick with me.
OK, so next, I'm actually going to do a multiple choice.
And I'm going to do, what taco toppings
are you willing to bring?
Guys, I've completely blanked and can't
think of another taco topping.
More cheese it is.
OK, and you continue building your form in this way.
So I also want to mention, there's
this option for Add Other.
And so when you add other, it will give the person
the option to click on that box and type in their own answer.
So just a quick note about multiple choice,
as well, multiple choice is choose one and only one.
So it will only allow the person to choose one option.
Our next one, which is checkboxes,
which we'll create a checkbox question,
will actually allow the person to select multiple or select
all that apply.
And as you can see, it already made it a checkbox for me.
So I want to show you another cool feature.
I'm going to go ahead and copy out this question.
Let's say I want these same options, as far
as what are your toppings and then what
are your preferred toppings.
I can actually choose to copy or duplicate this question.
So it will copy it exactly, what toppings
are you willing to bring?
What taco toppings are you willing to bring?
And I can delete that out and paste in my new question.
Just a quick trick for making the creation
a little bit faster.
The next one is going to be a dropdown.
And so dropdown is what this is right here,
so there's a button.
You drop it down and it gives you
a bunch of different options.
I was going to do what unit of extension-- in what unit
of extension do you currently work, but now that I'm
realizing I don't actually know the units of extension anymore.
That'll be fun.
That'll be the add your own option.
The next one is a file upload.
And so if you've ever done file upload before,
it used to be restricted to our domain.
So this is where you would ask someone
to add a photo, to upload a document, to upload something
so that you have things they wish to submit to you.
Tony was kind enough to check this for me very recently.
And so file upload is now available
outside of our domain, but the person uploading something
has to be logged into a Google account.
So it doesn't matter if it's like just a Gmail account,
or if it's like a k12.wi, if it's a CES Google account.
It doesn't matter what kind of Google account,
but they have to be signed into Google
so that you don't have random people uploading files,
because that's just a security disaster.
So I am going to add file upload.
I'm thinking, if you want to share any work
appropriate taco or potluck photos you
might have handy on your computer,
don't feel like you need to.
It's totally fine if you don't have any.
So it'll allow me to add a question.
And you have some options, as far
as how you can really break this down.
So I'm going to say five.
If you have a bunch of potluck photos,
those sound like a good time to share.
Only specific type of file I could share,
so it's only document.
It's only photos.
It's only PDF.
I'm not going to because I don't know how your files, what they
are.
And I'm going to dream big and say you have giant files.
I'm going to say you have reasonably giant files, OK.
So then I'm going to continue to create.
So we did file upload.
Now, we're going to do linear scale.
And linear scale is every extension person's favorite.
It's on a scale from 1 to 10, 1 being very satisfied
and 10 being highly dissatisfied.
How would you rate, in this case, how much
do you love Taco Tech Tuesday?
So the one label is going to be worst Tech Tuesday ever,
and the 10, or and the 5--
and actually, I'm going to switch it to 10
so I get a better rating here.
The 10 is going to be, why is this not every Tuesday?
OK.
A couple quick things, just to stop and kind of
take a breather, because we are going through this quite
quickly.
Duplicate, I already showed.
If you no longer want this question, you can delete it.
You can also make it a required question.
My one caution would be don't make
everything required unless you absolutely
need to know everything.
If there's information that would be nice
but you don't strictly need it, or if someone
had to answer that, that might stop them
from answering your survey or your form or registration.
Don't make it required, make it optional.
So I've seen some people that do forms and make absolutely
every single thing required, and when I and just
out in the world and I'm filling something out,
if everything is required, I get very annoyed,
and other people do, too.
You can, also, on any of these questions, add a description.
And so this is a good place to mention description,
because for linear scale, we might say something
like on a scale from 1 to 10, where 1 is worst
Tech Tuesday ever and 10 is why is this not every Tuesday,
how would you rate your Taco Tech Tuesday
experience thus far?
So just so you know, you can add that descriptive text,
if you would like to, and you can
do that for any question type.
OK, multiple choice grid.
So I always say that the multiple choice
grid is like the linear scale, but on steroids.
So you have your x and y-axis, or your columns and rows,
as Google chooses to label it.
So I'm going to do a multiple choice grid.
And my question is going to be, if this drink were available,
would you consume it?
And so I'm going to make the rows yes, no, and maybe.
I'm sorry, I'm going to make the columns yes, no,
and maybe, so that they go down this way,
and I'm going to make the drinks the rows,
so that they go across.
OK, so then these will be yes, no, and maybe.
Also, if anyone has some really brilliant options for,
in which unit of extension do you currently work, and you're
willing to type those in the chats, please do so
and I will add them in.
OK, so that is the multiple choice grid.
We're going to move on.
So you can see milk, yes, no, or maybe.
And because this is multiple choice,
again, it means you pick one and only one option.
Not too terribly long ago, about eight months, maybe, Google
also added multiple choice checkboxes.
So this allows you to make things
like what dates and times work for you so you can make grids,
much as you could have made, or can make,
in- boy, I'm blanking.
What is the time, the thing we all use to create meetings?
So anyway, someone type in the chat and tell me.
So I'm going to do a multiple choice checkboxes, which
days work for you?
OK, so row 1 is going to be Monday, Tuesday, or (MUMBLING)
Tuesday.
Oh man, that's going to be so hard to caption.
OK, and the columns are going to be 11:00 AM, noon, and 1:00 PM.
Doodle.
Thank you for whoever--
thank you.
It's Doodle.
OK, so which days in times works for you?
So the rows, Monday, Tuesday, Wednesday.
And then the columns will be these different times so
that people can actually type in any--
they might have multiple days and times
that will work for them.
TONY: Real quick, people, please don't do comments
in the Q&A section.
We have a chat section that you can
use if you just have general comments and you're answering,
such as what unit you're in.
The Q&A, it's really just for questions
because that, behind the scenes, it
actually does get stored separately from the chats.
We do capture that separately.
MEGAN WECKER: Thank you, Tony.
OK, so then I'm going to do the last two.
So the last one is date.
And so month, day, year, and it just inserts a day.
And so I decided, since I couldn't come up
with a really great Taco Tech Tuesday based question,
I decided, what date are you really looking forward
to in 2018?
And then the last one, which is time.
The question is going to be, what hour of the day
are you most productive, mostly just because I'm curious.
All right, so once you have built your form,
and so this is just very basic.
Please note, there are lots of other things
you can do as well.
So for example, in a checkbox, you
can do something called response validation.
So if you want people to pick three and only three,
or two or more, you can do some of those things.
So what I am showing you today is the extreme basic
of Google Forms.
There's a lot more it can do.
There's also a lot more you can do with the data
once you actually have that data stored and ready to go.
OK, so now I've built out this basic form.
Real quick, just because it's kind of an important branding
thing, if you go up here to Photo,
you have all these very cool backgrounds you can do.
You can also upload your own photos
and/or use somethings from our marketing team,
as far as adding those extension logos to your stuff.
I'm just going to do this one because I want to.
And while you guys are taking it,
I will probably also change it to a taco one,
because I'm pretty sure there's a taco one in there.
OK, so then once you have built up your form,
it is pretty much how you want it to look.
Then you can go ahead and send it.
And so there are multiple ways to send it.
Real quick, it doesn't matter because I'm
sending it to interior, all co-op people watching this.
If the people taking it were not co-op people--
so if you sending it to people outside of CES,
you would have to-- have to, have to, have to--
click Settings.
And where it says "Restrict to University
of Wisconsin cooperative extension users,"
you have to uncheck that box.
If you do not uncheck that box, people
will not be able to take your form,
and you'll get calls saying, your Google form is broken.
And you'll look everywhere and not be able to figure it out.
It's just this one little button you have to click.
There's some other things you can do in here, including Edit
After Submit.
So if people save the link, they are
able to go back and modify what they've just sent.
Usually, they don't save the link
and they're only able to modify it for like, 10 seconds
after they're done.
It's more like, did I do that right?
And they can go back and double check.
And you can allow people to see summary data and text
responses from the form they've just filled out.
For our purposes today, I'm not actually
going to do either of those, but just know they're there.
Also, Collect Email Addresses is an option.
If you have multiple pages--
I didn't do multiple pages here today,
just because it's basic--
but you can do multiple pages, and you can
do Go To Page Based on Answers.
So if they select A, it goes to page 2.
If they select B, it goes to page 3, and so on.
Skip logic, essentially.
TONY: Megan, you've been asked if you can and show
how you get those settings again and also
know how to add a photo.
MEGAN WECKER: Yeah, sure.
I would love to do both of those things.
Thank you, Tony.
So Show Progress Bar, you can do.
It if this were, for example, a quiz
and you wanted to randomize the questions,
you could also shuffle them.
And you can turn on and off this link
to submit another response.
And so you know, after they click Submit
and they've submitted their form,
it'll say "your response has been recorded."
You can do a whole lot more with that, if you would like to.
You can type in whatever you would like.
"Thanks for doing it.
Here's a link to our website," anything like that.
OK, so to get there, I went to Settings.
And so I clicked on Settings, and these will pop right up.
And that box you have to uncheck is
right in the General settings.
It's not hiding anywhere.
So it's right out in the open after one click of a button.
OK, and then adding a photo.
That's a really good question.
So this is what you do to add a new question.
This would add title or description.
Here's Photo.
Here's Video.
You can embed a YouTube video right in.
And actually, a lot of people have started
using forms for quizzes.
So they'll do a quiz on something
that they've presented, or if people can attend,
they'll record the session, put it on YouTube,
and then do a quiz to make sure you watch the video all the way
through.
So you can do that right within Google Forms
once you add the YouTube video.
And Add Section is if you were going
to use that skip logic I just very briefly mentioned.
That's how you would do it.
You would add a section.
So to add an image, you click on Add Image.
And you take an image from wherever you have one handy.
We'll do Megan and Eric's Christmas card
because it's you only one I have handy.
So there you would have our image.
Oh, that's scary.
OK, so to actually send this out, you go up to Send.
You can email it right from Google.
I don't really recommend it because a lot of times
it doesn't look very nice.
You're going to have a lot better luck if you
choose this link right here.
And so now you have this link.
You can shorten it, if you would like.
You can also embed it, but I'm not
going to talk about that because it's not really
pertinent for what we're doing.
OK, so I'm going to copy this out.
You can also click Copy.
And then I'm going to put it in the chat.
And if you guys, if you are willing,
go ahead and click on that.
And I'll give you like two minutes, just very, very
quickly run through it.
It doesn't have to be serious.
In fact, like I said, you get brownie points
for having fun with it.
Oh sorry, let me try that one more time.
All right.
I'm going to go going in, in the meantime,
and find that taco one because I know there's a taco one.
There's two pizza ones.
There has to be a taco one.
Man.
And if you're not interested in taking it,
feel free to watch my screen and see
all the very cool backgrounds you can get, or headers.
Must've been a weird dream.
I thought they had a taco one.
OK, so we have about 20 responses,
and I anticipate just a few more.
But I want to keep it moving because I'm officially
at 10:32.
Every time I do this Tech Tuesday, I run over.
And I thought I had it squashed this time, but apparently not.
OK, so let's say I have gotten out of this, and I've come back
and it's the next day, and I open up my Google Drive.
And I go into this Google form.
Please note, there's a bunch of add-ons
I'm not going to have any time to go into,
but you can have Google notify you when new people submit
something to your form.
So you don't have to go back in each time and be surprised.
I kind of like it because it's like Christmas, like,
did I get anything?
But that's just me.
OK, we are up to 28 responses.
So once you go back into your form the next day
and you go into responses, it's going to show you
some really cool stuff.
Oh well, hello, everyone.
There are so many people that responded.
This is wonderful.
TONY: Megan, just so you know, your screen share is so blurry
right now, we cannot make out any details.
MEGAN WECKER: Interesting.
I am connected to a wired internet connection.
TONY: You might want to just stop the screen share
and restart it.
MEGAN WECKER: I can do that.
Any better?
TONY: Definitely better.
MEGAN WECKER: Excellent.
Thank you, Tony.
OK, we were in the Question panel.
This is where we actually built the form.
When you go into Responses, we'll
be able to see two things.
So we'll be able to see Summary and we'll
be able to break out the individual responses.
So why are you participating--
TONY: And Megan, you're on the wrong screen.
You're on your document right now.
MEGAN WECKER: Oh, goodness gracious.
I'm not sure what's--
it keeps-- better?
TONY: Negative.
MEGAN WECKER: Hm.
It keeps wanting to screen share one and only one screen.
Better?
TONY: Yes, it is.
If you could just zoom in a little bit, that'll be perfect.
MEGAN WECKER: Excellent, can do.
OK, so we have our responses.
31 people have responded.
Thank you, guys, so much.
I appreciate it.
This is no fun if there are no responses.
Why are you participating?
We have everything from to learn about Google, because it's fun,
and just because you like tacos.
All good reasons.
I thought this was a food and nutrition webinar.
Oh, boy.
Yup, that's wonderful.
OK, what taco toppings are you willing to bring?
So people selected either one or, as you can see--
oh, yummy-- people added their own.
So these are some really, really good toppings selections.
I'm glad you guys could think about it when
I couldn't think anymore.
What are your preferred toppings?
Interesting.
The preferred don't mesh with what
people are willing to bring, but it's pretty close.
OK, and which of extension do you work?
So you can go--
11 people work in option 1.
Good for you.
Food Wise, 4H, zone office.
Wow, we have quite a good representation of people here.
Oh, boy.
So now we have all of these images,
and they'll actually be stored in their own folder,
as well as we can click on them and see.
Oh, yummy.
Apparently, Waupaca County has a taco bus,
so I'm kind of jealous.
Thank you, guys, for actually adding photos.
I wish I had a little more time I would go and look
at all of them.
How much do you love Taco Tuesday?
Oh thanks, guys.
You can see the responses.
If you were able to bring a drink, or if you were able,
would you consume it?
Milk, 16 said yes.
So anyway, so you can kind of see how this data shakes out.
What date are you really looking forward to in 2018?
So a good follow-up question would have been why,
and I'll show you in a moment.
What hours of the day are you most productive?
Oh, good.
I'm glad we catch some people at the right time.
I'm an 11:00 PM person myself.
4:31, that's marvelous.
As far as responses, we can also go in
and take a look at these on an individual basis.
So Amy, I'm putting you on the spot a little bit,
but these were Amy's individual things.
So this is obviously not random and not anonymous,
at this point.
OK, so I just want to show one more thing
and then I'm going to finish up.
The last thing-- you might recall that in the past,
this data has spit out in a Google Sheet.
So it's recorded this way, however,
if you click Create Spreadsheets,
you can either create a new spreadsheet
or you can put it in a tab of a spreadsheet you already have.
For here, I'm going to Create New.
And it will spit out that data in a format
you might be a little bit more accustomed to looking at.
It will also give you a direct link to any
of the files that were shared.
And just as a quick thought, so I created it in my test folder.
This is my form.
And that's my question, and then there are all the photos.
Nice.
Oh, that's wonderful.
Thank you, Stacey.
So there are the photos that were submitted.
OK.
I wanted to mention one less thing
about where to store these.
You can store them in Team Drives now.
So if you create it in Team Drives,
everyone will have access to it that is part of that Team Drive
and can edit it, if need be, and can get the results.
The one caveat is that in Team Drives,
you won't be able to use any of the add-ons.
So if you really like add-ons and you use them
for your Google form, you can't see that in Team Drives.
Otherwise, you can save them in Team Drives
so one person is not controlling all the forms
in your office, which almost always leads to problems.
OK, so I'm like 10 minutes over, as usual with this one.
So I wanted to say thank you so much for attending.
Join us again on April 24th at 10:00
AM for part three of our Google goodness series,
which is I'm going to be talking about documents, permissions,
and sharing.
I even wrote that out so I got that all right.
All right, and with that, I'm going to stick around
for a couple of minutes, take a look at the Q&A and the chat,
anything I need to address.
But otherwise, I'm going to stop recording, and thank
you so much for joining us, and come again next month.
Không có nhận xét nào:
Đăng nhận xét