Use the attached Excel worksheet to produce graphs and statistics to answer the questions below. Submit your report as a Word doc and include figures and tables you generate. The report should be easy to follow and interpret and should be written as an academic paper in proper APA formatting.
1. Look at the Excel Spreadsheet attached. There are 3 worksheets (see tabs on bottom of page. The first sheet “Nurse’s Interview” has a line list of employees who work at Flinn Corporation. This sheet represents the data the nurse has collected from those employees in an interview. Do you think that an outbreak exists? Why would you recommend to further investigate? Discuss your reasoning.
2. Research salmonellosis using academic sources. Are the symptoms that the ill employees exhibit consistent with salmonellosis? Provide a brief summary of the disease and discuss the chain of infection for this disease.
3. Identify the percentage of ill employees with each symptom. For example, 1 out of 12 ill employees had blood in stool .
4. Conduct descriptive epidemiology . Describe the characteristics of the ill employees to determine trends and risk factors.
a. Person – Calculate the percentage of ill employees that are male/female. Determine the mean age of the ill employees.
b. Place – What percentage of ill employees ate at the cafeteria? What percentage of well employees ate at the cafeteria?
c. Time – Using the data collected in the Nurse’s Interview, fill in the column “# of cases” in the “Epi Curve” worksheet. Use 0 if there are no cases. As you fill in the data, the graph will automatically generate. Choose an appropriate title for the graph. Copy and paste graph into your report. What type of epidemic curve is it ?
6. Based on your findings, what would you recommend for prevention and control measures? Apply food safety principles from academic sources to discuss further prevention of Salmonella outbreaks in the cafeteria.
