Microsoft Excel and Access are widely used in introductory courses designed to teach the fundamentals of spreadsheet and relational database modeling skills in various disciplines. To achieve the targeted learning outcomes, instructors of these courses strive to provide students with guided, frequent, and incrementally fruitful practice with the…

The COVID-19 pandemic has made mathematical epidemiology a topic of critical importance, providing mathematics educators with an unparalleled opportunity. This opportunity is accompanied by a challenge: how do mathematics educators, some of whom have little personal experience with mathematical modeling, teach mathematical epidemiology to their…

The author focused on solving problems of third-degree price discrimination under a monopoly by integrating microeconomic theory and spreadsheet modeling. Price discrimination refers to a firm situation in which the same good is sold to different groups of consumers at different prices. First, the author included an introductory math background…

Students today are often assumed to be digitally literate and prepared for college, but that is not always the case. Introductory technology courses at the college level provide students with the technology and digital skills necessary for them to succeed in college. This study, conducted at a small New England "business school" that…

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…

Powder diffraction is one of the most widely used analytical techniques for characterizing solid state materials. It can be used for phase or polymorph identification, quantitative analysis, cell parameter determination, or even full crystal structure analysis using the powerful Rietveld refinement method. As with much of modern crystallography,…

"Cap and trade" is one of the most innovative policy options developed by environmental economists. By placing a cap on a social bad and allowing firms to buy and sell the right to generate it, policymakers combine government intervention with market-based incentives to improve welfare and internalize the externality. Such programs…

The invention of the computer has led to the establishment of a new research paradigm, computation, which has recently become more and more popular in scientific exploration. However, computation is not well represented in high school and university curricula in science and engineering, although it applies to a wide range of disciplines beyond…

A simple Excel spreadsheet-based program for simulating atomic emission spectra from the properties of neutral atoms (e.g., energies and statistical weights of the electronic states, electronic partition functions, transition probabilities, etc.) is described. The contents of the spreadsheet (i.e., input parameters, formulas for calculating…

A key issue in exponential smoothing is the choice of the values of the smoothing constants used. One approach that is becoming increasingly popular in introductory management science and operations management textbooks is the use of Solver, an Excel-based non-linear optimizer, to identify values of the smoothing constants that minimize a measure…

We have designed an exercise suitable for a lab or project in an undergraduate physical chemistry course that creates a Microsoft Excel spreadsheet to calculate the energy of the S[subscript 0] ground electronic state and the S[subscript 1] and T[subscript 1] excited states of H[subscript 2]. The spreadsheet calculations circumvent the…

Despite their technological savvy, most students entering university lack the necessary computer skills to succeed in a quantitative analysis course, in which they are often expected to input, analyze, and plot results of experiments without any previous formal education in Microsoft Excel or similar programs. This lack of formal education results…

A project for students in an upper-level course in quantum or computational chemistry is described in which they are introduced to the concepts and applications of a high quality, ab initio treatment of the ground-state potential energy curve (PEC) for H[subscript 2] and D[subscript 2]. Using a commercial computational chemistry application and a…

Business students taking business analytics courses that have significant predictive modeling components, such as marketing research, data mining, forecasting, and advanced financial modeling, are introduced to nonlinear regression using application software that is a "black box" to the students. Thus, although correct models are…

This study investigates prospective secondary mathematics teachers' visual representations of polynomial and rational inequalities, and graphs of exponential and logarithmic functions with GeoGebra Dynamic Software. Five prospective teachers in a university in the United States participated in this research study, which was situated within a…