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…

The present article demonstrates a way of programming using an Excel spreadsheet to teach Fourier series expansion in school/colleges without the knowledge of any typical programming language. By using this, a student learns to approximate partial sum of the n terms of Fourier series for some periodic signals such as square wave, saw tooth wave,…

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…

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…

Descriptive statistics and appropriate visual representations of scores are important for all test developers, whether they are experienced testers working on large-scale projects, or novices working on small-scale local tests. Many teachers put in charge of testing projects do not know "why" they are important, however, and are utterly convinced…

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…

If larger and larger samples are successively drawn from a population and a running average calculated after each sample has been drawn, the sequence of averages will converge to the mean, [mu], of the population. This remarkable fact, known as the law of large numbers, holds true if samples are drawn from a population of discrete or continuous…

Presented are ideas for the utilization of Microsoft Works in the secondary mathematics classroom. The spreadsheet and graphing capabilities of this software package are demonstrated for several topics including the concept of slope for first year algebra, and creating and interpreting graphs for a general mathematics class. (Author/CW)

Described are several spreadsheet templates which use the functions of iteration and logical look-up which allow students to calculate and graph quantum mechanical functions and to simulate rotational and vibrational energy level and spectra. The templates are listed in the appendix. (KR)

Discussed are the possible uses of spreadsheets in the undergraduate curriculum in chemical engineering classes. The advantages and flexibility of spreadsheets, spreadsheet instruction, graphing capabilities, assignment examples, and conclusions are described. (KR)

The paper describes the use of a spreadsheet in a mathematics teacher education course. It shows how the tool can serve as a link between seemingly disconnected mathematical concepts. The didactical triad of using a spreadsheet as an agent, consumer, and amplifier of mathematical activities allows for an extended investigation of simple yet…