Difference between revisions of "Staff"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
 
(17 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-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 2018 Survey Results can be found here and the full report is available by following this link. 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 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>
 
−
 
 
−
==<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; 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">Undergraduates</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="padding:0.2em; font-size:100%; background-color:#343436;  border-bottom:0px solid #3D9DD7; text-align:center; color:#F5F5F5" width="10%" |
 +
[[Undergraduates|<font color="#CC9900" size=4 face="Agency FB">Undergraduates</font>]]
  
 
| style="background:none;" width="1%"| &nbsp;
 
| style="background:none;" width="1%"| &nbsp;
Line 62: Line 17:
  
 
| 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; 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%" |   
 
[[Staff|<font color="#CC9900" size=4 face="Agency FB">Staff</font>]]
 
[[Staff|<font color="#CC9900" size=4 face="Agency FB">Staff</font>]]
  
Line 69: Line 24:
 
[[Faculty|<font color="#CC9900" size=4 face="Agency FB">Faculty</font>]]
 
[[Faculty|<font color="#CC9900" size=4 face="Agency FB">Faculty</font>]]
 
|}  
 
|}  
−
 
−
* Insert Text Here
 
 
</div>
 
</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>==
+
[[File:Staff - Wordcloud.png|700px|frameless|center]]
−
<div style="font-size: 15px; padding-top: 15px; padding-bottom: 30px; padding-left: 15px; padding-right: 15px;">
+
</br>
−
* Insert Text Here
+
<center>From the word cloud generated by RStudio, the common words that appear consistently are book, staff, like, access, staff and many more.
−
</div>
+
</br>
  
−
==<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]]
 +
||
 +
* The four areas are generally well-performed as feedbacked by '''Staff''' users.
 +
* The areas with lower performance level than importance level are Facilities & Equipments and Information Resources.
 +
|-
 +
|
 +
<center> 2.
 +
||
 +
</br>
 +
[[File:Staff Biz.png|800px|frameless|center]]
 +
[[File:Staff - Biz.png|800px|frameless|center]]
 +
</br>
 +
</center>
 +
||
 +
'''Others''' </br>
 +
1. Similarity
 +
* For both libraries, they fare well in providing internet access to staff users.
 +
* They generally provide good services to staff users for both libraries.
 +
* Generally, staff members are able to find quiet places around the library.
 +
2. Differences
 +
* The big difference here is that the library website for KGC fared better in providing important information to Staff users.
 +
* The library services are not as informed for LKS as compared to KGC for staff users.
 +
|-
 +
|
 +
<center> 3.
 +
||
 +
</br>
 +
[[File:Staffers.png|800px|frameless|center]]
 +
</br>
 +
||
 +
'''Business''' </br>
 +
1. Similarity
 +
* Gernally, the service provided by the staff of both libraries are positively feedback by the Staff users as it meets their expectations.
 +
* The resources are generally easily accessible away from campus.
 +
2. Differences
 +
* Printing and scanning facilities are not as important to staff users but they fared better than what they have expected.
 +
* The staff are well informed by LKS website on the services that they have.
 +
* Information resources in the library (DVDs, books, journals) does not fully satisfy what the staff users need from LKS as deemed by their higher level of importance for these under information resource.
 +
|-
 +
|
 +
<center> 4.
 +
||
 +
</br>
 +
[[File:Information Systems - Staff.png|800px|frameless|center]]
 +
</br>
 +
||
 +
'''Information Systems''' </br>
 +
1. Similarity
 +
* Wireless accessibility by staff users are generally good as it performed up to the importance level as given by the staff users.
 +
* Online resources (databases, books) are useful for staff users in the '''Information Systems''' school.
 +
* Library staff as feedbacked earlier provided accurate answers to enquiries to Staffs from Information System School
 +
2. Differences
 +
* The expectation of computer availability in these areas are of low yet the performance level of computer availability signifies that the computer is not as available as a service in LKS.
 +
* The Library website is not as useful in telling the service as compared to other schools.
 +
* The library fare poorly as apposed to the importance on the library anticipating the needs of Information System's Staff based on the online enquiry system.
 +
|}
 
</div>
 
</div>
−
 
 
<!--Body-->
 
<!--Body-->

Latest revision as of 23:40, 15 March 2020

SMU.png

Findings

Overview

 

Undergraduates

 

Graduates

 

Staff

 

Faculty

Staff - Wordcloud.png


From the word cloud generated by RStudio, the common words that appear consistently are book, staff, like, access, staff and many more.


No. Finding Description
1.
1 .png
  • The four areas are generally well-performed as feedbacked by Staff users.
  • The areas with lower performance level than importance level are Facilities & Equipments and Information Resources.
2.


Staff Biz.png
Staff - Biz.png

Others
1. Similarity

  • For both libraries, they fare well in providing internet access to staff users.
  • They generally provide good services to staff users for both libraries.
  • Generally, staff members are able to find quiet places around the library.

2. Differences

  • The big difference here is that the library website for KGC fared better in providing important information to Staff users.
  • The library services are not as informed for LKS as compared to KGC for staff users.
3.


Staffers.png

Business
1. Similarity

  • Gernally, the service provided by the staff of both libraries are positively feedback by the Staff users as it meets their expectations.
  • The resources are generally easily accessible away from campus.

2. Differences

  • Printing and scanning facilities are not as important to staff users but they fared better than what they have expected.
  • The staff are well informed by LKS website on the services that they have.
  • Information resources in the library (DVDs, books, journals) does not fully satisfy what the staff users need from LKS as deemed by their higher level of importance for these under information resource.
4.


Information Systems - Staff.png

Information Systems
1. Similarity

  • Wireless accessibility by staff users are generally good as it performed up to the importance level as given by the staff users.
  • Online resources (databases, books) are useful for staff users in the Information Systems school.
  • Library staff as feedbacked earlier provided accurate answers to enquiries to Staffs from Information System School

2. Differences

  • The expectation of computer availability in these areas are of low yet the performance level of computer availability signifies that the computer is not as available as a service in LKS.
  • The Library website is not as useful in telling the service as compared to other schools.
  • The library fare poorly as apposed to the importance on the library anticipating the needs of Information System's Staff based on the online enquiry system.
Retrieved from ‘https://wiki.smu.edu.sg/1920t2is428/index.php?title=Staff&oldid=4104’