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

NUR 752 Assignment 6.1: Patient Outcomes Project Part I: Aggregating and Displaying Data

Introduction

In this two-part assignment, you will be boiling down large amounts of data: to information and to usable knowledge. You will be analyzing data in two ways: First by creating a chart, then by performing aggregate analyses (average, sum, and min/max) on the data. Finally, you will use this information to inform a decision.

Scenario

Your institution has taken an interest in nurse staffing and patient outcomes. On reflection, you believe that your patients seem to have better care when there is a higher percentage of BSN nurses staffed on the skilled nursing unit. You decide to investigate this quality matter by looking at the data.

Assignment Guidelines

You begin your investigation by gathering data from electronic medical records for each month from the last calendar year. You have organized and saved the data in Sheet #1 “Pt Outcomes | BSN” of your Excel file (Links to an external site.).

Displaying Data

  1. Download the Patient Outcomes Project (Excel) (Links to an external site.) file and save it to your computer with your last name in the filename.
  2. Use the data in Sheet #1 “Pt Outcomes | BSN” to develop a run chart showing the percentage of BSNs, the number of falls, and the number of pressure ulcers. Use a style 2 line graph with the numbers of the vertical axis in the bubbles. (See Example Chart and Bullets (Word) (Links to an external site.).)
  3. Create a new sheet in the file and move the embedded chart to its own tab titled “Monthly Chart.” This will be Sheet 2.

Aggregating Data

  1. Use the appropriate aggregate functions in Excel to determine the average of the % BSNs, as well as the average, sum, min/max for the number of falls, and the number of pressure ulcers.
  2. Document this data on a fourth tab titled “Descriptive Stats” in the Excel file. Order it so that this sheet is the third sheet of the four.

Formatting and Mechanics

Submit one Excel file with four sheets:

  • Sheet 1: Pt Outcomes | BSN
  • Sheet 2: Monthly Chart
  • Sheet 3: Descriptive Stats
  • Sheet 4: Scores | # BSN (this sheet will be used in the next assignment)

Important Notes:

  • After the submission due date, an answer key will be provided in the Instructor Announcements for you to check your work. Because of this, late work for this assignment will be given a zero.
  • This scenario continues in the next assignment. Save your file so that you can use it again.

Submission

Submit your assignment and review full grading criteria on the Assignment 6.1: Patient Outcomes Project Part I: Aggregating and Displaying Data 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)

In this lesson, you will be analyzing data by creating charts and by performing inferential analyses on the data. You will then create a short presentation of your conclusions.


Learning Outcomes

At the end of this lesson, you will be able to:

  • Employ data management systems for decision-making.
  • Justify management decisions with data.
  • Provide multidisciplinary leadership by analyzing data within healthcare systems.

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 21, “Quality-Improvement Strategies and Essential Tools”

Click here to ORDER an A++ paper from our Verified MASTERS and DOCTORATE WRITERS: NUR 752 Assignment 6.1: Patient Outcomes Project Part I: Aggregating and Displaying Data

NUR 752 Assignment 6.1: Patient Outcomes Project Part I: Aggregating and Displaying Data

NUR 752 Assignment 6.1: Patient Outcomes Project Part I: Aggregating and Displaying Data

Additional Optional Resources:

Consider reading in your optional Nursing Informatics for the Advanced Practice Nurse textbook:

Chapter 24, “Informatics in Management and Quality Improvement”

Consider reading in your optional Excel Bible textbook:

Chapter 20, “Getting Started with Excel Charts”

This chapter covers the basic steps for creating and working with charts in a spreadsheet:

Chapter 16, “Using Formulas for Statistical Analysis”

This chapter has a section describing calculating mean, median, and mode.

Review and reflect on the following in your Nursing Informatics for the Advanced Practice Nurse textbook:

Case Study 1 (pp. 528–529)

This case study exemplifies how analyzing data can lead to strong decisions to improve processes.

Week 6 Patient Outcomes Project Part I Rubric
Criteria Ratings Pts
Run graph (chart)
10 to >9 pts
Meets Expectations (>9 to 10 points)

Run chart with the numbers of the vertical axis in the bubbles. Three lines present.

9 to >7 pts
Nearly Meets Expectations (>7 to 9 points)

Line chart without numbers in the bubbles.

7 to >5 pts
Barely Meets Expectations (>5 to 7 points)

Line chart without bubbles or errors in graph.

5 to >0 pts
Does Not Meet Expectations (0 to 5 points)

Is not a line chart or is missing data.

10 / 10 pts
Descriptive data
10 to >9 pts
Meets Expectations (>9 to 10 points)

Descriptive data is present using the Excel formulas.

9 to >7 pts
Nearly Meets Expectations (>7 to 9 points)

Descriptive data is present, but the formulas from Excel are not present.

7 to >5 pts
Barely Meets Expectations (>5 to 7 points)

Descriptive data is missing one of the six required answers.

5 to >0 pts
Does Not Meet Expectations (0 to 5 points)

More than two of the descriptive data points are not present.

10 / 10 pts
Timeliness
0 pts
20 point deduction

Assignment is late. Maximum point deduction: -20 Points

0 pts
No deduction

Assignment is turned in on time. No point deduction. 0 Points

0 / 0 pts
Total Points: 20
Did you find apk for android? You can find new Free Android Games and apps.
error: