Managing Cataloging Statistics with a Spreadsheet

By Shelton, Judith M. | Computers in Libraries, March 1995 | Go to article overview

Managing Cataloging Statistics with a Spreadsheet

Shelton, Judith M., Computers in Libraries

Statistics for cataloging are maintained for a variety of reasons. The library is interested in monitoring the total size of the collection and the total size of various components of the collection. The library also uses cataloging statistics to monitor workflow: since new titles generally take less time and effort to catalog than serial title changes and editing existing records generally takes less time and effort than creating new ones, it is useful to observe the kind and amount of such work being done.

These data are useful in planning the number and level of staff to request when opportunities for changes in staffing occur, while, data on the changing proportions of different components of the collection, such as the proportion of serials to monographs, are useful in developing the budget. In addition, one's bibliographic utility may charge different rates for different processes so these statistics are also useful in monitoring that budget. Cataloging statistics may also be used to supervise the progress of training of individual catalogers and, if used with care, may provide objective data for some aspects of performance evaluation.

Traditionally, cataloging statistics have been gathered and managed manually. Individual catalogers keep tallies of their cataloging activity which are then compiled into institutional tallies at regular intervals, usually monthly and annually. Depending on the size and organization of the library, there may be a variety of compilations at different levels of the organization between the individual and the library as a whole.

For example, Pullen's Catalog Department is organized into units whose supervisors find it useful to develop statistical compilations to aid in managing their units' workflow and training activities.

The development of spreadsheet programs for personal computers inspired in me the desire to automate this labor intensive statistics-keeping function and I volunteered to make this a personal project. Accomplishing this goal turned out to be far more difficult than I or my department head ever anticipated.

For one thing, the training available in the use of particular spreadsheet products is grossly inadequate. The exercises and examples used never address the situations encountered in libraries, often being too simplistic, not to mention business-oriented. (The same criticism can be made of almost any application software not developed specifically for libraries, including wordprocessing and database programs.) Anyone setting out to automate cataloging statistics using a commercial spreadsheet program must accept that they will have to train themselves.

A more critical difficulty, however, is the actual complexity of cataloging statistics. It would seem that the calculation of cataloging statistics is very basic mathematics. One adds things cataloged and subtracts things removed from the collection. One rarely needs to multiply or divide and higher math, let alone fancy statistical operations, is not needed.

The simplicity of the math is deceptive. Complications arise when one begins to categorize the things being counted: titles v. pieces; monographs v. serials; book format v. other formats; copy v. original; new titles v. added volumes and copies; government documents v. general collection; one cataloger v. another; this month v. last month.

Because of the different uses to which the statistics are put, it is not unusual for an item, being cataloged to be recorded in more than one way. At Pullen, even a simple monograph represents three different categories: a title, an item and the source of copy. A new periodical may represent a title and the source of copy, but no item, since we catalog from the first issue but do not count items until they are added to the correction in permanent form (e.g. bound or microfilmed). An added volume to a monographic set or serial represents an item but not a new title, and therefore no source of copy either. …

The rest of this article is only available to active members of Questia

Sign up now for a free, 1-day trial and receive full access to:

  • Questia's entire collection
  • Automatic bibliography creation
  • More helpful research tools like notes, citations, and highlights
  • Ad-free environment

Already a member? Log in now.

Notes for this article

Add a new note
If you are trying to select text to create highlights or citations, remember that you must now click or tap on the first word, and then click or tap on the last word.
One moment ...
Default project is now your active project.
Project items

Items saved from this article

This article has been saved
Highlights (0)
Some of your highlights are legacy items.

Highlights saved before July 30, 2012 will not be displayed on their respective source pages.

You can easily re-create the highlights by opening the book page or article, selecting the text, and clicking “Highlight.”

Citations (0)
Some of your citations are legacy items.

Any citation created before July 30, 2012 will labeled as a “Cited page.” New citations will be saved as cited passages, pages or articles.

We also added the ability to view new citations from your projects or the book or article where you created them.

Notes (0)
Bookmarks (0)

You have no saved items from this article

Project items include:
  • Saved book/article
  • Highlights
  • Quotes/citations
  • Notes
  • Bookmarks
Cite this article

Cited article

Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

(Einhorn, 1992, p. 25)

(Einhorn 25)


1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25,

Cited article

Managing Cataloging Statistics with a Spreadsheet


Text size Smaller Larger Reset View mode
Search within

Search within this article

Look up

Look up a word

  • Dictionary
  • Thesaurus
Please submit a word or phrase above.
Print this page

Print this page

Why can't I print more than one page at a time?

Full screen

matching results for page

Cited passage

Citations are available only to our active members.
Sign up now to cite pages or passages in MLA, APA and Chicago citation styles.

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn, 1992, p. 25).

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences." (Einhorn 25)

"Portraying himself as an honest, ordinary person helped Lincoln identify with his audiences."1

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25,

Cited passage

Welcome to the new Questia Reader

The Questia Reader has been updated to provide you with an even better online reading experience.  It is now 100% Responsive, which means you can read our books and articles on any sized device you wish.  All of your favorite tools like notes, highlights, and citations are still here, but the way you select text has been updated to be easier to use, especially on touchscreen devices.  Here's how:

1. Click or tap the first word you want to select.
2. Click or tap the last word you want to select.

OK, got it!

Thanks for trying Questia!

Please continue trying out our research tools, but please note, full functionality is available only to our active members.

Your work will be lost once you leave this Web page.

For full access in an ad-free environment, sign up now for a FREE, 1-day trial.

Already a member? Log in now.