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.
Presenters
![[photo]](https://secure.gravatar.com/avatar/fccf90d5b4215c2960fc1903392d9e22.png?d=https://proposalspace.com/images/no_photo.png&r=PG&s=50 "Margaret Hogarth, MLIS, MS Environmental Studies, The Claremont Colleges Library")