ER&L 2015

February 22–25, 2015

Austin, Texas

Visit our "Search the ER&L 2015 Program" page to peruse all the accepted and peer-reviewed sessions for the 10th Anniversary Electronic Resources and Libraries Conference, February 22-25, 2015.

Click to view information about ER&L 2015 Online and Austin registration.

Data Entry Tips and Tricks

Wednesday, February 25, 2015 at 9:40 AM–9:55 AM CST

Room 301

Conference Track

1. Managing e-Resources & Licensing

Keywords

License, ERM, permitted uses, terms of use, ERM, web, macros, Excel, data entry

Learning Objectives

Labor for data entry projects, such as license data entry into an ERM, can be reduced using techniques such as pre-formatted data, macros for repetitive fields, quick keys and Notepad for text composition.
Excel, using Concatenate, can be used to quickly format permitted uses.
These techniques could be easily appropriated for other data entry projects.

Abstract

Unavoidable, by-hand data entry is intense and tedious. Using techniques such as formatting data pre-entry, and using macros for quick data entry and Excel to format changeable data such as permissions can reduce time and effort. Practical, immediately-usable techniques can be easily adapted to other data input projects.