Students' Perceptions on Engaging Database Domains and Structures

Several educational studies have argued for the contextualization of assignments, i.e., for providing a context or a story instead of an abstract or symbolic problem statement. Such contextualization may have beneficial effects such as higher student engagement and lower dropout rates. In the domain of database education, textbooks and educators typically provide an example database for context. These are then used to introduce key concepts related to database design, and to illustrate querying. However, it remains unstudied what kinds of database contexts are engaging for novices. In this paper, we study which aspects of database domain and complexity students find engaging through student…

On the relationship between occlusion times and in-car glance durations in simulated driving

Drivers have spare visual capacity in driving, and often this capacity is used for engaging in secondary in-car tasks. Previous research has suggested that the spare visual capacity could be estimated with the occlusion method. However, the relationship between drivers’ occlusion times and in-car glance duration preferences has not been sufficiently investigated for granting occlusion times the role of an estimate of spare visual capacity. We conducted a driving simulator experiment (N = 30) and investigated if there is an association between drivers’ occlusion times and in-car glance durations in a given driving scenario. Furthermore, we explored which factors and variables could explain t…

Status indicators in software engineering group projects

A segment of studies on group structure and performance in software engineering (SE) project-based learning (PjBL) have focused on roles, including studies that use Belbin team roles and studies that address problematic roles such as social loafing. The present study focuses on the status, which is basically missing in SE PjBL studies, although relating to roles. The study investigates the aspects that students identified as indicators of rising or declining status in their project groups. The status theory was utilized as the framework that motivated the research and on which the results were reflected. An inductive qualitative content analysis was applied to learning reports in which stud…

Information Systems Students’ Impressions on Learning Modeling Enterprise Architectures

This Full Research Paper presents enterprise architecture (EA) modeling tools utilized in an educational context. EA is a well-known and a commonly used approach for organizational development aiming to improve the alignment of business operations and information technology. This high level design of information technology (IT) driven business operations lays the foundations on lower level technical activities such as the design and implementation of application programs and features, system boundary interfaces, database distribution and data pipes, and system recovery. Organizations’ architectures are made visible by creating EA artefacts, such as business process diagrams, data models and…

The Effects of Database Complexity on SQL Query Formulation (journal-first)

The learning of practical Structured Query Language (SQL) skills often takes place in digital environments, where the learner writes queries against an exercise database. The exercise database is usually designed and implemented by the teacher, and populated with makeshift data. Although this approach is common, and SQL taught in almost all database courses, little scientific attention has been given to the nature of the exercise database.

Error messages in relational database management systems: A comparison of effectiveness, usefulness, and user confidence

Abstract The database and the database management system (DBMS) are two of the main components of any information system. Structured Query Language (SQL) is the most popular query language for retrieving data from the database, as well as for many other data management tasks. During system development and maintenance, software developers use a considerable amount of time to interpret compiler error messages. The quality of these error messages has been demonstrated to affect software development effectiveness, and correctly formulating queries and fixing them when needed is an important task for many software developers. In this study, we set out to investigate how participants ( N = 152 ) …

What to Expect and What to Focus on in SQL Query Teaching

In the process of learning a new computer language, writing erroneous statements is part of the learning experience. However, some errors persist throughout the query writing process and are never corrected. Structured Query Language (SQL) consists of a number of different concepts such as expressions, joins, grouping and ordering, all of which by nature invite different possible errors in the query writing process. Furthermore, some of these errors are relatively easy for a student to fix when compared to others. Using a data set from three student cohorts with the total of 744 students, we set out to explore which types of errors are persistent, i.e., more likely to be left uncorrected by…

Coping with Uncertainty in an Agile Systems Development Course

Uncertain and ambiguous environments are commonplace in information systems development (ISD) projects, and while different Agile frameworks welcome changes in organizational, technical, and business environments, the incurred uncertainty is known to negatively affect the development process and the quality of the final product. The effects of uncertainty on ISD projects have been studied in the past in real organizational contexts, but the effects of uncertainty on students in Agile systems development have received less attention from scholars. In this study, we measured the effects of experienced uncertainty on students’ performance in an Agile systems development course and how uncertai…

