2012 [AS13b, Wal12a]. 2013 [Alv13, Bar13, Cam13, Car13, CCS13, Cut13, Edi14, Swe13]. 2014 [CDS13, DN14, ND14, Rod14, Tym14a]. 2015 [DeL14a, DeL14b, She15b]. 2016 [AT16a, CCV16, CCV17, MR15, SDCT16a, SDCT16c, She16a]. 2017 [DG17, EC17, Fit18b, MJ18, TCSM17, TCM17]. 2018 [BG18b, DD17, Dec19b, Gol18, JI18, MKMP18, MMK18, PQH17, She18]. 2019 [Cut19, FI19, HPQ19, MP19a, MPRM19, MP19b, MS19, Rod18, She19a]. 2020 [DH19].

/pdf/a-complete-bibliography-of-publications-in-sigcse-bulletin-1aolnsl5m4.pdf

A Complete Bibliography of Publications in SIGCSE Bulletin: 2000{2009

Serious games in tertiary education: A case study concerning the comprehension of basic concepts in computer language implementation courses

Teaching abstract concepts can be best supported with supplemental instructional materials such as software animations. Visualization and animations have been shown to increase student motivation and help students develop deeper understandings. Through an NSF funded CCLI grant, a set of animations to support the teaching of database concepts is being developed and made freely available. Current modules available cover areas such as database design, interactive SQL, stored procedures and triggers, transactions and database security. In this paper, we provide an overview of the Animated Database Courseware (ADbC) as well as provide examples of how this software might be utilized in the classroom.

/pdf/animated-database-courseware-using-animations-to-extend-1tm9bhkkqc.pdf

Animated database courseware: using animations to extend conceptual understanding of database concepts

Introduction Database technologies are foundational to effective information systems and an effective database system is predicated on a good data model. The goal of database design is to conceptualize an underlying data model and determine an appropriate structure to be used in the physical implementation of that model. Consequently, understanding database design is central to understanding a good data model and an effective database implementation. However, the abstract nature of database design can make it challenging to teach and challenging to learn (Chilton, McHaney, & Chae, 2006). One way to address this challenge is through the use of supplemental instructional materials. We are developing a set of software animations to support the teaching of database design as well as other database related concepts. The animations are part of a larger animated database courseware project funded through a National Science Foundation Course, Curriculum and Laboratory Improvement grant. The courseware is freely available and can be accessed at http://adbc.kennesaw.edu Animations and visualizations have been touted as a means to provide additional instructional support to convey complex and dynamic topics especially when commonly used teaching methodologies such as lectures and textbooks do not appear to be sufficient. Animations have been used in many disciplines, including computer science, where animations exist to support the teaching of algorithms, machine execution, networking and programming. While the achievement of learning outcomes as a result of using animations has been mixed, there is evidence that animations do support the teaching and learning process. Animations have been found to increase student motivation and visualizations have been found to help students develop understanding of abstract concepts which are otherwise considered to be 'invisible' (Steinke, Huk, & Floto, 2003). In their study of ways to introduce the idea of pervasive computing to students, Woodcock, Burns, Mount, Newman, and Gaura (2005) cite that using words and pictures helped students construct verbal and pictorial mental models as well as to build connections between them and increased their ability to understand the precepts of the topic under study. Further, Mayer (2001) notes that the capacity of animations to portray information in a different way engages the use of an additional cognitive channel, thereby, reducing the learner's overall cognitive load. Whatever the case, providing multiple venues of learning support such as supplemental instructional materials does contribute to heightened levels of student learning. A review of the literature revealed very few animations or visualized tutorials that support the teaching of database concepts. A majority of these programs focus specifically on some aspect of SQL or query execution. For instance, W3Schools (W3Schools, 2009) offers an interactive SQL tutorial and Allenstein, Yost, Wagner and Morrison (2008) provide a simulation system to enable students to visualize the steps required to execute a database query. The WINRDBi Educational Tool developed at Arizona State University (WINRDBI Educational Tool, n.d.) provides an interpreter that allows students to program in interactive SQL, relational algebra, domain calculus or tuple calculus. While several drawing tools are available that provide support for the mechanical creation of ER diagrams, no animated instructional support materials were found that that address the topic of database design. The process of database design includes identifying user requirements, conceptualizing those requirements into a graphical data model, mapping that model into a physical database system and assessing the model to insure data anomalies are reduced, data integrity maintained and data redundancy eliminated, a process known as normalization. The animations included for database design in the Animated Database Courseware (ADbC) project follow this process for the development of a relational database system. …

/pdf/animated-courseware-support-for-teaching-database-design-1fm0sesdo1.pdf

Animated Courseware Support for Teaching Database Design

The Structured Query Language (SQL) is the most widely used declarative language for accessing relational databases, and an essential topic in introductory database courses in higher learning institutions. Despite the intuitiveness of SQL, formulating and comprehending written queries can be confusing, especially for undergraduate students. One major reason for this is that the simple syntax of SQL is often misleading and hard to comprehend. A number of tools have been developed to aid the comprehension of queries and to improve the mental models of students concerning the underlying logic of SQL. Some of these tools employed visualisation and animation in their approach to aid the comprehension of SQL. This paper presents an interactive comprehension aid based on visualisation, specifically designed to support the SQL SELECT statement, an area identified in the literature as problematic for students. The visualisation tool uses visual specifications depicting SQL operations to build queries. This is expected to reduce the cognitive load of a student who is learning SQL. We have shown with an online survey that adopting visual specifications in teaching systems assist students in attaining a richer learning experience in introductory database courses.

Generating SQL Queries from Visual Specifications

The underlying processes that enable database query execution are fundamental to understanding database management systems. However, these processes are complex and can be difficult to explain and illustrate. To address this problem, we have developed a Java-based query simulation system that enables students to visualize the steps involved in processing DML queries. We performed a field experiment to evaluate the system, and the results suggest that the system improves student comprehension of the query execution process.

A query simulation system to illustrate database query execution

Handle everyday research tasks with reliable, citation-backed results

Your personal Research Agent to handle research tasks with citation-backed results

Popular Tasks used by Researchers

How can I help with your research?

Meet SciSpace

Get more enhanced response by uploading the PDFs you want me to reference.

No relevant PDFs in your library

SciSpace is the AI research assistant for academics. Run systematic literature reviews on 280M+ papers, and write papers with cited sources. Trusted by 1M+ students, PhDs & researchers.

SciSpace | AI for Research

Analyze PDFs

Code & Manuscripts

Funding & Grants

Literature & Patents

Medical & Clinical Data

Systematic Review

Visualize & Present

Web & Data

Build a Google Scholar-like website for your research.

Build a website

Create charts and images for your research

Create a Chart

Write a paper for submission to a journal

Draft a manuscript

Patent Search

Design eye-catching scientific posters in minutes.

Scientific Poster Generation

Systematic Literature Review

One task is running at the moment. Your messages will be shown right after.

Drag and drop or click here to browse

Loved by <highlight>1 million+</highlight> researchers

Extract a list of specific topics and their sources from unstructured text

Topics

Compare and analyze relevant papers that matches with your search

Papers

Get insights from PDFs and bookmarked papers from your library

My library

Recent searches

Try searching for:

Catch AI-generated content in scholarly and non-scholarly content

{ai} Detector

Ai Writer

Get PDF Summaries, highlighted text explanations 

Chat with PDF

Effortlessly create in-text citations and bibliographies in APA and 2,500 other formats

Citation generator

Get explanations, summaries, and answers on academic papers

Ease up your research workflow with {scispace}'s cohort of exciting AI tools

Elevate your academic writing skills and convey your ideas the way you want

Paraphraser

Explore our range of reading and writing tools

Your file is being prepared and should be ready in a few minutes. If it's a large file, it might take a bit longer. You can close this window, and we'll email you the file when it's done.

You have reached a maximum limit of <strong>{limit}</strong> columns in the table. Remove at least <strong>1</strong> column to add or create another one.

Brett Allenstein

Author Tools

Chat about Author

Papers

A query simulation system to illustrate database query execution