This "Learning Analytics Data from Collaborative SQL Exercises using the SQLValidator" readme.txt file was generated on 2023-02-21 by David Broneske GENERAL INFORMATION 1. Title of dataset: Learning Analytics Data from Collaborative SQL Exercises using the SQLValidator 2. Author/ Creator information A. Principal Creator Contact Information: David Broneske, University of Magdeburg, david.broneske@ovgu.de B. Associate or Co-creator Contact Information: Victor Obionwu, University of Magdeburg, obionwu@ovgu.de 3. Project: DiP-iT (Digitales Programmieren im Team) 4. Date of data collection (single date, range, approximate date): 2021-04-01 to 2021-08-31 5. Geographic location of data collection: 52°07′39″ N, 11°37′44″ O, Magdeburg, Saxony-Anhalt, GERMANY 6. Information about funding sources that supported the collection of the data: This work was supported by the German Federal Ministry of Education and Research as part of the DiP-iT project in the Digital Higher Education funding line [grant numbers 16DHB 3007 and 16DHB 3008]. ABSTRACT This data set is part of the DiP-iT project (https://www.dip-it.ovgu.de), which tests and evaluates different didactic concepts to improve collaborative learning of programming languages. This data set resembles student data of 83 students recorded at the university of Magdeburg in the Summer Semester 2021, where the SQLValidator is used in the weekly exercises to practice SQL. It consists of student questionnaire answers, submissions of students’ task solutions (and trials of their solution), as well as their chat and submissions of their semester’s team project. The questionnaire contains items on socio-demographic characteristics (e.g. gender, age), on factors relevant to the course (e.g. subject semester, degree program), on attitudes and attitudes towards the course (e.g. self-efficacy expectations, interest) and on teamwork (e.g. experience, relevance, openness towards teamwork). The students' previous knowledge is also surveyed subjectively (e.g. previous knowledge of programming, previous knowledge of SQL) and objectively (knowledge test in the area of teamwork). In the task solutions, students test their SQL queries in the SQLValidator for the weekly exercises in a trial-and-error fashion. The aim was to analyze how students learn from the shown error messages and what problem-solving skills they employ. In the semester’s team project, a group of students is working on the tasks, chat about the tasks and submit their solutions. The aim of this part was to analyze collaboration behavior between students and factors for a successful collaboration. SHARING/ACCESS INFORMATION 1. Licenses or restrictions placed on the data: CC-BY 2. Links to publications that cite or use the data: Obionwu, V., Broneske, D., Hawlitschek, A., Köppen, V. & Saake, G. (2021). SQLValidator - An Online Student Playground to Learn SQL. Datenbank-Spektrum, 21, 73-81. Doi: https://doi.org/10.1007/s13222-021-00372-0 METHODOLOGICAL INFORMATION 1. Description of methods used for collection or generation of data: SQLValidator 2. Methods for processing the data: - 3. Instrument- or software-specific information needed to interpret the data: - 4. Standards and calibration information, if appropriate; Version of the data and included changes of the dataset: published data is anonymized. The "Age" columne from "First_Questioneer_DBC_ss21" is consolidated in age groups for anonymization. 5. Environmental/experimental conditions: - 6. Describe any quality-assurance procedures performed on the data: - DATA & FILE OVERVIEW 1. File List: 1.questionnaires ; 2.SQLValidator_tasks ; 3. results questionnairs and sql-data.zip, file includes DBC_Exercise_Task_Activity.csv, First_Questioneer_DBC_ss21.csv, Last_Questioneer_DBC_ss21.csv, Team_chat_Activity.csv, Team_Task_Submission_Activity.csv