Tip:
Highlight text to annotate it
X
just finished talking about
how we're going to make this look good
now it's time to take a look at
all of the responses
what does it look like on the back and after someone has already given us
information we've been looking for whether it's a quiz attest just the
surveyor questionnaire
we've had a little bit of a glimpse and so what it looks like on the back and
but now we're gonna take a deeper dive into
how we can manage and take a look at all this information so
the first thing that you have to understand
is that you should look at the bars of the tabs up here along the top
you see that we have the fema started out by the knew the forward and backward
heroes
and you also see the responses
menu item up there at the top as well as the answer to you and all of those other
good things
but here we are going to dive into
choose
abe response destination this is brand new in this new form of google forms
it used to be that it is an automatically dealt to spread she had no
way of she was in what you want to do with it exactly
but now they have
three major options the first one is make a new spread sheet
are based on all the submissions the common with us for minority of form
and then you have a spreadsheet that all of the information don'ts into that
actual google spreadsheet you've learned a lot about spreadsheets already so
it should be relatively comfortable with that
it is that's the most powerful way of actually
running in using one of these forms
the way that we always used to run them but now you have a couple of options the
dumb it down or peridot if you want to sell i would say for almost all of your
uh... uses you're going to pick
new spread sheet and you can even name that spreadsheet comrade here but i like
new survey responses tells me exactly what it is it's my new survey
and as the responses from that survey you can also pick this is pretty clever
ingenious if you have a bunch of different surveys are all feeding into
the same
concept you can actually pick that you wanted to go into a single sheet
from within a spreadsheet so now if you have
all spread sheet that was pretty when you have those tabs along the bottom you
can actually say
i want all of the responses for this takes a dump into a single sheet and you
can have that one document with multiple sheets
from different surveys all funneling down to one place it's a fairly clever
way off
aggregating multiple different surveys and the one spot
you can't also say
i'd just want to repeat all the responses only in this format the spot
rate not down here it's that create bond
if you cope better press that
it's going to keep all of those
responses
right here in the response
summary of responses and this is all your ever going to see you're not going
to have a spreadsheet
that is actually associated with it let me show you exactly what i'm talking
about by going back to shoes response destination and i'm going to create this
new spread sheet right here
and
after it's done doing that's actually going to identify a preconceived
thinking setting up the spreadsheet
sousa's don creating that's pretty clear it up
now i can view my responses in the spreadsheet form they do that by
clicking on this right here
and now you see i have a spreadsheet instead of
that
some review so i can see the exact responses of people on the top in the
first field bring up here
you see all the questions are all the survey
uh... topics or questions that you've created
and then below them you would see all of the answers you can see the timestamp
rigor when that person took it
and all of the responses of pieces that that individual
filled in
and obviously if you have something like a name field and hear what have you at
the beginning
here's to the person's name you could even have a student i_d_ or what have
you
built into this form so you can click the date on that individual so now
automatically you'll see that the top up here the steel names
are frozen they use a freeze-frame appears for that as you scroll down if
you know information
disappears that the republicans of responses no matter
even if you scroll down to the bottom you will still see you feel sixty
minutes
and if i close out of this
survey right here with this kind of actually kill that
it just brings me rate back to my survey potentially rate here
where i have my response but filled alive form
and i can kill this survey work here as well for that portion of the survey but
now when you might be saying here but i like that response view i don't want to
always go to the spreadsheet
that's not probably got copy responses
you guys do you still have that option for summary of responses but now you
have the view
the actual responses option
and you even are given that third option two
change that destination so quickly found that see this familiar dialog box pop up
so i can change the separate and unified creatine is pretty clear
later on i could decide that i want to stay inside the spreadsheet
realistically the only reason why you would want to keep it
built into the form and
disassociated from that spreadsheet in other words cut it off no spreadsheet
associated
with the if you warrant dissipating
that you're going to have thousands and thousands of responses because
google forms only lets you collect
x_ number of responses before a kind of shuts down spreadsheet so
unless you're anticipating just
crazy numbers of responses
realistically you want to have a spreadsheet because that's where the
power comes in you can then go back to the spreadsheet
and if you have tons of data here
you can write formulas that will collect the averages in the sounds of things of
you have a science project
and all the students are entering the lab data
into this form
they could have been aggregate total of all the different measurements and all
the different measuring recounts that you have to wrote that letter
if you do it invoice language piece in here where people are
entering the first that they think the biggest snapshot of all the different
first that everyone off
wanted to put in here
it's an extra really powerful way to collect the data
and the fact that it's had with the spreadsheet is brilliant
most of the time you are not going to want take away that option
there are a couple of little
interesting things that you can still do you do with responses or with the form
data internal
one of them is still underneath the response is here
and actually can learn a lot more about it by going right next door to helping
to go to help center
you can learn a lot more about what in the world and get pre filled you are
allen's literally
it's this basically
you can't have the forum
pre populated with some information that the number to give you a war
and user some hints about what they might want to put into the individual
areas within your form
it takes a little bit and know how for instance you have to be understand how
to key in something like the string you see here where you have the values of
zero managed to put in the entry values
followed by up all the rest of the string on the information within the u r
l
in order to make this work properly
but you can do it then there's a little cheap cheap rate here on the google dr
page if you just type in
appear in the google search
pre filled
u r l it will take you raise your to those parameters
we can learn more about it because on klein
we're not going to go that far just because it's pretty uh...
for someone to actually need that kind of
uh... ability to do that prieto
but it's possible so it's very nice to have just in case you need it
the other one is
you've got on link the former easily or you can delete all responses thankfully
they make sure that your certain before you do that someone hit cancel but that
will delete all the responses and your form which you might want to do because
maybe an you were doing a bunch of testing first before you sent that out
and instead of having to go in and highway to the cells and delete dahmer
the rosenbloom you could just pressed that button
tilly targeting start from scratch send out a form
and be good to go up
then over here under fire we have two more options that i want to go over with
the one is downloaded ads
this download has been a download ucsd file which is essentially a spreadsheet
file uh... comma-separated values that's all that really means
was going to download not the form but all of their responses to the form
in a spreadsheet for like excel at u_s_ senate off to someone who may not be
using google docs
or understand how to use the google spreadsheets you can do this
and then he meant to them
you can't also
in endure for if you click dead-end had barton
now you see a dozen different heights and weights that you can pick from in
pixels
and all you have to do is click on this and copy it you can be come and see your
control see if you're on a pc
and that copies that
html coding
but then you can paste into a web site into our learning management system so
that the forum is built directly into that webpage
so you don't have the redirect people
back and forth to and from places
anymore you can just copy and paste the embed code
embedded in a pcn already zone
and you are all up and running with your brand new google form ready to
collect responses
that's the engulfed
how we collect
manage and understand
all the different areas and components
of responses from google forms