Introduction to surveillance data exercise
Download
1 / 6

Introduction to surveillance data exercise - PowerPoint PPT Presentation


  • 65 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Introduction to surveillance data exercise' - kiayada-rios


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
Introduction to surveillance data exercise

Introduction tosurveillance data exercise

Preben Aavitsland


Contents
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)


Topics
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


Learning objectives
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


Outcome and presentation
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


Database in excel
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


ad