Data Collection Methods

Active learning works for this topic because students need to physically manipulate and visualize relationships to grasp abstract concepts like primary and foreign keys. Moving beyond spreadsheets forces them to confront duplication, errors, and scalability in real data structures.

• Year 9
• Technologies
• 3 activities
• 20 min–50 min

Learning Objectives

1. Analyze the potential biases and limitations of data collected through surveys.
2. Compare the efficiency and scope of data collection using sensors versus web scraping for a given scenario.
3. Evaluate the ethical considerations involved in collecting personal data from online sources.
4. Design a data collection strategy, including method selection and justification, for a specific research question about local community needs.

Inquiry Circle

⏱ 50 min·Small Groups

Inquiry Circle: The School Database Model

In small groups, students design a database for a fictional school. They must identify the entities (students, teachers, subjects) and draw the relationships between them using physical cards and string to represent keys, ensuring no data is unnecessarily repeated.

Prepare & details

Analyze the challenges of collecting reliable data from diverse sources.

Facilitation Tip: During the Collaborative Investigation, circulate and ask groups to explain how their table links connect to the real-world scenario, not just the technical terms.

Setup: Groups at tables with access to source materials

Materials: Source material collection, Inquiry cycle worksheet, Question generation protocol, Findings presentation template

• Analyze
• Evaluate
• Create
• Self-Management
• Self-Awareness

Gallery Walk

⏱ 30 min·Whole Class

Gallery Walk: Data Model Critique

Groups display their database designs on the walls. Other students walk around with sticky notes to identify potential 'data redundancy' issues or missing relationships, providing constructive feedback based on relational design principles.

Prepare & details

Differentiate between various data collection methods and their ethical implications.

Facilitation Tip: For the Gallery Walk, provide sentence starters on critique cards to guide students toward specific feedback about relationships and redundancy.

Setup: Wall space or tables arranged around room perimeter

Materials: Large paper/poster boards, Markers, Sticky notes for feedback

• Understand
• Apply
• Analyze
• Create
• Relationship Skills
• Social Awareness

Think-Pair-Share

⏱ 20 min·Pairs

Think-Pair-Share: The Query Challenge

Provide a simple table of data. Students work in pairs to write a 'natural language' query (e.g., 'Find all students in Year 9 who play soccer') and then attempt to translate it into a structured format, discussing why precision is necessary for computers.

Prepare & details

Design a data collection strategy for a specific research question.

Facilitation Tip: In the Think-Pair-Share, require students to write their query on paper first before testing it, so they identify syntax errors through reasoning rather than trial and error.

Setup: Standard classroom seating; students turn to a neighbor

Materials: Discussion prompt (projected or printed), Optional: recording sheet for pairs

• Understand
• Apply
• Analyze
• Self-Awareness
• Relationship Skills

Teaching This Topic

Teach this topic by starting with physical models before moving to digital tools. Research shows students grasp relational concepts faster when they handle tangible items like index cards or sticky notes to represent tables and relationships. Avoid rushing to SQL; focus first on why normalization matters for data integrity and efficiency. Use analogies carefully, as over-simplifying can reinforce misconceptions about spreadsheets being sufficient for relational data.

What to Expect

Successful learning looks like students confidently designing normalized tables, explaining why related data belongs in separate tables, and writing simple queries to extract information. They should critique models and justify their design choices with clear reasoning.

Watch Out for These Misconceptions

Common Misconception

During the Collaborative Investigation, watch for students treating the database as a single table by combining all data into one sheet.

What to Teach Instead

Redirect them to the activity’s focus on real-world relationships, such as students to classes, and ask them to identify duplicate entries that would occur if all data were in one table.

Common Misconception

During the Gallery Walk, watch for students assuming that more tables always mean a better database.

What to Teach Instead

Use the critique cards to guide them toward evaluating redundancy and efficiency, pointing out examples where fewer, well-linked tables serve the same purpose.

Assessment Ideas

Quick Check

After the Collaborative Investigation, present students with a scenario where they must identify which data collection method (survey, sensor, or web scraping) best answers a given research question, and justify their choice in one sentence.

Discussion Prompt

During the Think-Pair-Share, pose a scenario about a school cafeteria menu and ask students to debate whether a survey or motion sensors would better collect data on student preferences and usage patterns.

Exit Ticket

After the Gallery Walk, ask students to write down one way their own database model reduced redundancy compared to a single-table approach, using examples from their critique of peer models.

Extensions & Scaffolding

• Challenge: Ask early finishers to design a query that joins three tables and calculates a statistic, such as average class size per subject.
• Scaffolding: For students struggling with relationships, provide pre-labeled table cards and ask them to match primary keys to foreign keys before building their own model.
• Deeper: Invite students to research a real-world database, such as library systems or hospital records, and present how normalization reduces redundancy in that context.

Key Vocabulary

Survey	A method of gathering information from a sample of individuals through a set of questions, used to understand opinions, behaviors, or characteristics.
Sensor	A device that detects and responds to some type of input from the physical environment, such as light, heat, motion, or pressure, and records data automatically.
Web Scraping	An automated process of extracting data from websites, often used to gather large amounts of information for analysis.
Data Bias	Systematic error introduced into sampling or testing by selecting or encouraging any sample group in a mistaken way, leading to inaccurate results.
Ethical Data Collection	Practices that ensure data is gathered with respect for privacy, consent, and security, avoiding harm or exploitation of individuals.