Data Analytics in Healthcare: A Tertiary Study

AbstractThe field of healthcare has seen a rapid increase in the applications of data analytics during the last decades. By utilizing different data analytic solutions, healthcare areas such as medical image analysis, disease recognition, outbreak monitoring, and clinical decision support have been automated to various degrees. Consequently, the intersection of healthcare and data analytics has received scientific attention to the point of numerous secondary studies. We analyze studies on healthcare data analytics, and provide a wide overview of the subject. This is a tertiary study, i.e., a systematic review of systematic reviews. We identified 45 systematic secondary studies on data analy…

Skaalautuvan vektorigrafiikan sovellusalueet

  Taipalus, Toni Petteri Skaalautuvan vektorigrafiikan sovellusalueet / Toni Taipalus Jyväskylä: Jyväskylän yliopisto, 2010. 31 s. Kandidaatintutkielma Tässä tutkielmassa tarkastellaan skaalautuvan vektorigrafiikan standardin etuja ja heikkouksia sekä sen soveltumista erilaisiin käyttökohteisiin. Tarkoituksena on kartoittaa, mihin standardi sopii ja mihin se ei sovi. Arviointi pyritään tekemään ensisijaisesti kirjallisuuden pohjalta, mutta lisäksi on perehdytty standardin mukaisten dokumenttien rakenteeseen. Tarkoituksena on antaa käsitys standardin etujen ja heikkouksien vaikutukseen tilanteissa, joissa standardia harkitaan sovellettavaksi. Tutkielmassa havaitaan, että standardin soveltuvu…

SQL Education

Structured Query Language (SQL) skills are crucial in software engineering and computer science. However, teaching SQL effectively requires both pedagogical skill and considerable knowledge of the language. Educators and scholars have proposed numerous considerations for the betterment of SQL education, yet these considerations may be too numerous and scattered among different fora for educators to find and internalize, as no systematic mappings or literature reviews regarding SQL education have been conducted. The two main goals of this mapping study are to provide an overview of educational SQL research topics, research types, and publication fora, and to collect and propagate SQL teachi…

Explaining Causes Behind SQL Query Formulation Errors

This Full Research Paper presents the most prominent query formulation errors in Structured Query Language (SQL), and maps these errors to their cognitive explanations. Understanding query formulation errors is a key to teaching SQL. more effectively. However, studies on what kind of errors novices struggle with are relatively scarce when compared to, for example, programming languages. Although committing errors is a crucial part in learning, some errors are relatively easy to fix, and their commonness is not necessarily an indication of their difficulty. Other errors, however, halt the learning process, and are never fixed by the query writer. Using a previously established error taxonomy…

Errors and Complications in SQL Query Formulation

SQL is taught in almost all university level database courses, yet SQL has received relatively little attention in educational research. In this study, we present a database management system independent categorization of SQL query errors that students make in an introductory database course. We base the categorization on previous literature, present a class of logical errors that has not been studied in detail, and review and complement these findings by analyzing over 33,000 SQL queries submitted by students. Our analysis verifies error findings presented in previous literature and reveals new types of errors, namely logical errors recurring in similar manners among different students. We…

Foundations for Esports Curricula in Higher Education

Esports has generated an industry of increasing economic and cultural importance. In recent years, universities and other higher education institutions have responded to its growth by establishing programmes of study which aim to satisfy the needs of innovators operating in the area. However, there is not yet consensus on what an esports curriculum should include. Despite being a technology-driven sector with ethical and professional dimensions that intersect computing, current ACM and IEEE curricula do not mention esports. Furthermore, existing courses tend to provide teaching and training on a wide variety of topics aside from those traditionally in computer science. These include: live e…

The Effects of Database Complexity on SQL Query Formulation

