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
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:
- 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
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
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