DATA MANAGEMENT - San Jose State University数据管理-圣何塞州立大学.pptVIP

DATA MANAGEMENT Using EpiData and SPSS References Public domain (pdf) book on data management: Bennett, et al. (2001). Data Management for Surveys and Trials. A Practical Primer Using EpiData. The EpiData Documentation Project. : http://www.epidata.dk/downloads/dmepidata.pdf EpiData Association Website: http://www.epidata.dk/ Importing raw data into SPSS: /stat/spss/modules/input.htm Data Management Planning data needs Data collection Data entry and control Validation and checking Data cleaning and variable transformation Data backup and storage System documentation Other Types of Data Base Management Systems (DBMSs) Spreadsheets (e.g., Excel, SPSS Data Editor) Prone to error, data corruption, mismanagement Lack data controls, limited programmability Suitable only for small and didactic projects Also good for last step data cleaning Commercial DBMS programs (e.g., Oracle, Access) Limited data control, good programmability Slow expensive Powerful and widely available Public domain programs (e.g., EpiData, Epi Info) Controlled data entry, good programmability Suitable for research and field use We will use two platforms: EpiData controlled data entry data documentation export (“write”) data SPSS import (“read”) data analysis reporting What is EpiData ? EpiData is computer program (small in size 1.2Mb) for simple or programmed data entry and data documentation It is highly reliable It runs on Windows computers Runs on Macs and Linus with emulator software (only) Interface pull down menus work bar History of EpiInfo EpiData 1976–1995: EpiInfo (DOS program) created by CDC (in wake of swine flu epidemic) Small, fast, reliable, 100,000+ users worldwide 1995–2000: DOS dies slow painful death 2000: CDC releases EpiInfo2000 Based on Microsoft Jet (Access) data engine Large, slow, unreliable (resembled EpiInfo in name only) 2001: Loyal EpiInfo user group decides it needs real “EpiInfo for Windows” Creates open source public domain program Calls program “