Assignment: Incident Report Data Analysis Project
Use the nursing home fall incident data provided to complete the following assignment:
- Calculate total falls: Using a formula, show the total number of falls for each block of time. Show these values in the shaded cells in row #124 of the spreadsheet. The formula used to calculate each total should be embedded in each cell.
- Calculate the total and percentage of falls for each nursing shift: Calculate the total number of falls and percentages of falls for each severity level. Show these values in the shaded cells in rows 2, 3 and 4, columns S & P of the spreadsheet. The formula used to calculate each total should be embedded in each cell.
- Graph results: Create two graphs: one displaying the total number falls for each block of time and a second displaying the total number of falls for each nursing shift. Be sure to choose a graph type that will enable you and a viewer to easily compare the number of falls in each time period and shift. Title your graphs and include clear and meaningful labels.
- Calculate the total and percentage of falls for each severity level: Sort the data by severity. Calculate the total number of falls and percentages of falls for each severity level. Show these values in the shaded cells in rows 7 and 8, columns S & T of the spreadsheet. The formula used to calculate each total should be embedded in each cell.
- Graph Results: Create a graph that effectively displays the percentages of each type of fall. Be sure to title and label your graph appropriately.
- Identify Patterns: Analyze the data. What patterns or trends can you identify from the data analysis and visualizations?
- Summarize your findings: Create a short written report summarizing your findings and discussing any interesting patterns or trends in the data. Embed your graphs in the summary as appropriate to help illustrate your findings.
- Use Data to Inform Practice: Conclude your report with a paragraph recommending next steps. Based on your analysis, how might you use this data to inform nursing practice to reduce falls in the patient care environment? Are there any patterns or trends that may suggest the need for a quality improvement effort? What additional data would you want to gather and analyze to further assess the situation and target improvement interventions?
Submit two documents:
- Excel workbook, including the calculations on sheet one and graphs on sheets two and three.
- A Microsoft Word document with your report related to items 7 & 8 above. Your document may be as long as needed to answer the questions thoroughly and succinctly and may include references. There is no need for references for this assignment, but please include a cover sheet per APA guidelines.
- Please name both documents as follows: YourLastName_DataIncidentProject
