Reproducible research in spreadsheets with Stencila

A3 | Fri 25 Jan | 1:30 p.m.–3:10 p.m.

Presented by

  • Aleksandra Pawlik

    Aleksandra works as a Community Advocate for Stencila, the open source suite of components for reproducible research. Her role focuses on understanding users’ needs to direct Stencila development and supporting open source developer community. Aleksandra has been working in the research software area for over 7 years coordinating training for the Software Sustainability Institute in the UK and then for the New Zealand eScience Infrastructure. Aleksandra is a Software and Data Carpentry certified instructor and has trained other instructors in Europe, South Africa, Australia and New Zealand.


Spreadsheets are ubiquitous in research world but their convenience of use comes with the high price of lack of transparency and reproducibility. Stencila is an open source suite of components allowing users locked in spreadsheets step into the world of open source research tools underpinned by Python, JavaScript, R or Jupyter Kernels. During this hands-on (bring your laptops!) tutorial you will work through a sample dataset filtering, cleaning and visualising data in order to draft up a fully interactive and reproducible research article (or a report). We will use some R, some Python and some JavaScript.