IS428 AY2019-20T2 Assign ONG LI TING: Data

OVERVIEW

DATA

VISUALIZATION

TASK ANSWERS

MISCELLANEOUS

About the Data

The survey sent out to the SMU community consists of 3 sections – General Information, Survey Questions and Your Comments. The respondents does not require to answer all questions in the survey form.

For General Information, the question response is presented in multiple choice format. This section allow us to gain an overview of the profile of the respondents in terms of their faculty, student status and profession in SMU. Addionally, we will also know which library the respondents patronise more.

For Survey Questions, the question response is presented in rating scale format in terms of importance and actual perceived performance. The questions are relaed to the service and product quality provided by SMU Libraries for the area – Communication, Service Delivery, Facilities and Equipment and, Information Resources.

For Your Comments, the overall satisfaction will be measured in a rating scale format question. Respondents can also provide any suggestion, comments or overall improvement in an open-ended question format. Additionally, respondents will also be asked to answer how frequent they visit the campus, library and have access the library resources in multiple choice format.

The survey responses are consolidated in 2 files:
1. Raw data 2018-03-07 SMU LCS data file – KLG.xls
2. 2018-02-16 SMU Library Survey Comments MAC.xls

Raw data 2018-03-07 SMU LCS data file – KLG.xls

This file contains 2 tabs – SMU and Legend.
The SMU tab contains all the answers gathered from the respondents in numeric coded values.

Header	Description
Code	Numerical values that gives every respondent a unique number.
[Remaining Headers]	Answers coded in numerical value for every type of answer. The legend tab will be needed to map the value under these headers to a description.

The primary use of the legend tab is to give SMU Libraries the information needed to map the numerical values in the SMU tab to a description.

Header	Description
Code	Contains 88 unique answer keys for the questions answered. E.g. HowOftenL represents the question on “How frequently do you visit the library?” and HowOftenC represents the question on “How frequently do you visit the Campus?”.
Item	Contains 88 questions presented to the respondents.
Free text	Any open-ended questions response.
0 - 10	The numerical representation for the multiple-choice questions answered. For example: 1 represents YES, 2 represents NO.

2018-02-16 SMU Library Survey Comments MAC.xls

This file contains the comments posted by the respondents and their overall profile.

Header	Description
Which Library do you use more?	Multiple choice (1 of the following): Li Ka Shing Library Gwa Geok Choo Law Library
Position?	Multiple choice (1 of the following): Undergraduate year 1 Undergraduate year 2 Undergraduate year 3 Undergraduate year 4 & above Exchange student Graduate: Masters Graduate: Doctoral Faculty: Professor Faculty: Assistant Professor Faculty: Lecturer/Senior Lecturer Staff: Researcher Staff: Other administration position Others
What is your major area of study, research or teaching?	Multiple choice (1 of the following): Accountancy Business Economics Information Systems Law Social Sciences Others
Are you an international (non-exchange) student?	Multiple choice (1 of the following): Yes No
Please give us your suggestions for improvement or any other comments about the Library.	Open ended answer

Data Cleaning & Preparation

File: Raw data 2018-03-07 SMU LCS data file – KLG.xls

Assumption

• Exchange student (Answered in Q3) cannot be a non-exchange student (Answered in Q4)
• Graduate student (Answered in Q3) can be an international non-exchange student (Answered in Q4)
• Faculty profession respondents cannot (Answered in Q3) cannot be a non-exchange student (Answered in Q4)
• Staff profession respondents cannot (Answered in Q3) cannot be a non-exchange student (Answered in Q4)

Cleaning #1

Steps

Tab: SMU Remove rows that do not fulfil the assumptions stated above. It is essential to keep the dataset error free.

For column “ID”, sort it in ascending order. This will ensure a faster run time for Excel. For “1” under column “ID”, remove the entire role that contains number 5 (Exchange student), 9 – 11 (Faculty profession) and 12 – 13 (Staff profession) from the “Position” column. Select the group of data that potentially contains the number 5, 9 – 11 and 12 – 13. Ctrl + F and find the values. Highlight the results in the Find and Replace window. Close the window and Ctrl + - to open the Delete window. Select “Entire row”.