Skip to content
University of Maryland LibrariesDigital Repository at the University of Maryland
    • Login
    View Item 
    •   DRUM
    • University Libraries
    • Library Research & Innovative Practice Forum
    • View Item
    •   DRUM
    • University Libraries
    • Library Research & Innovative Practice Forum
    • View Item
    JavaScript is disabled for your browser. Some features of this site may not work without it.

    Title Normalization & Quality Control: Making Excel Work for You and Not the Other Way Around

    Thumbnail
    View/Open
    Poster Presentation (401.7Kb)
    No. of downloads: 34

    Date
    2019-06-11
    Author
    Burt, Claralyn
    Advisor
    Goldfinger, Rebecca
    DRUM DOI
    https://doi.org/10.13016/9mvf-i0q7
    Metadata
    Show full item record
    Abstract
    Every year, the Continuing Resources & Database Management Division systematically renews the journal and serial subscriptions for the Library.There are many moving parts resulting in a multi-step, multi-month workflow. This past 2018 renewal season, I streamlined the process in two innovative ways: title normalization and using the IF function in Excel as a quality control step. I began by cleaning the data to normalize the titles. After completing a rigorous vLookUp function, I added a quality control step with an IF function to ensure that the matches were accurate. Because I took the time to standardize and normalize my data at the beginning of this process, I could create a better, more inclusive formula. Ultimately, I did not have to manually check hundreds of titles because I engineered Excel to do it for me. This saved time and money in meeting the needs of the users and researchers here at McKeldin Library.
    Notes
    Every year, the Continuing Resources & Database Management Division systematically renews the journal and serial subscriptions for the Library.There are many moving parts resulting in a multi-step, multi-month workflow. This past 2018 renewal season, I streamlined the process in two innovative ways: title normalization and using the IF function in Excel as a quality control step. I began by cleaning the data to normalize the titles. After completing a rigorous vLookUp function, I added a quality control step with an IF function to ensure that the matches were accurate. Because I took the time to standardize and normalize my data at the beginning of this process, I could create a better, more inclusive formula. Ultimately, I did not have to manually check hundreds of titles because I engineered Excel to do it for me. This saved time and money in meeting the needs of the users and researchers here at McKeldin Library.
    URI
    http://hdl.handle.net/1903/21855
    Collections
    • Library Research & Innovative Practice Forum

    DRUM is brought to you by the University of Maryland Libraries
    University of Maryland, College Park, MD 20742-7011 (301)314-1328.
    Please send us your comments.
    Web Accessibility
     

     

    Browse

    All of DRUMCommunities & CollectionsBy Issue DateAuthorsTitlesSubjectsThis CollectionBy Issue DateAuthorsTitlesSubjects

    My Account

    LoginRegister
    Pages
    About DRUMAbout Download Statistics

    DRUM is brought to you by the University of Maryland Libraries
    University of Maryland, College Park, MD 20742-7011 (301)314-1328.
    Please send us your comments.
    Web Accessibility