Working with Spreadsheets: a workshop

Image of hand-drawn spreadsheet

What: Working with Spreadsheets: a workshop

When: 10:00—16:30, Tuesday 21 November

Where: Centre for Digital Scholarship, Weston Library (map)

Access: open to all members of the University

Admission: free

Trainers: Iain Emsley and Pip Willcox

Registration is required: please see below

This workshop is designed for anyone who works with spreadsheets and wants to learn how to explore that data more efficiently and consistently. No prior experience is required. The hands-on workshop teaches basic concepts, skills, and tools for working more effectively and reproducibly with your data.

We will cover data organization in spreadsheets and OpenRefine for managing data.

By the end of the workshop participants will be able to manage and analyze data effectively and be able to apply the tools and approaches directly to their ongoing research.

The workshop draws on lessons prepared by Data Carpentry and adapted by the trainers for use with Early English Books Online Text Creation Partnership data.

The methods that you will learn will be applicable to work in any field that uses spreadsheets. The EEBO-TCP subject matter we will use may be of particular interest to people working with library or early modern data.

Registration

To register, please email Pip Willcox (pip.willcox@bodleian.ox.ac.uk) with:

  • Your name
  • Your ox.ac.uk email address
  • Your departmental affiliation

This workshop is run in collaboration with the Centre for Digital Scholarship and the Reproducible Research Oxford project.

For announcements about future workshops and related activities run by Reproducible Research Oxford, please see the project website, subscribe to the mailing list, and follow the project on Twitter @RR_Oxford.

Equipment

Participants are requested to bring a laptop. To work with with spreadsheets, you will need an application such as Microsoft Excel, Mac Numbers, or OpenOffice.org. If you don’t have a suitable program installed, you might like to use LibreOffice, a free, open source spreadsheet program.

You will also need OpenRefine (formerly Google Refine) and a web browser, and to have Java installed.

If you cannot bring a laptop with you, please let us know before the day.

Trainers

Iain Emsley works for the University of Oxford e-Research Centre on digital library and museums projects. Having recently finished an MSc in Software Engineering, he has started a PhD in Digital Media at Sussex University.

Pip Willcox is the Head of the Centre for Digital Scholarship at the Bodleian Libraries and a Senior Researcher at the University of Oxford e-Research Centre.

Image credit: Stockbyte/Getty Images.

Comments are closed.