georgekinnear

Summarising student activity

Number of times each student attempted each quiz question

For each quiz in the course, for every student who attempted it, count how many attempts they made at each question.

SELECT q.name AS quiz, MIN(qa.slot) AS slot,

georgekinnear

$activity-icon-colors: (
    "administration": #004F71,
    "assessment": #830065,
    "collaboration": #154734,
    "communication": #C25E03,
    "content": #0099AB,
    "interface": #61BF1A
);

georgekinnear

#
# Anonymise data by replacing UUN with a hashed unique ID
#
# Note - in order to prevent "rainbow table" hacking of the hashing, a salt string is added in the anonymise function
#        This string must not be published.
#


library(tidyverse)
library(digest) # see https://jangorecki.github.io/blog/2014-11-07/Data-Anonymization-in-R.html

georgekinnear

<style>
/* overall look */
body {
    font-family: Arial;
}
.page-context-header {
    padding: 0;
}
/* styling of course overview pages */
.topics a {