Google Forms

Tips, Tricks, and How-to

CTAHR Distance Education

5/27/14

Agenda

● Google Drive

● Create a Google Form

● Google Form Settings

● Collaborating on a Google Form

● Permission Settings

● Questions

● Branching Questions

● Sending out the Form

● Viewing and Exporting Results

Google Drive

● Access to Google Drive is included in your

UH email

1. Click

here

2. Click

Drive

Google Drive

● Cloud based version of MS Office

○ Document (MS Word)

○ Spreadsheet (MS Excel)

○ Presentation (MS PowerPoint)

○ Forms

○ Drawing

● Simple formatting

● Allows for collaboration

Create a Google Form

3. Click Create

4. Click Form

Creating a Google Form

5. Name your

form

6. Pick a theme

Creating a Google Form

7. Add instructions on how to complete

your form. Give an estimate on how

long it will take

Creating a Google Form

8. Add a personalized closing

message

Google Form Settings

This can be helpful if

you want to restrict

you sample to UH

members

While useful to keep

track of participants,

would not maintain a

random sample

Important to enable,

particularly with long

surveys

Adding Collaborators

You can add

unlimited number of

collaborators as long

as they have a

Google Account (UH

and non UH)

● Go to File - Add

collaborators

Adding Collaborators

You can also change

the permission

settings

You can add

collaborators by

email address

Adding Collaborators

Can also share by sending this link in

an email, but permission setting need

to be “Anyone with the Link” or “People

at the University of Hawaii with the link”

Change

permission

settings here

Permission Settings

Not

recommended

Recommended

for sharing with

non UH

collaborators

Recommended

for sharing with

UH collaborators

Questions

Edit

Question

Duplicate

Question

Delete

Question

Adds same

question

type

Add different question type,

image, video, section header,

page break

Change question

type

Question Types

● Text

● Paragraph Text

● Multiple Choice

● Checkboxes (ex. check all that apply)

● Choose from a list (ex. drop down menu)

● Scale (ex. Likert questions)

● Grid (ex. schedule)

● Date (ex. birthday)

● Time (ex. duration)

Questions

Ask your question

Give examples, or

formatting

instructions

“Other” allows participants

to fill in their own answer

Handy feature to

ensure that all

questions are

answered

Branching Questions

● Helps to focus the questions that are asked

to participants

● Reduce N/A responses

● Start with either a Multiple Choice or

Choose from List Question

Undergraduate

Students

Questions

Branching Questions

General

Questions

Set 1

Student

Questions

Graduate

Students

Questions

Faculty/Staff

Questions

Community

Questions

General

Questions

Set 2

Note: Start each

section with a page

break and a section

name.

Note: Create the

sections before

“linking” the

branches

Branching Questions

1. Start with a

multiple

choice or

choose from

list question

2. Check

this box

3. For each option,

choose where you want

the responder to go next

Branching Question

Return from Branching

Adjust

navigation at

the end of a

page

Previewing Your Form

Accepting/Not Accepting Results

● When you are done collecting data, you can

“turn off” the form by pressing a button!

You can edit

this text!

Sending out the Form

● Send via url link

○ Go to File - Send Form - Copy and paste link into an email

message

○ Use a websites like TinyURL and Bitly to shorten the link

● Send via email

○ Go to File - Send Form - Add email addresses

● Embed form in an email or website

○ Go to File - Embed

○ Need to use html. Not available in UH email

View and Export Results

● Open your Google Form (creator view, not

form view)

● Click “View responses” button at top

○ You may need to specify a location for your results

first

View and Export Results

Pie Charts are used for “Choose from a

List” and “Multiple Choice” questions.

Otherwise, a different chart type, such as a

bar graph, may be used.

Exporting Results

● Sometimes the response summary is not

sufficient for your needs

● Exporting your Data allows flexibility with

your data to display it the way you want to

Exporting Results

There are many data export

options to choose from

Exporting Results

Any Questions?

● Google Drive

● Create a Google Form

● Google Form Settings

● Collaborating on a Google Form

● Permission Settings

● Questions

● Branching Questions

● Sending out the Form

● Viewing and Exporting Results