170 likes | 434 Views
Data Processing at the IEA DPC. Content. Data and Documentation Submission Data Processing at the IEA DPC Adapting the File Structure Cleaning Steps Further Schedule Contact Addresses. Material to be Submitted to IEA DPC. To be submitted by January 25, 2008.
E N D
Content • Data and Documentation Submission • Data Processing at the IEA DPC • Adapting the File Structure • Cleaning Steps • Further Schedule • Contact Addresses
Material to be Submitted to IEA DPC To be submitted by January 25, 2008 • Exported WinW3S database (*.MDB) • WinDEM data files (*.DBF) • Codebooks for each data file (*.SDB)(including all adaptations made to the structure)
Material to be Submitted to IEA DPC To be submitted by January 25, 2008 • Copy of the national ICCS achievement booklets and questionnaires (1 set per language) • National Adaptations Forms (version IV) (1 set per language) • Copies of all completed Student Tracking and Teacher Tracking Forms returned from schools (hard copies or scanned)
File-Exchange using the IEA DPC WebFTP-Server • The IEA DPC has setup secure FTP sites to exchange materials between countries and the - ISC at ACER and/or - IEA Secretariat and/or - IEA DPC • Can easily be accessed using a web browser (e.g. Internet Explorer) • Each country will receive a separate login
File-Exchange using the IEA DPC WebFTP-Server • Please inform the recipients via email as soon you have uploaded any materials • Further information on the IEA DPC WebFTP-Server will be provided in a separate WebFTP-Server Manual
Content • Data and Documentation Submission • Data Processing at the IEA DPC • Adapting the File Structure • Cleaning Steps • Further Schedule • Contact Addresses
Data & Codebooks IEA DPC Country Instruments & Forms Data Processing at the IEA DPC 1. Import to SAS and adapting the file structure INPUT Country communication will continue after data send-out!
Adapting the File Structure • WinW3S database and WinDEM data files are merged and converted to SAS data files • Unique system numbers (CSYSTEM, TSYSTEM, SSYSTEM) are added • System numbers usually correspond to the position of the record in the original WinDEM data files • If a data set is missing either in WinW3S or in WinDEM, higher system numbers will be assigned
Information: Student Questionnaire Information: Tracking Forms WinDEM (ISGxxxF2.DBF) Structure of the Merged Data Set Example: Student Questionnaire Data File Added during cleaning process
Data & Codebooks Country Database IEA DPC Country Instruments & Forms New Data Structure Reports, Statistics & Docu. Data Processing at the IEA DPC Structure Check Background Cleaning INPUT OUTPUT 2. Cleaning ID Cleaning Linkage Cleaning Country communication will continue after data send-out!
Content • Data and Documentation Submission • Data Processing at the IEA DPC • Adapting the File Structure • Cleaning Steps • Further Schedule • Contact Addresses
Further Schedule • Software: • July 23, 2007:WinW3S • August 20, 2007:SurveySystem • August 20, 2007:WinDEM • Documentation in Survey Operations Procedures Manuals: • July 23, 2007: SOP (FT), Unit 2 (WinW3S I) • August 20, 2007: SOP (FT), Unit 3 (WinW3S II, WinDEM, SurveySystem) • Material Submission for Field Trial: January 25, 2007
Content • Data and Documentation Submission • Data Processing at the IEA DPC • Adapting the File Structure • Cleaning Steps • Further Schedule • Contact Addresses
InternationalStudy Center (ISC) tel: +61 3 9255 5555 e-mail:iccs@acer.edu.au Web: http://iccs.acer.edu.au tel: +31 20 625 3625 e-mail: b.malak@iea.nl IEA Secretariat Contact Addresses
IEA DPC Sampling tel: +49 40 48 500 750 e-mail:sampling@iea-dpc.de tel: +49 40 48 500 611 e-mail:iccs@iea-dpc.de web-ftp: https://webftp.iea-dpc.org IEA DPC Contact Addresses