Difference between revisions of "ANLY482 AY2017-18T2 Group19 Project Overview"

From Analytics Practicum
Jump to navigation Jump to search
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
<!--Logo-->
 
<!--Logo-->
[[Image:G19_logo.png|center|748x116px]]<br>
+
[[Image:G19_Logo.png|center|800x150px|link=ANLY482 AY2017-18T2 Group19]]<br>
  
 
<!--Navbar Start-->
 
<!--Navbar Start-->
Line 53: Line 53:
  
  
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>SPONSOR INTRODUCTION</u></font></div>
+
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>PROJECT INTRODUCTION AND OBJECTIVES</u></font></div>
  
Fujitsu-SMU Urban Computing and Engineering (UNiCEN) Corp. Lab is part of the Urban Computing & Engineering Centre of Excellence (CoE), a Public-Private Partnership between Agency for Science, Technology and Research (A*STAR), Fujitsu Limited (Fujitsu) and Singapore Management University (SMU) established on 15 Oct 2014. UNiCEN focuses mainly on two research areas, namely Dynamic Mobility Management (DMM) and Maritime & Port Optimisation (MPO). These two areas place emphasis on solving problems associated with crowds, congestion and queues, and resource management.
+
SMU libraries’ mission includes possessing the capability in providing seamless access to information using innovative and leading-edge technology. They are committed to delivering exceptional services and building dynamic relationships with the SMU community. As such, they are constantly seeking out ways in which they can improve users’ experience in the libraries. Experience is derived not only in terms of the provision of space for users to study in, but also in terms of the quality of materials available to the users. This project focuses on the provision of printed course reserve materials by analysing the sufficiency of the loan periods assigned. A poor choice of loan period will result not only in dissatisfaction on the part of the library’s patrons, but also in increased costs for the library such as those resulting from increased record keeping.  
  
  
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>PROJECT INTRODUCTION</u></font></div>
+
As such, SMU Libraries aim to align its loan policy with the expectations of the undergraduate students such that it would render the loan policy more sufficient for them. From 2016 to 2017, the 2-hour loan policy of course reserve collection was extended to 3 hours long. This paper then aims to investigate if this 1-hour extension in loan policy helped make it more sufficient for the SMU undergraduate students and with these insights found, propose if SMU Libraries should consider the option of extending this 3-hour loan policy by an additional hour.
  
This project aims to provide a staff scheduling and route plan for nurses who are providing routine checkups and other services to the elderly in the comfort of their own homes. We aim to develop an algorithm, taking into consideration the appointment duration, traveling time to the patient’s location and other constraints to optimise the schedule for the nurses. This algorithm will be able to be used by all home health care foundations in the future to help them schedule their nurses efficiently.
+
 
We will build a simple web application to allow the user to upload a csv file of the patients’ locations and prefered appointment time. The system will then run the algorithm which will give a detailed breakdown of the nurses’ schedules. The schedule will include the start and end time for a patient at a location.
+
Analyze the differences between 2016 and 2017 transactions for:
 +
#Frequency of overdue transactions and duration of overdue period
 +
#Frequency of successive borrowings and duration of hours borrowed with successions
  
  
 
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>MOTIVATION</u></font></div>
 
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>MOTIVATION</u></font></div>
  
Singapore is experiencing an aging population, experiencing an increase in median age from 40 to 40.5 years old and 12.4% to 13% for the population aged 65 and above in 2017. This results in an increase in difficulties that the elderly face, such as disabilities or being frail, in order for them to go to a hospital to have their checkup. This may cause discomfort and a less than satisfactory check-up throughout the whole process from going to and from the hospital and thus the need for home healthcare services are increasing.
+
As active users of the library for 4 years, SMU Libraries has consistently been providing us with ample amounts of resources which have helped us greatly throughout our education in SMU. Like our peers, we have been heavily reliant on the resources only available in the library for revisions and homeworks. The course reserve consists of materials that have been classified as compulsory readings by professors, and hence essential for the course itself. Typically, these books are rather expensive, and thus, by providing these resources, SMU Libraries provides a cheaper alternative for us cost-conscious students. We feel eternally grateful to SMU Libraries for providing us with the relevant materials. We eagerly adopted this project as this project allows us an opportunity to give back to SMU Libraries.
Health Minister Gan Kim Yong estimated an increase in 7600 more places in day, home and palliative care by 2020. The current situation may still be acceptable where nurses are given the cases and locations and they will plan it out themselves. However when the number of cases per nurse increases exponentially, the current system may not provide the most efficient services to the patients.  
 
