Microsoft Excel is ubiquitous, cost-effective, and can be used to create publication-quality single-case design graphs. We systematically replicated the GraphPad Prism video tutorial by Mitteer et al. (2018) to teach 24 master's students to create multiple-baseline graphs using Excel 2016. Students' mean accuracy on the multiple-baseline graph was…

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…

The benefits of using Microsoft Excel built-in functions in an undergraduate Multistage Separations course are analyzed based on 15 years of experience teaching mass transfer in Chemical Engineering programs at both the Bachelor's and Master's levels. Eight reasons for using spreadsheets in a Mass Transfer virtual course are given. Through the…

Finite Mathematics has become an enormously rich and productive area of contemporary mathematical biology. Fortunately, educators have developed educational modules based upon many of the models that have used Finite Mathematics in mathematical biology research. A sufficient variety of computer modules that employ graph theory (phylogenetic trees,…

Throughout the general chemistry lab curriculum, a common shortcoming is the way in which students measure, record, and manipulate quantitative data. From initial measurements with different digital and analog instruments to proper conversions, calculations, and comparisons, students are often expected to be experts before they have been taught…

Access to online data sets and free, data-visualization software programs that don't require coding skills has given journalism students the ability to produce charts, maps, and graphs quickly. Maps that used to require weeks of software training and expensive programs to create can now be produced in less than an hour. However, students must…

A visual regression analysis using the least absolutes method (LAB) was developed, utilizing an interactive approach of visually minimizing the sum of the absolute deviations (SAB) using a bar graph in Excel; the results agree very well with those obtained from nonvisual LAB using a numerical Solver in Excel. These LAB results were compared with…

Using an ALTA II reflectance spectrometer, the USGS digital spectral library, graphs of planetary spectra, and a few mineral hand samples, one can teach how light can be used to study planets and moons. The author created the hands-on, inquiry-based activity for an undergraduate planetary science course consisting of freshman to senior level…

It is common for both algebra and calculus instructors to use power functions of various degrees as well as exponential functions to examine and compare rates of growth. This can be done on a chalkboard, with a graphing calculator, or with a spreadsheet. Instructors often are careful to connect the symbolic and graphical (and occasionally the…

Equilibrator is a Microsoft Excel program for learning about chemical equilibria through modeling, similar in function to EQS4WIN, which is no longer supported and does not work well with newer Windows operating systems. Similar to EQS4WIN, Equilibrator allows the user to define a system with temperature, initial moles, and then either total…

Two methods of data analysis are compared: spreadsheet software and a statistics software suite. Their use is compared analysing data collected in three selected experiments taken from an introductory physics laboratory, which include a linear dependence, a nonlinear dependence and a histogram. The merits of each method are compared. (Contains 7…

Over 10 years have passed since the publication of Carr and Burkholder's (1998) technical article on how to construct single-subject graphs using Microsoft Excel. Over the course of the past decade, the Excel program has undergone a series of revisions that make the Carr and Burkholder paper somewhat difficult to follow with newer versions. The…

In this article, our main objective is to present the use of Microsoft Software Excel 2007/2003 for teaching college and university level curriculum in science and engineering. In particular, we discuss two interesting and fascinating examples of interactive applications of Microsoft Excel targeted for undergraduate students in: 1) computational…

The teaching of scientific subjects usually require laboratories where students can put the theory they have learned into practice. Traditionally, electronic programmable calculators, dedicated software, or expensive software simulation packages, such as MATLAB have been used to simulate scientific experiments. Recently, spreadsheet programs have…

Calculus-based business mathematics is a required quantitative course for undergraduate business students in most AACSB accredited schools or colleges of business. Many business students, however, have relatively weak mathematical background or even display math-phobia when presented with calculus problems. Because of the popularity of Excel, its…