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…

Videoconferencing is a low-cost, high-reward tool for engaging stakeholders in participatory design and usability testing for online Extension products. This article details how we used the videoconference program BlueJeans to facilitate the redesign of the Great Lakes Aquatic Nonindigenous Species Information System database and highlights the…

Business schools are increasingly establishing MBA business analytics programs. This article discusses the importance of a sufficient body of knowledge about databases for MBA business analytics students. It presents the pedagogical design and the teaching method of a module of database-centric OLAP (online analytical process) for an MBA business…

Protection of academic integrity in online environments can be challenging. Understanding how the technology works and concerns about each of the methods for monitoring online interactions can assist in the selection of the best proctoring tools. Depending on the content, the type of assessment and the comfort level with the technology, a…

The case provides a realistic scenario that can be used in a systems analysis and design, accounting information systems or graduate level management information systems course. The case details the steps in the revenue and expense cycle processes of a health supply wholesale company providing students with the opportunity to map the business…

We often have little evidence of success to take to stakeholders in the preliminary stages of restoration projects. However, presenting initial monitoring data can allow for impactful science communication and stakeholder engagement around the early progress of restoration. We use reforestation monitoring in the Paulins Kill watershed to highlight…

Open access institutional repositories can be ill-equipped to manage the complexity of research outputs from departments of fine arts, media, drama, music, cultural heritage, and the creative arts in general. The U.K.-based Kultur project was funded to create a flexible multimedia repository model using EPrints software. The project launched the…

This article presents a case scenario that may be used in system analysis and design, database management, and business analytics classes. The case document includes realistic, detailed information on the operations at the American Guild of Musical Artists (AGMA). Examples of assignments for each class and suggested reading are presented. In each…

Structured Query Language (SQL) is still the de facto database query language widely used in industry and taught in almost all university level database courses. The role of SQL is further strengthened by the emergence of NewSQL systems which use SQL as their query language as well as some NoSQL systems, e.g., Cassandra and DynamoDB, which base…

This design case discusses the complex collaborative design reasoning processes involved in developing an online interactive learning tool for learners of all ages to explore and understand the role of flagellate plants in our society. The learning tool consists of a main website (the "Voyager") and an interactive, dynamic map of the…

Recent technological advancements in data storage and processing have changed how companies conduct their business. An increasing number of firms have started putting their efforts in extracting information from their databases to improve profitability and reduce costs using quantitative approaches. Thus, the job market has been experiencing a…

Data analytics is undergoing an evolution through effective data use to support both operational and learning analytics models. However, this evolution will require that institutional leaders transform their data systems to best support the needs of application modeling and use their intuition to help drive the development of better analytical…

In this article, I discuss the potential uses of the Department of Labor-sponsored Occupational Information Network (O*NET) in the classroom context. O*NET is a free, publicly available resource that provides an array of occupation-specific information, such as relevant tasks, knowledge, skills, abilities, and salary information. Tools such as the…

The National Longitudinal School Database (NLSD) comprises three files, making up a near-census of all schools and districts in the United States from school years 1990-91 to 2019-20. The three files are the Public School File, Private School File, and District File. As evident by the titles, the first two files report data at the school-level for…