You Have How Many Spreadsheets? Rethinking Electronic Resource Management

By Rux, Erika; Borchert, Theresa | Computers in Libraries, October 2010 | Go to article overview

You Have How Many Spreadsheets? Rethinking Electronic Resource Management


Rux, Erika, Borchert, Theresa, Computers in Libraries


Meet Theresa Borchert, the electronic resources librarian at our library. Theresa's email inbox is a disaster. Or rather, it was. Concordia College, a small liberal arts college in the Midwest where author Erika Rux also is employed as computer and web services librarian, had a library like every other in the country. Our internet-based resources and collections were growing exponentially, and we were poorly equipped to handle the explosion. Theresa had become a "hub." She and she alone knew where to find passwords, terms for license agreements, email support addresses, and anything else we needed to process and update access for our online resources. She was maintaining multiple spreadsheets, many of which contained duplicate information; her paper file cabinet was overflowing; and her email inbox was an unwieldy mess of messages containing passwords, updated passwords, contact information, new contact information, etc. Additionally, while Theresa's workload was steadily increasing, members of the staff who were managing print resources found their workloads decreasing. We needed a better solution. We needed to organize all of this information in a more efficient way, and we needed to store it in a place where multiple members of our staff could access it.

Investigating ERMs

We knew that there were commercially available electronic resource managers (ERMs) that might suit our needs, and we decided to start with an investigation of those options. After reading articles written by Marshall Breeding, Maria Collins, and Donna Ekart about the major commercial systems available, we developed an information-gathering plan. Staff members wanted to know what other libraries were doing, and we needed to prioritize our requirements.

Our first step was to poll librarian colleagues through an email list. We asked about experiences with the different vendors, and we began collecting data about the pros and cons of each. Simultaneously, we began analyzing our current practices. We considered the data we were already trying to manage, brainstormed about new information that needed to be tracked, and looked at our current workflow to begin thinking about ways to increase our effectiveness and efficiency.

The results of our investigation were somewhat surprising to us. One of the tools we learned of was very appealing, but it was still in development. Others provided attractive features (e.g., robust knowledgebases containing metadata for the major databases, server space to store and preserve data, and support and ongoing development). But the challenges these systems posed for our library quickly began to outweigh these benefits. None of the commercial tools did everything that we wanted it to do. None of them provided an out-of-the-box solution to all of our challenges. And all of the products came with significant costs--they presented budgetary challenges in the form of initial setup and training costs, as well as ongoing contractual obligations. With any system we decided to implement, we realized that our commitment of staff time was going to be immense. These realizations weighed heavily on us, and we decided that the commercial tools could not provide the solution that we had hoped to find.

Still, we knew that if we continued on the path we were following, our problems would only become more unmanageable. In the past, we had discussed creating our own relational database using Microsoft Access, and we returned to those conversations. We read about William Doering and Galadriel Chilton's self-created ERM that could be stored on an institution's local server. This system seemed to come closer to filling our needs in terms of customization, and the price was much more accessible. However, after downloading the program, we determined that it really didn't provide us with what we needed. We needed a product or system that could be accessed by multiple simultaneous users. We needed a system that was user-friendly and would not require a lot of technical knowledge and training for our technical services staff.

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 ...
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
Notes
Cite this article

Cited article

Style
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

1. Lois J. Einhorn, Abraham Lincoln, the Orator: Penetrating the Lincoln Legend (Westport, CT: Greenwood Press, 1992), 25, http://www.questia.com/read/27419298.

Cited article

You Have How Many Spreadsheets? Rethinking Electronic Resource Management
Settings

Settings

Typeface
Text size Smaller Larger
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

Style
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, http://www.questia.com/read/27419298.

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.