Spreadsheet Workshop

In this workshop, we will introduce possible pitfalls as well as some good practice guidelines when creating spreadsheets.
Start
End
Type of event
Workshop
Venue
Speakers
Dr. Cora Assmann
Dr. Volker Schwartze
Language of the event
English
Event website
Wheelchair access
Yes
Public
Yes
Registration required
Yes
Spreadsheets, they are loved, hated and for many people indispensable. In science, they are a widely used way to organize data. However, there are many pitfalls and the uncritical handling of spreadsheets can lead to sever misunderstandings or problems, as the loss of data about more than 10,000 COVID-19 cases in the UK shows. But also without such severe consequences, spreadsheets can be a source of annoyance if files that were created by others or just in a different software are not understandable or usable without additional effort. In addition, good data documentation will be discussed and Colectica will be introduced as a tool. The workshop consists of theoretical and interactive part. The exercises are demonstrated in Excel, but can also be applied to other systems.