Difference between revisions of "Graduates"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
 
(12 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
<!--Body-->
+
<div style="margin-bottom:30px;">[[File:SMU.png|200px|frameless|center]]</div>
−
==<div style="background:#121f29; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px;font-weight: bold; font-family:Agency FB; "><font color= #CC9900><center>Overview</center></font></div>==
 
−
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
 
−
Every two years, SMU Libraries conduct a comprehensive survey in which faculty, students and staff have the opportunity to rate various aspects of SMU library's services. The survey provides SMU libraries with input to help enhance existing services and to anticipate emerging needs of SMU faculty, students and staff. The latest survey is currently on going and will be ended by 17th February 2020.
 
−
 
 
−
The past reports are mainly made-up of pages of tables, which are very difficult to comprehend. In view of this, your task is to apply appropriate data visualisation to transform these tables into visual representation that allow SMU libraries to gain useful insights.
 
−
</div>
 
−
 
 
−
==<div style="background:#121f29; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px;font-weight: bold; font-family:Agency FB; "><font color= #CC9900><center>Data Cleaning & Preparation</center></font></div>==
 
−
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
 
−
'''About'''</br>
 
−
An overview of the library 2018 survey results found that there are 2638 respondents in total that responded to various parts of the 83 survey questions with respect to the performance and importance level of the library and other general questions to understand the patron's sentiments of the SMU Library. Here is the breakdown of the users that frequent the SMU library</br>
 
−
[[File:Spread.png|400px|frameless|center]]
 
−
<center>''Figure 1''</center></br>
 
−
 
 
−
As seen from figure 1, predominantly, most of the survey respondents comes from undergraduates with some from other areas such as graduates, faculty, staff and others. In order to gain more insights from the survey results, we will first do some pre-processing and cleaning of the data. </br>
 
−
 
 
−
'''Cleaning'''</br>
 
−
{| class="wikitable" style="margin-left: auto; margin-right: auto; width: 100%;
 
−
|-
 
−
! style="font-family:Agency FB; font-weight: bold;background: #00ffd5;color: #121f29;width: 5%;font-size:18px;" |Step
 
−
! style="font-family:Agency FB; font-weight: bold;background: #273746;color: #00ffd5;width: 50%;font-size:18px;" |Screen shot
 
−
! style="font-family:Agency FB; font-weight: bold;background: #273746;color: #CC9900;width: 45%;font-size:18px;" |Explanation
 
−
|-
 
−
| <center>1
 
−
|
 
−
[[File:Dataset.png|600px|frameless|center]]
 
−
<center>''Img 1''
 
−
[[File:Legend.png|600px|frameless|center]]
 
−
<center>''Img 2''
 
−
|
 
−
*Based on the initial dataset given, the datset is aggregated by values for various fields as seen from img 1. The column names are labelled by its code number and there is no name given in the raw data. The given names are represented in img 2 where the labelling of each code are given in the legend.
 
−
*To re-label the data into a readable dataset for users to further analyse, we will then process the data and labelling through excel.
 
−
|-
 
−
|<center>2
 
−
|
 
−
[[File:Cleaned - Data.png|600px|frameless|center]]
 
−
<center>''Img 3
 
−
|
 
−
* Through using lookup and concatenate function, we can combine the id code and the name into the column headers. We then transfer the values into a new sheet and re-arrange the values such that the general questions are in front as seen in Img 3.
 
−
|-
 
−
| <center>3
 
−
|
 
−
*Insert Image
 
−
|
 
−
*After further inspection of the survey questions, there is 26 survey questions that are irrelevant towards the insights that will be generated later on. The survey questions that fall under the ID code 'NA' to filtered and removed under the 'Datasource' tab.
 
−
|}
 
−
 
 
−
 
 
−
</div>
 
  
 
==<div style="background:#121f29; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-weight: bold; font-family:Agency FB; "><font color= #CC9900><center>Findings</center></font></div>==
 
==<div style="background:#121f29; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-weight: bold; font-family:Agency FB; "><font color= #CC9900><center>Findings</center></font></div>==
Line 73: Line 24:
 
[[Faculty|<font color="#CC9900" size=4 face="Agency FB">Faculty</font>]]
 
[[Faculty|<font color="#CC9900" size=4 face="Agency FB">Faculty</font>]]
 
|}  
 
|}  
 +
</div>
  
−
</br>
+
[[File:Graduate.png|800px|frameless|center]]
−
[[File:Graduate.png|700px|frameless|center]]
 
  
 
</br>
 
</br>
−
<center>From the word cloud generated by RStudio, the common words that appear consistently are study, seats, can, find, good, seats, like and many more.  
+
<center>From the word cloud generated by RStudio, the common words that appear consistently are book, area, hour, find, make and many more.  
 
</br>
 
</br>
  
Line 92: Line 43:
 
||
 
||
 
<center>
 
