ACENET: Using Spreadsheets for Humanities, Social Sciences, & Librarians

Wed, Nov 8, 2023 @ 1:30pm - 4:30pm

Status: Completed

This introductory workshop offers best practices for data organization in spreadsheets for humanities, social sciences, & librarians.

Full title: Data Organization in Spreadsheets for Humanities, Social Sciences, & Librarians

T he session is the first of our Humanities & Social Sciences Data Organization & Analysis Series.

Beginner, 3 hours

Prerequisites: None

Requirements: Laptop or desktop computer with a Mac, Linux or Windows operating system that has Microsoft Excel or Google Sheets.

Good data organization is the foundation of any research project. Most researchers have data in spreadsheets, so it’s the starting place for many research projects. To use tools that make computation and analysis more efficient, such as programming languages like R or Python, we need to structure our data the way that computers need the data. This workshop aims to teach researchers, librarians, and information professionals basic concepts, skills, and tools for working with data to get more done quickly and with less pain. In this lesson, you will learn good data entry practices, how to avoid common formatting mistakes, approaches for handling dates in spreadsheets, basic quality control and data manipulation, and exporting data from spreadsheets. This domain-specific workshop focuses on examples and challenges from Humanities, Social Sciences, and library research fields and uses librarycarpentry.org materials.

This session will be delivered online.

Participants must register using their institutional / organizational email address (not a personal email, ie. gmail).

Connections details for the session as well as further preparation information will be sent out prior to the session.

For more ACENET events, click here.