Spreadsheet Workshop

1 Nov 2022 08:00
Course starts
1 Nov 2022 12:00
Course ends
7 places
Available places

Course further information

In this workshop, we will introduce possible pitfalls as well as some good practice guidelines when creating spreadsheets.

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.
Contact
zedif@uni-jena.de
Language
English
Core areas
  • Good practice in creating spreadsheets
  • Data documentation (metadata)
  • Colectica presentation
Maximum capacity
20
Location
Ernst-Abbe-Platz 2, Windows pool 2 (room 3417)
Dr. Cora Assmann
Course instructor
Dr. Volker Schwartze
Course instructor