280 likes | 329 Views
Learn the importance of data quality, techniques for ensuring accuracy, and error detection and prevention in health information systems. Understand the impact of inaccurate data and common data problems.
E N D
Health Management Information Systems Data Processing Topic 4 João Carlos de Timóteo Mavimbe Oslo, April 2007
Presenting Interpreting Data Collation & Accuracy ANALYSIS Processing USE Collection Input Raw data
Learning objectives (1) • Explain the use of the data handling process as a strategy to provide good data quality • Explain the techniques for providing and ensuring good quality data • Describe mechanisms for assessing data quality
Learning objectives (2) • Examine the importance of good data quality • Appreciate the importance of accuracy in health data • Understand why errors occur • Acquire the skills required to detect, correct and prevent future errors • Establish and apply the logistics of error checking
Presenting Interpreting Data Collation & Accuracy ANALYSIS Processing USE Collection Input Raw data Processing data in the information cycle
Ensuring data accuracy • Once data has been collected, it should be checked for any inaccuracies and obvious errors. • Ideally this should be done as close to the point of data collection as possible. • But also at all steps of the information cycle.
Why checking data is vital? • Use of inaccurate data is DANGEROUS • Producing data is EXPENSIVE • Inaccurate data are USELESS data • Producing inaccurate data is a WASTE of money and time
Why checking data is vital? Better to have NO data, than to have inaccurate data!!!
Common problems with data • large gaps • unusual month to month variations • duplication • Promoted by different vertical programs • inconsistencies • unlikely values • data is present where it should not be • typing errors • maths problems – poor calculation • data entered in wrong boxes
Good quality data • WHAT? data that are complete, correct and consistent (and timely) • WHY? facilitates: good decision-making appropriate planning ongoing Monitoring & Evaluation improvement of coverage and quality of care • HOW? provides an accurate picture of health programmes and services
Visual scanning (eyeballing) checking for 3 C’s • Completeness • Correctness • Consistency
Are data complete? • submission by all (most) reporting facilities • physical events observed = events registered (how?) • registered data = collated data (how?) • all data elements registered
Are data correct? • data within normal ranges • logical data • existing standardised definitions used adequately • legible handwriting • are there any preferential end digits used?
Are data consistent? • data in the similar range as this time last year (last reporting period) • no large gaps • is the correct target population being used?
Accuracy enhancing principles • Training • User-friendly collection/collation tools • Feedback on data errors • Feedback of analysed Information • Use of information (and prove it!)
How do you detect Errors? • general accuracy checking measures • specific accuracy checking measures
General accuracy checks • Completeness • Proper place • Friendly tools • Arithmetic
Specific Accuracy Checks • Time-trend consistency • Time-trend variation • Minimum/maximum • Realism • Comparison • Parts vs whole • Preferential end-digits
PREFERENTIAL END-DIGITS Other examples ?
Practical error checking procedures • Check completeness of the data forms • Set minimum and maximum values • Examine a printout of data for errors using general and specific error checks • Hold an error feedback session
What to do if you find errors? • Find the cause • Correct the error • Prevent future errors
small, essential dataset - EDS • clear definitions - standardized • careful collection and collation of data – good tools • local analysis of data using relevant indicators • presentation of information to all collectors • regular feedback on both data and information • supportive supervision - at all levels • ongoing training and support • discussion of information at facility team meetings • monitoring use of information
Data, in order to be locally useful, should be: • AVAILABLE ON TIME fix dates for reporting • AVAILABLE AT ALL LEVELS who reports to whom? - feedback mechanisms • RELIABLE & ACCURATE check that all data is correct, complete, consistent • COMPREHENSIVE collected from all possible data sources • USABLE if no action, throw data away • COMPARABLE same numerator and denominator definitions used by all
Controlling quality with DHIS • Maximum / minimum values • 13-month retrospective • Regression line • Validation rules: absolute statistical • Validation reminders