NUR 752 Assignment 6.2: Patient Outcomes Project Part II: Create Knowledge and Conclusions

NUR 752 Assignment 6.2: Patient Outcomes Project Part II: Create Knowledge and Conclusions

NUR 752 Assignment 6.2: Patient Outcomes Project Part II: Create Knowledge and Conclusions

Introduction

In the second part of this two-part assignment, you will use the information you displayed and aggregated in Part I and inferential statistics to inform a decision in Part II.

Assignment Guidelines

Update I: Patient Outcomes Quarterly

After you completed the chart in the Excel file from Part I, the nursing manager expressed to you that it is too cluttered and would prefer it to be organized by quarter, not by month.

1. Use the data in Sheet #1 “Pt Outcomes | BSN” to develop a second run chart, organized by quarter. Use a style 2-line graph with the numbers of the vertical axis in the bubbles. (See Formatting Example Chart and Bullets (PDF)Links to an external site. to see how the chart should look.) Note the following:
   1. This step requires you to sum the data by quarter (and average the % of BSN data by quarter).
   2. This graph will have only four data points for each line.
   3. If you create this new chart with merged cells the bubbles will not have lines connecting them.
2. Insert this new run chart into a Word document.

Update II: Inferential Statistics

As a result of the institution’s interest in staffing and patient outcomes, the nursing manager has created a score using various parameters to measure daily patient outcomes. Note: This is a fictitious score and was created for the purpose of this assignment.

These daily scores are present in your Patient Outcomes Excel file, Sheet 4 “Scores | # BSN”, Column A. Column B contains the number of BSN-prepared nurses who were present on each of the days. You need to determine if the number of BSN-prepared nurses assigned to the unit per shift impacts the daily patient outcomes score, and if so, how much?

You will accomplish this task by taking the following steps:

1. With help from the IHI QI Essential Toolkit Scatter Diagram (PDF)Links to an external site., create a scatterplot for the data on Sheet 4 and save it.
2. Copy this scatterplot to your Word document on page two.
3. Complete a Pearson R test for significance.
4. Use R² (RSQ) to Test for goodness of fit (this test will tell you what percent of the change in outcome scores is accounted for by the number of BSNs).
5. Display the results beneath the chart on page two of the Word document.

Notes

• The data in the scatter plot is not very scattered, the data falls into rows.
• Pearson R is always between 0 and 100%:
  • 0% indicates that the model explains none of the variability of the response data around its mean.
  • 100% indicates that the model explains all the variability of the response data around its mean.
• The function for R² in Excel is RSQ.

(Minitab Blog Editor, 2013Links to an external site.)

Click here to ORDER an A++ paper from our MASTERS and DOCTORATE WRITERS: NUR 752 Assignment 6.2: Patient Outcomes Project Part II: Create Knowledge and Conclusions

Update III: Conclusions—Create Usable Knowledge

• Given the information you obtained from the data, present bullet-points under the scatterplot in the Word document describing

  

  how you would interpret the relationship between the daily scores and the number of BSNs. Do the data in Part I and Part II of this assignment measure the same thing? Do they lead you to the same conclusion?

Formatting and Mechanics

• Use landscape orientation for the page layout.
• Use formatting similar to the presentation example, Formatting Example Chart and Bullets (PDF)Links to an external site., to see how the chart and bullets should look.
• In the Word document, include the revised run displaying quarterly data.
• On page two, insert the scatterplot and a bulleted list.
  1. Include Pearson R and R² in the bullets to support your conclusions.
  2. Present your conclusions.
  3. Present bullet-points, not full sentences and not paragraphs.
• Limit the Word document to two pages.
• Save the Word file.

Submit for Assignment 6.2:

• Two-page Word document with a line graph on page one and a scatter plot and bulleted list with inferential statistics and conclusions on page two.

Submission

Submit your assignment and review full grading criteria on the Assignment 6.2: Patient Outcomes Project Part II: Create Knowledge and Conclusions page.

Week 6: Using Data for Systems Improvement

This week has one lesson: Use of Data to Impact Management Decisions (Excel Skills). Activities include readings, a learning module, a two-part written assignment, and a graph assignment.

Review a list of all items due this week in your course’s syllabus.

Lesson 1: Use of Data to Impact Management Decisions (Excel Skills)