In response to research indicating a need for an increased emphasis on aspects of corporate accounting, including corporate taxation, in the accounting curriculum as well as employer expectations that entry-level accounting position applicants possess Excel skills, this classroom exercise uses Excel to compare the financial impacts of three…

Data Analytics has grown dramatically in importance and in the level of business deployments in recent years. It is used across most functional areas and applications, some of the latter including market campaigns, detecting fraud, determining credit, identifying assembly line defects, health services and many others. Indeed, the realm of…

Chemistry is increasingly data centric and the undergraduate curriculum needs to adjust to keep up. To address this, we created the "Air Quality Activity," a new first-year undergraduate activity where students use Microsoft Excel to analyze a unique subset of atmospheric ozone (O[subscript 3]) and nitrogen dioxide (NO[subscript 2])…

The drive in computational methods and more intuitive software has seen a rise in the number of publications in this area in recent years. Computational simulations can be found in many areas of science from computational biology and chemistry to fundamental physics. These may help synthetic chemists in their drug discovery endeavors and…

A laboratory experiment characterized by a whole-class data-pooling approach to generate a data set that can be used to test a model of the influence of ionic strength on electrolyte solubility is described and discussed. The design of the experiment makes efficient use of the laboratory period and releases time for instructional and dialogic…

Scientific Data Analysis Toolkit (SDAT) is a rigorous, versatile, and user-friendly data analysis add-in application for Microsoft Excel for Windows (PC). SDAT uses the familiar Excel environment to carry out most of the analytical tasks used in data analysis. It has been designed for student use in manipulating and analyzing data encountered in…

For the least-squares analysis of data having multiple uncertain variables, the generally accepted best solution comes from minimizing the sum of weighted squared residuals over all uncertain variables, with, for example, weights in x[subscript i] taken as inversely proportional to the variance [delta][subscript xi][superscript 2]. A complication…

Asking questions about your data is a constant application of all business organizations. To facilitate decision making and improve business performance, a business intelligence application must be an integral part of everyday management practices. Microsoft Excel added PowerPivot and PowerPivot officially to facilitate this process with minimum…

Dashboards allow managers to interact with data, asking "what if" questions and looking for patterns. This topic is typically mentioned in information systems courses; however, many students will not have experience with developing dashboards or using them to answer business questions. The purpose of this assignment is to provide…

The oxidation of iron is an important reaction due to its high economic impact. In this laboratory exploration, the total order of this reaction was determined using commercially available handwarmer packets that rely on the iron-oxygen reaction to generate heat. The active ingredient in the handwarmer packet is iron, which interacts with…

Single-period inventory models with uncertain demand are very well known in the business analytics community. Typically, such models are rule-based functions, or sets of functions, of one decision variable (order quantity) and one random variable (demand). In academics, the models are taught selectively and usually not completely. Students are…

Historically, some baby names have been more popular during a specific time span, whereas other names are considered timeless. The Internet article, "How to Tell Someone's Age When All You Know Is Her Name" (Silver and McCann 2014), describes the phenomenon of the rise and fall of name popularity, which served as a catalyst for the…

This case involves actual data from a student managed café that serves as a learning laboratory for a college of business. The student team that manages the café has never had access to precise data from a point of sale system until this semester. However, once they downloaded the raw data from the cash register they were unable to make sense of…

The development of a student's ability to make data-driven decisions has become a focus in higher education (Schield 1999; Stephenson and Caravello 2007). Data literacy, the ability to understand and use data to effectively inform decisions, is a fundamental component of information competence (Mandinach and Gummer 2013; Stephenson and Caravello,…

Simple numerical data analysis is described, using a standard spreadsheet program, to determine distance, velocity (speed) and acceleration from voltage data generated by a skateboard/longboard speedometer (Hare 2012 "Phys. Educ." 47 409-17). This simple analysis is an introduction to data processing including scaling data as well as…