NUR 752 Discussion 4.1: Bongo CLABSI Board Presentation—Part I
NUR 752 Discussion 4.1: Bongo CLABSI Board Presentation—Part I
Overview of Due Dates and Point Values
Item | Due | Value |
---|---|---|
Part I: Bongo Presentation—Deliver Board Presentation | Week 4, Sunday | 40 points |
Part II: Respond with questions to peers’ Board Presentations in Bongo | Week 5, Thursday | 4 points |
Part III: Follow-up Posts—Respond to Questions | Week 5, Sunday | 5 points |
Introduction
This discussion has three parts. You will complete Part I – the presentation – this week. Next week, you will complete Parts II and III. This week’s discussion addresses the Excel competency of sorting and filtering data in a spreadsheet. You will master this skill by manipulating a large database created and secured by Medicare.
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—None of whom has a background in a medical field. One of the board members has discovered Hospital Compare, (Links to an external site.) 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 Central Line-Associated Bloodstream Infection (CLABSI) data from the data set for your hospital.
To prepare for your board presentation, you will be using the huge dataset found at data.medicare.gov (Links to an external site.). Orient yourself to this dataset. The Guide to CMS HAI data may be a helpful resource.
Instructions
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.
- Download the CSV file.
- Use Excel to find the required information.
- Using search, locate your chosen hospital. Searching by City is recommended.
- Use the Measure ID column to locate the Measure ID and Measure Name for Central Line-Associated Bloodstream Infection (ICU + select Wards) (CLABSI).
Step II: Present the Data
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)
- 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) (CLABSI) 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 cases or HAI-1-ELIGCASES (denominator)
- Observed cases or HAI-1-NUMERATOR
- Standardized Infection Ratio or HAI-1-SIR
- Central Line Associated Bloodstream Infection (ICU + select Wards):
- Go back to the large data set:
- Use the sort and filter to determine this information.
- Use the multiple custom sort and filter to determine this information. Add multiple levels of sort to narrow down the list.
- Of the six HAI (CAUTIs, CLABSIs, SSI colon, SSI abdominal IDs, Clostridium Diff, MRSA) how did your institution score on the six HAIs? Were any in the worse category for benchmarking?
- How many Hospitals reported data to the CMS for CLABSIs?
- How many Hospitals are “Worse than National Benchmark” for central line-associated bloodstream infections (CLABSIs)?
Step III: Present to the Board
Initial Post
After creating a PowerPoint, deliver a five-minute presentation to the board using Bongo. Present the numbers and what the numbers represent in relation to the hospital’s goals. Remember the board is your audience.
Next week, be prepared to answer and respond to their written questions and act as the board for your classmates in Parts II and III.
This discussion/presentation will be graded using the Board Presentation Rubric found in your syllabus. Once your work has been graded, go to the gradebook to view instructor feedback (Links to an external site.).
Submission
Post your initial and follow-up responses on the Discussion 4.1: Bongo CLABSI Board Presentation—Part I page.
Week 4: Clinical Decision Support Systems
This week has one lesson: Using CDS Tools in Complex Systems. Activities include readings, a learning module, a discussion, and a written assignment.
Review a list of all items due this week in your course’s syllabus.
Lesson 1: Using CDS Tools in Complex Systems
In this lesson, you will explore a large dataset, analyze aggregate health data using Excel, and present your findings using CDS tools.
Learning Outcomes
At the end of this lesson, you will be able to:
- Manage aggregate level information.
- Perform an analysis of aggregate health data.
Before attempting to complete your learning activities for this week, review the following learning materials:
Learning Materials
Read the following in your Nursing Informatics for the Advanced Practice Nurse textbook:
- Chapter 18, “Data Management and Analytics: The Foundations for Improvement”
- Chapter 19, “Clinical Decision Support Systems”
These chapters give you the basis for data management and explain how clinical decision support (CDS) uses strategic systems thinking to create flows that support quality processes.
Review and reflect on the following case study in your Nursing Informatics for the Advanced Practice Nurse textbook:
Chapter 19, Case Study 2: Think Sepsis (pp. 477–479)
This case study exemplifies how strategic thinking via CDS can assist in designing EHR tools to address patient problems.
Additional Readings:
Consider reading in your optional Excel 2019 Bible textbook:
Chapter 14, “Using Formulas for Matching and Lookups”
This chapter will assist you in finding and sorting data in a large database.