Using the database

Academic staff questionnaire

  1. Input the data from your questionnaire responses into the database. Many of the fields have dropdown options eg male/female.

You may wish to amend the tables in design view to reflect any changes you have made to the questionnaire to reflect the needs of your institution.

  1. Export the data into Excel to analyse the quantitative data.
  1. Delete fields you do not intend to analyse using Excel (the more qualitative data may be best exported to Word for analysis purposes).
  1. Use the find and replace feature to replace all TRUE statements with a number 1. This will allow you to add to the number of respondents giving a positive answer to each question.

Questionnaire number / Used archives / Used bibliographic databases / Used book chapters
1 / TRUE / TRUE / TRUE
2 / TRUE / FALSE / TRUE
3 / FALSE / TRUE / TRUE
4 / FALSE / FALSE / FALSE

Becomes

Questionnaire number / Used archives / Used bibliographic databases / Used book chapters
1 / 1 / 1 / 1
2 / 1 / FALSE / 1
3 / FALSE / 1 / 1
4 / FALSE / FALSE / FALSE
TOTAL / 2 / 2 / 3

You should now be able to determine:

  • the numbers of staff who have used each type of resource during the last month.
  • the number of staff who consider each type of resource to be one of the three they use most frequently.
  • the number of staff accessing EIS from various locations.
  1. Remember to add data listed in the ‘other’ columns for questions 4 and 5.
  1. Sort the ‘last access EIS’, ‘last download electronic document’ and ‘last visit library’ columns and, in each case, tally the responses in each category to identify how frequently academic staff make use of the library in each of these ways.
  • Consider how electronic access relates to physical access.
  • Consider whether there is any relationship between frequency of library use (physical or remote) and the number of services used.
  1. Sort the ‘preferences’ column and tally the responses in each category to identify which type of resource is preferred by academic staff.
  • Consider whether there is any relationship between preferences for EIS or print materials and usage of EIS resources
  • Consider whether there is any relationship between preferences for EIS or print materials and frequency of EIS or library access.
  1. Sort the data by gender to find out if there are any patterns in terms of frequency of EIS and library use, preferences for EIS or print materials, or the services used.
  1. Sort the data by academic department to find out if there are any patterns in terms of frequency of EIS and library use, preferences for EIS or print materials, or the services used.

Student questionnaire

  1. Input the data from your questionnaire responses into the database. Many of the fields have dropdown options eg male/female.

You may wish to amend the tables in design view to reflect any changes you have made to the questionnaire to reflect the needs of your institution.

  1. Export the data into Excel to analyse the quantitative data.
  1. Delete fields you do not intend to analyse using Excel (the more qualitative data may be best exported to Word for analysis purposes).
  1. Use the find and replace feature to replace all TRUE statements with a number 1. This will allow you to add to the number of respondents giving a positive answer to each question.

Questionnaire number / Used archives / Used bibliographic databases / Used book chapters
1 / TRUE / TRUE / TRUE
2 / TRUE / FALSE / TRUE
3 / FALSE / TRUE / TRUE
4 / FALSE / FALSE / FALSE

Becomes

Questionnaire number / Used archives / Used bibliographic databases / Used book chapters
1 / 1 / 1 / 1
2 / 1 / FALSE / 1
3 / FALSE / 1 / 1
4 / FALSE / FALSE / FALSE
TOTAL / 2 / 2 / 3

You should now be able to determine:

  • the numbers of students who have used each type of resource during the last month.
  • the number of students who consider each type of resource to be one of the three they use most frequently.
  • the number of students accessing EIS from various locations.
  1. Remember to add data listed in the ‘other’ columns for questions 4 and 5.
  1. Sort the ‘last access EIS’, ‘last download electronic document’ and ‘last visit library’ columns and, in each case, tally the responses in each category to identify how frequently students make use of the library in each of these ways.
  • Consider how electronic access relates to physical access.
  • Consider whether there is any relationship between frequency of library use (physical or remote) and the number of services used.
  1. Sort the ‘preferences’ column and tally the responses in each category to identify which type of resource is preferred by students.
  • Consider whether there is any relationship between preferences for EIS or print materials and usage of EIS resources
  • Consider whether there is any relationship between preferences for EIS or print materials and frequency of EIS or library access.
  1. Sort the data by gender to find out if there are any patterns in terms of frequency of EIS and library use, preferences for EIS or print materials, or the services used.
  1. Sort the data by course to find out if there are any patterns in terms of frequency of EIS and library use, preferences for EIS or print materials, or the services used.
  1. Sort the data by mode of study to find out if there are any patterns in terms of frequency of EIS and library use, preferences for EIS or print materials, or the services used.
  1. Sort the data by year to find out if there are any patterns in terms of frequency of EIS and library use, preferences for EIS or print materials, or the services used.