top of page

Google Forms with Data Collection Fundamentals

DURATION: 2 hours 

Prerequisites

This course requires Basic knowledge in Spreadsheets. Knowledge in basic Logical and Lookup Functions are recommended.

Course Description 

Course Description 

This Virtual Class course on Google Sheets is intended for participants who has basic knowledge in spreadsheets and want to discover more innovative ways on data collection from Google Forms. One of the essential activities in business is data gathering or collection. In this course, you will discover a modern and accessible way of collecting data thru online forms using Google platform. Since everyone has an access on the internet now a days, it will be easier to acquire information from them via web with regards to surveys, evaluations, taking orders, registration, and a lot more.

Course Objectives

 At the end of this course, the participant should be able to:      

                             

  1. Create and modify forms for both Microsoft and Google

  2. Learn different tricks to easily gather data from Forms

Course Content

Lesson 1:  Introduction to forms

  • Intro to Google Forms

  • Designing Forms

  • Linking Forms
     

Lesson 2:  discovering form features

  • Utilize Option features

  • Creating Surveys, Registrations and Orders
     

Lesson 3: data collection

  • Extraction of Data collected from Forms

  • Organize Data Gathered

  • Summarize using Pivot table basics

Who Should Join

Experienced users who want to maximize their learning and finding innovative ways to gather data. This also targets people who rely on MS Excel to do data entry and want to discover a faster and reliable way to collect data in a more accessible and compact way.

bottom of page