Summary
Highlights
This section introduces Google Forms as a simple, free tool for gathering data, emphasizing its ability to link with spreadsheets for analysis and insights. It outlines the core process: create, send, fill, store, and analyze. The video sets the stage for a practical case study involving a company training program for Google apps.
Learn how to access Google Forms by searching 'forms new'. The interface is explained, highlighting tabs for questions, responses, and settings. The video demonstrates how to name a form, add a description, organize it into folders, star it for favorites, and customize the theme by changing fonts, adding header images, and adjusting background colors. It also emphasizes the utility of pre-built templates to save time.
This segment delves into various question types. It starts with 'Short Answer' and 'Paragraph' for basic information gathering (e.g., employee ID, designation). It then introduces 'Multiple-choice Grid' and 'Checkbox Grid' to assess familiarity with Google apps, explaining the difference in allowing single vs. multiple selections per row. The 'Preview' function is used to show how respondents will see the form, alongside an important note about unpublished forms not accepting responses.
The video continues exploring question types, including 'Multiple Choice' and 'Dropdown' for single-selection questions. Key form management features are introduced: duplicating questions, deleting questions, marking questions as 'Required' or 'Optional', and adding 'Descriptions' to provide context for respondents. The importance of these features for clear and effective data collection is highlighted.
This section explains how to add new sections to organize your form into logical parts, using an example of scheduling training sessions. It demonstrates how to add 'Date' and 'Time' question types, showcasing their respective calendar and clock widgets. The 'Linear Scale' question type is also introduced for rating or likelihood assessments, with customization options for the scale range.
A powerful feature, 'Go to section based on answer', is presented. This allows for dynamic form flow where respondents are directed to different sections based on their answers, effectively filtering out irrelevant participants (e.g., those who don't use computers). The mechanism for moving sections within the form is also shown.
The process of publishing a form is detailed, including sharing options: inviting specific individuals via email (as responders or editors) or sharing a link for broader access. Important settings like controlling file permissions and download/print/copy options for viewers are discussed. The video then demonstrates how to view captured responses in 'Summary', 'Question', and 'Individual' views, highlighting the automated charts for quick insights. It also shows how to link responses to a Google Sheet for comprehensive data organization.
This part covers advanced settings under the 'Responses' and 'Presentation' tabs. It explains options for collecting email addresses (verified vs. responder input), sending respondents a copy of their answers, allowing response editing, and limiting responses to one per person. Under 'Presentation', features like 'Show progress bar' and 'Confirmation message' customization are discussed. 'Defaults' for future forms and questions, such as making all questions required by default, are also covered.
The video explores various tools available through the three-dot hamburger menu: making a copy, moving to trash, embedding HTML, printing (or saving as PDF), and using 'Apps Script' for automation. 'Add-ons' for extending functionality are introduced, along with a note on Google Workspace Marketplace. Keyboard shortcuts are also highlighted for efficiency. The section transitions to creating a quiz.
This segment focuses on leveraging Google Forms for quizzes. It demonstrates how to add questions based on images (e.g., identifying a Google app icon) and embed YouTube videos, followed by relevant questions (e.g., rating the video with 'Rating' question type). The difference between 'Linear Scale' and 'Rating' is clarified. The ability to import questions from other Google Forms and reorder questions/sections is also shown, showcasing the flexibility of the platform.
The masterclass concludes with an advanced, yet practical, trick: using 'Prefill form'. This feature allows creators to pre-populate certain fields in a form, saving respondents time and reducing input errors. The video demonstrates a step-by-step process of getting a pre-fill link from the form, using it within a Google Sheet with a SUBSTITUTE formula to dynamically insert data (like employee IDs), and generating customized pre-filled links for each respondent.