Library Transaction and Attendance Statistics

1
Library Transaction and Attendance Statistics

• Jay Forrest
• 8 June 2006

2
URLs for Library Statistics

• Library Tally Sheet http//www.lwcsurvey.gatech.e
  dy/tally
• Tally Sheet Reports (Tabular Data)
  http//www.lwcsurvey.gatech.edu/tally/html/report.
  php
• Tally Sheet and Attendance Graphs
  http//intranet.library.gatech.edu/news/stats.php
  http//www.prism.gatech.edu/tf33/libstat.shtml

3
Library Tally Sheet 2005/06
4
How the Tally Sheet Works

• The Library Tally Sheet uses PHP to record data
  into an MySQL database hosted by OIT.
• Each click records
• Date, Time, and Day of the Week
• Location (and IP address)
• Type (Directional, IT, Traditional Reference,
  Other Services)
• Question (A pull-down selection or text entry)
• Service Details

5
Reports

• While any combination of data is possible from
  the SQL data.
• Several pre-made reports are always available
• Categories
• Locations
• Time of Day (by Month, by Semester, and by
  Semester and Location)
• Questions
• Service Details
• Security Tallies (Entries and Visitor Log)

6
Tabular Data Categories
7
Tabular Data Locations
8
Tabular Data By Hour
9
Tabular Data Questions
10
Tabular Data Other
11
Tabular Data Service Details
12
Graphical Data

• Library Wide Tally Data
• Category by Month
• Count by Day of the Week
• Count by Location
• Time Spent by Location
• Details by Term
• Count and Time Spent by Hour
• Count by Location
• Count by Hour and Day
• Time Spent by Hour and Weekday
• Details by Department
• Overview
• Questions by Category

13
Attendance Data

• Library Attendance data has three sources
• Daily exit gate count readings
• Hourly census counts between midnight and 7AM
• Number of entrants between 7AM and 8AM
• Attendance Data is maintained in Excel format and
  is available from 2002-
• Attendance Data is presented by Term
• Annual Totals
• Monthly Totals
• Gate Count Weekly Totals and Daily Averages
• Third Shift Weekly Totals, Averages by Day and
  Hour, and Women in Attendance

14
ISD Tally Sheet 2006/07