Love Data Week | Data TLC: Organizing Data with Spreadsheets Part 2

February 17, 2022 - 1:00pm to 2:00pm

 

University Library System

Good data organization is the foundation of any research project. Typically, we organize data in spreadsheets in ways that we as humans want to work with the data. However, computers require data to be structured in particular ways in order to use tools that make computation and analysis more efficient.

In this workshop, participants will learn  

  • How to document data for future use

  • Basic quality control and data manipulation in spreadsheets

  • How to export data from spreadsheets

This workshop will not cover data analysis with spreadsheets but will focus on the important initial “data wrangling” stage that enables you to do proper analysis later.

If you are new to using spreadsheets, don't forget to sign up for Part 1! Part 1 of this workshop will occur 12-1pm and will cover common uses for spreadsheets, good data entry and formatting practices, and how to avoid common formatting mistakes.

Can't make it to this workshop? You can always contact us with your questions about this and other digital scholarship topics.

This workshop is part of our Dealing with Data and Digital Humanities Toolkit Series.

Registration