<center>
−
[[File:1.png|700px|frameless|center]]
+
[[File:1 - Graduates.png|800px|frameless|center]]
 
||  
 
||  
−
* Undergraduates generally have equal weightage in terms of performance and importance level of the four groups of questions posed under these criterias.  
+
* Looking at the overall findings for Performance and Importance, generally most metrics perform nearly up to the level of what the Graduates expect of the library.
−
* The only disparity spotted is that undergraduates find that the facilities & equipment are not up to standard as seen by the greater negative sentiment as denoted by the red to yellow area that contrasts between importance and performance.  
+
* One big difference is the variance in the Facilities & Equipment which is similar to undergraduates where the performance level of these group of services fall short of the expectations.
 +
* However, the negative ratings in these group generally comes from the performance of the library services.  
 
|-
 
|-
 
|
 
|
Line 102: Line 54:
 
<center>  
 
<center>  
 
</br>
 
</br>
−
[[File:2..png|700px|frameless|center]]
+
[[File:GraduateAcc - 2.png|800px|frameless|center]]
−
[[File:2(1).png|700px|frameless|center]]
+
[[File:GraduatesAcc - 2(1).png|800px|frameless|center]]
 
</br>
 
</br>
 
</center>
 
</center>
Line 109: Line 61:
 
'''Accountancy''' </br>
 
'''Accountancy''' </br>
 
1. Similarity
 
1. Similarity
−
* In the perspective of the accountancy students, the library performed well when they render '''services''' to users at either libraries as seen by code P13 and I13 under Service Delivery
+
* There is good wireless access in both libraries as seen by the positive green areas from both libraries by the graduate respondents.
−
* Interestingly, the mobile access under Information resource to library resources for I26 and P26 fared the worst comparatively for both LKS and KGC.  
+
* The libraries are lacking in providing ample quiet places in the library to the graduate users in both library.
 +
* The Library workshops are providing sufficient help to graduate users.
 
2. Differences
 
2. Differences
−
*
+
* The items that graduate users constantly look for are often or not missing in LKS as compared to KGC.
 +
* Opening hours of LKS do not meet the requirements of grduate users as compared to KGC.
 +
* Information resources are not as available for graduate users in LKS as compared to KGC.
 +
* Laptop facilities (power,desk) are more readily available in LKS as compared to KGC for graduate users.
 
|-
 
|-
 
|
 
|
Line 119: Line 75:
 
<center>
 
<center>
 
</br>
 
</br>
−
*Insert Image here
+
[[File:3 glaw.png|800px|frameless|center]]
 +
[[File:3(1) - GLaw.png|800px|frameless|center]]
 
</br>
 
</br>
 
||  
 
||  
−
'''Accountancy''' </br>
+
'''Law''' </br>
 
1. Similarity
 
1. Similarity
−
* In the perspective of the accountancy students, the library performed well when they render '''services''' to users at either libraries as seen by code P13 and I13 under Service Delivery
+
* Same as the undergraduates respondents, they face equally good wireless signals in both libraries.
−
* Interestingly, the mobile access under Information resource to library resources for I26 and P26 fared the worst comparatively for both LKS and KGC.  
+
* Both libraries are providing sufficient materials and resources in the library for law graduates.
 +
* Both libraries do not provide sufficient course specific resources online for Law Graduates.
 
2. Differences
 
2. Differences
 +
* The stark contrast in both libaries is that the library hours in LKS meet the graduate requirements as opposed to KGC library.
 +
* Another important point is that computers are not available in KGC to use as opposed to lks.
 +
* The library laptop facilities are better at LKS as opposed to KGC.
 
|-
 
|-
 
|
 
|
Line 133: Line 94:
 
<center>
 
<center>
 
</br>
 
</br>
−
*Insert Image here
+
[[File:GBiz - 4.png|800px|frameless|center]]
 +
[[File:4 (5) 4.png|800px|frameless|center]]
 
</br>
 
</br>
 
||  
 
||  
−
'''Accountancy''' </br>
+
'''Business''' </br>
 
1. Similarity
 
1. Similarity
−
* In the perspective of the accountancy students, the library performed well when they render '''services''' to users at either libraries as seen by code P13 and I13 under Service Delivery
+
* Wireless access to internet is sufficiently adequate in both libraries as feedbacked by business graduates.
−
* Interestingly, the mobile access under Information resource to library resources for I26 and P26 fared the worst comparatively for both LKS and KGC.  
+
* Self-service services are adequately sufficient in both libaries.
 +
* Library staff provides accurate answers to enquiries in both libraries.
 +
* Both libraries do not provide sufficient quiet places and meeting areas to these group of business graduates.
 
2. Differences
 
2. Differences
 +
* The Library signange is not clear in LKS as opposed to KGC.
 +
* Online resources fared better in KGC as opposed to LKS for these group of graduates.
 +
 
|-
 
