ad hoc analysis of epi data n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Ad hoc Analysis of EPI Data PowerPoint Presentation
Download Presentation
Ad hoc Analysis of EPI Data

Loading in 2 Seconds...

play fullscreen
1 / 5
sasha-hanson

Ad hoc Analysis of EPI Data - PowerPoint PPT Presentation

113 Views
Download Presentation
Ad hoc Analysis of EPI Data
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. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Ad hoc Analysis of EPI Data Use of Microsoft Excel Training Workshop for EPI Data Managers and Surveillance Focal Persons (Day 4)Ulaanbaatar, Mongolia – 25-28 August 2009

  2. What is a ‘Pivot Table’? • Pivot table • An interactive table that quickly combines and compares large amounts of data • Can rotate rows and columns to see different summaries of the source data

  3. How to create a pivot table • Demo • Gender of confirmed measles cases by aimag/sourn • Understanding the data: • iCaseID: Unique internally generated ID • sGender: Gender (M=Male; F=Female) • sLevel1: Aimag • sLevel2: Sourn • sConfirmedM: Confirmed measles case? (Y=Yes; N=No)

  4. How to create a pivot table • Exercise • Check lab results of confirmed measles/rubella cases • Understanding the data: • iCaseID: Unique internally generated ID • iMIgM1: Measles IgM result (1=Positive;2=Negative; 3=Equivocal; 4=Pending; 8=Not done; 9=Unknown) • iRIgM1: Rubella IgM result • sConfirmedM: Confirmed measles case? (Y=Yes; N=No) • iConfMethodM: Method of confirmation of measles (1=Lab confirmed; 2=Epi-linked; 3=Clinically) • sConfirmedR: Confirmed rubella case? • iConfMethodR: Method of confirmation of rubella

  5. How to make charts • Demo • Gender of suspected measles cases by aimag • Understanding the data: • iCaseID: Unique internally generated ID • sGender: Gender (M=Male; F=Female; U=Unknown) • sLevel1: Aimag