Department

Circulation

Purpose

The library compiles and reports various statistics every year.

Overview

This outlines how to find checkout and renewal statistics and where they are reported.

Required Knowledge/Skills

Sierra

Sdrive

Safety Issues/Precautions

N/A

Equipment/Supplies

Access to Sierra Web Reports

Access to the Sdrive

Calculator

Procedure

1. Open the "Annual data from Circulation" spreadsheet found at S:\CCLS\Statistics\Circulation
2. All Data should be recorded under the "Raw Data" column.
3. After opening Sierra and using personal sign in click on "Web Management Reports" under "Reports" in the upper toolbar.
4. This will open Web Management Reports in a new web browser tab
5. In the lefthand toolbar under "CIrculation" click on "Circ Activity". 
6. You will need to use your personal Sierra login access this.
7. This will open a new toolbar on the left side.
8. For Check out you will do the following:
9. In the new toolbar under "Circ Stats" click on "Checkout"
10. Under "Dates" click on "User spec"
11. Under "Locations" click on "Special"
12. Scroll to the bottom of the toolbar and click on submit.
13. In the date screen, click on July of previous year and June of current year.
14. Click on submit.
15. Two reports will need to be run for Checkout and Renewal to capture all needed data.
16. On the next screen, type in the following Location Codes:
    1. cgen3
    2. cgen4
    3. cars0
    4. cars1
    5. cmerd
    6. cmevi
    7. cgeat
    8. cgest
    9. cgeus
    10. cmecd
17. Click on Submit
18. When the statistic table comes up write down the following numbers found in the "QTY" column grouped as follows.
19. Faculty:
    1. Faculty, Prof. Emeritus
    2. Faculty-Music
    3. Library Faculty
20. Students:
    1. Undergraduates
    2. Grad Students
    3. VU Special Student
21. Staff:
    
    1. Staff, VIsiting Scholars
    2. Attorneys, Law Alumni
    3. Regular Fee
    4. Alumni
    5. Family, Courtesy
    6. Library Staff
22. Click on "Recaluculate" to get the rest of the needed data;
23. The last of the Locations are as follows:
    1. cmega
    2. cmedi
    3. cmepr
    4. cmero
    5. cmesp
24. Click on "Status"
25. There will be fewer groups, but following the groupings in steps 17-19 write down the number of checkouts listed in "QTY"
26. Add up the numbers for each grouping and record them in the statistic spreadsheet, for each group.
27. For Renewals change Checkout to Renewal 
28. Click on Recalculate;
29. Follow Steps 15-25 
30. For Reserves Checkouts
31. In the left toolbar click back on Checkout 
32. Recalculate
33. In the next table use the following location codes
    1. cresg
    2. cresm
34. Put the total on the statistic spreadsheet in the correct location.
35. For Reserve Renewals
36. Change Checkout to Renewal
37. Recalculate
38. Follow Steps 32 and 33
39. For Laptop Checkouts and Renewals
40. Click on recalculate both"Checkout" and "Renewal" tables as above using the cmeeq as the only location code.
41. Add both the Checkout and Renewal together and record them in the Statistic Spreadsheet.
42. Save and close the spreadsheet.