1 / 32

Statistical Soup: What you can do with stats & reports

Learn how to leverage statistics and reports to make data-driven decisions for budgeting, weeding, and ensuring user satisfaction with your library collection.

beverlyd
Download Presentation

Statistical Soup: What you can do with stats & reports

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. Statistical Soup:What you can do with stats & reports Diane Brodson, Arlington Heights Memorial Library & Ane Carriveau, Ripon College

  2. Arlington Heights Memorial Library Public Library Population: 74,138 Staff: 240 includes 23 FT librarians plus 52 FT & 165 PT staff 200 Volunteers; 196 JLVs 459,000 Items Lane Library – Ripon College Liberal Arts College Bachelors degree (no graduate students) Serving ~1000 students and 60 Faculty 4 librarians, 1 Staff, 40 student workers 240,000 items Who we are…

  3. Ways to get stats & reports • Web management reports • Millennium statistical reports

  4. What do you need to find out? • Age of collection • Item counts (how many do you have?) • Circulation stats (how popular is it? get turnover rates) • Internal use? Copy use? • Money spent by format, by genre, by Dewey • Fulfillment rate (number holds by format and genre) • Using data: • to increase budgets • sunset collections • make sure you’re buying evenly • make sure you’re buying what patrons want • To maintain the collections: • Zero-circ reports (weeding) • New book added (move into regular collection) • DVD circs over 50 (earmark for cleaning)

  5. Using Milstats Scroll down to click Statistics Scroll down to click the Statistics icon.

  6. Milstats Opening Screen Click New Query

  7. Name it; Grab it! Name it! Grab it! **Corey Seeman’s Milstats 101

  8. Define it! (what are you counting?) Items • Choose items • Click Field Statistics • Fastest Accumulation • Run the Query!

  9. It may take a few hours; let it run over night! Click Results When complete…

  10. Select report! (Export to Excel?)

  11. Open in Excel

  12. Clean up the columns

  13. In Excel • Choose what is important to see. • Add a column for turnover rate? • Formula = LYRCirc / record count • Remember the Caveats! • Are you comparing 4-week books with one-week DVDs? • Corey cautions people to keep saved queries in Results Files….

  14. Adding a column for turnover rate. LYRCRC/ Record Count = Turnover rate Caveat: a snapshot!

  15. Adult Print and AV

  16. SCAT Table 2

  17. SCAT Table 2 & turnover rates To see what is circulating the most

  18. What isn’t circulating well? Are these areas candidates for weeding?

  19. Combining statistics…

  20. Possible Academic Uses… • Evaluating your collection • Space planning • Weeding • Justifying your budget • Checking for coding mistakes • Seeing how your users search

  21. Academic Space Planning

  22. Academic Collection Planning

  23. Age of Collection

  24. Circ Stats from Web Reports Choose your criteria.

  25. Checkout Report by Location Use arrows to scroll through reports

  26. Circ Stats by Location and Call Number

  27. Opac Searches

  28. Kinds of Searches by Index

  29. Remember: Innopacusers Group Even if you can’t go…..

  30. You can get slides: Like Ben Klein’s Using WMR for Circ Work

  31. Remember CS Direct FAQs, Tutorials, Archives

  32. Thank you • Any Questions? • Contact us… • Ane Carriveau carriveaua@ripon.edu • Diane Brodson dbrodson@ahml.info

More Related