The University of Arizona's Music Library's Needs Assessment

Part IV. Data Analysis

Recording the data

Microsoft Excel was used to create a spreadsheet of the raw data. The spreadsheet records all individuals' responses to questions asking participants to rate both the level of importance they ascribe to the various types of materials, services, physical facilities and equipment found in the Music Library, as well as their satisfaction with each type of material, service, etc. These questions were posed through the written and email questionnaires, and used a five-point Likert scale (5 = High importance or satisfaction, 1 = Low importance or satisfaction).

Excel tables that collated, tabulated and summarized the data were also created, as were four charts visually representing composite responses to importance/satisfaction ratings.

Here is a sample of the spreadsheet showing some of the "raw data." The sample shows the responses students in the Masters Program gave about the importance of and their satisfaction with books, scores, and recordings. For example, 34 responses were received about the importance of books, but only 33 recorded their satisfaction. Of those responding, 64.71% rated books as being "very important" (they chose "5" from the Likert scale) but only 24.24% also rated their satisfaction as "5."



Masters Program   1. Materials
    Books (Imp.) Books (Sat.) Scores (Imp.) Scores (Sat.) Recordings (Imp.) Recordings
(Sat.)
Total # Responses   34 33 34 32 34 32
Average of All Responses   4.5 4.1 4.8 3.6 4.7 3.4
Percentages of Each Response              
Scores:   5 64.71% 24.24% 91.18% 18.75% 79.41% 18.75%
   4 20.59% 54.55% 0.00% 34.38% 14.71% 21.88%
   3 2.94% 12.12% 2.94% 25.00% 0.00% 31.25%
   2 2.94% 3.03% 0.00% 15.63% 0.00% 21.88%
   1 2.94% 0.00% 2.94% 0.00% 2.94% 0.00%
PERCENTAGE TOTALS:
  94.12% 93.94% 97.06% 93.75% 97.06% 93.75%

Let's continue.

Test Your Knowledge How To Reference Case Study Make Your Plan Resources Home UA Library Homepage Top Download the Tutorial