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.
|