Steps fo or Creat ting a G Google F Form

Stepsfo
orCreattingaG
GoogleF
Form
1. O
Open CHRO
OME to browse the in
nternet.
2. C
Create a Go
oogle accou
unt. (If you
u have a gm
mail accoun
nt, then you
u are done))
Go to website: htttps://accou
unts.google.com/SignU
Up
If yoou are not using a gm
mail addresss, then you
u will havee to verify y
your other email addrress.
3. C
Create a Fo
orm: (Checck out the demo
d
video
o: http://you
utu.be/ob8
8tt5aMXYc )
Go to Google drive
e:
n into your google account: http
ps://accountts.google.coom
OR sign
Chooose "apps" and selectt Google Drrive
Pg.1
Clicck on Creatte. Then ch
hoose Form
m from the pull down menu.
4. Y
Your next screen
s
will look like this:
Thiis is wheree you will ty
ype in the
titlle of your foorm:
Cou
uld be a su
urvey, quiz,,
info
formation g
gathering, eetc.
xt choose a theme. Y
You can
Nex
scrroll and seee all of yourr choices.
Theen select O
OK
Pg.2
5. Y
Your next screen
s
will look like this:
Thiss is where you can sta
art typing in
your question
ns. You ca
an choose frrom a varieety of
form
mats. Just select
s
the pull-down
p
menu.
m
You can
n even mak
ke the quesstion
requireed. This is a good idea
a if you
want too make surre the persoon has
entered
d their nam
me, email a
address,
or anyth
hing else y
you might w
want.
WorkshopForm
First
F
Name *required question
Last
L
Name *required question
Email
E
Addrress *requirred questio
on
1. 2 + 5 =__
____ (multtiple choice
e)
3
7
2. 5 x 6 = __
________ (text)
(
Pg.3
6. After you have created all of your questions. Your last option is how you want the
confirmation. The defaults are shown. You can personalize the message.
7. This is where you can now check to see what the actual "Live Form" looks like:
If the form needs changing, you can "Edit the form" (button) OR close this tab and just go back to
the previous tab.
Pg.4
8. Now is the time to CHECK TO SEE IF IT WORKS. Click on "View Live Form"
Submit some responses.
9. Time to see the responses. Click on "Choose response destination"
This now pops up:
Now you can "View Responses"
Pg.5
A sp
preadsheett will now open.
o
You can see alll of your da
ata. If som
mething doeesn't look rright, go
back
k and edit the form.
10. Once yourr form is fin
nal,
then you can go to File and
a select:
1. Share: Sh
hare it with
h other
colllaboraters, where the
ey can mak
ke
cha
anges
2. Send form
m: Email a link to the
e
forrm.
3E
Embed: Em
mbed the fo
orm into
you
ur website..
4. Email colllaborators.
11. When you
u have colle
ected all
of yoour respon
nses,
you
u can down
nload
this as an EXC
CEL spread
dsheet.
Clicck on FILE> Downloa
ad as>
mak
ke your cho
oice.
Pg.6
UsingScripts
WARNING! If you are planning to use Flubaroo (grading script), you must rename the "Form
Submission" sheet.
You need to rename this sheet to
Student Submissions
Formemailer: This script allows you to send an email to the form submitter either on form
submission or at any other time. It is like using Mail Merge in WORD, but much easier.
Video: http://youtu.be/xjcjYERHVnI
1. You need to find the script. On the spreadsheet (Responses), find TOOLS> Script Gallery.
Pg.7
2. Search for Formemailer: (type this in search bar)
3. Now you will need to install:
You will now get this warning: Don't worry. Just click on "Authorize"
Next screen
Scroll down and coose Accept
Next screen is: Click "Close"
Pg.8
You will now see FormEmailer in your choices
Click on this and choose "Install" and then "install" again.
Now an extra page has been added to your spreadsheet.
4. Go to "FormEmailer" and select Settings:
Pg.9
5. Y
You now se
ee this:
Unless you lik
ke html cod
de, UNCHE
ECK the bo
ox.
q
where I have ask
ked them foor their nam
me and em
mail addresss
The following is from a quiz
b
the
ese emails will be sen
nt from you
ur gmail acccount. If
The "reply to" is optionall. I use it because
t my gmaiil instead oon my schoool account. I want th
heir replies
the student just hits replly, it goes to
to goo to my sch
hool accoun
nt.
In th
he "To", th
his is where
e you can in
nsert a pla
aceholder. Chosen froom the drop
pdown men
nu.
Type the body of your em
mail, insertting placeholders (theese are valu
ues from th
he spreadsheet)
Save and Close.
Pg.10
6. Send the emails manually.
I just choose the first line (my answer key with my email) to see if I like the look of the email.
7. I check my email and see:
I now know that the settings are correct. Now I can process manually and send email to all
those that submitted a response.
Pg.11
8. Set up AUTOMATIC EMAIL. Go to Tools> Script editor.
A new screen opens:
Click on Resources>Current Triggers
Add new trigger
Pg.12
Chooose the opttions show
wn.Then SA
AVE
Now
w go to File
e menu and
d SAVE aga
ain.
Closse tab.
Testt it out.
Flub
baroo: Thiis script alllows you grrade a quizz and then send the rresults to y
your studen
nts.
Cheeck out theiir web page
e: http://w
www.flubaro
oo.com/flub
baroo-userr-guide
Go tthrough the same ste
eps to find and
a installl the scriptt.
1. Find
d TOOLS> Script Galllery
2. Search for Flub
baroo.
3. Now you will need to insttall:
4. Just click
g screen.
c
on "A
Authorize" when
w
you get
g warning
5. You will
w now see Flubaroo
o in your ch
hoices
6. G
Grading the assignme
ent.
ke your cho
oices from the
t
Mak
pulll down men
nus.
Pg.13
Select which submission
is the answer key.
Grading is completed: You will now see the scores.
7. Emailing the grades to the students.
Check out this video about Flubaroo:
http://youtu.be/QJ60szcUbBE
Pg.14