Prior to analyzing data for The Summerville County Health Department, look over some over some other local or state surveillance reports or dashboards. What types of data analyses and measures were utilized? Is there any mention of any of the three main components of data quality? Answer the discussion questions and provide a link to this report for other interns
Course Readings -Lee: Ch. 6- Analyzing and Interpreting Public Health Surveillance Data (Lee, L.M., Teutsch, S.M., Thacker, S.B., St. Louis, M.E. (2010) Principles & Practice of Public Health Surveillance (3rd Ed.). New York, NY: Oxford University Press.)
-Lesson 2 Summarizing Data and Lesson 3 Measures of Risk Centers for Disease Control and Prevention. (2011). Principles of Epidemiology in Public Health Practice, an Introduction to Applied Epidemiology and Biostatistics (3rd Ed.). Retrieved from: https://www.cdc.gov/csels/dsepd/ss1978/index.html
-The resources below will assist you in better understanding the concepts covered in this module as well as assist you in preparing your surveillance report: Improving Data Quality: A Guide for Developing Countries (WHO) Download Improving Data Quality: A Guide for Developing Countries (WHO) This is a good reference that provides a good overview of data quality throughout the surveillance process. Excel References and Training This page contains several Excel references and training videos to assist you in analyzing your data. Excel Analysis Basics for Surveillance (Dr. Cervantes) (Links to an external site.) In this short video presentation, Dr. Cervantes goes over the basics of Excel data clean-up and analysis you will perform for your surveillance report. Excel Formulas & Tutorial Template Download Excel Formulas & Tutorial Template This is a nice Excel document that provides you excellent formulas you can practice with and edit to use for your surveillance report VLOOKUP Refresher Card Download VLOOKUP Refresher Card Good resource once with a break down of the VLOOKUP command and how to use it
For This or a Similar Paper Click Here To Order Now
