Education Sampling Data Management
Goal
Create a practical sampling, recruitment, participant-ID, consent, anonymization, and data-management plan for education research.
Use After
Use after a study path and basic research design are selected:
education-quantitative-study-design
education-qualitative-study-design
education-mixed-methods-design
education-action-research-design
education-design-based-research
education-program-evaluation
education-psychometric-scale-development
education-learning-analytics-design
Do not expose the skill name to users. Present it as "样本与数据管理设计".
Inputs
- Paper type and research design
- Target participants: students, teachers, parents, administrators, schools/classes
- Education level, subject, grade, region
- Data sources: surveys, tests, interviews, observations, student work, logs, documents
- Whether minors are involved
- Access constraints: school permission, class access, teacher cooperation
- Data sensitivity and sharing requirements
Workflow
- Identify sampling unit:
- student
- teacher
- class
- school
- lesson/session
- artifact/document
- platform account/log
- Select sampling strategy:
- convenience
- purposive
- stratified
- cluster/class-based
- random
- snowball
- maximum variation
- theoretical sampling for grounded theory
- Define inclusion/exclusion criteria.
- Estimate sample size needs:
- quantitative: power/precision/model complexity
- qualitative: information richness/saturation
- psychometric: item-to-participant and factor analysis needs
- meta/log data: unit count and time window
- Design recruitment workflow:
- school/administrator permission
- teacher coordination
- parent/guardian consent if minors
- student assent when appropriate
- participant reminders
- Create anonymized participant ID scheme.
- Create data dictionary and linking table plan.
- Define secure storage, file naming, versioning, and access control.
- Plan missing-data and attrition tracking.
- Output a data-management package.
Tool Calls
Sample Size and Power
G*Power: https://www.psychologie.hhu.de/arbeitsgruppen/allgemeine-psychologie-und-arbeitspsychologie/gpower
R packages:
install.packages(c("pwr", "simr", "WebPower"))
Participant/Data Tracking
Excel / Google Sheets
Airtable: https://www.airtable.com/
REDCap: https://www.project-redcap.org/
Notion: https://www.notion.so/
Open Science Framework: https://osf.io/
Secure Survey/Data Collection
Qualtrics: https://www.qualtrics.com/
问卷星: https://www.wjx.cn/
Google Forms: https://forms.google.com/
REDCap: https://www.project-redcap.org/
Output Format
1. Sampling Plan
| Item |
Decision |
| Target population |
|
| Sampling unit |
|
| Sampling strategy |
|
| Inclusion criteria |
|
| Exclusion criteria |
|
| Expected sample size |
|
| Minimum acceptable sample |
|
| Recruitment channel |
|
| Key feasibility risk |
|
2. Recruitment Workflow
| Step |
Actor |
Material Needed |
Output |
| School permission |
Researcher/school admin |
Study brief |
Permission |
| Teacher coordination |
Researcher/teacher |
Schedule and task description |
Class access |
| Parent/guardian consent |
Parent/guardian |
Consent form |
Consent record |
| Student assent |
Student |
Age-appropriate explanation |
Assent record |
| Data collection |
Researcher/teacher |
Survey/test/interview protocol |
Dataset |
3. Participant ID Scheme
Use anonymous IDs, not names.
Example:
| Entity |
ID Pattern |
Example |
| School |
S + two digits |
S01 |
| Class |
S + school + C + class |
S01C02 |
| Student |
S + school + C + class + ST + number |
S01C02ST015 |
| Teacher |
S + school + T + number |
S01T003 |
| Interview |
INT + participant ID + date |
INT-S01T003-20260609 |
4. Data Dictionary
| Variable Name |
Label |
Level |
Type |
Allowed Values |
Missing Code |
Source |
Notes |
Example levels:
- student-level
- teacher-level
- class-level
- school-level
- session-level
- item-level
- artifact-level
5. Dataset Inventory
| Dataset/File |
Unit of Analysis |
Key ID |
Sensitive Fields |
Storage Location |
Access |
6. Consent and Ethics Checklist
| Check |
Status |
Notes |
| School permission |
Pending/Done |
|
| Parent/guardian consent |
Pending/Done/Not needed |
|
| Student assent |
Pending/Done/Not needed |
|
| Teacher consent |
Pending/Done/Not needed |
|
| Data anonymization |
Pending/Done |
|
| AI/tool data policy checked |
Pending/Done/Not relevant |
|
| Withdrawal option explained |
Pending/Done |
|
Recommended File Naming
projectname_dataset_unit_date_version.ext
aiwriting_survey_student_20260609_v01.xlsx
aiwriting_interview_teacher_20260609_v01.docx
aiwriting_score_student_prepost_20260609_v01.xlsx
Data-Linking Rule
Maintain two layers:
- Analysis datasets with anonymous IDs only.
- Separate identity linking table stored securely and not included in analysis exports.
Never put real names, phone numbers, parent contacts, student numbers, or school-identifying details in the analysis dataset unless there is a clear approved reason.
Education-Specific Risks
- Minors require extra consent/assent attention.
- Class-based sampling often creates nested data; record class/school IDs.
- Intervention studies need attrition tracking by group.
- Teacher-collected data may create pressure on students; make voluntariness explicit.
- AI platform logs may include sensitive prompts, writing samples, or account identifiers; anonymize text artifacts carefully.
Quality Rules
- Every dataset must have a unique participant or unit ID.
- Record group assignment, time point, and data source early; do not reconstruct later from memory.
- Keep raw data, cleaned data, and analysis data separate.
- Use consistent missing-value codes.
- Record all data exclusions with reasons.
- For multi-level education data, preserve school/class/teacher/student hierarchy.
User-Facing Closure
End by asking for the most important missing feasibility detail:
接下来需要确认一个实际条件:你预计能接触几个班、多少名学生/教师?我可以据此帮你把样本表、匿名编号规则和数据字典做成可直接采集的版本。
1---2name: education-sampling-data-management3description: Use before collecting education research data, or when planning samples, recruitment, participant tracking, school/class/teacher/student data structures, consent, anonymization, data dictionaries, file naming, secure storage, and dataset readiness. This second-layer execution skill supports quantitative, qualitative, mixed-methods, experimental, action research, DBR, program evaluation, psychometric, and learning analytics workflows.4---56# Education Sampling Data Management78## Goal910Create a practical sampling, recruitment, participant-ID, consent, anonymization, and data-management plan for education research.1112## Use After1314Use after a study path and basic research design are selected:1516- `education-quantitative-study-design`17- `education-qualitative-study-design`18- `education-mixed-methods-design`19- `education-action-research-design`20- `education-design-based-research`21- `education-program-evaluation`22- `education-psychometric-scale-development`23- `education-learning-analytics-design`2425Do not expose the skill name to users. Present it as "样本与数据管理设计".2627## Inputs2829- Paper type and research design30- Target participants: students, teachers, parents, administrators, schools/classes31- Education level, subject, grade, region32- Data sources: surveys, tests, interviews, observations, student work, logs, documents33- Whether minors are involved34- Access constraints: school permission, class access, teacher cooperation35- Data sensitivity and sharing requirements3637## Workflow38391. Identify sampling unit:40 - student41 - teacher42 - class43 - school44 - lesson/session45 - artifact/document46 - platform account/log472. Select sampling strategy:48 - convenience49 - purposive50 - stratified51 - cluster/class-based52 - random53 - snowball54 - maximum variation55 - theoretical sampling for grounded theory563. Define inclusion/exclusion criteria.574. Estimate sample size needs:58 - quantitative: power/precision/model complexity59 - qualitative: information richness/saturation60 - psychometric: item-to-participant and factor analysis needs61 - meta/log data: unit count and time window625. Design recruitment workflow:63 - school/administrator permission64 - teacher coordination65 - parent/guardian consent if minors66 - student assent when appropriate67 - participant reminders686. Create anonymized participant ID scheme.697. Create data dictionary and linking table plan.708. Define secure storage, file naming, versioning, and access control.719. Plan missing-data and attrition tracking.7210. Output a data-management package.7374## Tool Calls7576### Sample Size and Power7778```text79G*Power: https://www.psychologie.hhu.de/arbeitsgruppen/allgemeine-psychologie-und-arbeitspsychologie/gpower80```8182R packages:8384```r85install.packages(c("pwr", "simr", "WebPower"))86```8788### Participant/Data Tracking8990```text91Excel / Google Sheets92Airtable: https://www.airtable.com/93REDCap: https://www.project-redcap.org/94Notion: https://www.notion.so/95Open Science Framework: https://osf.io/96```9798### Secure Survey/Data Collection99100```text101Qualtrics: https://www.qualtrics.com/102问卷星: https://www.wjx.cn/103Google Forms: https://forms.google.com/104REDCap: https://www.project-redcap.org/105```106107## Output Format108109### 1. Sampling Plan110111| Item | Decision |112|---|---|113| Target population | |114| Sampling unit | |115| Sampling strategy | |116| Inclusion criteria | |117| Exclusion criteria | |118| Expected sample size | |119| Minimum acceptable sample | |120| Recruitment channel | |121| Key feasibility risk | |122123### 2. Recruitment Workflow124125| Step | Actor | Material Needed | Output |126|---|---|---|---|127| School permission | Researcher/school admin | Study brief | Permission |128| Teacher coordination | Researcher/teacher | Schedule and task description | Class access |129| Parent/guardian consent | Parent/guardian | Consent form | Consent record |130| Student assent | Student | Age-appropriate explanation | Assent record |131| Data collection | Researcher/teacher | Survey/test/interview protocol | Dataset |132133### 3. Participant ID Scheme134135Use anonymous IDs, not names.136137Example:138139| Entity | ID Pattern | Example |140|---|---|---|141| School | S + two digits | S01 |142| Class | S + school + C + class | S01C02 |143| Student | S + school + C + class + ST + number | S01C02ST015 |144| Teacher | S + school + T + number | S01T003 |145| Interview | INT + participant ID + date | INT-S01T003-20260609 |146147### 4. Data Dictionary148149| Variable Name | Label | Level | Type | Allowed Values | Missing Code | Source | Notes |150|---|---|---|---|---|---|---|---|151152Example levels:153154- student-level155- teacher-level156- class-level157- school-level158- session-level159- item-level160- artifact-level161162### 5. Dataset Inventory163164| Dataset/File | Unit of Analysis | Key ID | Sensitive Fields | Storage Location | Access |165|---|---|---|---|---|---|166167### 6. Consent and Ethics Checklist168169| Check | Status | Notes |170|---|---|---|171| School permission | Pending/Done | |172| Parent/guardian consent | Pending/Done/Not needed | |173| Student assent | Pending/Done/Not needed | |174| Teacher consent | Pending/Done/Not needed | |175| Data anonymization | Pending/Done | |176| AI/tool data policy checked | Pending/Done/Not relevant | |177| Withdrawal option explained | Pending/Done | |178179## Recommended File Naming180181```text182projectname_dataset_unit_date_version.ext183aiwriting_survey_student_20260609_v01.xlsx184aiwriting_interview_teacher_20260609_v01.docx185aiwriting_score_student_prepost_20260609_v01.xlsx186```187188## Data-Linking Rule189190Maintain two layers:1911921. Analysis datasets with anonymous IDs only.1932. Separate identity linking table stored securely and not included in analysis exports.194195Never put real names, phone numbers, parent contacts, student numbers, or school-identifying details in the analysis dataset unless there is a clear approved reason.196197## Education-Specific Risks198199- Minors require extra consent/assent attention.200- Class-based sampling often creates nested data; record class/school IDs.201- Intervention studies need attrition tracking by group.202- Teacher-collected data may create pressure on students; make voluntariness explicit.203- AI platform logs may include sensitive prompts, writing samples, or account identifiers; anonymize text artifacts carefully.204205## Quality Rules206207- Every dataset must have a unique participant or unit ID.208- Record group assignment, time point, and data source early; do not reconstruct later from memory.209- Keep raw data, cleaned data, and analysis data separate.210- Use consistent missing-value codes.211- Record all data exclusions with reasons.212- For multi-level education data, preserve school/class/teacher/student hierarchy.213214## User-Facing Closure215216End by asking for the most important missing feasibility detail:217218```text219接下来需要确认一个实际条件:你预计能接触几个班、多少名学生/教师?我可以据此帮你把样本表、匿名编号规则和数据字典做成可直接采集的版本。220```