To access the old site click here! X

  • Course
  • Vendor

This course will cover all aspects of creating and using Google Forms. We will show you how to create forms, apply templates, share forms, embed forms and display form results. We will then look at how forms interact with Google spreadsheets.

  • Course Start Date: 2019-02-28
  • Time: 09:00:00 - 16:00:00
  • Duration:
  • Location: Edmonton
  • Delivery Methods(s): Instructor Led
$100.00
February 28th
2 seats left!
or make an offer

Course Outline

Lessons

This course will cover all aspects of creating and using Google Forms. We will show you how to create forms, apply templates, share forms, embed forms and display form results. We will then look at how forms interact with Google spreadsheets. We will conclude with a show-and-tell of some spreadsheet techniques from Google Spreadsheets Advanced to get the most out of form data. Such techniques include parsing strings of data from checklist questions, auto-summarizing data, re-arranging or displaying only portions of data, and creating summary cells that will auto-email you when certain circumstances occur with your collected data.

Why Google Forms?

Are you currently using a spreadsheet to track information sent to you by other people? How are you inputting this information into your spreadsheet? Do they email it you and you copy-paste? Thats a lot of redundant work. Do you have people enter the info themselves into a shared spreadsheet? This is a real issue because people can easily mess up your spreadsheet or misenter the information. Solution: Google Forms. You can create custom forms with all different types of data entry: text, multiple choice, drop-down menu, checkboxes, scale, grid. The form can be embedded into an email, embedded into a webpage, or simply sent to people as a link. When a form is filled out the data can be automatically entered into a spreadsheet. The time savings are instant and everyone is happier!

Basic Question Types
  • Text
  • Paragraph text
  • Multiple Choice
  • Checkboxes
  • Choose from a List
Adding, Duplicating and Deleting Questions
Re-ordering Questions and selections within Questions
Confirmation Message

  • Settings within confirmation page.
Domain Settings
Send / Post the Form

  • Send Via Email Using the Send Form window
  • The Link to Share
  • Embed a Form into a Webpage
Form Responses
  • Viewing the Summary of Responses
  • Choosing the Form Response Destination
Pre-populate form responses
Creating a Complex Form
Advanced Question Types

  • Scale
  • Grid
  • Date
  • Time
Other Items
  • Section Headers
  • Page Breaks
  • Images
Non-linear Forms
  • Go to page based on answer
Data Validation
Creating a Form from a Spreadsheet
Tips on Manipulating Data in a Google Spreadsheet
  • Considerations when creating forms
  • Analyzing data in Google Spreadsheet
Applications of Forms with Google Apps Scripts

Cancellation Policy

10 business days cancellation or full course fee will be charged

Training Location

TTC, B-11 Cameron Library
11320-89 Avenue, University of Alberta

Edmonton, Alberta
Canada   

About Technology Training Centre

x

Technology Training Centre is THE place for computer software training in Alberta.
This is where you come to learn how to get more from the computer or the mobile device in front of you.
Register for courses on Microsoft Office and the Adobe Creative Suite along with customized one on one or group training.
Come to the heart of the University of Alberta campus to learn from our instructors. These highly skilled professionals will also travel across the province to deliver exceptional training for you and your company.
We have your MS Office needs covered, including training on upgrading to a newer version of the software. We offer courses in Microsoft Word, Excel, PowerPoint, Access, SharePoint, Publisher, SQL, Visio, Project, Outlook, OneNote, and InfoPath.
Our graphic designers will train you in Adobe Photoshop, InDesign, Illustrator, Dreamweaver, Acrobat, Lightroom, and Visual Design. If you need training for your digital camera, we’ll provide that as well.

You will also receive:
•    6 months of email support on courses.
•    The option to retake courses within 6 months at no additional charge.
•    Training from instructors that use each of the software packages they teach and have the ability to go beyond what is covered in the outline.
 

Training Provider Rating

This vendor has an overall average rating of 4.38 out of 5 based on 195 reviews.

The course was excellent, the instructor Rachel was great.
No comment
No comment
Was a very informative course.
No comment
My payments were taken care of by last minute training with the University of Alberta. The teacher was good, the content was good.
I already completed a survey at the end of the course so not sure why I have to complete another survey on line? LOL
No comment
No comment
No comment
The information learned in this course will assist me in my current role. Enjoyed the class.
No comment
I would have preferred using the manual given to follow, so I could add my notes to each area as we worked through the course. Unf ... Read more
x

I would have preferred using the manual given to follow, so I could add my notes to each area as we worked through the course. Unfortunately all my notes are in the beginning of the book as we, only looked it once, when a student asked what page we were on.

No comment
More useful contents can be fit in and taught in this class definitely.
No comment
Worthwhile training that provided me with the skills needed to use Onenote.
No comment
No comment
I had a lot of knowledge on the course I took but I still learned a few new things which is really nice to come out of a course le ... Read more
x

I had a lot of knowledge on the course I took but I still learned a few new things which is really nice to come out of a course learning something. Thanks for the informative day. Doreen

Course Reviews

No Reviews Yet

More Courses from Technology Training Centre

TECHNOLOGY TRAINING CENTRE
2019-01-08
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-02-21
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-01-25
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-01-15
Edmonton

More Courses in 'Internet Marketing Training' Category

TECHNOLOGY TRAINING CENTRE
2019-02-28
Edmonton
TECHNOLOGY TRAINING CENTRE
2019-02-28
Edmonton