Process and score multiple choice questions
remotes::install_github("awellis/mcq")
Load packges:
library(tidyverse)
library(mcq)
Read in exam results and answers from Excel spreadsheet:
results <- readxl::read_excel("Ergebnisse.xlsx",
sheet = "Antworten") %>%
select(Matrikel, StudisID, Nachname, Vorname, Serie,
starts_with("A_"), starts_with("K_"))
answers <- readxl::read_excel("Ergebnisse.xlsx",
sheet = "Loesung") %>%
select(Serie, starts_with("A_"), starts_with("K_"))
Combine A
and K'
question results:
exam_results <- score_exams(results = results, answers = answers)