GOOGLE Forms
Creating & Using Google Questionnaires
3 weeks: Day: Tuesdays
Dates: Nov 15, Nov 22, Nov 29
Time: 4:00pm - 6:30pm at the Career Center
We will Create Questionnaires using Google Forms. Using Forms significantly reduces your work-load. Learning to be efficient is fun and empowering. We are going to dedicate this class to using Google's tools to collect data, eliminate data entry, and generate visual reports with graphs. I will teach you how to setup your form to email you alerts as questionnaires are being filled in. You will be introduced to the growing options of "Ad-Ons" to create Thank-You Letters, Certificates of Completion, Inventory Reports and Form Receipts. This is a great tool for Teachers, Parents, Business Owners and Non-Profit groups that need to learn to do more in less time.
Users should have a G-Mail account, be familiar with eMail, Word Processing, and Spreadsheets concepts. Many of you may know it is possible, and now you can learn to create these information gathering tools.
No software is required to be purchased, you can can bring your own laptops, tablets and phones to class or a desktop will be provided. If you have questions or would like help setting up a G-Mail account please call JilMac 802-254-8628 before class.
Forms are extremely versatile. The uses of forms and form add-ons grows every week. You can apply forms to an ever growing applications, as you learn to do more - you learn you can do more!
Forms can be used for a variety of things:
1. To gather data
2. To enter Inventory
3. To give a Test
4. To create a Training Tutorial
5. Allow only specific email addresses to enter data
7. Be copied from year to year
Forms can Include:
1. Images
2. Videos
3. Verifications for email or website addresses
4. Restrict only one entry per computer or email address
5. Radio Buttons so only 1 selection can be made
6. Check Boxes so multiple selections can be made
7. Pull down selections
8. Ranges and Grids
During or After the Data is collected you can have the Google Sheet (similar to a Spreadsheet)
1. Alert you that Data has been entered
2. Allow a user to review and change their selections
3. Display a Thank you page
Forms can be expanded or added onto:
1. Generate a Confirmation email or Certificate
2. Show a different page depending on a previous answer
Data from a form can be saved indefinitely and can be used for as long as you would like
Similar products such as: Survey Monkey have restrictions as to how many entries or how long data is saved.
What you can't do (yet)
1. Modify the data and expect the reports to update
2. You can not combine data from different forms and expect the reports to update.
ASSIGNMENTS
Session 1:
Create a NEW Form
Add Questions
Add Images
Add Thank you page
View Data
View Reports
Understand different types of questions - display different graphs
Designing Questionnaires to display reports that are meaningful
Distribute your Questionnaire
Set up eMail alerts that Questionnaires have been filled out
Assignment 1:
Create 3 questionnaire that utilize each type of question
Copy & Paste a Report into a Document
Copy a Questionnaire and modify the copy
Forms can be done in several ways.
The 1st is an attached document that the visitor to your site can print and mail in.
Click Insert > Documents > Select the Document you want linkable
Note: the Document that you are putting on the web site has to be SHARE > Public on the Web
1. You can just add the LINK (you get this from your Documents-Share-Link to Share)
https://docs.google.com/open?id=0B_nsZH_N7X9mQW9tYWltaHN2MDQ This is a PDF document.
2. It can be displayed - IF - it has been saved as a GOOGLE DOCUMENT
four new (Fall 2013) features to create your perfect form: progress bars, data validation, embedded YouTube videos, and custom messages.
http://googledrive.blogspot.com/2013/09/four-new-ways-to-customize-your-google.html
Great instructions "Using Google Forms" from Eric Curts - ericcurts@gmail.com - www.ericcurts.com
https://docs.google.com/document/d/15i1AamaA_47cI-9Wc9Rw_A-Tr7h6yM0lp-xofJImgzI/edit
The 2nd - is an interactive form that you have the visitor to your site enter on-Line
Go to Google Docs/Drive
Create a NEW Document > Select FORM > enter the Form Information
Edit the page at the location you want the Electronic Form to display
Click Insert > Spreadsheet Form > Select the form
How to create a Google FORM that updates a Google SPREADSHEET
Forms: http://docs.google.com/support/bin/topic.py?hl=en&topic=15166
Creating a Form: http://docs.google.com/support/bin/answer.py?hl=en&answer=87809&topic=15166
Spreadsheets: http://docs.google.com/support/bin/topic.py?topic=15115
Validation: http://docs.google.com/support/bin/answer.py?hl=en&answer=186103
Google Forms Advanced Tutorials
Google HELP General Form Overview (3.5 min) https://www.youtube.com/watch?v=xEY10Ub-k-U&feature=youtu.be
Google for Teachers & Students (15min) https://www.youtube.com/watch?v=oP7fx0dmrx4&feature=youtu.be
DotToTech (13 min) Distribute Demo https://www.youtube.com/watch?v=xEY10Ub-k-U&feature=youtu.be
Lodge Status
GOOGLE HANGOUTS vs. YouTube LIVESTREAM
How to Use Google Hangouts - NEW 2016 Tutorial https://www.youtube.com/watch?v=DPZb3D0500I