Summary and Schedule

A hands-on workshop that builds on what you already know from SPSS to get you productive in R. No programming experience required. By the end, you will be running analyses, creating publication-quality visualizations, and working in a fully reproducible workflow.
This course is developed by Rendell de Kort (University of Aruba / DCDC Network) and is open and freely reusable under a CC-BY 4.0 license.
Schedule
The workshop runs on two days at the University of Aruba, 22 and 24 April 2026, 9:00 to 16:00 on both days. Lunch and coffee breaks are built in. Each topic below links to the corresponding episode so you can jump directly to the material.
Day 1 · Tuesday 22 April
| Time | Topic |
|---|---|
| 09:00 – 09:10 | Welcome and introductions |
| 09:10 – 09:55 | Episode 1 — The case for switching |
| 09:55 – 10:10 | Coffee break |
| 10:10 – 11:40 | Episode 2 — Your first R session |
| 11:40 – 12:00 | Questions and consolidation |
| 12:00 – 13:00 | Lunch |
| 13:00 – 14:30 | Episode 3 — Data manipulation |
| 14:30 – 14:45 | Afternoon break |
| 14:45 – 15:45 | Episode 4 — Your first visualization |
| 15:45 – 16:00 | Wrap-up and homework brief |
Between Day 1 and Day 2: the homework
The 48 hours between the two days is when the course content becomes a skill. A short practice assignment is waiting for you on a dedicated page, so you can reopen it from any device overnight:
→ Day 1 homework brief
Pick a dataset you already use, write a short R script that imports it, transforms it, summarises it, and charts it. Thirty to sixty minutes is plenty. Bring the script to the Day 2 open lab.
Day 2 · Thursday 24 April
| Time | Topic |
|---|---|
| 09:00 – 09:30 | Review and troubleshooting |
| 09:30 – 09:45 | Short break |
| 09:45 – 10:45 | Episode 5 — Statistical analysis, part 1 |
| 10:45 – 11:00 | Coffee break |
| 11:00 – 12:00 | Episode 5 — Statistical analysis, part 2 |
| 12:00 – 13:00 | Lunch |
| 13:00 – 14:00 | Episode 6 — Reproducible reporting |
| 14:00 – 14:15 | Afternoon break |
| 14:15 – 15:00 | Episode 7 — Where to go from here |
| 15:00 – 15:45 | Open lab |
| 15:45 – 16:00 | Wrap-up and next steps |
Who is this for?
This course is designed for anyone who currently uses SPSS and wants to transition to a free, more powerful alternative. You do not need any programming experience. If you understand basic statistical concepts like means, standard deviations, and hypothesis testing, you have everything you need to start.
- Students
- Using SPSS for coursework or thesis research and looking for a cost-free alternative
- Lecturers
- Teaching research methods and interested in integrating open-source tools into courses
- Researchers
- Seeking reproducible analysis workflows and better visualization capabilities
- Institutional analysts
- Working with data in government, healthcare, or policy and paying for software licenses
| Setup Instructions | Download files required for the lesson | |
| Duration: 00h 00m | 1. The Case for Switching |
Why should I switch from SPSS to R? What can R do that SPSS cannot? How much does SPSS actually cost compared to R? |
| Duration: 00h 45m | 2. Your First R Session |
How does RStudio compare to the SPSS interface? How do I import data, including SPSS .sav files?How do I get descriptive statistics and frequency tables in R? |
| Duration: 02h 15m | 3. Data Manipulation |
How do I filter, sort, and recode data in R the way I do in
SPSS? What is the tidyverse and why does it matter? How do I create new variables from existing ones? |
| Duration: 03h 45m | 4. Visualization with ggplot2 |
How do I create charts in R that look better than SPSS Chart Builder
output? What is the ggplot2 “grammar of graphics” approach? How do I customize colors, labels, and themes? |
| Duration: 04h 45m | 5. Statistical Analysis in R |
How do I run t-tests, ANOVA, correlations, and regression in R? How does R output compare to SPSS output tables? How do I extract and report results? |
| Duration: 06h 45m | 6. Reproducible Reporting |
How do I combine my analysis and write-up in one document? What is R Markdown and why is it better than copy-pasting from SPSS output? How do I create a report that updates when data changes? |
| Duration: 07h 45m | 7. Where to Go from Here |
Where do I find help when I get stuck? What resources are available for continued learning? How do I access Dutch Caribbean data directly from R? |
| Duration: 08h 30m | Finish |
The actual schedule may vary slightly depending on the topics and exercises chosen by the instructor.
You need to install R and RStudio before the first session on April 22. Both are free. Follow the instructions below for your operating system.
Using a work-issued laptop? Check with IT first
Many universities and employers lock their laptops so that users cannot install software themselves. If your laptop was issued by an institution, check with your IT department before following the steps below, otherwise the installer will simply fail.
University of Aruba laptops require a ticket through TopDesk. When you submit the ticket, explicitly ask IT to install both R and RStudio. Asking for only one of them is a common cause of a half-working setup that wastes course time.
Give IT at least a week to process the request so your laptop is ready before the first session.
Pre-workshop installation clinic
We will not spend course time on installation troubleshooting. To make sure everyone starts ready to go, there is an optional drop-in session before the course:
When: Thursday, April 16, 2026, 9:00 – 12:00 Where: University of Aruba Research Center What: Bring your laptop. We help you install R and RStudio, verify everything works, and install the required packages. Walk in, walk out.
If you cannot attend the clinic, follow the instructions below and
test your setup by opening RStudio and typing 1 + 1 in the
console. If it returns 2, you are ready.
Software Setup
Install R and RStudio
You need both R (the language) and RStudio (the interface). Think of R as the engine and RStudio as the dashboard — you will work in RStudio, but it needs R installed to run.
- Download R from CRAN — click “Download R for Windows”, then “base”, then the download link.
- Run the installer with default settings.
- Download RStudio from Posit — click “Download RStudio Desktop”.
- Run the RStudio installer with default settings.
- Open RStudio — if you see a console panel with the R version number, you are ready.
R Packages
During the course, we will install packages together. If you want to get ahead, open RStudio and run this command in the console:
R
install.packages(c("tidyverse", "haven", "rmarkdown"))
- tidyverse includes dplyr (data manipulation), ggplot2 (visualization), readr (reading data), and more
-
haven reads SPSS
.savfiles directly into R - rmarkdown creates reproducible reports
Verify your setup
Open RStudio and paste this into the console:
R
install.packages(c("tidyverse", "haven", "rmarkdown"))
library(tidyverse)
ggplot(mpg, aes(x = displ, y = hwy)) + geom_point()
If a scatter plot appears in the Plots pane, everything is working. Bring any errors you see to the installation clinic or email the instructor.
Download the workshop data
From Episode 2 onwards you will load the same small dataset in two different formats — first as a CSV file, then as an Excel workbook with multiple sheets. Download both files now and keep them together.
- aruba_visitors.csv — plain-text version (one flat table of 120 rows)
-
aruba_visitors.xlsx
— Excel version, two sheets:
stayoverandcruise
Open each link in your browser, then click the Download raw file button near the top right of the preview and save the file. Do not open the CSV in Excel and re-save — that can silently change the encoding.
Where to put the files
Create a folder for the workshop, for example
Documents/r-workshop/, and inside it create a subfolder
called data. Drop both files into data. Your
structure should look like this:
r-workshop/
└── data/
├── aruba_visitors.csv
└── aruba_visitors.xlsx
When you open RStudio during the course, use File → Open
Project to open r-workshop (or set your working
directory to the folder). The code in the lessons assumes this layout,
so read_csv("data/aruba_visitors.csv") and
read_excel("data/aruba_visitors.xlsx") both find their
files without any extra path work.
If you cannot download the files in advance, we will walk through this step together at the start of Episode 2. Bring the two links.