320 likes | 416 Views
Explore ways to utilize statistics and reports in library settings for collection management, budgeting, weeding, and user preferences. Learn how to access, analyze, and interpret data effectively using Milstats. Enhance your library's efficiency and effectiveness using statistical insights.
E N D
Statistical Soup:What you can do with stats & reports Diane Brodson, Arlington Heights Memorial Library & Ane Carriveau, Ripon College
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…
Ways to get stats & reports • Web management reports • Millennium statistical reports
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)
Using Milstats Scroll down to click Statistics Scroll down to click the Statistics icon.
Milstats Opening Screen Click New Query
Name it; Grab it! Name it! Grab it! **Corey Seeman’s Milstats 101
Define it! (what are you counting?) Items • Choose items • Click Field Statistics • Fastest Accumulation • Run the Query!
It may take a few hours; let it run over night! Click Results When complete…
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….
Adding a column for turnover rate. LYRCRC/ Record Count = Turnover rate Caveat: a snapshot!
SCAT Table 2 & turnover rates To see what is circulating the most
What isn’t circulating well? Are these areas candidates for weeding?
Possible Academic Uses… • Evaluating your collection • Space planning • Weeding • Justifying your budget • Checking for coding mistakes • Seeing how your users search
Circ Stats from Web Reports Choose your criteria.
Checkout Report by Location Use arrows to scroll through reports
Remember: Innopacusers Group Even if you can’t go…..
You can get slides: Like Ben Klein’s Using WMR for Circ Work
Remember CS Direct FAQs, Tutorials, Archives
Thank you • Any Questions? • Contact us… • Ane Carriveau carriveaua@ripon.edu • Diane Brodson dbrodson@ahml.info