Login for PhD students at UCPH      Login for others
From Excel to R
Provider: Faculty of Health and Medical Sciences

Activity no.: 3341-25-00-00There are 16 available seats 
Enrollment deadline: 28/02/2025
Date and time31.03.2025, at: 08:00 - 01.04.2025, at: 16:00
Regular seats35
Course fee2,760.00 kr.
LecturersAnders Krogh
ECTS credits1.50
Contact personHeaDS Administration    E-mail address: heads-admin@sund.ku.dk
Enrolment Handling/Course OrganiserPhD administration     E-mail address: phdkursus@sund.ku.dk

Aim and content

This is a generic course. This means that the course is reserved for PhD students at the Graduate School of Health and Medical Sciences at UCPH.

Anyone can apply for the course, but if you are not a PhD student at the Graduate School, you will be placed on the waiting list until enrollment deadline. After the enrolment deadline, available seats will be allocated to the waiting list.

The course is free of charge for PhD students at Danish universities (except Copenhagen Business School), and for PhD students at NorDoc member faculties. All other participants must pay the course fee.


Learning objectives

A student who has met the objectives of the course will be able to:

1. Define and explain the use of basic programming concepts in the scripting language R.

2. Perform data wrangling/data management tasks using the tidyverse framework.

3. Visualize data and results of analysis with the ggplot2 package.

4. Understand the use of tidyverse and ggplot2 in the context of applied statistics/bioinformatics in R.

5. Demonstrate best practice when working in R, importantly in regard to generating reproducible scientific results with R Markdown.


Content

The course From Excel to R will spend time on making participants familiar with Rstudio, directory paths, scripts, R-projects, help functions, shortcuts, etc., to ensure that the users will have a solid understanding of the practicals before diving into using the scripting language itself. The course is taught mainly using the R-framework tidyverse, a variety of R-functions and syntax which make data-wrangling much more intuitive for first time R-users. Tidyverse will form the basis for the other major focal point of the course, that is, plotting with ggplot2.

Next, the course will allow participants to test out their newly acquired skills in data wrangling and visualization on an example of basic applied statistics in R, simultaneously introducing them to the strength of R as a statistical programming language. Participants will also briefly be introduced to R Markdown for reproducible report making in R.

The learning outcome of the course is to provide attendees with the basic skills for manipulating and setting up data for visualization and analysis in R.


Participants

Seats: 35

From Excel to R is an introductory course targeted towards people with no (or very limited) experience in R.


Relevance to graduate programmers

The course is relevant to PhD students from the following graduate programs at the Graduate School of Health and Medical Sciences, UCPH:

All graduate programs


Language

English


Form

Lectures, interactive presentations from within R, group work and exercises.

N.B: Before the course starts participants must have installed the newest versions of R & Rstudio, as well as a list of packages provided by instructors, this is done to alleviate any installation issues on the course days. Anyone with installation issues can join for a technical help session on the first day of the course between 08:30 – 09:00.


Course director

Anders Krogh,
Professor, Head of Center for Health Data Science,
Center for Health Data Science,
anders.krogh@sund.ku.dk


Teachers

Thilde Terkelsen
PhD, Data Scientist
Center for Health Data Science
thilde.terkelsen@sund.ku.dk

Henrike Zschach,
PhD, Data Scientist
Center for Health Data Science
henrike.zschach@sund.ku.dk

Adrija Kalvisa
PhD, Special Consultant
reNEW
adrija.kalvisa@sund.ku.dk

Tugce Karaderi,
PhD, Assistant Professor
Center for Health Data Science
tugce.karaderi@sund.ku.dk


Dates

31 March – 1 April 2025 - 08:00 - 16:00


Course location

Room TBD
Faculty of Health and Medical Sciences, Panum,
Blegdamsvej 3B, 2200 København


Registration

Please register before 28 February 2025.


Expected frequency

The course will run again twice in Fall 2025.

Seats to PhD students from other Danish universities will be allocated on a first-come, first-served basis and according to the applicable rules. Applications from other participants will be considered after the last day of enrolment.

Note: All applicants are asked to submit invoice details in case of no-show, late cancellation or obligation to pay the course fee (typically non-PhD students). If you are a PhD student, your participation in the course must be in agreement with your principal supervisor.

Search
Click the search button to search Courses.


Course calendar
See which courses you can attend and when
JanFebMarApr
MayJunJulAug
SepOctNovDec



New courses
Courses are published regularly. High demand courses are announced in spring and autumn.


Learn which courses are announced on fixed dates