1 / 24

How to Check Circulation Statistics by Campus by Month

How to Check Circulation Statistics by Campus by Month. A tutorial for librarians using Agent VERSO. From the Staff Menu, select the Statistics Tab. Step 1:. Step 2: C lick on Circulation Statistics. This expands the menu. Step 3: C lick on Item Location.

egant
Download Presentation

How to Check Circulation Statistics by Campus by Month

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. How to CheckCirculation Statisticsby Campusby Month A tutorial for librarians using Agent VERSO

  2. From the Staff Menu, select the Statistics Tab Step 1:

  3. Step 2: Click on Circulation Statistics This expands the menu. Step 3: Click on Item Location

  4. The default settings for a circulation report by location (your campus) look like this.

  5. Step 4: To view or save the report in a usable form, simply change the settings to this: As you make changes to the default settings, the screen automatically updates.

  6. At some point, Agent will display a list of links, so that you can select the month of your choice. Step 5: Click on the month you want

  7. A popup window will open to ask if you want to open or save the file. If you save the file, it’s easier to make the changes shown on the following slides.

  8. Step 6: Save this Excel Spreadsheet to your computer

  9. Unfortunately, this popup window does not ask you where you would like to save this file. The file will be saved in the default location for your browser. This may be Downloads, My Documents, the Desktop, or another location. • Click Start, then Search. • Choose “all files.” • Type itemlocation into the name blank. • Scroll down and select “select dates.” • Today’s date should display automatically. • Click Search. To locate the file, after downloading:

  10. Step 7: After you find the file, double-click to open it.

  11. Some things to notice on this screen. Column I is missing. Column A is very narrow. The date is not easy to read. Total includes Check-ins. Row totals are entered as numbers and are not calculated. And, very importantly, Grand Totals by campus do not exist.

  12. Before we continue, please notice that on this report the Total includes Checkins. Normally, libraries count material usage, which excludes Checkins.However, the statistics we generate, report, and live by are no longer limited to counting mere usage. We want to include Checkins in our Circ Stats each month, because that measures total circulation activity for your library. This is an important measurement for staffing purposes.

  13. In addition, in order to ensure that this Activity Measurement includes as much library activity as possible, it is important to Check In new books, instead of verifying the records by using Item Status.While it’s true, that this will boost our In-House Usage statistic, we aren’t measuring usage, any more. We are measuring total activity. So it’s important to measure receiving new books as an activity.Now, back to finding your stats…………..

  14. Step 8: Find your campus statistics Scroll down to find your campus. Set your cursor in Column K, at the end of your last row of data.

  15. Step 9: Calculate the Grand Total for your campus. First, click on the Summation Symbol in the icon bar. That action produces an assumption by the software that you want to add across.

  16. Step 9: Calculate the Grand Total for your campus. But, we don’t want to add across. We want to add Column G down.

  17. Step 9: Calculate the Grand Total for your campus. To alter the shape of the Summation Selection Box, hold the CNTL key and press the RIGHT ARROW, until it looks like this.

  18. Step 9: Calculate the Grand Total for your campus. Release the CNTL key, then press and hold the SHIFT key, while repeatedly pressing the UP ARROW, until it looks like this. When ready, press ENTER.

  19. Step 9: Calculate the Grand Total for your campus. Pressing ENTER will total the numbers in column G that you specified. Before relying on this number, be sure to verify that the rows included are correct.

  20. Step 10: Verify the Calculation The formula for calculating your circulation statistics is: =SUM(G5:G9) Where you keep Column G, but the numbers will vary. This formula appears in the formula bar, near menu and tool bars, at the top of your Excel window.

  21. To get the formula to appear, you must click on the cell that has your total in it.

  22. Of course, if you are comfortable using Excel, you may wish to manually enter the formula in the formula bar for yourself, and dispense with the automatic Summation Boxes.

  23. As an idea for easily finding your campus again, if you intend to save this file for future reference, you may consider changing the font size or color of the calculated total, or perhaps making it BOLD.

  24. This tutorial is presented by Jennifer Carless,Director of Library Servicesfor Keiser University’sOrlando campus.

More Related