Difference between revisions of "Undergraduates"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
(Created page with "<!--Body--> ==<div style="background:#121f29; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Agency FB; "><font co...")
 
 
(40 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
<div style="margin-bottom:30px;">[[File:SMU.png|200px|frameless|center]]</div>
 +
 
<!--Body-->
 
<!--Body-->
==<div style="background:#121f29; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Agency FB; "><font color= #CC9900><center>Overview</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>==
<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-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-family:Agency FB; "><font color= #CC9900><center>Findings</center></font></div>==
 
 
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
 
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
  
 
{|style="background-color:#343436; color:#4d79ff; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" align="center"|
 
{|style="background-color:#343436; color:#4d79ff; padding: 10 0 10 0;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" align="center"|
| style="padding:0.2em; font-size:100%; background-color:#343436; text-align:center; border-bottom:0px solid #3D9DD7; color:#F5F5F5" width="10%"|  
+
|style="padding:0.2em; font-size:100%; background-color:#343436; text-align:center; color:#F5F5F5" width="10%"|  
 
[[IS428_AY2019-20T2_Assign_KOH_TECK_YUN|<font color="#CC9900" size=4 face="Agency FB">Overview</font>]]
 
[[IS428_AY2019-20T2_Assign_KOH_TECK_YUN|<font color="#CC9900" size=4 face="Agency FB">Overview</font>]]
  
 
| style="background:none;" width="1%" | &nbsp;
 
| style="background:none;" width="1%" | &nbsp;
| style="padding:0.2em; font-size:100%; background-color:#343436;   border-bottom: 5px solid teal" width="100%"; text-align:center; color:#F5F5F5" width="10%" |  
+
| style="padding:0.2em; font-size:100%; background-color:#343436; border-bottom:5px solid #CC9900; text-align:center; color:#F5F5F5" width="10%" |  
 
[[Undergraduates|<font color="#CC9900" size=4 face="Agency FB">Undergraduates</font>]]
 
[[Undergraduates|<font color="#CC9900" size=4 face="Agency FB">Undergraduates</font>]]
  
| style="background:none;" width="1%" | &nbsp;
+
| style="background:none;" width="1%"| &nbsp;
 
| style="padding:0.2em; font-size:100%; background-color:#343436;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" |  
 
| style="padding:0.2em; font-size:100%; background-color:#343436;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" |  
 
[[Graduates|<font color="#CC9900" size=4 face="Agency FB">Graduates</font>]]
 
[[Graduates|<font color="#CC9900" size=4 face="Agency FB">Graduates</font>]]
  
 
| style="background:none;" width="1%" | &nbsp;
 
| style="background:none;" width="1%" | &nbsp;
| style="padding:0.2em; font-size:100%; background-color:#343436; border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" |  
+
| style="padding:0.2em; font-size:100%; background-color:#343436; border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" |
 
[[Staff|<font color="#CC9900" size=4 face="Agency FB">Staff</font>]]
 
[[Staff|<font color="#CC9900" size=4 face="Agency FB">Staff</font>]]
  
Line 73: Line 25:
 
[[Faculty|<font color="#CC9900" size=4 face="Agency FB">Faculty</font>]]
 
[[Faculty|<font color="#CC9900" size=4 face="Agency FB">Faculty</font>]]
 
|}  
 
|}  
 +
</div>
  
* Insert Text Here
+
[[File:Undergraduate.png|700px|frameless|center]]
</div>
 
  
==<div style="background:#121f29; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; font-family:Agency FB; "><font color= #CC9900><center>Revealed Insights</center></font></div>==
+
</br>
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
+
<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.
* Insert Text Here
+
</br>
</div>
 
  
==<div style="background:#121f29; padding-top: 20px; padding-bottom: 20px; line-height: 0.3em; text-indent: 15px; font-size:20px; 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;">
 
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
*Insert Text Here
+
{| 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;" |No.
 +
! style="font-family:Agency FB; font-weight: bold;background: #00ffd5;color: #121f29;width: 55%;font-size:18px;" |Finding
 +
! style="font-family:Agency FB; font-weight: bold;background: #273746;color: #CC9900;width: 40%;font-size:18px;" |Description
 +
|-
 +
|
 +
<center> 1.
 +
||
 +
<center>
 +
[[File:1.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.
 +
* 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.
 +
|-
 +
|
 +
<center> 2.
 +
||
 +
<center>
 +
</br>
 +
[[File:2..png|800px|frameless|center]]
 +
[[File:2(1).png|800px|frameless|center]]
 +
</br>
 +
</center>
 +
||
 +
'''Accountancy''' </br>
 +
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
 +
* Interestingly, the mobile access under Information resource to library resources for I26 and P26 fared the worst comparatively for both LKS and KGC.
 +
* Internet Services are excellent for both Libraries
 +
* Information resources are readily available offline from the Campus library
 +
2. Differences
 +
* '''LKS''' had performed worst than '''KGC''' in terms of the previously mentioned Facilities & Equipment. Overall, there is negative thoughts of the facilities in LKS as compared to KGC
 +
* LKS Performed poorly in providing a room for groups to have meetings and also a quiet place for people to study in.
 +
|-
 +
|
 +
<center> 3.
 +
||
 +
<center>
 +
</br>
 +
[[File:3_-_U(b).png|800px|frameless|center]]
 +
[[File:3(1).png|800px|frameless|center]]
 +
</br>
 +
||
 +
'''Business''' </br>
 +
1. Similarity
 +
* Both '''KGC''' and '''LKS''' have performed well in serving the business undergraduates with both libraries having a relatively well-to-do scoring in the likert scale for service delivery
 +
* Similar with Accountancy undergraduates, business undergraduates are well-connected to the internet service under P18 and I18.
 +
* Both group of undergraduates for either library feedback that there is no need for libraries with both valuing a computer availability as one of the lowest under Facilities & Equipment
 +
* Both business undergraduates feedback that there is no need for library workshops with it ranking dead last for both importance and performance.
 +
2. Differences
 +
* Course specific materials are readily available for KGC library as compared to LKS library
 +
* Opening hours for LKS are better than that of KGC
 +
|-
 +
|
 +
<center> 4.
 +
||
 +
<center>
 +
</br>
 +
[[File:4 - UGEcons.png|800px|frameless|center]]
 +
[[File:4(1) - UGEcons.png|800px|frameless|center]]
 +
</br>
 +
||
 +
'''Economics''' </br>
 +
1. Similarity
 +
* Both group of economics undergraduates found that internet access in both libraries are sufficiently comprehensive due to mostly neutral - positive sentiments under P18 and I18.
 +
* Both groups felt that there is insufficient places to meet in the library as feedbacked under P15 that falls below their expectation of I15.
 +
* Interestingly, the mobile access under Information resource to library resources for I26 and P26 fared the worst comparatively for both LKS and KGC.
 +
2. Differences
 +
* The major difference here is that the access to online resources through mobile and tablet is more accessible in KGC than LKS as seen by the big differen in P26 and I26 for both libraries.
 +
* Library staff assistance fared worst at KGC than LKS
 +
|-
 +
|
 +
<center> 5.
 +
||
 +
<center>
 +
</br>
 +
[[File:5 - UndergradLaw.png|800px|frameless|center]]
 +
[[File:Undergradlaw(1).png|800px|frameless|center]]
 +
</br>
 +
||
 +
'''Law''' </br>
 +
1. Similarity
 +
* Law undergraduates found that both library website are providing useful information for them.
 +
* The printing and scanning services performs below their expectations as seen by P19 and I19
 +
* Both libraries provided able information resources within the library to sustain the undergraduates needs as seen by P20 and I20
 +
* Wireless access generally meets their expectations for both libraries as seen by P18 and I18.
 +
* Opening Hours fall short of their expectations
 +
2. Differences
 +
* One major difference here is the computer availability as seen by the big difference between P16 of both libraries, LKS generally fared better in providing a computer to economics undergraduates
 +
|}
 
</div>
 
</div>
 
 
<!--Body-->
 
<!--Body-->

Latest revision as of 23:44, 15 March 2020

SMU.png

Findings

Overview

 

Undergraduates

 

Graduates

 

Staff

 

Faculty

Undergraduate.png


From the word cloud generated by RStudio, the common words that appear consistently are study, seats, can, find, good, seats, like and many more.


No. Finding Description
1.
1.png
  • Undergraduates generally have equal weightage in terms of performance and importance level of the four groups of questions posed under these criterias.
  • 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.
2.


2..png
2(1).png


Accountancy
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
  • Interestingly, the mobile access under Information resource to library resources for I26 and P26 fared the worst comparatively for both LKS and KGC.
  • Internet Services are excellent for both Libraries
  • Information resources are readily available offline from the Campus library

2. Differences

  • LKS had performed worst than KGC in terms of the previously mentioned Facilities & Equipment. Overall, there is negative thoughts of the facilities in LKS as compared to KGC
  • LKS Performed poorly in providing a room for groups to have meetings and also a quiet place for people to study in.
3.


3 - U(b).png
3(1).png


Business
1. Similarity

  • Both KGC and LKS have performed well in serving the business undergraduates with both libraries having a relatively well-to-do scoring in the likert scale for service delivery
  • Similar with Accountancy undergraduates, business undergraduates are well-connected to the internet service under P18 and I18.
  • Both group of undergraduates for either library feedback that there is no need for libraries with both valuing a computer availability as one of the lowest under Facilities & Equipment
  • Both business undergraduates feedback that there is no need for library workshops with it ranking dead last for both importance and performance.

2. Differences

  • Course specific materials are readily available for KGC library as compared to LKS library
  • Opening hours for LKS are better than that of KGC
4.


4 - UGEcons.png
4(1) - UGEcons.png


Economics
1. Similarity

  • Both group of economics undergraduates found that internet access in both libraries are sufficiently comprehensive due to mostly neutral - positive sentiments under P18 and I18.
  • Both groups felt that there is insufficient places to meet in the library as feedbacked under P15 that falls below their expectation of I15.
  • Interestingly, the mobile access under Information resource to library resources for I26 and P26 fared the worst comparatively for both LKS and KGC.

2. Differences

  • The major difference here is that the access to online resources through mobile and tablet is more accessible in KGC than LKS as seen by the big differen in P26 and I26 for both libraries.
  • Library staff assistance fared worst at KGC than LKS
5.


5 - UndergradLaw.png
Undergradlaw(1).png


Law
1. Similarity

  • Law undergraduates found that both library website are providing useful information for them.
  • The printing and scanning services performs below their expectations as seen by P19 and I19
  • Both libraries provided able information resources within the library to sustain the undergraduates needs as seen by P20 and I20
  • Wireless access generally meets their expectations for both libraries as seen by P18 and I18.
  • Opening Hours fall short of their expectations

2. Differences

  • One major difference here is the computer availability as seen by the big difference between P16 of both libraries, LKS generally fared better in providing a computer to economics undergraduates