Analysis of supplied patient data

Intent: This assessment item focuses on the development of data analysis and presentation skills in order to make recommendations that are congruent with contemporary literature.

Objective(s): This assessment task addresses subject learning objective(s):

A, B, D and E

This assessment task contributes to the development of graduate attribute(s):

1.2 and 4.2

Type: Report

Groupwork: Individual

Weight: 50%

Task: You have been engaged as a consultant to the Local Health District (LHD). The LHD governing

council requires you to develop a report based on data from ‘UTS Hospital’ (an Australian public hospital situated in New South Wales) to address issues related to AR-DRGs E69A/B/C ‘Bronchitis& Asthma (with or without comorbidities or complicating diagnoses; in AR-DRG v4.1, also split by age)’. The governing council is primarily interested in the analysis, and expects clear recommendations that apply to, and are implementable by, ‘UTS Hospital’.

  • Locate the UTS Hospital data file from the Data Files folder in UTSOnline.
  • Produce a written report no longer than 2500 words for the LHD council based on the supplieddata (UTS Hospital data file) and the following topic.
  • The report must contain brief background literature, a data analysis strategy, the analysis, andappropriate recommendations that integrate the findings and the background literature.
  • Includes tables or figures as appropriate (for example, to profile the target group or to show comparisons).

 Topic: Asthma & Bronchitis (AR-DRG E69A/B/C)

(Note: there is an issue with this categorisation but that is not in your purview; in-depth discussion of that issue is not necessary)

 A: Background Literature

With reference to Australian and overseas literature, briefly:

  1. Define these AR-DRGs, including the diagnoses usually associated with them

2.Describe the current prevalence & incidence of antenatal admissions to acute hospitals, and any relevant trends

3.Describe approaches used to prevent hospitalisation and decrease length of stay for asthma &bronchitis

B: Analysis

Analyse the UTS Hospital dataset as follows:

Create a profile of patients in AR-DRGs E69a, E69b & E69c

1.1 include both individual and episode characteristics (e.g. age [an individual characteristic]

and length of stay [an episode characteristic], and others you identify in the literature)

1.2 include the proportion of the dataset that these patients comprise

1.3 compare this to a profile of all patients in this dataset

For patients in AR-DRGs E69a, E69b & E69c:

2.1 identify the most common principal and secondary diagnoses

2.2 identify the most common principal and secondary procedures

2.3 compare the length of stay for patients in AR-DRGs E69a, E69b & E69c to patients in related AR-DRGs, and/or the same MDCs

C: Analysis

1.Based primarily on your analyses, but with reference to the literature:

Identify important points in your analyses that might suggest interventions to reduce the incidence of hospitalisation and length of stay in AR-DRGs E69a, E69b & E69c

2.Make specific recommendations to reduce the incidence of hospitalisation and length of stay for patients in AR-DRGs E69a, E69b & E69c


) and referencing

find the cost of your paper