1 / 35

Enhancing Data Automation and Analysis in ReCAP at Columbia University

This report summarizes the advancements in data management within the ReCAP program at Columbia University, focusing on the automation and refinement of request, accession, and circulation sets. Over the years from 2008 to 2011, significant progress has been made using MS Office 2010 tools for better data handling, facilitating system-wide standard reports. The ReCAP Data Center serves as a clearinghouse for crucial metrics such as request rates and trends in user behavior. Insights from this data pave the way for iterative analyses and policy adjustments aimed at enhancing user access to offsite collections.

desirae-lancaster
Télécharger la présentation

Enhancing Data Automation and Analysis in ReCAP at Columbia University

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ASCC:ReCAP Data Summary Zack Lane ReCAP Coordinator August 30, 2011 ReCAP Columbia University

  2. ReCAP Data “Automated” • Three main categories: request, accession and circulation • Request and accession sets developed and refined 2008-2010 • MS Office 2010 allows better “automation” • Data flows into Excel, pivot table, pivot charts and PowerPoint. • Beginning to “standardize” system-wide and department reports • Plan to push data and analysis out ReCAP Columbia University

  3. “Automation” ReCAP Columbia University

  4. Where is the data? • ReCAP Data Center is clearinghouse for system-wide data and analysis • Request rate • Timing of requests • High use titles • High volume requests • EDD • Publication Date (Monographs) • Department websites have both explicit data and presentations ReCAP Columbia University

  5. ReCAP/Department Websites ReCAP Columbia University

  6. Circulation • Mining ReCAP data but also looking at system-wide and department trends • Internship project found evidence in data of: • Policy changes: REG loan period 4-weeks to 1 term • System/Procedure: BDirect loans charge to BDX • User behavior patterns: charge/renewal patterns • Department analysis limited to happening location • Crafting analysis will be iterative process • Can interesting visuals be useful? ReCAP Columbia University

  7. ReCAP Columbia University

  8. ReCAP Columbia University

  9. ReCAP Columbia University

  10. ReCAP Columbia University

  11. ReCAP Columbia University

  12. ReCAP Columbia University

  13. Request • 443,311 total requests since ReCAP opened • FY08 : 59,755 • FY09 : 69,060 • FY10 : 71,119 • FY11 : 71,513 • Includes both patron and staff, EDD and physical delivery • Excludes many staff requests • Represents only CUL activity at the ReCAP facility • Patron access to offsite collections is excellent: dynamic with few failures ReCAP Columbia University

  14. ReCAP Columbia University

  15. ReCAP Columbia University

  16. ReCAP Columbia University

  17. ReCAP Columbia University

  18. Accession Statistics • 3,554,494 accessions since ReCAP opened in January 2002 • FY08/09 : 308,486 • FY09/10 : 209,668 • FY10/11 : 183,394 • Columbia Law Library • 276,825 accessions • 30,000 more are Orphan barcodes • 8,616,724 total accessions at ReCAP ReCAP Columbia University

  19. LOAD IN MIDDLE PHASE 3rd ReCAP Columbia University

  20. ReCAP Columbia University

  21. ReCAP Columbia University

  22. Other Analysis • Performed with request and accession data sets • Reveals aspects of collection usage and trends • Never perfect or absolutely complete ReCAP Columbia University

  23. Language • Distribution by language includes all items • 424 total languages • Top ten language in ReCAP collections • English : 49.9% • German : 7.8% • Japanese : 5.5% • Chinese : 5.4% • French : 5.2% • Spanish : 3.9% • Russian : 3.8% • [none] : 2.4% • Italian : 2.1% • Korean : 1.4% ReCAP Columbia University

  24. ReCAP Columbia University

  25. ReCAP Columbia University

  26. ReCAP Columbia University

  27. Retrieval Rate by Department ReCAP Columbia University

  28. ReCAP Columbia University

  29. ReCAP Columbia University

  30. ReCAP Columbia University

  31. ReCAP Columbia University

  32. ReCAP Columbia University

  33. ReCAP Columbia University

  34. ReCAP Columbia University

  35. More Data Available • More information about data sets can be found on the ReCAP Data Center website • Primary data categories include: accession, retrieval, delivery and circulation • Tailored data sets and analysis will be provided to staff via the ReCAP Coordinator • Please see the main ReCAP website for general information about CUL procedures and systems ReCAP Columbia University

More Related