Design, Collect, Analyze

This assignment connects question design, Forms, Sheets, and evidence. You will collect a small, non-sensitive classroom dataset and make one bounded claim from it.

Step 1 — define the purpose

Choose a harmless course question such as:

• Which Google tool needs more practice?
• Which course artifact was most useful for learning file organization?
• Which presentation support helps most: diagram, example, chart, or speaker explanation?

Write one sentence defining the purpose before creating the Form.

Step 2 — design 3–5 questions

Every question must have a purpose. Include at least two different question types.

Do not collect:

• passwords or authentication information;
• student IDs;
• medical information;
• home addresses;
• private phone numbers;
• unnecessary personal email;
• anything else that makes the dataset more sensitive without helping the stated question.

Get classroom approval before collecting responses from other people. If collection is not available, use a teacher-provided synthetic response set.

Step 3 — run the privacy check

Complete a short table:

Remove at least one tempting but unnecessary field if your first draft included one.

Step 4 — collect a small response set

Use the authorized classroom audience only. The goal is not statistical representativeness; the goal is to trace the workflow safely.

Record the number of responses. Do not describe the sample as “all students” unless it actually is.

Step 5 — analyze in Sheets

Connect or export the responses to Sheets. Create:

• one summary count or percentage;
• one chart appropriate to the question;
• one filter or grouping if it improves the analysis.

Step 6 — claim + limitation

Example:

In the 12-response classroom sample, Google Sheets was selected most often as the tool learners wanted more practice with. This convenience sample cannot establish what all students in the school need.

Notice the sample is named and the limitation is real.

Submit — Design, Collect, Analyze

Your evidence packet includes:

1. purpose statement;
2. Form or privacy-safe Form evidence;
3. field-purpose/privacy table;
4. response count and access statement;
5. response Sheet or supplied data analysis;
6. one chart;
7. one bounded claim;
8. one limitation;
9. one sentence explaining how the question design shaped the dataset.

Defense

Be ready to answer:

Which field could you delete while still accomplishing the purpose?

If the answer is “none” without analysis, revisit the form. Good digital data collection is deliberate before the first response arrives.