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

Open the "Annual data from Circulation" spreadsheet found at S:\CCLS\Statistics\Circulation
All Data should be recorded under the "Raw Data" column.
After opening Sierra and using personal sign in click on "Web Management Reports" under "Reports" in the upper toolbar.
This will open Web Management Reports in a new web browser tab
In the lefthand toolbar under "CIrculation" click on "Circ Activity".
You will need to use your personal Sierra login access this.
This will open a new toolbar on the left side.
For Check out you will do the following:
In the new toolbar under "Circ Stats" click on "Checkout"
Under "Dates" click on "User spec"
Under "Locations" click on "Special"
Scroll to the bottom of the toolbar and click on submit.
In the date screen, click on July of previous year and June of current year.
Click on submit.
Two reports will need to be run for Checkout and Renewal to capture all needed data.
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
Click on Submit
When the statistic table comes up write down the following numbers found in the "QTY" column grouped as follows.
Faculty:
1. Faculty, Prof. Emeritus
2. Faculty-Music
3. Library Faculty
Students:
1. Undergraduates
2. Grad Students
3. VU Special Student
Staff:
1. Staff, VIsiting Scholars
2. Attorneys, Law Alumni
3. Regular Fee
4. Alumni
5. Family, Courtesy
6. Library Staff
Click on "Recaluculate" to get the rest of the needed data;
The last of the Locations are as follows:
1. cmega
2. cmedi
3. cmepr
4. cmero
5. cmesp
Click on "Submit"
Click on "Status"
There will be fewer groups, but following the groupings in steps 17-19 write down the number of checkouts listed in "QTY"
Add up the numbers for each grouping and record them in the statistic spreadsheet, for each group.
For Renewals change Checkout to Renewal
Click on Recalculate;
Follow Steps 15-25
For Reserves Checkouts
In the left toolbar click back on Checkout
Recalculate
In the next table use the following location codes
1. cresg
2. cresm
Put the total on the statistic spreadsheet in the correct location.
For Reserve Renewals
Change Checkout to Renewal
Recalculate
Follow Steps 32 and 33
For Laptop Checkouts and Renewals
Click on recalculate for both "Checkout" and then for "Renewal" tables as above using the cmeeq as the only location code.
Add both the Checkout and Renewal Numbers together and record them in the Statistic Spreadsheet.
Save and close the spreadsheet.

Browser not supported