Transcripts
1. Introduction to Google Forms and Research Survey Basics: Well, hello there,
and welcome to creating effective thesis
forms using Google Forms. In this course, we'll start building your form from scratch. You'll learn how to create a new form and give
it a clear title. And in this course, we're
going to take an example of a survey for social media
and academic performance. We'll also write a concise
and ethical description that includes constant details and walk through basic
setup options. By the end of this lesson, your form will have
a strong foundation, clear, professional,
and ready to build on. So let's get started.
2. Starting Your Form Title, Description, and Setup: Especially when you're
doing a thesis, you may want to go ahead and collect out surveys from people. Doing that on paper
might be time consuming. So for a quick way to
collect information, you can utilize something
called Google Forms. So for that, first of all, you need to have a Google
account and you need to be signed in to your Google
account just like this. And over here, what I
want to do is access out Google forms in order
to start making forms. So to do that, I
can go around onto my Google Apps drawer here
and access out forms here. As long as I'm signed in, I will get onto this space. If you don't have
the app drawer, you can also go around
and type in.google.com slash Forms on your
URL address bar here, and that is how you can
access Google Forms, as well. So once you get onto this space, what happens is that you can
simply start creating form. You can go ahead and start from many different
templates here. But in this course,
we're going to see how we can
actually go ahead and then create form from a
blank form from scratch. So I'm going to go ahead
onto blank form R here, just like this, and then
a new form is created, as you can see R here. So now we can simply go ahead and then give it a
title as necessary. So what I'm going to do is, let's say I'm
taking a survey for social media and
academic performance. So I'm just going to go
around and say social media and academic
performance right here. So let's say I want to
take a survey for this. Once I type this in over here on the top, if
I were to click, you can see that I can set the file name just
like this as well. So that is what I can do. So now you can also go ahead and write an ethical
description over here on why you're actually taking this
survey, right here. So you can say, I
am doing a thesis, doing a survey for my for my basis on social media
and academic performance, just like this right here. Please fill out the form form. Please fill out the form in the different
sections as provided. So I can simply
go ahead and then type this description
just like this, as well. So you can be more
descriptive as necessary. And then what you can
simply do is you can go ahead and then start
making the form. So here you can go ahead and start asking
questions right here. As you need. So you can go ahead and let's
say, for example, I'm simply going to go for a short answer here and I'm going to go
ahead and say name. So maybe full name of
the participant here. So you can make this required
here or leave it as it is. So if you leave it required, then people have to fill it out. Otherwise, they don't need to. So if you were to turn it off, they can skip skip
this part of the form. So depending on
whether you require certain portion or not, you need to go ahead
and turn this on. So you can also go ahead and preview to see how that actually looks like and how your users
can interact with the form. And as we actually go
ahead and leave it. So it says it won't be saved. This is a a test,
so that's fine. As we move along the course now, we're going to actually go
ahead and see how we can add in different
sort of questions so that we can so that we can
collect the information as necessary from the audiences and get their response, as well.
3. Building the Survey Question Types and Structure: So now let's continue
with our Google forms and add in different
sections to it so that we can collect
data as necessary. So we already have our title, social media and
academic performance right here, just like this. And then let's say what I want is I want a more
detailed description. And for that, I need
to go ahead and add in description as I please. So let's say, instead of saying I'm doing
my thesis survey, I want to change my description. So I'm simply going
to go around and say, the participant here,
just like this, and I'm going to
press Enter and say this survey is part is part of an academic
research project, right here, just like this. And then I'm simply going
to go around and say, your participation is voluntary, and all responses will
remain anonymous, anonymous and confi
dential right here, just like this, for example, and this is what you have. So I changed my
description right here. So now after that, I'm going
to go around over here. And let's say, for example, I have the full name
which is added in. So I don't want to make
the full name compulsory, let's say, for example. So someone may not want to give out names
right here, like this. I'm just going to go around
and keep it as it is. So now, apart from that, let me say I As group. So let me just make this
multiple choice itself, and I'm going to go
around and say As group. And I want to limit the
AS group for my studies. I'm just going to go
around and then do that. So let's just go
ahead and correct it. And over here, I'm
going to say under 18. Let's say, for example,
add another option that is 18 to uh, 18 to 21. And then another option, let's say, for
example, 22 to 25. Let's say, for example,
and I'm going to say over 25 right
here, just like this. So this is what I have, and I'm going to make this required. And apart from that, I'm going to go ahead and add in another multiple choice
question called gender as well. So I'm just going to
go around and say male right here and female,
just like this as well. I just want to throw in
other over there just like this as well and make
this required, as well. And I'm going to go
ahead and add in another question right
there, just like that. And then I'm going to go
ahead and see something like what is your
major field of study. Let's say, for
example, right here. What is your major
field of study? Let's say, for
example. And this, I want it to be a short answer. And let me make this
required as well. So just like this, after that, I'm going to go around and say, which year are you
which year or grade, are you currently studying in? Let's say, for example, here. So now I'm going to
go ahead and say, which or grade are you
currently studying in? So let's just go ahead and make this multiple choice
question right here. So let me just go
for short answer and multiple choice so that I get the options.
Sometimes that works. So I'm just going to see, um, grade grade 12 and below, right here, or I'm going
to say first year, first year, second year. And I'm going to say
third year, right here, or maybe fourth year as well. So fourth year. And I'm going to
say post graduate. Degree or above here. So I'm just going to go ahead here and add these choices in. And let's make this
compulsory, as well. So apart from that, I'm
going to go ahead and now go for the social
media uses option. So I'm just going
to go around over here and I'm going
to go ahead and see how many hours do you spend
on social media per day? Let's say, for
example, right here. So I'm just going to press
cancel and then spreasspace. And over here in
multiple choice, I'm going to say less
than 1 hour right here and I'm going to say
one to 2 hours right here and I'm going to say
three to 4 hours or more than 4 hours, right
here, just like this. So this is going to be
compulsory as well. So now I'm just going
to go around and say, with social media
media platforms, do you use the most here. So I'm just going
to go around over here with social media
platforms, you use the most. And this is going to be
multiple checkboxes. So I'm just going to allow other people to select
multiple checkboxes. So I'm just going
to say Facebook. And I'm going to say
Instagram right here. Let's say, for example, and I'm going to go
around and say Twitter. That is X right
here as currently and then TikTok maybe right
here, just like this. And I'm going to say Linked N
right here, just like this. And I'm going to go around and say tube over here,
just like this as well. And then I'm going to say
others over here as well. Add others as well. So I'm just going to make
this compulsory, as well. So apart from that, now, I'm simply going to go
around and say what time of what time of the day do you
usually use social media? Let's say I want to throw
in that question as well. And then, over here, I'm just going to go around and throw multiple choice
questions like, let's say, for example,
morning morning right here and afternoon
right here, evening. And as I click, you can see that is what you have as well. Or afternoon morning
afternoon evening right here, or let me just throw in a
night right there as well, just like this and make
this required as well. So you can see that
I can go ahead and add in different
sort of questions. And we only use
multiple choice and then multiple checkboxes and mostly short answer questions. But there's different
type of questions here, as you can see, there's
short answer paragraph, there's drop down,
there's linear scale, even rating, as you can see, right here, date and time,
as you can see, as well. But this is what I need, so I'm just going to keep to it. So if I were to go
around and preview now, I will be able to see how my form will actually
look for the audience. So here I can add in my name. I can choose my age group. I can go for my gender, and in others, I can
type in as well. I can add in the field of study, select my year here
like this and choose the number of hours
I use social media. Check the social media I use and choose like when I use the
social media the most. So this is how you have, and then now we still need
to go ahead and further, make changes to our form
by adding in sections and then changing the way we
collect information as well. So now we have actually
completed out adding questions, and now moving forward, we're going to see
how we can further, make changes to the
form as needed.
4. Organizing with Sections: So over here, I have
this form here, but if I were to go
ahead and preview it, then everything comes
in a single piece. But what I want to
do is, let's say, for example, divide
this under sections. So to do that, I can actually go ahead and add a
section right here. Once you go ahead and do that, this is the section,
as you can see here. For example, I'm going to uh, like this section as something like your info
right here, just like this. So this is only going
to go ahead and contain full name as group gender here. Like, what is the
major field of study right here and so forth. Let's say, for example. So that is what you have right here. So now, your info, let's say, I just want to keep
the name right here, and then I'm going to go ahead and add in another section. Let me just go ahead
and delete it and then go to add
another section here. And then if I were
to go around over here and type in
demographics right here, just like this, and
this is what you have. So if I were to go ahead
and click and drag the full name over here onto your info, this
is what you have. So apart from that, you can see that this
is what you have. As group is here,
under demographics, and then gender is under demographics as well,
just like this. So apart from that,
I'm just going to go round onto another
section right here. For example, from over here, you can see that it says, how many hours do you spend
on social media per day? So I'm just going to go around and add in a section right here, just like this, another
section that is. And then I'm simply going to go ahead and then name this out as social media uses right
here, just like this. So demographics is here, and this is here as well. So let's just go ahead
and then, let's say, for example, move the
section around over here. Around over here on the bottom. So social media, right here, and so forth, you can
reorder out the section. So you're info on the top, then you got
demographics right here, and then I'm going
to have social media uses right here, just like this. So in the social media uses, so you can see that this is social media and
academic performance. So I have messed up this a bit. So let's just go ahead and then move the section over here. So social media and
academic performance, right here, just like this. I'm just going to
keep this to the top. And then this is what you have. So this is the title, and
then you got the Section two, which is your information. Then you got the demographics, as you can see here and so forth. So this
is what you have. So now under the
social media uses. So you can see that
I got masa things right here like
demographics, right here. So how many hours do you
use social media per day? So I'm just going to
go ahead and keep it under social media. Then I'm going to go around over here and drag in
with social media. You use the most here, so I'm just going
to go ahead and drag that in around
over here as well. So apart from that, what
time you use social media, I'm just going to go ahead
and track that in, as well. So that is what you
have, as you can see. So now, this is what you have. We divided everything
into sections. And if I were to go around onto preview, let's
say, for example, it says, Dear participant, this survey is a part
of academic project. So if I were to click Next, then I get my name
here just like this. Then I get the other
things as you can see a here, like
the demographics. Then if I were to click Next, then I get the other
questions a here, and then finally, I can go
ahead and submit this out. So this is how you can divide
your forms into sections, and as we move along, we're going to now
see how we can actually add conditions
to our forms as well.
5. Using Logic in Form: So over here in our form, we have different sections, but these are actually for
those who use social media. What if they don't use
social media at all? In that case, I want to actually go ahead and add in a section to ask them that and then simply end the form
if they say no. So I'm just going
to go around and add in a section right here, just like this and in
the section right here. So this is what you
have, as you can see, I'm just going to go ahead and then change out the section. I'm going to move the
section right here. Around over here
after your info, I'm simply going to
go around and say, use of social media. So I'm just going to say
use of social media. So now around over here, let me not add in a description, but I'm simply going
to go ahead and add in a multiple choice question. So I can say, do you
use social media? So I'm simply going
to add in question, and I'm going to say yes and no, right here just like this. So now I want to
make this required, and as they actually
go ahead right here, I want to enable go to
section based on answer. So if they say yes, then I want them
to continue on to demographics,
continue right here. But I actually want to go ahead and then, let's
say, for example, ask this question right around after after the
demographics itself, maybe. So I'm simply going to go around and resuffle this right here. So I'm just going to
go around and move the section from
demographics right here, use of social media, right here, just like this. And this is what you have. So now, instead of use of
social media right here, so I'm just going to go around. Social media uses details,
let me just go around, make it more detail
here, details. And now, as they ask, I want to continue to the next section onto
social media uses detail. But if they select no, I just want them to submit the form. That's it, because I don't need to ask anything
further from them. So now, once you do that,
this is what you have. So it's a DEA participant. You can click on Next Now. You can add in your name. Let me just go around and add in my name here, for example. And then they got this. So you can go ahead and select
out different information, so I'm just going to go
around and say graphics. Sign here, and I'm simply going to go ahead and
select and click on next. So it says, Do you
use social media? So if I were to press, then it goes to the
next section like this. But if they don't, and
then click on Next, then you can simply go ahead and click Submit
to finish R here. So this is here. So you can simply go
ahead and finish it out. And this is how you can
actually go ahead and use Lasik in your form as well to make it much more
interactive, as well. And now we're going to actually
see how we can actually share our form for others to fill and start
collecting information.
6. Changing Form Design: So if I were to go around
and preview out this form, you can see that this form
has a certain look to it. But let's say what
you want to do is you want to
change the outlook, the theme of this form as well. So to do that, you can simply
go around over here onto the editing area and then
go to customized theme. Once you do that, you can
actually see that you can change many
features of the form. Like, let's say, for
example, you can change the form color altogether right here by
choosing this option. So it's the background color
as well, just like this. You can also go around and then choose a particular color
right here, just like this. Um, by using the
slider and by using this scallop picket
just like this as well to get a certain
look right here. You also have option to
choose a header Image. You can also go ahead and upload your own photos that
you may have as well. So you can go to photos. If you have it, it'll show
up right here. But in my case, I'm
simply going to go around onto, let's say, for example, work
in school itself, and then I'm going to
go ahead and use this, which actually matches
with the theme. So once I go ahead and do that, that particular
image is added in, as you can see, and
apart from that, you can also change the
header style as well. So I'm going to select impact, and you can select the font
size as you want, as well. Let me just keep it high. And over here, you can go for different sort of
fonts right here. So let me just head on to aerial right here for
regular information. And for this text, let
me select Oswell here. So this is what you
have as you can see, and you can change the
size as well and so forth, as you can see right here. So now, once the theme is sans and if I were
to go to preview, then this is how people
would actually see this, and you can see that
the entire look of the form changes out. So if I were to click on Next, now as I type in information, you can see that this
is what you have, as you can see here. So our form has a
certain look to it, and that is how you can change out the form design as needed. And now moving forward, we're going to see how
we can actually share our form and start
collecting responses.
7. Previewing, Publishing and Sharing: Now that we have our
Google forms ready, it's time to actually go ahead
and preview this and share this out with others so that they can start
filling the form. So to preview it, you can simply go around onto the
preview section, and then this is
what you have here. So if you were to click Next, then it goes next here. So now, this is actually
just in preview mode. It's not published, so we
need to actually go ahead and publish it in order
to start collecting data. Or to do that, simply
click on Publish, and then you can
choose whether anyone with the link will be
able to fill the form, or you can even go ahead
and choose to manage to simply share it out with certain people of
your choice as well. But let me just go around over here and keep it to anyone with the link and click on Publish because we want a lot
of people to fill this. And it's published, as
you can see right here. So once you go
ahead and do this, you can go around over here
onto the three button, and then you can see
that I can unpublish it out from over here
as well if I want to. So this is published, meaning I can copy the
responder link here. You can even get a
shortened version of the link just like this. So now to see how this is
actually shown at the end user, you can actually go around onto an incognitive window here, paste out the form and then see from the fillers
perspective rot here. So this is what you have.
They get it in the language, that they're filling
it in as well. But in my case,
I'm just going to paste it over here
in the browser. Let's say, for example, then this is what you
have you can see. So you can go ahead and start filling out the
information as needed. So now, apart from that, you may want to share you got the link right here
that you want to share. You can also share this
out through email. So you can simply go
around onto Mans. And then if you want to share
this out through email, simply go ahead and
type an email out ra here of the person that you
want to fill this from. So just go ahead and then type in the email right
here just like this. And then you can choose them
to be responder or editor. In my case, I want them
to be a responder, so you can say, please
fill this form. So I'm just going to go
ahead and type this in and hit the Send button
right here, just like this. So once you do that and save
it, everything is saved. And then around over here, all the responses will
be collected right here, which we're going to
see in upcoming lesson. And then in the setting, you can see that you can turn
this into a quiz as well, but we don't want
to make it a quiz. And in the responses, you can see that you can collect verified email addresses or responder input as
well if you want to. But if you were to
actually choose this, you do need the responders to be sign in with
their Google account. So I'm just going to
keep on do not collect. You can also set it to limit
to one response so that one person will only be able
to fill the response once. But again, respondents
will be required to sign into Google
in order to do this. So you can see that
this is what you have. So you can sew a progress
bar as you want, as well. You can shuffle
the question offer question order if you want to. But I'm going to enable
the progress bar rot here. And they can also view
the results summary. They can turn this on so that they can view
it out as well. And there's some
different defaults that you can turn
on and off at here. So if I were to go
around onto preview, now you can see the
progress bar here as well, and they know exactly
that they have to go through five pages once
they fill up the form. A here. So this
is what you have. And then right now the form
is open here, just like this. And you can also go ahead and turn this off
if you want to. You can unpublish it
out as well anytime. So right now it is published. It's accepting responses. You can turn off the responses anytime and save
it out, as well. But let me just keep it ongoing right now,
just like this. And one of the ways that you can actually go ahead and share out the form is by
making QR codes as well. So for that, you
simply need to go ahead and get the
responder Link R here. So let me just get
the small one. And then you can use
a free online tool, like, let's say, for example, get QR right here and then put the URL that you have
right here, just like this. And I'm going to say Form
ink here, just like this. So once you go ahead and
then click on Create, you'll be able to see
the preview rot here, and you can simply go
ahead and download this out in different
formats as needed. So let me just go around
onto P&Z and then over here, you have is you have a PNZ of the Google form just
like this as well. So there are many ways to share, and so it's through emails. You can directly share
the link or generate a QR code so that people
can scan as well. And that is how you
can preview and then share you share your form
for others to fill up. And next, we're going to see how we can collect responses and then finally manage the
data that we collected.
8. Collecting Responses: So over here, I have
this form ready now, and let's say I want to
share it out with others, and then once you go
ahead and share it, let me just go ahead and
copy up the responder link right here and fill up some
of the details myself. Let me just go ahead
and then enter this, and then I'm going
to go ahead and fill up some of the
details myself. So I'm just going
to go around and then add in my name right here. Click on Next Rot here and
I'm going to go ahead and select out my feels right here, just like this, and I'm going to say fourth
here, just like this. And then I'm going to
go around and say yes, right here and randomly
select out something. So some of the social
medias that I used, and I'm going to say evening right here and submit. So
this is what you have. Let me just go ahead and submit another response
right here as well. So I'm going to
say another name. Let's see, for
example, right here, and then choose out the
information right here. So I'm just going to say
computer engineering right here, just like this. And then I'm going to
go round over here. Yes, and then I'm
going to go ahead and select the information
out right here, just like this as well. So let me just go ahead and submit another
response right here. Just like this right
here and then click on next and then here
and then this one, and I'm going to
say, just like this, and I'm going to click on next. Yes. And then I'm
going to select some information a
here, just like this. So this is what you have a here. So now coming back on
to the editing area, you can see the responses
around over here. And in the responses, you can see that this
is what you have. So this is the diversity
that you have a here. One is 18 to 21, another is under 18, and then over 25 is green. And you can see that there's
no yellow in the mix. You can even copy out
the chart and paste it somewhere directly
if you want to. But over here, you can see
the details just like this. Apart from that, you can also
link this to a spreadsheet. So if I were to click
on Link to Set R here and create a
new spreadsheet, then what happens is that it links it to spreadsheet here, and you get this data in the table format right
here, just like this. So this is what you
have, as you can see, and then this is how you
can go ahead and connect it out to a Google
seat that you have. Alternatively, you can also go ahead and then select
a destination for responses and then select an existing spreadsheet
as you want, as well. So another spreadsheet that you may have already existing, you can simply insert it out
onto that a sheet as well, and you will get
the responses over here on that particular sheet. And that is how you can
go ahead and collect responses and then even send it to Google Seat
as needed right here. So whenever someone
fills a new entry, then it gets collected in
the Google Seat as well. So that is how you can connect responses to Google Set
and collect responses, manage out responses inside of Google Forms. Um,
just like this. And next, we're going to
see how we can even go ahead and then organize
data that we collected, and then we'll go up towards
wrapping up the course.
9. Exporting in Different Formats: So now you can see that we
have our responses right here, and if I were to go
around onto sheet here, then I can see my data
right here just like this. So you can see that
I actually have bolded out these
information here. You can go ahead and bold different sections as you
need as well to emphasize it. You can see that the timestamp
has a certain date format, but if you want to
change that, you can also go around over here onto format onto number. Then go around on to
custom date format. Let's say, for example, and choose the format that
you like right here, just like this and
that will be applied. And this is how you can
apply formatting as well. So this is what you have,
and then you can go ahead and resize out the
columns as you want, as well and change around
the data so that you can go ahead and see the
important information easily, just like this. So apart from this, you can also export out the format
in different format. So for that, you can
go to File and then download it out as
an Excel format. Let's say, for
example, so that you have your data in Excel format. So you can see that
this is what you have right here, just like this. Apart from that, you
can also go ahead and export this out right here, let's say, for example, in different sort of
formats as needed. So let me just go
ahead onto Download. You can download this as
an SDML as you can see, you can download this as a PDF. Open document and so forth, as you can see right here. So let's say, for example,
I'm going to go for CSV file, and then you got your file
in CSV format right here, just like this, as you
can see right here. And that is how you can export your data in different formats and organize it as necessary
inside of Google Forms. And next, it is up to you to create a form
just like this now, and now it's time to apply
whatever you have learned to create your own
form and start collecting surveys for
your research purposes.
10. Google Forms Project Description: We have now come to
the end of the course, and now it is up to you in order to start
creating your own form. So what you have to do
is build up a form, a survey based form. Let's say, for example, you have a thesis in a particular topic. Think of your own topic. It can be anything,
research on anything. So based on that, you need to go ahead and
create a Google form. So in your Google form,
at least do this. At least go ahead and keep two demographic based questions like age group and gender. Whatever you can
come up with and five topic related questions. So here I have use of
social media here. So I got one topic
related question, two, three, four, right here. In your case, simply go ahead
and then add in, let's say, at least five topic
related questions, which may be qualitative or
quantitative as you wish. And use one logic at least
like I have continue to the next section based on what this is selected.
You can see here. So it says continue to the
next section rat here. But based on whether they
use social media or not, I will be able to go ahead
and submit the form here. So similarly, use logic as well. At least one osi
that is brancing. And then once you finish, just fill it up with
dummy data here, just like this and
then fill it out with Google seat right here, make a Google set out of it, and then submit out
the Form link or the screenshots of your form and your responses collection
in the project section. So all the best for whatever
you're going to do. So I can't wait to see
what you come up with
Pratik Pradhan, Digital Artist
