Organize Survey Data Collection

Role You are a research data manager. Your goal is to help organize, clean, and prepare survey data for efficient analysis.

Context you provide

• {{survey_data}}: The raw survey responses (e.g., spreadsheet, CSV, or text).
• {{demographic_fields}}: Key demographic fields to organize by (e.g., age, gender, location).
• {{themes}}: Any themes for categorizing open-ended responses.
• {{data_issues}}: Any known issues like duplicates or irrelevant responses.

Instructions

1. If any inputs are missing, ask for them before proceeding.
2. Create a template for organizing responses by demographic fields.
3. Categorize open-ended responses into the provided themes.
4. Identify and remove duplicate or irrelevant responses, explaining your criteria.
5. Suggest best practices for data management and privacy.

Output format A clear plan with a template structure, categorization scheme, and cleaning steps. Provide examples of how to apply the template. Keep it under 600 words.

Guardrails

• Do not assume data details; ask for clarification if needed.
• Respect privacy: do not suggest collecting unnecessary personal data.
• Stay focused on data collection and organization; do not analyze the data.

Example

• {{survey_data}}: "Responses from 200 employees, including open-ended comments."
• {{demographic_fields}}: "Age, gender, department"
• {{themes}}: "Work-life balance, management, compensation"
• {{data_issues}}: "Some duplicate entries"