Sept 11 and Sept 15, 2023
09:00 am - 4:00 pm
Instructors: Søren Willer Hansen, Lars Kjær, Lorna Wildgaard, Asger Væring Larsen, Henrik Hornemann, Ene Rammer Neilsen
Helpers: Christian B. Knudsen, Søren Davidsen, Daniel Pryn
This workshop is provided in collaboration with Copenhagen University's Digital Literacy and Skills initiative. Data Carpentry develops and teaches workshops on the fundamental data skills you'll need to manage data throughout your studies. The target audience is students who have little to no prior computational experience, and the skills taught during the workshop can be applied in all disciplines where you work with data in sheets. You will quickly be able to apply what you have learned in your own projects. Digital development is constantly evolving, affecting society as well as the labour market. It is therefore important that you as a student can use both during your studies and when you graudate. In order to ensure this, all students at UCPH will during their Bachelor degree programme, acquire knowledge of five topics in the field of digitisation. These topics are gathered in the UCPH model for students' digital literacy and competencies. This workshop gives you hands-on practice in managing data. Participants will be encouraged to help each other.
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 students and others interested in an introduction to responsible approaches to managing data in sheets. You don't need to have any previous knowledge of the tools that will be presented at the workshop.
Where: Undervisningslokale 1, Copenhagen University Library, Karen Blixens Plads 7, 2300 Copenhagen S.. Get directions with Google Maps.
When: Sept 11 and Sept 15, 2023. 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).
Registration: Click here. On the registration form, choose which lessons you want to take part in. There is a learning progression from lesson to lesson, so dive in and join us in all the lessons to get the most out of the workshop!
Contact: Please email lowi@kb.dk for more information.
Roles: To learn more about the roles at the workshop (who will be doing what), refer to our Workshop FAQ.
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.
Please be sure to complete these surveys before and after the workshop.
Before starting | Pre-workshop survey |
09:00-09:10 | Welcome |
09:15-09:45 | Filenaming and formatting |
09:50-12:00 | Data Organization in Spreadsheets |
13:00-15:45 | OpenRefine for Data Cleaning |
15:45-16:00 | Wrapping up |
09:00-09:10 | Welcome |
09:15-11:15 | Best practices in Excel |
11:30-12:30 | Getting started in SQL |
13:00-15:00 | Data Management with SQL |
15:00-15:15 | Wrapping up |
Post-workshop survey |
To participate in a Data Carpentry workshop, you will need access to software as 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.
Before the workshop, please make sure you have installed OpenRefine. The installation instructions can be found at https://openrefine.org/docs/manual/installing. You will also need to install DB Browser for SQlite, found at https://datacarpentry.org/sql-socialsci/. If you need help with the installation, drop by the KUB Datalab, at Copenhagen University Library, North Campus, Nørre Allé 49, any Wednesday between 12:30 pm and 02:00 pm.