Labeled Environment Questions Utica College Crea

By /

Labeled Environment Questions Utica College Crea

The main part of the assignment is to create a spreadsheet

Homework B Directions

Background

  • You are the supervisor of three nursing units in a hospital that just opened last year. It is now one year later and the units have been open for one full year. You are looking at the HCAHPS (Hospital Consumer Assessment of Healthcare Providers and Systems) Scores for your units for the last 4 quarters (year) to see if you can determine a pattern. The data was collected by the administrative team where you work from surveys administered to patients upon discharge.
  • You have data for Questions 1-9 for your units by quarter. (See questions below) You want to do something on each unit to raise the scores but you need to analyze the data first to see what the root causes of any issues are. You decide to put this data in a spreadsheet in order to better analyze the information by calculating the average (mean) score for each question for each unit and by calculating the average (mean) score for each quarter for each unit.
  • Your ultimate goal is to implement an intervention tailored to each unit’s needs in order to raise the scores.
  • All data cell computations should be centered and 1 placement right of the decimal.

Spreadsheet Creation and Formatting

  1. Create A Spreadsheet (see Example of Chart Format below)
    1. Make a spreadsheet in Excel of the data provided where the quarters are the rows and the columns show you the questions and center your column labels in the cells (Be sure to label the questions as Q1, Q2, Q3, etc. NOT 1, 2, 3, etc.).
    2. Subdivide the questions and label them as the following: 1-4 are labeled as “Nurse Questions”, 5-7 are labeled “Physician Questions” and 8 & 9 are labeled “Environment Questions”.
    3. Input the mean score data into the Question/Quarter cells and center the data in the cells
  2. Calculate Values (Be sure to center these values within the cells and choose a format that uses number format and one decimal place.)
    1. Use the formula function in Excel to calculate the mean score for each unit for each quarter row
    2. Use the formula function in Excel to calculate the overall mean of the question columns
    3. Use the formula function in Excel to calculate the average for the unit overall.
  3. Apply Cell Attributes

Bold and Italics

    • Apply the “Bold” attribute to the first column (Quarters), Mean Column for each unit, the top three rows (Units, Category, Questions), and bottom row (Means).
    • Apply italics to the Category column headings (i.e. Nurse Questions, Physician Questions, etc.).

Lines and Shading

    • Apply dark shading to the top row (unit names) and the individual cells that contain the overall unit mean (bottom right cell for each unit).
    • Apply lighter shading to the “Category and “Quarter/Questions” rows.
    • Apply a double line as an outline border and single line as inside lines

Font Size

    • Change the font to Calibri 14 point for the top row (unit names) and “Category” and “Quarter” cells

and the “Mean” cell at the bottom of the first Column.

    • All other cells should be Calibri 11 point.
  1. Create three Charts
    1. Create a bar chart in Excel for each unit showing the mean score for each individual question
    2. Be sure that the correct variable names appear on the X-axis (e.g. Q1, Q2, Q3, etc.)
    3. Be sure that the Y-axis has the same range for all three charts
    4. Change the indicator bars to a different color for each unit (Blue – Oncology, Green – Stroke Unit, Brown – Geriatric unit)
    5. Properly label each axis so the X and Y titles are clearly identified as “Mean Score” and “Question”.
    6. Add a title to the top of each chart (within the chart frame) to show the name of the unit.