1 / 6

Norwegian Disease Surveillance Data Analysis Exercise

Analyze Norwegian disease surveillance data sets using Excel pivot tables, create graphs, and present findings in PowerPoint. Learn about campylobacteriosis, shigellosis, hepatitis A, malaria, and meningococcal disease trends from 1981 to 2005.

kiayada-rios
Télécharger la présentation

Norwegian Disease Surveillance Data Analysis Exercise

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. Introduction tosurveillance data exercise Preben Aavitsland

  2. Contents • Analyse data sets from the Norwegian Surveillance System (MSIS) • Excel pivot table functions and graphics • Present important features of the disease in PowerPoint • time trend, seasonal trend • place characteristics (place of living and place of infection) • person characteristics (age, sex, place of birth)

  3. Topics • A Campylobacteriosis in Norway 1981 – 2005 • File CAMP.xls • B Shigellosis in Norway 1981 – 2005 • File SHIG.xls • C Hepatitis A in Norway 1981 – 2005 • File HEPA.xlx • DMalaria in Norway 1981 – 2005 • File MALA.xls • E Meningococcal disease in Norway 1981 – 2005 • File MENO.xls Real (but anonymised) data sets from Norway

  4. Learning objectives • Understand the structure of a surveillance database • Master the use of Excel pivot tables to analyse surveillance data • Create tables and graphs for presenting surveillance data • Analyse surveillance data by time, place and person • Present surveillance data

  5. Outcome and presentation Produce a PowerPoint presentation using template: • Title slide • Disease and setting • Surveillance system (provided) • Time trends (for example long term trends, seasonal variation) • Place characteristics (for example place of residence, place of infection) • Person characteristics (for example age and sex, place of birth) • Other features • Discussion • Conclusion

  6. Database in Excel • Record = one line = one disease event • Variable (or field) = one column = one charatersitic of the event • Value = content of a field • File specification = explanation of variables and values

More Related