data management seminar, 9-12th july 2007, hamburg 1 data processing at the iea dpc

1 Data Management Seminar, 9-12th July 2007, Hamburg

Data Processing at the Data Processing at the IEA DPC IEA DPC


ContentContent

• Data and Documentation Submission

• Data Processing at the IEA DPC– Adapting the File Structure

– Cleaning Steps

• Further Schedule

• Contact Addresses


To be submitted by January 25, 2008

Material to be Submitted to IEA Material to be Submitted to IEA DPCDPC

Exported WinW3S database (*.MDB)

WinDEM data files (*.DBF)

Codebooks for each data file (*.SDB) (including all adaptations made to the structure)


To be submitted by January 25, 2008

Material to be Submitted to IEA Material to be Submitted to IEA DPCDPC

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 File-Exchange using the IEA DPC WebFTP-ServerDPC 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


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

File-Exchange using the IEA File-Exchange using the IEA DPC WebFTP-ServerDPC WebFTP-Server


ContentContent



– Cleaning Steps




Data Processing at the IEA DPCData Processing at the IEA DPC

Data & Codebook

sInstrument

s & Forms

INP

UT

IEA DPC

CountryCountry communication will continue after data

send-out!

1. Import to SAS and adapting the

file structure


Adapting the File StructureAdapting 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


Structure of the Merged Data Structure of the Merged Data SetSet

Variable ValueIDQUEST 1

IDPUNCH 1

...,ITPART1..2,

IDSCHOOL,

IDCLASS,...

3...

8001

800101

IDSTUD 80010101

IDCHECK 373

TOKEN01 3

CS2GSEX 1

SSYSTEM,... 000001

Addedduring

cleaningprocess

Example: Student Questionnaire Data File

Information:

TrackingForms

Information:Student

Questionnaire

WinDEM(ISGxxxF2.DBF)


Data Processing at the IEA Data Processing at the IEA DPCDPC

Country Databas

eNew Data

Structure

Reports, Statistic

s & Docu.

INP

UT

OU

TP

UTStructur

e Check

Background

Cleaning

IEA DPC

Country

ID Cleaning

Linkage Cleanin

g

Data & Codebook

sInstrument

s & Forms2. Cleaning

Country communication will continue after data send-out!


ContentContent



– Cleaning Steps




Further ScheduleFurther 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


ContentContent



– Cleaning Steps




Contact AddressesContact Addresses

tel: +61 3 9255 5555

e-mail:[email protected]

Web: http://iccs.acer.edu.au

tel: +31 20 625 3625 e-mail: [email protected]

InternationalStudy Center (ISC)

IEA Secretariat


Contact AddressesContact Addresses

tel: +49 40 48 500 750

e-mail: [email protected]

IEA DPC Sampling

IEA DPC tel: +49 40 48 500 611

e-mail: [email protected]: https://webftp.iea-

dpc.org


Thank you very much for your Thank you very much for your attention!attention!

data management seminar, 9-12th july 2007, hamburg 1 data processing at the iea dpc

Documents