Open Access. Powered by Scholars. Published by Universities.®
Articles 1 - 2 of 2
Full-Text Articles in Entire DC Network
An Old Tool With Enduring Value: Using Excel To Prepare Data For Analysis, Gregory A. Smith
An Old Tool With Enduring Value: Using Excel To Prepare Data For Analysis, Gregory A. Smith
Faculty Publications and Presentations
Microsoft Excel was first released on the Windows platform 30 years ago and has since become widely used. Although new tools for manipulating, analyzing, and visualizing data are constantly emerging, Excel remains a potent tool—and not just because of newer features. Simple functions such as TRIM, MID, SUBSTITUTE, FIND, ROUNDDOWN, and VLOOKUP can be used to manipulate data sets in powerful ways.
This workshop applies selected functions to realistic library data sets. Demonstrations include:
- deriving time-series categories from date and time stamps
- pre-coding survey comments based on keywords
- dealing with messy data points such as …
Retooling The Profession: Librarianship In An Era Of Accountability And Competition, Gregory A. Smith
Retooling The Profession: Librarianship In An Era Of Accountability And Competition, Gregory A. Smith
Faculty Publications and Presentations
Librarianship has changed substantially in recent years. We who work in libraries must continually acquire new knowledge and skills. We must adapt to the reality that academic libraries, along with their parent institutions, face increased accountability. The functions that many of us have thought to be at the core of our profession are slipping from our grasp and will leave behind a mere managerial role. Nevertheless, many academic libraries will find a viable future by adopting and taking seriously the role of supporting learning. As we look at disruptive innovators in the information and learning scene, we should consider carefully …