Circulation

The library compiles and reports various statistics every year.

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

Sierra

Sdrive

N/A

Access to Sierra Web Reports

Access to the Sdrive

Calculator

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 "Submit"

25. Click on "Status"

26. There will be fewer groups, but following the groupings in steps 17-19 write down the number of checkouts listed in "QTY"

27. Add up the numbers for each grouping and record them in the statistic spreadsheet, for each group.

28. For Renewals change Checkout to Renewal 

29. Click on Recalculate;

30. Follow Steps 15-25 

31. For Reserves Checkouts

32. In the left toolbar click back on Checkout 

33. Recalculate

34. In the next table use the following location codes

    1. cresg

    2. cresm

35. Put the total on the statistic spreadsheet in the correct location.

36. For Reserve Renewals

37. Change Checkout to Renewal

38. Recalculate

39. Follow Steps 32 and 33

40. For Laptop Checkouts and Renewals

41. Click on recalculate for both "Checkout" and then for "Renewal" tables as above using the cmeeq as the only location code.

42. Add both the Checkout and Renewal Numbers together and record them in the Statistic Spreadsheet.

43. Save and close the spreadsheet.