By working on this project, we hope that we are able to maximise the level of satisfaction for the elderly during their check-ups while utilising the nurses efficiently by planning the shortest route to achieve the most number of services in a day.
 
 
 
 
 
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>OBJECTIVES</u></font></div>
 
  
1. Provide an algorithm for the scheduling of staffs that maximises the followings:
 
*Maximizing number of matches of prefered time slots from patients
 
*Maximizing number of revisiting nurses to patients instead of a new nurse each visit
 
*Maximizing utilisation of nurses in a day
 
2. Provide a UI for staffs to see their schedules
 
  
3. Provide dashboard to show the staff utilisation rate, plot out the route of the nurse for the day and inform where they should be at the current time
+
Furthermore, we are able to understand the problems users might have faced during the process of borrowing the course reserves. Hence, we are committed towards analyzing the loan data and ultimately providing useful insights for the library to improve the current policies, and this project has given us the opportunity to do so. Our fellow schoolmates will have a better user experience while the library continues to adhere to its ‘just in time’ access policy.
  
  
 
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>SCOPE OF WORK</u></font></div>
 
<div style="background: #FFFFFF; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 15px;letter-spacing:-0.03em;font-size:16px;id:UT1"><font face='Century Gothic' color=#000000 ><u>SCOPE OF WORK</u></font></div>
  
1. Data Preparation
+
# Data collection  
*Data collection
+
# Data cleaning  
*Data cleaning
+
# Exploration of data
*Exploration of data
+
# Analysis and Testing
2. Model Planning
 
*Problem Definition
 
*Generation of model objective and constraints
 
3. Model Building
 
*Development of algorithm
 
4. Model Evaluation
 
*Model validation
 
*Improvements in model score and per client’s recommendation
 

Latest revision as of 19:35, 15 April 2018

G19 Logo.png


G19 Home.png   HOME

 

G19 Overview Icon.png   PROJECT OVERVIEW

 

G19 Findings Icon.png   PROJECT FINDINGS

 

G19 Management Icon.png   PROJECT MANAGEMENT

 

G19 Documentation Icon.png   DOCUMENTATION

 

G19 To Main Page icon.png   BACK TO MAIN PAGE


 

[[BACKGROUND]]


PROJECT INTRODUCTION AND OBJECTIVES

SMU libraries’ mission includes possessing the capability in providing seamless access to information using innovative and leading-edge technology. They are committed to delivering exceptional services and building dynamic relationships with the SMU community. As such, they are constantly seeking out ways in which they can improve users’ experience in the libraries. Experience is derived not only in terms of the provision of space for users to study in, but also in terms of the quality of materials available to the users. This project focuses on the provision of printed course reserve materials by analysing the sufficiency of the loan periods assigned. A poor choice of loan period will result not only in dissatisfaction on the part of the library’s patrons, but also in increased costs for the library such as those resulting from increased record keeping.


As such, SMU Libraries aim to align its loan policy with the expectations of the undergraduate students such that it would render the loan policy more sufficient for them. From 2016 to 2017, the 2-hour loan policy of course reserve collection was extended to 3 hours long. This paper then aims to investigate if this 1-hour extension in loan policy helped make it more sufficient for the SMU undergraduate students and with these insights found, propose if SMU Libraries should consider the option of extending this 3-hour loan policy by an additional hour.


Analyze the differences between 2016 and 2017 transactions for:

  1. Frequency of overdue transactions and duration of overdue period
  2. Frequency of successive borrowings and duration of hours borrowed with successions


MOTIVATION

As active users of the library for 4 years, SMU Libraries has consistently been providing us with ample amounts of resources which have helped us greatly throughout our education in SMU. Like our peers, we have been heavily reliant on the resources only available in the library for revisions and homeworks. The course reserve consists of materials that have been classified as compulsory readings by professors, and hence essential for the course itself. Typically, these books are rather expensive, and thus, by providing these resources, SMU Libraries provides a cheaper alternative for us cost-conscious students. We feel eternally grateful to SMU Libraries for providing us with the relevant materials. We eagerly adopted this project as this project allows us an opportunity to give back to SMU Libraries.


Furthermore, we are able to understand the problems users might have faced during the process of borrowing the course reserves. Hence, we are committed towards analyzing the loan data and ultimately providing useful insights for the library to improve the current policies, and this project has given us the opportunity to do so. Our fellow schoolmates will have a better user experience while the library continues to adhere to its ‘just in time’ access policy.


SCOPE OF WORK
  1. Data collection
  2. Data cleaning
  3. Exploration of data
  4. Analysis and Testing