In Structured Query Language (SQL) education, students often execute queries against a simple exercise database. Recently, databases that are more realistic have been utilized to the effect that students find exercises more interesting and useful, as these databases more accurately mimic databases students are likely to encounter in their future work environments. However, using even the most engaging database can be counterproductive to learning, if a student is not able to formulate correct queries due to the complexity of the database schema. Scientific evidence on the effects of database complexity on student’s query formulation is limited, and with queries from 744 students against thr…

Incorporating teacher-student dialogue into digital course material : Usage patterns and first experiences

This work-in-progress research investigates teacher-student communication via Learning Management Systems (LMS) in highly populated courses. An LMS called TIM (The Interactive Material) includes a specific commenting technology that attempts to make teacher-student dialog effortless. The research goal is to explore students’ willingness to use the technology and identify patterns of usage. To these ends, a survey with both Likert and open-ended questions was issued to CS1 and CS2 students. A favorable student evaluation was observed while several critical viewpoints that inform technology development were revealed. We noticed that besides appreciating the possibility of making comments, man…

Towards a Framework to Support the Design of Esports Curricula in Higher Education

Esports has generated an industry of increasing economic and cultural importance. In recent years, universities and other higher education institutions have responded to its growth by establishing undergraduate courses to satisfy the needs of innovators operating in the area. However, there is not yet consensus on what an esports curriculum should include. Despite being a technology-driven sector with ethical and professional dimensions that intersect computing, current ACM and IEEE curricula do not mention esports. Furthermore, existing courses tend to provide teaching and training on a wide variety of topics aside from those traditionally in computer science. These include: live events ma…

Refining distraction potential testing guidelines by considering differences in glancing behavior

Driver distraction is a recognized cause of traffic accidents. Although the well-known guidelines for measuring distraction of secondary in-car tasks were published by the United States National Highway Traffic Safety Administration (NHTSA) in 2013, studies have raised concerns on the accuracy of the method defined in the guidelines, namely criticizing them for basing the diversity of the driver sample on driver age, and for inconsistent between-group results. In fact, it was recently discovered that the NHTSA driving simulator test is susceptible to rather fortuitous results when the participant sample is randomized. This suggests that the results of said test are highly dependent on the s…

Engaging Databases for Data Systems Education

Challenges in Geographically Distributed Information System Development : A Case Study

Geographically distributed information system development (ISD) projects are more and more common, especially among organisations operating in global markets. Distributed ISD yields potential competitive advantages by developing new products near the target markets, utilizing global labour markets, and exposing the organisation to innovations, ideas and new paradigms. However, distributed ISD also presents challenges and problems which organisations must take into consideration. The pivotal challenge is usually communication. People working on the same project in different locations find it difficult to communicate due to lack of formal and informal face-to-face communication, different wor…

Uncertainty in information system development: Causes, effects, and coping mechanisms

Information system development (ISD) projects are an ever-growing field of project management (PM) with their unique features, and project failures in ISD are relatively common. In the broader context of PM, uncertainty is a studied, yet mercurial phenomenon. By contrast, uncertainty in ISD projects has received relatively little attention from scholars, and PM literature has not systematically focused on uncertainty in ISD from a viewpoint other than that of project managers. In order to understand uncertainties in ISD projects, we need to first understand the causes behind them, their effects on everyday ISD work, and share coping mechanisms utilized among industry professionals. In the c…

NewSQL Database Management System Compiler Errors : Effectiveness and Usefulness

Modern database management is often faced with a high number of concurrent end-users, and the need for database distribution to ensure fault tolerance and high throughput. To flexibly address these challenges, many modern database management systems (DBMS) provide highly automated and effortless, i.e., highly usable database distribution, deployment, and maintenance. However, the usability considerations are yet to extend from the aforementioned DBMS features to query language compilers. In this study, based on participant answers (N = 157), we compare the error message qualities of four modern DBMSs (CockroachDB, SingleStore, NuoDB, and VoltDB) using one objective and three subjective metr…