This study was developed to provide a possible solution to the problems and difficulties encountered by the office of student affairs in a secondary high school in the Province of Nueva Ecija, Philippines. It covers the management and organization of student records and the effective delivery of information through Short Message Service (SMS)…

Academic libraries must provide accessible electronic and information technology to patrons using assistive technology to access library materials. Accessibility of scholarly material is particularly important in the STEM disciplines, where attrition rates of students with disabilities is higher than in other fields. In this study, the…

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,…

Management is evolving as a foundational domain to the field of instructional design and technology. However, there are few tools dedicated to the management of instructional design and development projects and activities. In this article, we describe the development, features and implementation of an instructional design database--built from a…

Conceptual modeling of databases is a complex cognitive activity, particularly for novice database designers. The current research empirically tests a new pedagogy for this activity. It examines an instructional approach that stresses visualizing gradual transitions between levels of abstraction in different hierarchic levels of a relational…

This case describes a real-world scenario based on a fictional new commuter airline seeking to develop a database to support their operations. Students are asked to design and develop a database to allow the airline to track flights, passengers, bookings, and more, based on a set of business rules, default data, and other requirements. The case…

The authors conducted six focus group semi-structured interviews consisting of graduate students and postdoctoral researchers within the College of Engineering at the University of Illinois Urbana-Champaign (UIUC) in order to understand their roles within research groups and their ability to manage research data. More specifically, participants…

Design tasks are difficult to teach, due to large, unstructured solution spaces, underspecified problems, non-existent problem solving algorithms and stopping criteria. In this paper, we comment on our approach to develop KERMIT, a constraint-based tutor that taught database design. In later work, we re-implemented KERMIT as EER-Tutor, and…

This article details the process the authors--a doctoral student at the time, and a faculty member--engaged in to change the ways the University of Iowa (UI) asks for and reports student name, gender pronouns, sex, and gender identity. The UI Inclusive Student Records Initiative raises implications for practice and research. Two focus groups--one…

Information systems (IS) curriculum review is a continuous process. Universities seek to offer content that they believe will be most beneficial to students as they begin their career. However, that content may or may not satisfy employer needs. This paper, which is part of a larger study, seeks to determine if required course content matches the…

This teaching case describes the functionality of an applicant processing system designed for a fictitious hotel chain. The system detailed in the case includes a webform where applicants complete and submit job applications. The system also includes a desktop application used by hotel managers and Human Resources to track applications and process…

The following is an applied database scenario based on a single season in the FIA Formula One (F1) World Championship of auto racing. This scenario builds database understanding and skills through data modeling, data acquisition, creation of a database schema through a database management system, query construction, and report creation. In the…

A common problem encountered when teaching database courses is that few large illustrative databases exist to support teaching and learning. Most database textbooks have small "toy" databases that are chapter objective specific, and thus do not support application over the complete domain of design, implementation and management concepts…

This applied database exercise utilizes a scenario-based case study to teach the basics of Microsoft Access and database management in introduction to information systems and introduction to database course. The case includes background information on a start-up business (i.e., Carol's Travel Club), description of functional business requirements,…

The Michigan State University (MSU) Libraries' Website has a case of TMI: too much information organized by librarians for librarians. Finding relevant information about various library services, including the 24/7 Distance Learning Support Line, and access points to scholarly resources is often cumbersome, and given the limited time and staffing…