Social and Behavioral Sciences Commons^™

An Old Tool With Enduring Value: Using Excel To Prepare Data For Analysis, Gregory A. Smith

Gregory A. Smith

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 call numbers and publisher names …

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 …

Librarians' Perceptions Of Artificial Intelligence And Its Potential Impact On The Profession, Barbara A. Wood, David Evans

Faculty and Research Publications

The subject of artificial intelligence (AI) is being discussed everywhere in the media. Stephen Hawking, Elon Musk, and Bill Gates regularly sound the alarm about AI as an existential threat to humankind. Open a newspaper, turn on the television, or log on to the internet, and you will find a plethora of information and opinions on AI and its potential impact on human endeavors. In addition to being a hot topic in the media, the scholarly literature in medicine and law is replete with AI research. It acknowledges AI as a transformative, if not disruptive, game changer. AI is being …

Essentialism, Social Construction, Or Individual Differences, Jenelys Cox, Jeff Rynhart, Shea-Tinn Yeh

University Libraries: Staff Scholarship

Per the United States Department of Labor Women’s Bureau’s latest available statistics, the percentage of women employed in computer and information technology occupations was consistently lower than the average for all occupations. When broken down by selected characteristics, these numbers range from 12.4% in computer network architectures to 35.2% in web development. Is this trend reflected in the libraries? Although no comprehensive statistics are available for women in library IT, Lamont’s study does reflect the same trend in that the number of women as library IT department heads has been about one half that of men between 2004-2008. Why is …