The summary of ‘Creating a Google Forms Survey’

The YouTube video tutorial covers various aspects of creating and analyzing surveys using Google Forms. The content creator emphasizes the advantages of Google Forms and provides a step-by-step guide for setting up surveys, including making them anonymous for honest responses. Handling diverse responses, distinguishing between scale and categorical variables, using Likert scales, and reverse coding for accurate measurement of engagement levels are key points discussed. The importance of clear numeric ranges, utilizing multiple choice grids, and properly categorizing survey items are also highlighted. Additionally, the tutorial touches on survey sharing methods and the use of Excel for reverse coding.

00:00:00

In this segment of the video, the content creator explains how to create a Google Forms survey. They highlight the advantages of using Google Forms over other survey platforms like Survey Monkey, Qualtrics, or Microsoft Forms. The process involves logging into a Google account, creating a new survey, adding a title and description, and structuring questions using various question types such as multiple-choice. Emphasis is placed on making the survey anonymous to encourage honest responses, especially for sensitive topics. The tutorial covers basic steps for setting up and customizing the survey form.

00:03:00

In this segment of the video, the speaker discusses the importance of handling diverse responses in survey data analysis. They suggest using an “other” option to prevent a cluttered presentation of data in graphs like bar charts or pie charts. The speaker also talks about using numeric scale variables in surveys, emphasizing the need for clear numeric ranges like 1 to 10 for linear scales. For variables with varied responses that can’t be categorized into fixed numerical ranges, the speaker recommends using short answer options for participants to input their responses.

00:06:00

In this segment of the video, the speaker discusses the difference between scale and categorical variables in data analysis. Scale variables involve averaging numerical responses, such as ratings on a scale of 1 to 10, while categorical variables include non-numeric data like gender or college major. The example of age is given, where organizing it into categories makes it categorical and keeping it as individual numbers makes it a scale variable. The speaker also mentions the use of multiple choice grids for organizing responses to statements or questions on the same concept.

00:09:00

In this part of the video, the speaker explains how to use Likert scales in research. They recommend using numbers (1 to 5) instead of words for easier data analysis. Likert scales are treated as ordinal variables but can be considered scale variables by assuming equal intervals between each number category. Researchers typically take the average when multiple statements share a similar concept.

00:12:00

In this segment of the video, the speaker discusses the importance of properly categorizing survey items related to student engagement. They mention the concept of reverse-coded items, exemplified by the statement “I hate going to class” which contrasts with other positively-worded statements. To address this, they recommend reversing the scoring for such items to ensure accurate measurement of engagement levels. By reversing the coding for these items before averaging responses, researchers can prevent falsely lower scores for highly engaged individuals. This adjustment involves assigning a value of 1 for the reverse-coded item, 2-5 for the others, enabling a fair representation of engagement levels in the final analysis.

00:15:00

In this segment of the video, the speaker discusses reverse coding in surveys. They explain how to reverse code responses by subtracting the original number from a set value. They demonstrate the process with examples and mention the importance of recognizing which items may need to be reverse coded. The speaker also briefly mentions using Excel for reverse coding and offers to show the process in another video. Additionally, they explain how to preview and share surveys, including sending them via email or posting them on social media or discussion boards for data collection purposes.