As part of the medical insurance package, your company may receive a discount if they require their employees to use a particular hospital for any treatment or procedures that they have to undergo.

ASSIGMENT BRIEF

DATA SKILLS PORTOFOLIO

Portfolio assignment

In this assessment, you work for a large company based in the United States who wish to provide medical insurance for your employees.

The Financial Director, Paula Lane, has narrowed the choice down to three hospitals in the area: Meadowfield, Brightly and Tiverton.

The Financial Director has asked you to look at some data that he has acquired from an official government source that relates to the three hospitals. Each hospital is the same size, has the same number of staff, and sees roughly the same number of patients each year.

• Meadowfield and Brightly offer a 15% discount if you choose them.

• Tiverton hospital only offers a 5% discount.

Task

Examine the tables of data for the three hospitals. This data appears on the VLE in the folder marked “ASSIGNMENT – HOSPITAL DATA.”

The two data files consist of:

1. Hospital Data – Complaints Received. A spreadsheet that shows the number of complaints received at each hospital in relation to major medical procedures in 2018.

1. Hospital Data – Patient Survey Results. A spreadsheet showing details from Patient Surveys run across the three hospitals taken in 2018.

You need to examine this data and then create a small data portfolio (no more than 1,000 words) that explains which hospital you would recommend your company to choose for its employees to use.

Using the data, create a briefing document that explains which hospital is your preferred choice

• Write the briefing document as though you are addressing the Financial Director at your company

• You need to use visual methods, such as creating graphs or putting the data into different tables, to help to demonstrate your findings if you wish to (you may earn additional marks for use of tables, graphs etc.

• You need to indicate the source of the information in your writing.

• They key to scoring good marks in this assessment is looking at the numbers and explaining what they mean

NB: Numerical information given in tables is not included in the word count.

Sample Answer

Briefing Document for Hospital Selection

To: Paula Lane, Financial Director
Subject: Recommendation for Preferred Hospital Provider Based on 2018 Data

Introduction

As requested, I have analysed the 2018 data from the official government sources provided, which compare three potential hospitals: Meadowfield, Brightly, and Tiverton. The analysis is based on two key datasets:

1. Complaints Received by Procedure Type

2. Patient Survey Results

All three hospitals are similar in size, staffing, and patient volume, which allows for a fair comparison. This report evaluates the performance of each hospital, combining both quantitative findings and qualitative implications, with the objective of selecting the most appropriate hospital for our employees’ healthcare needs while considering both service quality and cost-efficiency.

Part 1: Complaints Data Analysis

The 2018 complaints data outlines the number of complaints received per hospital in key procedure areas such as General Surgery, Cardiology, Maternity, and Orthopaedics.

Total Complaints by Hospital

From the table above, Tiverton has the lowest number of overall complaints, suggesting better patient satisfaction or fewer issues in service delivery.

Complaints by Procedure Type 

Across procedures:

• Tiverton consistently shows fewer complaints in General Surgery and Cardiology.

• Brightly shows higher complaints in Maternity but performs well in Orthopaedics.

• Meadowfield has the highest complaint numbers across three out of four categories.

Conclusion: On complaints alone, Tiverton performs best overall, indicating a stronger track record in patient outcomes and quality of care.

Part 2: Patient Survey Analysis

This dataset measures patient satisfaction across five metrics:

• Cleanliness

• Staff Friendliness

• Wait Times

• Communication

• Overall Experience

Average Ratings (Out of 5)

• Tiverton leads in all five categories, suggesting higher patient satisfaction and better hospital culture.

• Brightly performs better than Meadowfield across all categories.

• Meadowfield consistently ranks the lowest, especially on communication and wait times.

Conclusion: Patient-reported experience strongly supports Tiverton as the best-performing hospital.

Continued...