Analyze CLABSI Data

Scenario
For this scenario, you must do some role play. You need to identify and explore a local hospital that will serve as your hospital. In your hospital, you will be working as a DNP leader. Your hospital’s advisory board comprises persons from the community—one of whom has a background in a medical field. One of the board members has discovered Hospital Compare, and the other board members are curious to learn more. As the DNP leader in your organization, the board has asked you to present information regarding CLABSI at your hospital.
To prepare for your summary presentation, you will be using the huge dataset found at data.medicare.gov. (Links to an external site.) After you have oriented yourself to this dataset, complete the following steps.
Professor’s Tips
If you need additional tutorials try these:
Microsoft Office Support (Links to an external site.)
How to Download and View Data (Links to an external site.)
Assignment Guidelines
Note: Problem-solving is a fundamental skill in finding and appraising data. Because the data for this assignment is hosted by a third party, content updates occur without notice. The instructions provided in this assignment may differ from what you see on the website. You are encouraged to lean into the uncertainty and find what you’re looking for in inventive and thoughtful ways.
Step I: Gather Data
Go to data.medicare.gov (Links to an external site.).
Search “Healthcare Associated Infections—Hospital” using the search bar. Then select the first result. (OR download CSV and use excel to find this information).
Select Toggle Fullscreen to enlarge the data set.
Use the search bar beneath Faculty Name to search for the hospital of your choice.
Use the search bar beneath City to search for the city of your choice. (Florida, MIAMI)
Use the Measure ID column to locate the Measure ID and Measure Name for Central Line-Associated Bloodstream Infection (ICU + select Wards) (CLABSI).
Utilize the horizontal scroll bar and the Previous/Next buttons to view the entire data set as needed.
Step II: Present the Data
Using the data you have gathered, create a PowerPoint presentation with the following information:
Name and location of the institution
The number of observed cases of Central Line Associated Bloodstream Infection (ICU + select Wards) (CLABSI)
The measure start dates and end dates that the data was collected. (Note: You may have to expand the column width to see the dates.)
List the scores for the following Central Line Associated Bloodstream Infection (ICU + select Wards) Measure ID names:
Central Line Associated Bloodstream Infection (ICU + select Wards):
Lower Confidence Limit or HAI-1-CI-LOWER
Upper Confidence Limit or HAI-1-CI-UPPER
Number of Device days or HAI-1 DOPC days Score
Predicted case or HAI-1-ELIGCASES (denominator)
Observed cases or HAI-1-NUMERATOR
Standardized Infraction Ratio or HAI-1-SIR
Of the six HAI IDs, how did your institution score on the HAI IDs? (Were any in the worse category for benchmarking)?
Go back to the large data set:
How many Hospitals reported data to the CMS? Use the sort and filter to determine this information
How many institutions are “Worse than National Benchmark” for central line-associated bloodstream infections (CLABSIs)? Use the multiple custom sort and filter to determine this information. Add multiple levels of sort to narrow down the list.
Formatting and Mechanics
For this assignment, turn in the following to the Assignment tab:
The PPT with the above-listed data
A sorted and filtered Excel file with only the data for your chosen institution (six rows of data).

Last Completed Projects