Learning relational algebra by snapping blocks

Authors:
Jason Gorman;Sebastian Gsell;Chris Mayfield
Affiliations:
James Madison University, Harrisonburg, VA, USA;James Madison University, Harrisonburg, VA, USA;James Madison University, Harrisonburg, VA, USA
Venue:
Proceedings of the 45th ACM technical symposium on Computer science education
Year:
2014

Citing 9
Cited 0

Scalable game design and the development of a checklist for getting computational thinking into public schools

Proceedings of the 41st ACM technical symposium on Computer science education
The Scratch Programming Language and Environment

ACM Transactions on Computing Education (TOCE)
Alice, Greenfoot, and Scratch -- A Discussion

ACM Transactions on Computing Education (TOCE)
Bringing computational thinking to K-12: what is Involved and what is the role of the computer science education community?

ACM Inroads
Computational Thinking and Expository Writing in the Middle School

ACM Transactions on Computing Education (TOCE)
A virtual tutor for relational schema normalization

ACM Inroads
Database animations for many majors: conference tutorial

Journal of Computing Sciences in Colleges
The first five computer science principles pilots: summary and comparisons

ACM Inroads
SNAP! (build your own blocks) (abstract only)

Proceeding of the 44th ACM technical symposium on Computer science education

Quantified Score

Hi-index	0.00

Visualization

Abstract

Relational algebra provides a theoretical foundation for how modern database management systems optimize and execute queries. Its main concepts are based on set theory and first order logic, which can be challenging for students to learn due to their abstract nature. This paper presents Bags, a new type of visual programming environment (inspired by Snap!) for the teaching of relational operations and data analysis. Students formulate algebraic queries by snapping together graphical blocks that represent data sets and relational operators, resulting in an interactive visualization of the underlying concepts. The outcomes of this work will not only enhance university-level database courses, but also provide an engaging computational thinking resource for K-12 teachers in content areas outside of science and engineering.