Detailed information about the course
Title | Data Management for Ecologists and Evolutionary Biologists |
Dates | 16-17 March 2017 |
Organizer(s) | Malie Lessard-Therrien, University of Bern (CH) Dr. Dominique Roche, University of Neuchâtel (CH) |
Speakers | Dr. Roel van Klink, University of Bern (CH) |
Description | This workshop will teach you how to create a database in Microsoft Access or MySQL. You will also learn why good data management skills are important (especially in an era of big data) and learn to identify good and bad practices when organizing your own data and dealing with other people’s data.
You will learn the basics of relational databases (https://en.wikipedia.org/wiki/Relational_database_management_system) and the Structured Query Language (https://en.wikipedia.org/wiki/SQL) to subset and select (i.e. query) data from databases. One of the workshop’s main objectives is to help you create a database tailored to your own system, data, and research questions. Thus, the workshop will be most useful for students who already have data stored in some form (e.g. field notes, lab notes, simple digital formats) and are ready or have started to analyze them. The database you will create will be flexible to suit many different purposes and can be expanded in future experiments or projects. The aim is to make data entry as easy and flawless as possible, while making the database (re)user friendly.
In the final stages of the workshop, we will cover data export from the database software and import into R, and how to shape your data into any desired format for analysis. We will also cover best practices in data re-use (i.e. re-using data collected by other researchers) and simple tricks to reshape poorly stored data.
Course outline:Day 1 1) Lecture: importance of good data management do’s and don’ts 2) Practical: sketching of your data structure with respect to the aims of the research a. What questions do I seek to answer? b. What type of data do I have? c. How are the data currently stored and organized? d. What is the relation of these data to my other research questions/projects? e. What are potential ways in which people might want to re-use my data in the future? f. What types of statistical analyses will I carry out on these data? 3) Lecture: using queries to select data from your relational database 4) Lunch break 5) Create or improve your own database
Day 2 6) Lecture: using digital ‘forms’ to enter data into your relational database 7) Practical: make a form in your database 8) Lunch break 9) Lecture: importing data into R and reshaping it 10) Practical: R reshape 11) Lecture: best practices for data sharing and re-use |
Location |
University of Bern |
Credits | 1 |
Evaluation | Full attendance and Active participation |
Information | Requirements for attending the workshop:
Bring to the workshop:
When?16-17 March 2017
Where?Uni Tobler Kursraum, Room B -181, Länggassstrasse 49, 3012 Bern Way to classroom:
Classroom location: |
Expenses | Reimbursement:PhD students of the DPEE are eligible for reimbursement of incurred travel expenses by train (half-fare card, and 2nd class). Please send the original tickets (no copies, except for the general abonnement) with the reimbursement form to:
Caroline Betto-Colliard Doctoral Program in Ecology and Evolution DEE- Biophore Building University of Lausanne CH-1015 Lausanne
Concerning reimbursement of accommodation, please contact Caroline Betto-Colliard (ecologie-evolution(at)cuso.ch) BEFORE the beginning of the course.
For all other PhD students, please check reimbursement conditions on the website of your doctoral program |
Registration | Priority is given to PhD students of the DPEE and the Interuniversity Doctoral Program in Organismal Biology until 1st of March 2017. After this deadline, first comes, first serves
CUSO PhD students: through your MyCUSO account.
External participants (non-CUSO PhD students, post-docs, etc...): use the icon "registration" at top of page and the last gray box "non-CUSO student" ("personne hors myCUSO"). |
Places | 20 |
Deadline for registration | 07.03.2017 |