Google Forms Tutorial
Part 1:
How to Create Online Survey using
Google Forms
Jan 2018
About Google Forms
• Google Forms, another product from Google, is an app to create web based forms and collect
answers online.
• As a platform, Google Forms can be used for practically any data gathering purpose. It is
popular to use Google Forms to develop online questionnaire and to conduct surveys. Google
Forms is useful for students doing school projects as well as professionals for company
projects.
• Google Forms has quiz feature that enable question scoring. This feature can transform
questionnaire into learning/educational tool that can be very useful for teachers or trainers
for example to administer quiz/test to their students or course participants through their
devices (smartphone, tablet or laptop).
• Google Forms is Free.
• This tutorial is for Google Forms to create online survey. Google Forms for quiz is in part 2 of
this tutorial.
2
Example of
Google Forms
Questionnaire
3
Interest to Buy a New Smartphone
• This tutorial contains an example of Google Forms questionnaire, where the objective is to
understand consumer interest to buy a new smartphone
• In the questionnaire, we want to show picture of the phone and its specification
• As background to the finding, we want to understand brand awareness, brand image and
ownership.
• Final questionnaire will be shown first along with description for each question, then
followed by how to make the questionnaire.
4
Questionnaire (1)
Title
Title Description Question Type : Checkbox
Respondent can select more than
1 answers
Question
Description can be as long
Question Description as necessary
Question Type : Short Answer
Question Type : Paragraph
5
Questionnaire (2)
Question Type : Checkbox grid
Respondent can select more than 1 answers for each row
Question Type : Checkbox
Respondent can select more than 1
answers
In “Other” respondent to type in
other answer not listed in options
Google Forms will take care of display
6
Questionnaire (3)
Question Type : Paragraph
Question Type : Multiple Choice Respondent can type in their
Respondent can only select 1 answer answer as long as necessary
Question Type : Short Answer
Short answer can accept numeric in addition to text
Can apply validation so only numbers meeting
criteria accepted
Question Type : Short answer
7
Questionnaire (4)
Question Type : Multiple Choice Grid
Respondent can only select 1 answer for each row
Add Image
Credit : GSM Arena
8
Questionnaire (5)
Add Table saved as Image
Question Type : Linear Scale
Respondent to select a number
In this question we created question
jump (not seen in the questionnaire).
Those answering Interested/Very will go
to certain section while Not Interested/At
all go to another section
Credit : GSM Arena
Will not able to move to next
section if any required answer
question (with * asterisk) is empty
9
Questionnaire (6)
This is the section for respondents This is the section for respondents
answering interested/very interested answering not interested/not at all
Question Type : Paragraph Question Type : Paragraph
Question Type : Multiple Choice Question Type : Multiple Choice
Meaning that respondent can only Meaning that respondent can only
select 1 answer select 1 answer
Will go to next assigned section, in this Will go to next assigned section, here the
case “About You” same “About You”
10
Questionnaire (7)
This is the last section “About You”
To submit data
Will not able to submit data if required
answer question (with * asterisk) is
empty.
11
Google Forms
Questionnaire
Development
12
Open New Form
• Sign up or Sign in to your Google account
• Go to docs.google.com/forms or to your Gdrive click New> More > Google Forms
• In the top left, click the plus button +.
• A new form will automatically open
13
Menu List in Form Set questionnaire color
palette here.
Can have background
image
• This is after you click the + button Preview the
Questionnaire Setting
Select Responses tab if Add on
want to view summary
Questions tab where you
result of entered
develop questionnaire
responses
Type Form Title here More menu
To send the form
(less often
used)
Select Question type on dropdown
menu here. The default is Multiple + button to add new
Type Form Description choice. question
here
Type in Question here To add title and
description
Type in first option answer To add image
here
To add video
Type in second option
To add section
answer here
To duplicate
Additional option answer
question Whether
automatically shows up Other relevant menu
To delete
below answer is
question such as inserting
required for
question description,
the question
shuffling order or data
validation
14
Developing Questionnaire (1)
Background changed to image
Form Title
Added
You can add Form
Description here
Title Added How to add space for
Question Description
Title Description
Added
Title Added
Question Added
Click here to Add Title
and Description
Select what type of question the
question is in dropdown menu. In this
case “Short Answer”
Slide to the right to make
answer for the question
required
15
Developing Questionnaire (2)
Select type of question “Paragraph”
Question Description
Added
• Paragraph : For answers in long
sentence or series of words
• Short answer : For short text or
number
16
Developing Questionnaire (3)
• Checkboxes : Respondents are allowed to
give one or more than one answers
Option answers added, no limit on
how many but may need to keep
it simple
Type here to add
option answer
The question is required meaning that
Click here so that space for “Other” respondent has to answer the question, can
answer is provided, so that respondent not be empty, otherwise data can not be
can write their own answer submitted (or move to next section)
17
Developing Questionnaire (4)
• Checkbox grid : Respondents are allowed to give more
than one answers for each row.
•In our case we want to know what images are
If the question is designed as “Checkbox associated with each brand.
Grid”, you’ll have rows and columns to fill
Questionnaire preview
Check this to shuffle the row order, so
different respondent will see different row
order in their questionnaire
18
Developing Questionnaire (5)
• “Checkboxes” : Respondents are
allowed to give one or more than
one answers
• In addition to text, option answers
can use texts + images.
“Other” answer is provided, so that
respondent can write their own answer
19
Developing Questionnaire (6)
• “Multiple choice” means
respondents can only select one
answer.
• In addition to text, options can use
texts + images.
20
Developing Questionnaire (7)
Validation type for
Number input
• “Short Answer” question type
accepts text and/or numeric data
input.
Validation input applied, only accept number
input between 100 and 1000. Input outside
criteria will not be accepted.
21
Developing Questionnaire (8)
• “Multiple Choice Grid” means in each row respondents can only
select one answer.
• Often used for rating using ordinal scaling (for example liking
If the question is designed as “Multiple Choice You can add image scale from dislike strongly to like strongly)
Grid”, you’ll have rows and columns to fill after the question • In our case we want to the evaluation of product attributes.
These dots are
holder so you can
move the question
anywhere in the
questionnaire
Questionnaire preview
On this menu you can find menu to shuffle the row
We want every row has response, no missing data order, so different respondent will see different row
order in their questionnaire
22
Developing Questionnaire (9)
This time we want to show image only, separate Click to add image Add Hover
from question. Useful to give illustration. Add Image Title Text
Add Image
Title
Add Hover
Text Menu to position the
image
The table is saved as image
To position the
image
23
Developing Questionnaire (10)
In “Linear Scale” respondent is to choose a number. Usually it is a question on evaluation about something represented by a number. Select
range of values (lowest 1 and highest is 10) with corresponding labels for lowest and highest number.
Questionnaire preview
24
Developing Questionnaire (11)
When you start developing questionnaire, a section is
automatically created.
Section is important in two ways :
1. The display in device screen is by page, one page
for a section. A section can contain all questions in
the questionnaire or just one question or one
title. Some project owners prefer to show
questionnaire in one page that to go to next
question you do that by scrolling, others prefer
one question at a time, have it answered and
Click to add section proceed to next. In this case section needs to be
created for each question.
2. Skip jump / Question jump in Google Forms is
Added section
based on section, that from a question you go to
certain section and not question. Since when you
create question from where the branch emanates,
the section where it go to does not yet available,
first we need to develop all questions, create
sections, then go back to the branching question
At the moment skip jump can to create skip jump.
not be used because we
haven’t created go to sections
An example diagram showing skip jump
Interested to buy?
Yes No
Reasons yes ?
Reasons no ?
Demography
25
Developing Questionnaire (12)
Section Added, the previous become
Section Added
section 2 of 3
Section Title Section Title
Question Added Question Added
Question Added Question Added
To add section To add section
26
Developing Questionnaire (13)
Section Added
Section Title
Question Added Now that we have completed creating
all questions and their sections we can
go back to branching question to
define skip jump.
Question Added
Question Added
Question and Description Added
Question Added
Title Added
27
Developing Questionnaire (14)
Now all created sections are shown, each answer can be
assigned which section to go to
After this section is
completed go to section
4 (“About you”)
After this section is
completed go to section
4 (“About you”)
Total 4 sections in the questionnaire
28
Send Out
Questionnaire
29
Settings (1)
Before Sending Out Questionnaire
This window pops up after clicking the setting button
If this box is checked, Google
Forms will automatically add a
question in the questionnaire
asking for respondent’s email
When checked, respondent will
receive a copy of their responses
When checked it limits to 1
response but requires sign in to
respondent’s Google account.
Links after submission to edit
previous answers and to see
summary chart and text
responses
30
Settings (2)
Before Sending Out Questionnaire
Showing current page of total
page
Shuffle question order
Show link to submit another
response. Useful for team of
interviewers carrying interview
device to interview respondents
Confirmation message after data
submission
31
Settings (3)
Before Sending Out Questionnaire
Slide right to make
questionnaire a quiz
Respondent can view score in
the submitted form
Respondent can have the
score in their email after
review by reviewer, which can
then follow up by viewing
score in the submitted form
Options that respondent can
view in the submitted form
32
Send Form (1)
This window pops up after clicking the setting button
If this box is checked, Google
Forms will add a question asking
their email in questionnaire
distributed to respondents
Email address respondent
Form in email body
33
Send Form (2)
Link for the form
To copy the link
34
Send Form (3)
Share in social
HTML code
media
To copy the code
35
Summary
Data
36
Summary Data (1) Example : Data from 3 Respondents
“Responses” can mean number of respondents if a respondent sends
one response only. Your form record number of
Switch to Responses tab to get respondents in real time
summary and individual data.
To Questions tab Click for more menu (eg. to
print responses, delete
responses)
Summary Responses from all Switch to this tab for Individual
respondents respondent data
Download responses in
spreadsheet (Google Sheet)
In our case 3 responses = 3 respondents because each respondent
“Short Answer” result, each line sends one response only
in answer for each respondent
37
Summary Data (2)
“Checkbox Grid” result
“Paragraph” result, each line for each respondent
Number of Scroll for more complete charts
respondents
“Checkbox” result
“Checkbox” result
In parentheses is percent
Number of
number of respondents with
respondents
that answer compared to
total respondents
38
Summary Data (3)
“Multiple Choice” result
“Paragraph” result, each line for each respondent
“Short Answer” numeric result
“Short Answer” result, each line
in answer for each respondent
39
Summary Data (4)
“Short Answer” result, all 3
respondents answered “none”
“Multiple Choice Grid”
result
Linear scale result 1-9
Scroll for more complete charts
“Paragraph result”, each line for each respondent “Multiple Choice result”
Summary Data (5)
Number of respondents Number of respondents
Paragraph result from 1 respondent
Paragraph result, each line for each respondent
“Multiple Choice” result “Multiple Choice” result
41
Summary Data (6)
“Short Answer” results, each line in
answer for each respondent
“Multiple Choice” result
42
Individual Data
In Individual tab, we can see the answer for each question from each individual Selection made by
respondent 1 for
question A2
We are now looking at
data from respondent 1
out of 3
Selection made by
respondent 1 for the
question A3
Respondent 1 answer for
question A1a
Respondent 1 answer for
question A1b
43
Survey Data in
Spreadsheet
44
Survey Spreadsheet (1)
Click this link to
view responses in
spreadsheet
45
Survey Spreadsheet (2) Survey Data downloaded in
spreadsheet (Google Sheet)
46
Thank You
MaxiResearch
PT. Mulia Karya Inovasi
Office 8, Level 18-A
Jl. Jend Sudirman Kav. 52-53 SCBD
Jakarta Selatan 12910
Indonesia
www.maxiresearch.com
ask@maxiresearch.com
47