IS428 AY2019-20T2 Assign LIM SI LING

Overview

Background

Every two years, SMU Libraries conduct a comprehensive survey in which faculty, students and staff can rate various aspects of SMU library's services. The survey results are an important feedback for SMU libraries to understand the quality of their services and facilities and identify key areas that needs improvement to better meet the needs of their users.

Objectives

I am tasked by SMU libraries to use visual analytics approach to reveal the level of services provided by them as perceived by:

• the undergraduate students
• the postgraduate students
• the faculty
• the staff

There was previously a report (Library Survey Report) generated. However, it consists of many separated graphs and charts which is too disjointed to be read properly. Additionally, the report incorrectly uses Mean as a measure. The survey questions are graded based on a 7 point Likert scale. The mean in a Likert scale can't be found because it is not possible to find an average of “agree”, “disagree”, and “neutral. Therefore, the goal is to produce a visualisation of the survey results by reducing the number of charts and providing dashboards to highlight performance of SMU libraries in terms of overall satisfaction, facilities, resources and services provided.

Survey Data

Description of Data

The survey data provided is a single excel workbook containing two sheets:

Sheetname	Description
SMU	The raw survey results containing survey respondents and each of their reply to the survey questions in the form of ratings. The raw survey results have a total of 2639 rows or number of participants. There are a total of 89 column. However, there are missing data as well that needed to be removed. The attributes of the data can be divided into the following: Information on participants: ResponseID (unique ID representing survey respondents) Campus (which library do respondents use more) Position (Type of user) ID (international Student or not) HowOftenL (frequency of visit to library) HowOftenC (frequency of visit to Campus) HowOftenW (frequency of accessing library resources) Survey Questions on quality of library facilities and services: Divided into 3 types (Importance, Performance and N/A) Respondents who picked 'N/A' for the question need not select a rating for both importance and performance. There are 26 questions for importance and N/A and 27 questions for performance, represented by 78 different columns Free response questions: Comment1 (suggestions for improvement)
Legend	The legend that contains the exact survey questions and the question code that they represent.