Documentation: Viewing statistics

From ReservesDirect: Open Source EReserves System

Table of contents

1 System Reports Structure 2 Canned Reports 2.1 For Instructors 2.2 For Staff

System Reports Structure

ReservesDirect comes with a flexible reports structure that allows for powerful and comprehensive statistics to be gathered on virtually any aspect of the system. The reporting structure allows new reports to be created quickly by simply by writing a SQL statement and dropping it in. The reports structure handles generating the display table, as well as an export function that allows any given report to be saved to a spreadsheet (export is in tsv format).

Canned Reports

Since the reports are essentially SQL queries, ReservesDirect does not install with any reports set up by default. However, we have written a number of powerful reports that can be created by your system administrator once ReservesDirect is created. These reports include:

For Instructors

• View log for a class - Allows an instructor to choose any course they have taught and see how many times each document was opened (Total Hits) and how many individual students opened it (Unique Hits). ReservesDirect logs every time a document is opened and who opened it in order to generate this report. All ELECTRONIC items will track correctly. Since physical items do not get "opened" or "checked out" within ReservesDirect itself, physical items will always show zero usage.

For Staff

• Totals: Items and Reserves - Gives the total number of items in the system, and how many reserves (actual usage of those items for courses). The number of reserves will either be equal to or greater than the number of items, since a single item may be on reserve for multiple different courses. This report reflects all items and reserves for all semesters regardless of library.
• Totals: Courses - The total number of courses in the system for all semesters and all libraries.
• Totals: Users - A breakdown of the total number of users by role for the entire system.
• Global: Courses and Users - Shows all the departments for a library with the number of Courses, Instructors, Proxies, and Students for each department. The number of students is a count of how many students have the course as part of their profile (MyReserves). This report allows you to select one or more terms and one or more libraries.
• Global: Items and Reserves - Shows all the departments for a library with the number of items that department is using, how many reserves that represents, and how many of those reserves have actually been opened by students. This report allows you to select one or more terms and one or more libraries.
• Global: Upload Activity - Shows the username, role, and how many documents that user uploaded for all users who uploaded at least one document during a given semester (or multiple semesters).
• Items added by Role - For a given semester, shows the total number of items uploaded by each user role.
• Item View Log for a Class - Total and unique hits by document for a class
• Item View Log for a Class by Date - For each document in a class, shows what days of the semester the document was opened, how many total hits it received that day, and how many students opened it.