Individual work of Bachelor students monitored using a dynamic assessment dashboard

This document explain how data were generated and how to interpret them.   

LICENSE: CC0
But if you want to combine data with other datasets, feel free to use them as if they were published under CC0 license.   
Data were published in February 2017. At that time, Zenodo only provided CC BY, CC BY-SA, CC BY-NC, CC BY-ND and CC BY-NC-ND. No CC0 option was available.

HOW DATA WERE COLLECTED
Data provided in this dataset were collected in Fall 2016 as part of the Bachelor course 'Formation des usagers en bibliothèques' taught at the University of applied sciences Geneva (Information Sciences Department).   
Data were generated by the interaction of the students with DAD, the Dynamic assessment dashboard, software to be released in 2017 (https://github.com/grolimur/DAD). Only data related to individual activities are published in this set. They were then cleaned and anonymised.

The activities.csv file is provided for information purpose.

Data are provided in 2 formats:

* Comma-spearated values (submissions.csv)
* SQLite (submissions.sqlite)

CSV is not correctly read by Excel, it's recommended to convert it into an .xslx file before using it.   
SQLite is provided in order to apply different sorting and filters to the data. It can be read using SQLite manager for Firefox (https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/).

CODEBOOK
Here is the name, the meaning and the possible values of the columns (name - description [possible values]).

ID - database row ID [(database unique row ID)]
ActivityID - unique activity ID [1, 2, 3, 4, 10, 14, 16, 21, 22, 23, 41]
StudentID - unique anonymous student ID [#50 to #72]
date - recorded by the database [timestamp]
year - year extracted from date [2016, 2017]
month - month extracted from date [01, 11, 12]
day - day extracted from date [1 to 31]
weekday - weekday calculated from date [1, 2, 3, 4, 5, 6, 7]
hour - hour extracted from date - 00 to 23]
minute - minute extracted from date [00 to 59]
second - second extracted from date [00 to 59]
gr - group activity or not [0]
validated - was the submission validated or not [-1 or 1]
week - week number [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, H1, H2]

ActivityID meaning
Activities are described in activities.csv. This file conatins only individual activities description.   
The  2 activities iwth the bonus particularity are not present in the data because students didn't need to apply for them. A bonus was automatically added when activity 1 AND 2 AND 3 AND 4  (bonus = activity 5) as well as when activities 21 AND 22 AND 23 (activity 24) were completed.

Date format
The date is formatted like YYYY-MM-DD hh:mm:ss.

Weekday meaning
1 stands for Monday, 2 for Tuesday and so on until 7 for Sunday.

Group meaning
0 stands for 'individual activity' and 1 would stand for group activity'.   
Only entries with gr="0" appears in this dataset.

Validated meaning
-1 stands for 'rejected' and 1 for 'validated'.

Week meaning
The course lasts 10 weeks. 1 stands for the 1st week and so on until 10 that stands for the 10th week.   
H1 and H2 stand for the Christmas holiday weeks that took place between week 8 and 9.   
No submission were sent in weeks 1, 2 and 10.