Difference between revisions of "IS428 AY2019-20T2 Assign JORDY NELSON SAMUEL"

From Visual Analytics for Business Intelligence
Jump to navigation Jump to search
Line 92: Line 92:
 
For this section, the Undergraduate [https://public.tableau.com/profile/jordy.nelson.samuel#!/vizhome/Assignment1_jnsamuel_2016/Undergraduate story] will be referenced.
 
For this section, the Undergraduate [https://public.tableau.com/profile/jordy.nelson.samuel#!/vizhome/Assignment1_jnsamuel_2016/Undergraduate story] will be referenced.
 
===Undergraduates are satisfied using their personal laptops in the library, but computers at the library are not always available.===
 
===Undergraduates are satisfied using their personal laptops in the library, but computers at the library are not always available.===
[[File:Undergrad comp.jpg|800px|frameless|center|Undergraduate Evaluation of Computer Use]]
+
[[File:Undergrad comp.jpg|800px|frameless|center|Undergraduate Evaluation of Computer Use]] ''Undergraduate Satisfaction under 'Undergraduate' story''
 
Undergraduates rated the computer facilities when it comes to using their own laptops very highly in comparison to other fields, excluding their overall satisfaction. This indicates that undergraduates use the library as a study space for a good portion of the time they are at the library, as they have a strong, positive opinion of using their own laptops.
 
Undergraduates rated the computer facilities when it comes to using their own laptops very highly in comparison to other fields, excluding their overall satisfaction. This indicates that undergraduates use the library as a study space for a good portion of the time they are at the library, as they have a strong, positive opinion of using their own laptops.
  
Line 102: Line 102:
  
 
Looking at which library is more popular, Li Ka Shing is the definite winner. 85.63%(135,450) visit Li Ka Shing library more often, an overwhelming majority.
 
Looking at which library is more popular, Li Ka Shing is the definite winner. 85.63%(135,450) visit Li Ka Shing library more often, an overwhelming majority.
[[File:Kgc popularity.jpg|800px|frameless|center|Popularity of Various Campuses in SMU]]
+
[[File:Kgc popularity.jpg|800px|frameless|center|Popularity of Various Campuses in SMU]] ''Favourite Campus: Law vs Non-Law Graduates under 'Undergraduate' story''
  
 
If we just look at non-law students, we now see that Li Ka Shing is an even more overwhelming majority at 91.44% popularity amongst non-law students. Law students, however overwhelmingly prefer the law library, with 71.65% preferring to visit. Proximity could be one factor, but could the difference be because of other factors?
 
If we just look at non-law students, we now see that Li Ka Shing is an even more overwhelming majority at 91.44% popularity amongst non-law students. Law students, however overwhelmingly prefer the law library, with 71.65% preferring to visit. Proximity could be one factor, but could the difference be because of other factors?
  
 
We can compare law students' rating average over categories.
 
We can compare law students' rating average over categories.
[[File:Lib comparison.jpg|300px|frameless|center|Library Comparison among Law Students]]
+
[[File:Libcomp.jpg|500px|frameless|center|Law Students' Comparison of Both Libraries]] ''Law Students' Preference for Kwa Geok Choo Law Library''
  
 
While answers differ across the board, we can see that overall, law students are more satisfied with the Law library, with an overall rating of 5.8074 vs 5.6792 in Li Ka Shing. The most notable difference is Resource Access, with a 0.1625 higher rating in the Law Library. Since law students need their own set of resources different from the other schools, it makes sense to say that the reason why law students overwhelmingly choose the Law Library is due to the access of resources it provides.
 
While answers differ across the board, we can see that overall, law students are more satisfied with the Law library, with an overall rating of 5.8074 vs 5.6792 in Li Ka Shing. The most notable difference is Resource Access, with a 0.1625 higher rating in the Law Library. Since law students need their own set of resources different from the other schools, it makes sense to say that the reason why law students overwhelmingly choose the Law Library is due to the access of resources it provides.

Revision as of 19:32, 13 March 2020

Overview

The 2018 dataset for the library survey has been used. In general, we are trying to get a picture through this visualisation of who uses the library, what they use it for and how well the library has been serving them.

Data & Preparation

Screenshot Description
Sheets.jpg
The data comes in 2 sheets: SMU and Legend. SMU contains all the actual responses, while Legend contains all the codes for the questions and responses.
Responses without Legends
Upon importing the SMU sheet, we can see that while the legend and ratings are available, the actual questions are not. We must proceed to import the Legends sheet as well, but first, we must treat this data. Tableau does not like this format where every question has its own column, therefore we need to pivot it.
Pivot Fields
Pivoted data
We select all the columns from I01 to NPS1 and pivoted them into 2 fields as shown in the second image. This will allow tableau to manipulate the data easier when we build our likert scale and various other graphs. We shall rename 'Pivot Field Names' to 'Code' and 'Pivot Field Values' to 'Rating'.
Pivot jnsamuel.jpg
We can now drag in the 'Legend' sheet and inner join them by 'Code'. This will allow us to have the 2 columns, Item and Rating, that will enable us to plot our visualisations.
Question Groups
In addition, to better evaluate the services the library provides, each question has been grouped into respective categories that evaluate the computer facilities, overall satisfaction, resource access, service and the space of the library. The 5 groups are Computer Facilities, Resource Access, Service, Space and Overall. These categories will help us to evaluate different aspects of the libraries' service.

The categories consist of:

Category Questions
Overall Overall how satisfied are you with the library?
Computer Facilities A computer is available when I need one

I can get wireless access in the Library when I need to
Laptop facilities (e.g. desks, power) in the Library meet my needs
Printing, scanning and photocopying facilities in the Library meet my needs

Resource Access Access to Library information resources has helped me to be successful at university

Course specific resources (online and in the reserve collection) meet my learning needs
I find it easy to use mobile devices (e.g. tablets and phones) to access online resources
Information resources located in the Library (e.g. books, journals, DVDs) meet my learning and research needs
Online resources (e.g. online articles, databases, ebooks) are useful for my studies and help me with my learning and research needs
The items I'm looking for on the library shelves are usually there
The Library search engine enables me find relevant library resources quickly
When I am away from campus I can access the Library resources and services I need

Service Books and articles I have requested from other Libraries are delivered promptly

Face-to-face enquiry services meet my needs
I am informed about the Library services
I can get help from library staff when I need it
Library staff provide accurate answers to my enquiries
Library workshops, classes and tutorials help me with my learning and research needs
Online enquiry services (e.g. Email, Library Chat) meet my needs
Opening hours meet my needs
Self Service (e.g. self-check loans, requests, renewals, holds) meets my needs
The Library anticipates my learning and research needs
The Library website provides useful information
Library Signage is Clear

Space I can find a place in the Library to work in a group when I need to

I can find a quiet place in the Library to study when I need to

Demographics

Overall demographics of survey

Full visualisation here The primary audience of the survey is undergraduate students, taking up 79.92%(158,175) of the survey's respondents. Postgraduate students are second at 10.57%(20,925) respondents.

In proportion to the overall demographics of SMU, Business students take up 38.89%(76,950) of the respondents, the largest among the other schools. Information Systems comes in second, with about half of Business's students at 14.75% (29,175) of the total students.

Overall Results

Service Scores

Overall Survey Results

Service tab under 'Overall' story

The library maintains a high level of service across all domains, with above-5 (4 being neutral) scores across each category. Overall, respondents rated the library 5.72 out of 7, with the weakest category being related to spaces available at the library at 5.50.

The worst scoring item is 'A computer is available when I need one' at 4.47, while the best is 'I can get wireless access in the library when I need to'.

Visitation

Frequency of Visitation Overall

Visitation and Frequency tab under 'Overall' story

Li Ka Shing is still the most popular library, with 86.55%(171,300) respondents claiming to go there, while the Kwa Geok Choo Law Library is second with 13.41%(26,550) of respondents claiming to go there. People who visited the campus frequently, on average, also visited the library, albeit at a slightly lower frequency.

Undergraduates

For this section, the Undergraduate story will be referenced.

Undergraduates are satisfied using their personal laptops in the library, but computers at the library are not always available.

Undergraduate Evaluation of Computer Use

Undergraduate Satisfaction under 'Undergraduate' story

Undergraduates rated the computer facilities when it comes to using their own laptops very highly in comparison to other fields, excluding their overall satisfaction. This indicates that undergraduates use the library as a study space for a good portion of the time they are at the library, as they have a strong, positive opinion of using their own laptops.

When it comes to the 'Computer Facilities' category, we can see that undergraduate students need access to the computers in the library, but may not always be able to get one. For the question 'A computer is available when I need one', over 30% of respondents answered negatively. With an average score of 4.48 amongst the group, the response is barely positive (4 being a neutral score).

In fact, amongst all the survey question, the availability of computers scores the worst, with the largest proportion of undergraduate respondents responding negatively. It also has the lowest mean score across all the questions.

Li Ka Shing is still the most popular library... except amongst law students

Looking at which library is more popular, Li Ka Shing is the definite winner. 85.63%(135,450) visit Li Ka Shing library more often, an overwhelming majority.

Popularity of Various Campuses in SMU

Favourite Campus: Law vs Non-Law Graduates under 'Undergraduate' story

If we just look at non-law students, we now see that Li Ka Shing is an even more overwhelming majority at 91.44% popularity amongst non-law students. Law students, however overwhelmingly prefer the law library, with 71.65% preferring to visit. Proximity could be one factor, but could the difference be because of other factors?

We can compare law students' rating average over categories.

Law Students' Comparison of Both Libraries

Law Students' Preference for Kwa Geok Choo Law Library

While answers differ across the board, we can see that overall, law students are more satisfied with the Law library, with an overall rating of 5.8074 vs 5.6792 in Li Ka Shing. The most notable difference is Resource Access, with a 0.1625 higher rating in the Law Library. Since law students need their own set of resources different from the other schools, it makes sense to say that the reason why law students overwhelmingly choose the Law Library is due to the access of resources it provides.

Resource Access is Everyone's Big Gripe

Undergrad Response Categories

On average, access to resources is the worst rated category among all questions. At 5.3461 average, it is the worst scoring among all categories.

Resource Access Likert Scale among Graduates

Drilling down into the questions for this category, the worst question is 'Information resources located in the Library (e.g. books, journals, DVDs) meet my learning and research needs' at 5.09 out of 7. So is there a mismatch with the libraries' provision of resources and students' needs?

Let's take a look at the responses for the question, 'How often do you access library resources'. The page on the full visualisation is here

Frequency of Resource Access by Study Area

The lower the rating, the more frequently students from that study area access resources. Let's first take note that students from Law and Social Sciences access resources the most, at 1.4 and 1.9 respectively.