|-
 
|
 
|
Line 147: Line 114:
 
<center>
 
<center>
 
</br>
 
</br>
−
*Insert Image here
+
[[File:5 - GOthers.png|800px|frameless|center]]
 
</br>
 
</br>
 
||  
 
||  
−
'''Accountancy''' </br>
+
'''Others''' </br>
 
1. Similarity
 
1. Similarity
−
* In the perspective of the accountancy students, the library performed well when they render '''services''' to users at either libraries as seen by code P13 and I13 under Service Delivery
+
* For graduates that indicated others for their school, they generally feedback that LKS website provides sufficient important information online for them to use.
−
* Interestingly, the mobile access under Information resource to library resources for I26 and P26 fared the worst comparatively for both LKS and KGC.  
+
* Library workshops places at a high level for them that the library has done well in LKS.
 +
* The items that they generally look for are not always there.
 
2. Differences
 
2. Differences
 +
* Interestingly, they feedback that they did not have wireless access despite placing a high importance in this area.
 +
* A quiet place can be found in the library as opposed to finding a room to conduct a meeting.
 +
* The opening hours of the library fell short for a few graduates expectations as it performed worse than the importance.
 
|}
 
|}
−
</div>
 
−
 
−
==<div style="background:#121f29; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-weight: bold; font-family:Agency FB; "><font color= #CC9900><center>Revealed Insights</center></font></div>==
 
−
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
 
−
* Insert Text Here
 
−
</div>
 
−
 
−
==<div style="background:#121f29; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-weight: bold; font-family:Agency FB; "><font color= #CC9900><center>Report</center></font></div>==
 
−
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
 
−
*Insert Text Here
 
 
</div>
 
</div>
  
 
<!--Body-->
 
<!--Body-->

Latest revision as of 22:09, 15 March 2020

SMU.png

Findings

Overview

 

Undergraduates

 

Graduates

 

Staff

 

Faculty

Graduate.png


From the word cloud generated by RStudio, the common words that appear consistently are book, area, hour, find, make and many more.


No. Finding Description
1.
1 - Graduates.png
  • Looking at the overall findings for Performance and Importance, generally most metrics perform nearly up to the level of what the Graduates expect of the library.
  • One big difference is the variance in the Facilities & Equipment which is similar to undergraduates where the performance level of these group of services fall short of the expectations.
  • However, the negative ratings in these group generally comes from the performance of the library services.
2.


GraduateAcc - 2.png
GraduatesAcc - 2(1).png

Accountancy
1. Similarity

  • There is good wireless access in both libraries as seen by the positive green areas from both libraries by the graduate respondents.
  • The libraries are lacking in providing ample quiet places in the library to the graduate users in both library.
  • The Library workshops are providing sufficient help to graduate users.

2. Differences

  • The items that graduate users constantly look for are often or not missing in LKS as compared to KGC.
  • Opening hours of LKS do not meet the requirements of grduate users as compared to KGC.
  • Information resources are not as available for graduate users in LKS as compared to KGC.
  • Laptop facilities (power,desk) are more readily available in LKS as compared to KGC for graduate users.
3.


3 glaw.png
3(1) - GLaw.png

Law
1. Similarity

  • Same as the undergraduates respondents, they face equally good wireless signals in both libraries.
  • Both libraries are providing sufficient materials and resources in the library for law graduates.
  • Both libraries do not provide sufficient course specific resources online for Law Graduates.

2. Differences

  • The stark contrast in both libaries is that the library hours in LKS meet the graduate requirements as opposed to KGC library.
  • Another important point is that computers are not available in KGC to use as opposed to lks.
  • The library laptop facilities are better at LKS as opposed to KGC.
4.


GBiz - 4.png
4 (5) 4.png

Business
1. Similarity

  • Wireless access to internet is sufficiently adequate in both libraries as feedbacked by business graduates.
  • Self-service services are adequately sufficient in both libaries.
  • Library staff provides accurate answers to enquiries in both libraries.
  • Both libraries do not provide sufficient quiet places and meeting areas to these group of business graduates.

2. Differences

  • The Library signange is not clear in LKS as opposed to KGC.
  • Online resources fared better in KGC as opposed to LKS for these group of graduates.
5.


5 - GOthers.png

Others
1. Similarity

  • For graduates that indicated others for their school, they generally feedback that LKS website provides sufficient important information online for them to use.
  • Library workshops places at a high level for them that the library has done well in LKS.
  • The items that they generally look for are not always there.

2. Differences

  • Interestingly, they feedback that they did not have wireless access despite placing a high importance in this area.
  • A quiet place can be found in the library as opposed to finding a room to conduct a meeting.
  • The opening hours of the library fell short for a few graduates expectations as it performed worse than the importance.


Retrieved from ‘https://wiki.smu.edu.sg/1920t2is428/index.php?title=Graduates&oldid=3719’