Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research最新文献

Adaptive Test Recommendation for Mastery Learning 熟练学习的适应性测试建议

Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research Pub Date : 2023-06-23 DOI: 10.1145/3596673.3596977

Nassim Bouarour, Idir Benouaret, C. D'Ham, S. Amer-Yahia

引用次数: 0

Offering Data Science Coursework to Non-Computing Majors 为非计算机专业的学生提供数据科学课程

Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research Pub Date : 2023-06-23 DOI: 10.1145/3596673.3596971

Xumin Liu, E. Golen, R. Raj, Kimberly Fluet

引用次数: 0

Student's Learning Challenges with Relational, Document, and Graph Query Languages 学生对关系、文档和图形查询语言的学习挑战

Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research Pub Date : 2023-06-23 DOI: 10.1145/3596673.3596976

Ridha Alkhabaz, Zepei Li, Sophia Yang, Abdussalam Alawini

引用次数: 0

pTA: A Programmable Teaching Assistant for Lab Courses 实验课程的可编程教学助理

Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research Pub Date : 2023-06-23 DOI: 10.1145/3596673.3596975

Jawad Tahir, Raj Mandal, Olha Stefanova, H. Jacobsen, Christoph Doblander, R. Mayer

{"title":"pTA: A Programmable Teaching Assistant for Lab Courses","authors":"Jawad Tahir, Raj Mandal, Olha Stefanova, H. Jacobsen, Christoph Doblander, R. Mayer","doi":"10.1145/3596673.3596975","DOIUrl":"https://doi.org/10.1145/3596673.3596975","url":null,"abstract":"Lab courses play a crucial role in enabling students to gain a deeper understanding of theoretical concepts, but these courses require a significant effort from the course's organizational staff, such as instructors and teaching assistants. To address this challenge, we developed pTA, an acronym for programmable teaching assistant, which automates the functional evaluation of students' submissions for the Cloud Databases course taught at the Technical University of Munich (TUM). pTA reduces the staff workload and provides instant feedback to students, thereby enhancing their understanding of the project specifications. Additionally, pTA includes a live leaderboard that provides a gamification element that makes the course more interactive and engaging for students. It is deployed on a Kubernetes cluster that ensures scalability with evaluation requests. In this paper, we describe the course's learning milestones and provide an overview of pTA's architecture and features. The system's efficacy was evaluated at TUM and the University of Toronto, where it was deployed in two similar courses. Our findings show that pTA reduced the staff workload by at least 75%, lowered the operating cost, and increased course capacity in terms of the number of students. Furthermore, our study suggests that students exhibit more interest in courses that integrate interactive learning systems and gamification elements.","PeriodicalId":409189,"journal":{"name":"Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research","volume":"1 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2023-06-23","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"122693912","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}

引用次数: 0

Mining SQL Problem Solving Patterns using Advanced Sequence Processing Algorithms 使用高级序列处理算法挖掘SQL问题解决模式

Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research Pub Date : 2023-06-23 DOI: 10.1145/3596673.3596973

Sophia Yang, Geoffrey L. Herman, Abdussalam Alawini

{"title":"Mining SQL Problem Solving Patterns using Advanced Sequence Processing Algorithms","authors":"Sophia Yang, Geoffrey L. Herman, Abdussalam Alawini","doi":"10.1145/3596673.3596973","DOIUrl":"https://doi.org/10.1145/3596673.3596973","url":null,"abstract":"SQL is a crucial language for managing relational database systems, and is an essential skill for individuals in roles such as researchers, developers, and business professionals who work with databases. However, learning SQL can be a challenge, presenting an opportunity to study the various methods students use to arrive at semantically equivalent SQL queries. In this study, we examined students' SQL submissions to homework assignments in the Database Systems course offered to upper-level undergraduate and graduate students at the University of Illinois Urbana-Champaign during the Fall 2022 semester. Our goal was to understand how students arrive at SQL solutions and overcome challenges in the learning process by building on prior research on line chart visualizations that instructors can use to increase visibility on students who are struggling. However, a major limitation of this approach was the difficulty for instructors to sift through a large number of visuals representing each student's performance on a SQL problem and generate action items at scale, especially when dealing with enrollments of over 700 students. To overcome this limitation, we developed a novel technique to generate textual representations of the student submission sequence using global sequence alignment scores and regular expression algorithms to further compact these submission sequences. This allows instructors to gain insights quickly, on an aggregate level, and in an automated manner, enabling them to identify students who may be struggling with SQL based on their submission sequence characteristics and take appropriate action to improve database education. Our study discovered common textual submission patterns and pattern elements, and we present our recommendations to instructors to improve database education based on these findings.","PeriodicalId":409189,"journal":{"name":"Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research","volume":"43 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2023-06-23","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"127372240","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}

引用次数: 0

Relational Playground: Teaching the Duality of Relational Algebra and SQL 关系型游乐场:关系型代数和SQL的对偶性教学

Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research Pub Date : 2023-06-23 DOI: 10.1145/3596673.3596978

Michael J. Mior

引用次数: 0

Teaching Data Science by Visualizing Data Table Transformations: Pandas Tutor for Python, Tidy Data Tutor for R, and SQL Tutor 通过可视化数据表转换来教授数据科学:Pandas Python教程，Tidy Data R教程和SQL教程

Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research Pub Date : 2023-06-23 DOI: 10.1145/3596673.3596972

Sam Lau, Sean Kross, Eugene Wu, Philip J. Guo

{"title":"Teaching Data Science by Visualizing Data Table Transformations: Pandas Tutor for Python, Tidy Data Tutor for R, and SQL Tutor","authors":"Sam Lau, Sean Kross, Eugene Wu, Philip J. Guo","doi":"10.1145/3596673.3596972","DOIUrl":"https://doi.org/10.1145/3596673.3596972","url":null,"abstract":"Data science instructors often find it hard to explain to students how a piece of code written in Python, R, or SQL executes in order to transform tabular data. They currently resort to hand-drawing diagrams or making presentation slides to illustrate the semantics of operations such as filtering, sorting, reshaping, pivoting, grouping, and joining. These diagrams are time-consuming to create and do not synchronize with real code or data that students are learning about. In this paper we show that a step-by-step visual representation of tabular data transforms can help instructors to explain these operations. To do so, we created a table visualization library that illustrates the row-, column-, and cell-wise relationships between an operation's input and output tables. On top of this library we built a trio of free web-based visualization tools - Pandas Tutor for Python, Tidy Data Tutor for R tidyverse, and SQL Tutor - that run users' code and automatically produce diagrams of how Python/R/SQL transforms data tables step-by-step from input to output. Since launching in Dec 2021, over 61,000 people from over 160 countries have visited our website to try out these tools.","PeriodicalId":409189,"journal":{"name":"Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research","volume":"51 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2023-06-23","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"116010909","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}

引用次数: 1

Feedforward-Aided Course Designs for Similarity Search 前馈辅助相似度搜索课程设计

Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research Pub Date : 2023-06-23 DOI: 10.1145/3596673.3596974

Thomas Hütter, Daniel Kocher

引用次数: 0

Human Learners of Relational Query Processing: Who Cares? 关系查询处理的人类学习者:谁在乎?

Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research Pub Date : 2023-06-23 DOI: 10.1145/3596673.3603143

Sourav S Bhowmick

{"title":"Human Learners of Relational Query Processing: Who Cares?","authors":"Sourav S Bhowmick","doi":"10.1145/3596673.3603143","DOIUrl":"https://doi.org/10.1145/3596673.3603143","url":null,"abstract":"There is an increasing attention on lifelong learning of data-related topics primarily due to the data-driven world and rapidly changing technological landscape. This has increased the importance of database-related courses in recent times. One of the key learning goals of adult learners taking a database systems course is to understand how SQL queries are processed in an RDBMS in practice. Most database courses supplement traditional modes of teaching with off-the-shelf RDBMS to provide hands-on opportunities to learn database concepts used in practice. Notably, the data management community has traditionally directed their attention primarily to the needs of enterprise users and developers rather than of learners. Consequently, these RDBMS are not designed for effective and efficient pedagogical support. In this paper, we present a vision that calls for action to direct some of our attention to learners by exploring and building effective and efficient technological support to supplement learning of relational query processing. We focus on research challenges in this novel space that are motivated by challenges confronted by real-world learners and discuss state-of-the-art tools and techniques that are deployed in practice to mitigate some of them. We identify opportunities for the data management community to make database education data-driven as well as opportunities to create technologies that are inclusive, i.e., facilitating disabled adults (e.g., learners with autism spectrum disorder (ASD)) to learn database systems. In summary, realizing our vision has tremendous potential of real-world impact on something that is very personal to us - education.","PeriodicalId":409189,"journal":{"name":"Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research","volume":"471 1","pages":"0"},"PeriodicalIF":0.0,"publicationDate":"2023-06-23","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"134405019","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}

引用次数: 0

SQL: A Trojan Horse Hiding a Decathlon of Complexities SQL:隐藏着十项全能的复杂性的特洛伊木马

Proceedings of the 2nd International Workshop on Data Systems Education: Bridging education practice with education research Pub Date : 2023-06-23 DOI: 10.1145/3596673.3603142

Toni Taipalus

引用次数: 1