Create a pivot table, an active surveillance, in Excel to identify adverse events related to flu vaccine. I need to come up with a background information, indicate the goals of the surveillance and data management then decide what information you need to have in order to do the surveillance then create a worksheet using a Pivot table.
Epidemiological data and operational information about outbreaks is dynamic and changes rapidly. I have to develop a comprehensive Event Management System to manage critical information about an outbreak using. This is one method to ensure accurate and timely communications between key public health professionals and the community. I have to use one of the field below
Active Surveillance
Case management
Emergency Response
Safe Drinking Water
Food
Environmental
Laboratory
Features of the data management system created should include:
1. A background of the investigation (from a health center network or one created by you -this needs to have the known agent, descriptive case, etc.)
2. An Excel workbook of a database chosen or created.
3. Formulas and Charts of the investigation.
4. Pivot Table Reports.