Data Carpentry Workshop at UC Riverside
Data Organization in Spreadsheets
Part of the UCR Library Summer workshop series, Working With Data

University of California, Riverside ONLINE

August 7, 2020

10:00 a.m. - 12 noon

Instructors: Kat Koziar

Helpers: Rachel Starry

General Information

Data Carpentry develops and teaches workshops on the fundamental data skills needed to conduct research. Its target audience is researchers who have little to no prior computational experience, and its lessons are domain specific, building on learners' existing knowledge to enable them to quickly apply skills learned to their own research. Participants will be encouraged to help one another and to apply what they have learned to their own research problems.

For more information on what we teach and why, please see our paper "Good Enough Practices for Scientific Computing".

Who: The course is aimed at graduate students and other researchers. You don't need to have any previous knowledge of the tools that will be presented at the workshop.

Where: Online (ignore the following coordinates, this workshop is online!). Get directions with OpenStreetMap or Google Maps.

When: August 7, 2020. Add to your Google Calendar.

Requirements: Participants must bring a laptop with a Mac, Linux, or Windows operating system (not a tablet, Chromebook, etc.) that they have administrative privileges on. They should have a few specific software packages installed (listed below).

Accessibility: We are committed to making this workshop accessible to everybody. For workshops at a physical location, the workshop organizers have checked that:

Materials will be provided in advance of the workshop and large-print handouts are available if needed by notifying the organizers in advance. If we can help making learning easier for you (e.g. sign-language interpreters, lactation facilities) please get in touch (using contact details below) and we will attempt to provide them.

Contact: Please email katherine.koziar@ucr.du for more information.


Code of Conduct

Everyone who participates in Carpentries activities is required to conform to the Code of Conduct.This document also outlines how to report an incident if needed.


Surveys

Please be sure to complete these surveys before and after the workshop.

Pre-workshop Survey

Post-workshop Survey


Schedule

August, 2020
We'll take breaks as needed

10:00 Data Organization in Spreadsheets
11:00 10 min break
12:00 END

Working with Data Workshop Series
Friday Mornings, Summer 2020

July 24, 2020 The Unix Shell,
Register for Workshop, View the Workshop Repository
July 31, 2020 Version control with Git,
Register for Workshop, View the Workshop Repository
   
August 7, 2020 Data Organization in Spreadsheets (this workshop),
Register for Workshop, View the Workshop Repository
   
August 14, 2020 Introduction to Data Visualization,
Register for Workshop
   

Syllabus


Setup

To participate in a Data Carpentry workshop, you will need access to the software described below. In addition, you will need an up-to-date web browser.

We maintain a list of common issues that occur during installation as a reference for instructors that may be useful on the Configuration Problems and Solutions wiki page.

Data Organization in Spreadsheets

To interact with spreadsheets, we can use LibreOffice, Microsoft Excel, Gnumeric, or other programs. Commands may differ a bit between programs, but the general ideas for thinking about spreadsheets are the same.

For this lesson, if you don't have a spreadsheet program already, you can use LibreOffice. It's a free, open source spreadsheet program.

macOS users who use Apple's Numbers application should note that it does not contain some of the features (particularly data validation) that we will be using. Please use LibreOffice or Microsoft Excel instead.

  • Download the Installer
  • Install LibreOffice by going to the installation page. The version for Windows should automatically be selected. Click Download Version X.X.X (whichever is the most recent version).
  • Install LibreOffice
  • Once the installer is downloaded, double click on it and LibreOffice should install.

  • Download the Installer
  • Install LibreOffice by going to the installation page. The version for Mac should automatically be selected. Click Download Version X.X.X (whichever is the most recent version).
  • Install LibreOffice
  • Once the installer is downloaded, double click on it and LibreOffice should install.

  • Download the Installer
  • Install LibreOffice by going to the installation page. The version for Linux should automatically be selected. Click Download Version X.X.X (whichever is the most recent version).
  • Install LibreOffice
  • Once the installer is downloaded, double click on it and LibreOffice should install.
Package manager option:
  • pacman (Arch): pacman -S libreoffice
  • yum (Fedora, CentOS): yum install libreoffice
  • apt (Debian, Ubuntu): apt install libreoffice