Theory
Where did the survey data come from?
In the Sheets lessons, Priya's team analysed 200 survey responses. But where did those responses come from? Nobody typed them in by hand.
They came from Google Forms: an online questionnaire the team built and shared, into which classmates typed their answers, and every response landed automatically in a spreadsheet.
This closes the project loop: Forms collects the data that Sheets analyses and Slides presents. This lesson builds the form itself, choosing question types that shape the data you get back. Ask the right kind of question, and clean data flows in with zero manual entry.
Theory
A self-filing questionnaire
A paper survey means collecting sheets, then typing every answer into a computer, slow and error-prone. A Google Form is a self-filing questionnaire: each person answers online, and the response files itself into a neat spreadsheet row, no typing, no lost sheets, no mis-keyed data. The form is not just the questions; it is an automated data-collection pipeline feeding straight into Sheets.
At a glance
Question types and the data they give
| Type | Respondent picks | Good for |
|---|---|---|
| Multiple choice | ONE option | Single-answer questions |
| Checkboxes | MANY options | 'Select all that apply' |
| Short answer / Paragraph | Types text | Names, opinions |
| Dropdown / Linear scale | One from a list / a rating | Long lists, 1-5 ratings |
Theory
Build the form
Open a Form (from Drive), give it a title and description, then add question blocks:
- Multiple choice: respondent picks one (e.g. 'Which year are you in?').
- Checkboxes: pick many ('Which apps do you use?').
- Short answer / Paragraph: free text.
- Dropdown: one choice from a long list. Linear scale: a rating (1 to 5). Date, File upload too.
Mark key questions Required so submissions are complete. Reorder and duplicate questions easily.
The question type shapes the data: multiple choice gives clean single answers to count; free text gives varied opinions to read. Choose types with the analysis in mind.
Quiz
Priya wants respondents to select ALL the Google apps they use (they may use several). Which question type fits?
- Checkboxes, which allow selecting multiple options
- Multiple choice, which allows only one
- Short answer, so they type app names
- Linear scale, a 1-5 rating
Show the answer
Checkboxes, which allow selecting multiple options
Checkboxes let a respondent select multiple options, exactly right for 'select all that apply'. Multiple choice allows only one answer (wrong here), and short answer would give messy free text to clean up. Matching the question type to whether you want one answer (multiple choice) or many (checkboxes) is the core form-design decision, and it shapes how clean your collected data is.
Think first
Choose types for easy analysis
Priya could ask 'Which year are you in?' as a Short answer (type it) or as Multiple choice (pick First/Second/Third). Which gives cleaner data to analyse later, and why?
Show the answer
Multiple choice. Everyone picks from the same fixed options (First/Second/Third), so the data is consistent and instantly countable. Short answer would produce '1st', 'First year', 'FY', 'first', a messy spread to clean before analysis (exactly the typo problem from BCA106-01's data validation). Choosing structured question types (multiple choice, dropdown) over free text, wherever possible, means the responses arrive clean and analysis-ready. Design the form for the analysis you want.
Watch out
Where marks leak
Not knowing the question types and what each gives: multiple choice = one answer, checkboxes = many, short answer/paragraph = text, dropdown/linear scale = list/rating. Forgetting questions can be Required. And missing the big point: Forms collects responses automatically into a linked Sheet (no manual entry). Choosing structured types for clean data is the design insight examiners reward.
Theory
The pipeline is taking shape
The form is the front door of the data pipeline: answers in, structured rows out, straight into Sheets. Next lesson covers the features and settings that make the form smart and fair, section breaks, answer validation, shuffling options, and collecting (or not) email addresses, before sending it out and watching the responses arrive. Next: form features and settings.
Summary
Key takeaways
- Google Forms builds an online questionnaire from question blocks with a title and description.
- Question types: multiple choice (one answer), checkboxes (many), short answer/paragraph (text), dropdown, linear scale (rating), date, file upload.
- Mark key questions Required for complete submissions.
- Responses are collected automatically and structured, no manual data entry.
- Prefer structured types (multiple choice, dropdown) over free text for clean, analysis-ready data.
- Memory hook: a self-filing questionnaire, answers file themselves into a spreadsheet.