Event box

Survival Skills: Formatting Information for Analysis

Spreadsheets and data tables are tools to store and organize information collected from scholarly research or administrative projects, teaching, or class work. Whether you are exporting the data to other programs (such as R or Python) or keeping it in your spreadsheet program (such as Excel, Numbers, or LibreOffice), good organization is the key to making your tables useful for analysis or reference.

By the end of this workshop, you should be able to:

  • Implement better practices in data and information organization
  • Identify and address common formatting mistakes, including handling dates, numbers, and text
  • Be aware of basic quality control features
  • Effectively export data from spreadsheet programs to universal formats

There are no pre-requisites for this workshop. We will discuss concepts, so bringing a computer or any software is not needed.

This workshop will be offered in a hybrid format, both in person and on Zoom. This workshop is typically offered once per semester and can also be scheduled on request.  Automatic captioning will be provided via Zoom. The curriculum is freely available online at: https://osf.io/jwg8u/. We have no scheduled breaks during this one-hour workshop. Gendered/family restrooms are available on the same floor. Food and drinks are not provided but Bizzell Memorial Library has a coffee shop on LL1 (hours may vary) and vending machines on LL1, in the hall east of LL118 (the community room).  Water fountains are available on all floors. For additional accommodations on the basis of disability, please contact the workshop instructor or .

Registration is required to receive the Zoom link.

Questions? Contact Amanda Schilling, amanda.schilling@ou.edu.

Wednesday, February 15, 2023
10:30am - 11:30am
LL 123 Classroom
Bizzell Memorial Library
Research Workshops—OU Libraries
Registration has closed.