Data Skills Analysis

NW Kent Group of Medical Practice operates three medical Centres in rural Kent –
Kirkwood Medical Centre, Broadleaf Medical Centre, and Sycamore Medical Centre.
Each medical centre has over 5,000 patients with Broadleaf being the largest with
9,500 patients. You are employed as the Practice Manager for the NW Kent Group
of Medical Practice and as such attends the monthly management meetings of the
The NW Kent Group of Medical Practice is a partnership comprising of four doctors.
Two of the partners practice medicine at Broadleaf Medical Centre, while
Kirkwood and Sycamore Medical Centre has one partner each. At their last monthly
meeting, the partners at NW Kent Group of Medical Practice expressed a desire to
investigate an increase in the number of patients’ complaints levied against NW
Kent Group of Medical Practice. You were asked to investigate the three medical
centres to determine which of the three medical centres, if any, can be used as a
model for the others. The results of which is hoped to be used to make positive
changes within NW Kent Group of Medical Practice.
To achieve this, you used a questionnaire to collect data during the two months
ending August 2020. You also received data regarding complaints made by patients
from each of the three medical centres.
Examine the tables of data for the three medical centres. This data appears on the
VLE in the folder marked “ASSIGNMENT – NW Kent Group of Medical Practice
The two data files consist of:

  1. Medical Centre Data – Complaints Received. A spreadsheet that shows the
    number of complaints received at each medical centre.
  2. Medical Centre Data – Patient Survey Results. A spreadsheet showing
    details from Patient Surveys run across the three medical centres taken in
    July and August 2020.
    You need to examine this data and then create a small data portfolio (no more
    than 1,000 words) that explains which medical centre you would recommend to be
    the model medical centre, and areas of best practice that can be used in
    redesigning the business model for NW Kent Group of Medical Practice.
    Using the data, create a briefing document that explains which medical centre is
    your preferred choice.
    4 | P a g e
     You will want to think about the different things that you have learned on
    the module. Look back at different topics that you have covered and
    consider how you might apply those ideas to the data.
     Write the briefing document as though you are addressing the four partners:
     Dr James Dawkins
     Dr Michelle Francis
     Dr Stephen Greaves
     Dr Chloe Jackson
     You may use visual methods, such as creating graphs, charts 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 and charts but it
    is possible to pass the assignment without doing so).

Sample Solution