As the world struggles to contain the ever-changing variants of COVID-19, healthcare industry is facing tremendous stress from issues arising from different aspects. One significant issue is on resource allocation and utilization. Building additional hospital facility may not be a viable solution in a land scarce country like Singapore. One long standing problem among resource utilization is due to missed appointments. When patients do not show up following their appointment time, the missed appointment results in a waste of resources that have been scheduled and planned. There has not been good solution in reducing the no-show rates. In some, the rates are not even been tracked or computed.

You are to create a Python-based program that can be useful for healthcare industry in tackling this issue. This program is a prototype or proof-of-concept to path the implementation for subsequent development solution to be integrated to the existing system. You are given a sample dataset to start with. It comes with past records of patients who show-up or did not show-up for the appointment in a clinic. You can use it as a start, to develop a suitable solution to provide insights to healthcare professionals. The solution can be a dashboard, web-based or command prompt program. The objective is to apply what you have learnt in this course into this problem domain.

The following table displays the first 5 records from the attached dataset “appointmentData.csv”. It includes the age and gender information of patients. Followed by the time they registered for the appointment and the appointment time details. The day name of appointment is reflected. The other details like their health condition, and other relevant features are also captured. The last column “Show Up” denotes if the patient shows up for the medical appointment.


Below are some questions you can try to answer or features you can try to include, you can address one or more of the following or suggest other relevant questions:

  1.     How is the overall picture of no shows over the period?
  2.     No-show made up of how many percent of the given data?
  3.     What kind of people or age group likely to no-show? Or it’s random?
  4.     Does sending reminder helps with reducing no-show?
  5.     Provide appropriate dashboard or visualization features to summarize the given data set for viewing.
  6.     Suggest or implement suitable features that can help with reducing no-show or highlight patients more likely to no-show with additional reminders or etc?

Alternatively, you can look for additional dataset that can help with understanding or tackling this issue or for better resource planning in healthcare. For example, the healthcare resources data, infection rates, chronic disease rates etc. You can make assumptions on information not stated in this requirements, or target a certain specialist clinic.

All work must be done in the Python programming language.

Prepare a zip file (in .zip format only) containing the relevant deliverables below:

  • Report: One word or pdf file containing the proof-of-concept prototype with the following content:
    — Work/responsibility distribution. Which team members in charge of which part of the program.
    — Objective of the project and how it addresses the issue.
    — Features/Functionalities designed for the prototype.
    — User manual with print screens from the prototype to illustrate how to use this project’s program; consider different user roles.
    — Include the links to recording, i,e. the hyperlinks to every group member’s individual recorded videos. Do not submit video files, submit only hyperlink.
  • One folder containing additional dataset (if any), all working files.

One group submit one copy of the above. Submission box will be opened in Week 11. All works submitted will go through plagiarism checker. Submitting work done by others will result in failing the module directly.

No presentation nor lesson on week 13, you are to prepare the recording beforehand and submit before due date. Recording replaces class presentation. The duration of each group member’s individual recording should be about 2 to 3 minutes maximum. You are advised to adhere to the time limit strictly or penalty will be imposed. In the individual video, you are required to reflect on your contribution to the group project, what you have done for the project, what have you learnt from the project. Each group member will record his/her own video and ensure that the hyperlink to the video is included on the first page of the report submitted by the group. You can use Zoom, Teams or YouTube for recording. If you use other software to record into mp4 file, upload online to Youtube, OneDrive or other cloud storage (Do not submit video files). In the case of Youtube, indicate as restricted, and submit only the link information. Include the link information (one link for each team member) in your report.

You are required to submit a peer evaluation form online individually at the end of the semester.
Individual peer evaluation submission is compulsory for all team members. An online peer evaluation system will be opened nearer to the submission date.

Good project outcome is the end product of good teamwork. We hope to see all team members contribute equally. The peer evaluation will be considered in evaluating the project grade should the contribution be significantly unequal. Submission will be kept confidential.

Due Date:
Week 13 Wednesday (13 Apr 2022, 7 p.m.)

Zoom Recording:
Registering your NTU Zoom account (If you have not done so. Quick Start Guide for NTU Zoom Account.pdf)
Zoom Login & Create Meeting (See Quick Start Guide for Online Meetings with Zoom.pdf)
Video Guide on Recording
Teams Recording:
Zoom Login & Create Meeting (See Quick Start Guide for Online Meetings with Zoom.pdf)
Online Guide on Recording: https://support.microsoft.com/en-us/office/record-a-meeting-in-teams-34dfbe7f-b07d-4a27-b4c6-de62f1348c24


View Github