1 / 25

From the data to the report

From the data to the report. Module 2. Introduction. Welcome Housekeeping Introductions Name, job, district, team. Overview.

asher-rivas
Download Presentation

From the data to the report

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. From the data to the report Module 2

  2. Introduction • Welcome • Housekeeping • Introductions • Name, job, district, team

  3. Overview • The data management cycle has many different stages where data quality can fall down. This module addresses good practice at a range of levels from data entry through to reporting. • New software (compared to Module 1) in the form of a data entry package, Epi Info, and a statistics package, Instat, are added to the toolkit.

  4. Module content • Data management • Data entry principles and practices • using Epi Info • designing data capture screens, • labelling and entering data, etc. • Simple statistical analysis • in Epi Info • and using the statistics package, Instat. • Report writing.

  5. Duration and timetable

  6. Module Learning Objectives At the end of the module, participants will be able to: • Undertake a range of data management tasks, from data entry through to reporting, for simple surveys. • Train or advise others on how to undertake the same tasks. • Discuss the relative merits of Excel, Epi Info and Instat. • Use Excel, Epi Info and Instat as appropriate for data management work on different projects.

  7. Prerequisites Completion of Module 1 of this course.

  8. Resources • A small set of questionnaires provided by UBOS. • Epi-info. • Instat

  9. Concepts more than software • The emphasis is on the concepts of data management • For data entry, analysis and reporting • And developing your skills to plan your strategy • We introduce new software • E.g. Epi Info for data entry and checking • But could equally have used CSPRO • You could change later; the same concepts would apply • Software is now easy to master • It is the statistical concepts that benefit from a course

  10. Module 1: A one-slide review Statistical Concepts

  11. Review of Module 1 At the end of Module 1 participants were able to: • Define statistics • Interpret different measures of variation • Organise data in Excel • Summarise data using appropriate tables and graphs • Have confidence that statistics is a manageable subject

  12. Data Collection and the Research Process Module 2 Session 1

  13. Overview (of Session) • This session sets the scene for the rest of the module. • The data collection process is reviewed; • and participants share their experiences.

  14. Session Learning Objectives At the end of the session participants will be able to: • describe the data collection process • highlight a range of different problems that arise in the data collection process • outline other roles or types of support he/she could undertake in their own office • install Epi Info.

  15. Data management cycle Design questionnaire Enumerators collect data in the field Design survey Manual checking, editing etc. Conception Reporting of results Data entered onto computer Data analysis Computer data management

  16. Data management cycle Design questionnaire Enumerators collect data in the field Design survey Manual checking, editing etc. Conception Reporting of results Module 2 Data entered onto computer Data analysis Computer data management

  17. Data management cycle Module 3 Design questionnaire Enumerators collect data in the field Design survey Manual checking, editing etc. Conception Reporting of results Data entered onto computer Data analysis Computer data management 17

  18. Uganda Context • Now let’s look at examples of data collection activities and their data handling in the Uganda context • at both the national level and at the Districts’ level.

  19. Ugandan National Household Survey (e.g. UNHS2) • The 2002/2003 UNHS survey collected data on: • approx.50,000 individuals • 9700 households • 970 communities The whole of this was undertaken entirely by UBOS – questionnaire, enumerators, data entry, management, analysis and reporting.

  20. UNHS2 – “All the data” Households • Info. collected about community • Health facility within 3 km • Bank within 10km • Info. collected about household members • Age • Sex • Schooling status etc. • Info. collected about households • Housing conditions – type of roof, etc. • Household condition - what fuel used for lighting etc. • Household consumption expenditure

  21. Part of UNHS2 questionnaire

  22. Districts’ Examples • At the District level, there are different studies and involvement in the data management cycle can be different • Externally funded, e.g. • Baseline survey at Bundibuyo (BTC) • Here the whole survey under the control of the district

  23. Districts’ Examples • Ministry driven (for planning purposes) • HMIS questionnaires at health units • Education – annual census • Local government mandatory assessments - largely only enumerators, checking, data entry. • District driven e.g. • human resources – assessing capacity. • Revenue enhancement - involvement in whole process.

  24. Activity 3: Discussion – who does what? (30 mins) • Working in pairs. • Find out what the other does, in terms of dealing with data - and what the problems are (if any). - with examples. • Who else in the District deals with data, and what do they do?

  25. Installing Epi-Info • http://www.cdc.gov/epiinfo/ • Latest version: 3.4.3 • Release Date: November 26, 2007 • Download • Install from Web, or • Download setup.exe file • Run setup.exe and follow instructions • The setup.exe file is also available on the DVD under the Resources folder

More Related