Linking an online form to a spreadsheet

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. When a student submits a linked online form, what happens in the responses sheet?

A A new row is added with their answers

B The first row is overwritten with their answers

2. In a form responses sheet, what does each column usually represent?

A One question from the form

B One person who answered the form

3. Which column is added automatically to the responses sheet to show when a response was sent?

A Primary key

B Timestamp

4. Why is linking a form to a spreadsheet useful for acquiring data?

A Answers must be copied by hand from emails into a table

B Answers arrive directly in a table ready to sort, filter and count

5. You want a form question that only allows one choice from a list, such as year level. Which question type fits best?

A Multiple choice

B Paragraph text

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Timestamp column		AAn automatic first column that records the date and time each response was submitted
2One row per response		BQuestion type: Dropdown (Year 9, Year 10)
3Each question on the form becomes its own column in the responses sheet		CEach time someone submits the form, a new row is added to the linked spreadsheet
4Choosing a multiple choice or dropdown question limits answers to set options, giving consistent data		DThis does not link the form to the spreadsheet. Manual typing is slow and can add errors. Link the form so responses arrive automatically.
5Typing survey answers into the sheet by hand after collecting them on paper		EQuestion: Favourite subject? -> Column C header: Favourite subject?
6Deleting the Timestamp column because it looks like it is not needed		FThe timestamp records when each response was submitted. Removing it loses useful data, such as spotting duplicates or checking dates.

Definitions

Form responses sheet

Fill in the Blanks

Complete each line of code by filling in the missing parts.

_________ | Name | Year level | Pet 2/3/2025 9:15 | Mia | 9 | Dog

Header = row 1 Response 1 = row 2 Response 2 = row _

Pick many options: __________

Rate from 1 to 5: ____________

Form question: Year level Sheet: one new ______ per question

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Form question: Favourite food

B Sheet column: Favourite food

C Each response = one new column

Question 2

A Each question = one row

B Each response = one row

C Timestamp = when it was sent

Question 3

A Row 1: Timestamp, Name, Year

B Row 2: 5/3 9:02, Mia, 9

C Row 3: 5/3 9:15, 10, Jai

Question 4

A Student submits the form

B Sheet adds a new row

C Student types the timestamp

Question 5

A Short answer: one-line text

B Dropdown: free typing allowed

C Paragraph: long text

Answer Key

Linking an online form to a spreadsheet

Section A: Quick Questions

A — A new row is added with their answers

A — One question from the form

B — Timestamp

B — Answers arrive directly in a table ready to sort, filter and count

A — Multiple choice

Section B: Match the Pairs

Timestamp column → An automatic first column that records the date and time each response was submitted

One row per response → Each time someone submits the form, a new row is added to the linked spreadsheet

Each question on the form becomes its own column in the responses sheet → Question: Favourite subject? -> Column C header: Favourite subject?

Choosing a multiple choice or dropdown question limits answers to set options, giving consistent data → Question type: Dropdown (Year 9, Year 10)

Typing survey answers into the sheet by hand after collecting them on paper → This does not link the form to the spreadsheet. Manual typing is slow and can add errors. Link the form so responses arrive automatically.

Deleting the Timestamp column because it looks like it is not needed → The timestamp records when each response was submitted. Removing it loses useful data, such as spotting duplicates or checking dates.

Section C: Definitions

Form responses sheet — A spreadsheet linked to an online form. Each submitted response becomes a new row, each question is a column, and a timestamp column records when it was sent, giving data ready to use.

Section D: Fill in the Blanks

Timestamp | Name | Year level | Pet
2/3/2025 9:15 | Mia | 9 | Dog

Header = row 1
Response 1 = row 2
Response 2 = row 3

Pick many options: Checkboxes

Rate from 1 to 5: Linear scale

Form question: Year level
Sheet: one new column per question

Section E: Spot the Error

C — Each submitted response is added to the responses sheet as a new row, not a new column. It should read: Each response = one new row.

A — Each form question becomes a column (a heading), not a row. It should read: Each question = one column.

C — The values must follow the column order from the headings: Timestamp, Name, Year. Here the year and name are swapped. It should be Row 3: 5/3 9:15, Jai, 10.

C — The timestamp column is filled in automatically with the date and time of submission. The student does not type it. It should read: Timestamp is added by itself.

B — A dropdown question makes the user choose from a fixed list, which keeps the data consistent. It should read: Dropdown: pick from a list.