Populate data using a Google Form
1. Populate data using a Google Form
Welcome to Module 4: Populate data using a Google Form. Google Forms are online surveys used to collect data and provide the opportunity for quick data analysis. Google Forms allow multiple question types, apply branching logic, as well as the options to embed YouTube videos and images. In this module, we're going to explore how forms and sheets work together by connecting collected form data to a spreadsheet, or by creating a form from an existing spreadsheet. To create a Google Form that connects a Google Sheets spreadsheet, open an existing spreadsheet, open the Tools menu, and click "Create a form." A Google Form will open in a new browser tab. The form will have the same name as the spreadsheet from where it was created, but it can be changed by clicking on the name and typing the new name. Google Forms supports many different question types. For text based answers, there are the short answer and paragraph question types. For choice based questions, there are multiple choice, dropdown, and checkbox question types. To accept a file as an answer, there is the file upload question type. For answers that are in a range, or for multiple answers to a single question, there are the linear scale, multiple choice grid, and checkbox grid question types. And lastly, there are the date and time question types. Every new form starts with a blank multiple choice question. To change the question type, click the dropdown and select another option. To add a new question to the form, click the "Add question" button from the floating toolbar to the left of the question card. To duplicate a question, click the "Duplicate" button on the question card. The question and any provided answers will be copied to a new question. To import questions from another Google Form in Google Drive, Click "Import questions" from the floating toolbar to the right of the question card, browse to the form that has the question or questions to import, and click "Select." Click "Select all" to import all of the questions in the form, or click the checkbox next to each question to import. Finally, click "Import questions" to add them to the form. If you want to customize the form for an event or an audience, you can change the theme and/or the font of the form. To change the theme, click the "Customize theme" button. The theme options panel will open on the right side of the page. To add a header image, click the "Choose image" button. Browse the headers provided by Google, upload an image from your device, or browse your Google Photos. Once an image has been selected, click "Insert" to add it to the form. The header will appear above the title of the form. Google Forms will automatically change the theme and background to complimentary colors based on the header image. Change the theme color by clicking on one of the options, or clicking the "Add custom color" button to choose a color visually or by hex number. Each theme has background color options to choose from. Click the background color to apply it. There are four font types to choose from: Basic, Decorative, Formal, and Playful. Click the dropdown to select a font other than Basic, which is the default font. To see the form as the respondents will see it, click the "Preview" button. This will open the form in a new browser tab.2. Let's practice!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.