Want create site? With Free visual composer you can do it easy.

NUR 752 Discussion 4.1: Bongo CLABSI Board Presentation—Part I

Overview of Due Dates and Point Values

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


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.


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.


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

  1. Go to data.medicare.gov (Links to an external site.).
  2. Search “Healthcare Associated Infections—Hospital” using the search bar.
  3. Download the CSV file.
  4. Use Excel to find the required information.
  5. Using search, locate your chosen hospital. Searching by City is recommended.
  6. 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
  • 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.).

Click here to ORDER an A++ paper from our Verified MASTERS and DOCTORATE WRITERS: NUR 752 Discussion 4.1: Bongo CLABSI Board Presentation—Part I

NUR 752 Discussion 4.1: Bongo CLABSI Board Presentation—Part I

NUR 752 Discussion 4.1: Bongo CLABSI Board Presentation—Part I


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.

Learn Pivot Tables in 6 Minutes Transcript

This lesson is on pivot tables. So pivot tables automatically summarize your data for you. So you can slice and dice it in a million different ways. So you can forget about creating lots of summary calculations. You don’t need them. You can let Excel do the work for you.

So we’re looking at our order sheet here in our sample file. The first thing that we might want to do is take a look at what we might be interested in knowing, how we might want to summarize this data. An example is we might want to know sales or quantity by product number. Now what we can do is we can go over to the insert tab and click either the blank pivot table option or recommended pivot tables. We’ll start with recommended pivot tables just so you can see what that looks like. So what Excel does in the popup that appears is give you a few different options for how you might want to summarize the data.

So this is an example, sum of unit price by product number. We might not be as interested in that. Here’s another one. Sum of total costs by order category, that’s a little more useful. But what we want to do is actually start with a blank pivot table so you can see how to do that. So we’ll go back to the insert tab and click on pivot table. A pop up appears that basically asks us if we want to insert this into a new worksheet or an existing worksheet. We’ll just click okay.

And then this is what appears, a new sheet. And then what you’ll see on the left hand side, which is highlighted here, your blank pivot table space. And then what you’ll see on the right hand side is your list of fields in the original table, and then areas on your pivot table. So you’ve got filters, columns, rows, and values. To see how this works, the first thing that we’ll want to do, we can try to do, is just select or check the total costs button. And what this is going to do is move that total costs field over to the values area. And in our pivot table you can see that all it’s doing is just summing all of the total costs in the previous sheet.

Now to add some dimension to our pivot table, what we may want to do is, let’s actually take the order category and we’re going to move that to rows. So what this is going to do now is put the order categories in the rows and tell us how many costs or how many sales we have for each of those order categories. So it’s just a way to slice that data up for us. We’re not actually summarizing order category, we’re just using that to break up our sales. We can also move it over to columns, too. It just kind of depends on how you’d visually like to see it.

What we’re going to do now is uncheck order category and maybe we want to see costs by product number. So we’ll drag product number down to the rows. And now what we’ll see is it’s taken that total cost column and broken up those costs by product number. Okay. What we’re going to do now is just clear our table. We’ll start fresh, and we’re going to take a look at quantity now. So we can check quantity. That’s going to move it over to the values field and what it’s going to do now is sum all of the quantity that we’ve sold. We can take our product number, drag that down to the rows. And now what it’s going to do is tell us the quantity that we’ve sold by product number, because we’ve got product number in the rows and our quantity is in the value section.

Okay. One thing that we can do, too, is add an additional field into our rows area. And we’ll put order category right before the product number. And what this is going to do now is group or separate our quantity sold by the order category and then by the product. Just another way, again, to slice up our data. And you can actually add as many fields as you want to that row area and it’ll just continue to break out those slices.

What we can also do, too, is move over that order category to the columns. So we’ve got our product numbers in the rows and our order categories in the columns. So this will tell us, not only by product number but also by order category, how many we’ve sold. What I think is helpful is if you just start, moving things around, dragging and dropping to see how it looks in different ways. We can also move order category over to the filter section. So this allows us to filter our quantity sold by order category. So we’ll just select multiple items, uncheck everything. And then we want to take a look maybe at small and normal orders. So this will filter down all of our quantity sold by small and normal orders, and then by product numbers in those rows. So you can start to see how many different ways there are to start exploring your data.

Okay, so we’re actually going to put order category back into the rows so you can see quantity sold by order category and then by product. And we’re actually going to change our headers here just to make it a little bit easier for folks to read. We change it to quantity sold on the right and then we’ll change this to products on the left. Just so when folks read this, they can make sense of it.

What we can do, also, is go to the design tab and it gives us different options to format our pivot table. So it makes it a little bit easier to read. And so we’ll try this option here. Pretties it up for us. And another thing that we can do, is we can right click the values and then sort it by largest to smallest. So we might want to see within eac

Did you find apk for android? You can find new Free Android Games and apps.