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

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.
• 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)

2. 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.

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

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.

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

Select Grader