80 likes | 239 Views
GCA Data Capture Practices. GCA Data Processing. Handling documentation Auditing Coding Scanning Final Cleaning Excel Syntax. Form Handling. Forms sorted by Institution Type (i.e. CEQ/PREQ) Round Batched Counted Batched into batches of around 100 Document attached for tracking
E N D
GCA Data Capture Practices
GCA Data Processing • Handling • documentation • Auditing • Coding • Scanning • Final • Cleaning • Excel • Syntax
Form Handling • Forms sorted by • Institution • Type (i.e. CEQ/PREQ) • Round • Batched • Counted • Batched into batches of around 100 • Document attached for tracking • Recorded in spreadsheet
Auditing • Coding Audit • 100% of a new coder’s 1st batch is audited • 5% of subsequent batches (unless errors are being found) • Verification • TeleForm will raise anything it cannot read • e.g., unclear ticks, unclear handwriting. • All email addresses manually entered • Incorrect codes will be flagged • Final Audit • 10% of all forms scanned at GCA are audited in the data file against the original form.
Data Cleaning • Input missing data for • Level (level of education) • Maj1 (major 1) • Correct out of range codes for • Maj1-4 (majors) • Permnat (nationality) • Ceqmaj1-2 (CEQ majors) • Industry • Empnat2 (country of employment) • Duties • Furmaj1-2 (further study majors) • Furinst (further education institution)
In Summary • Audit coding: 5% of all forms • Audit data file: 10% of all forms • Complete missing data where possible • Correct incorrect codes • SPSS clean (syntax available on START)