This paper presents a dynamic Excel visual. The visual has three graphs that are all driven by the same data, so students can see how changes (via Slider controls) in data appear on a univariate graph, a bivariate graph, and a graph that shows a ratio of two variables on one axis. The visual has macros that let a statistics teacher reveal parts of…

It's not surprising that rainbows have received a great deal of attention: in textbooks, in magazines, and on the web. They are, after all, beautiful, fascinating, occasionally awe-inspiring, even a little mysterious. They are an almost perfect blend of natural beauty and simple physics. Has everything that can be said about rainbows already been…

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,…

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,…

Graphing is socially significant for behavior analysts; however, graphing can be difficult to learn. Video modeling (VM) may be a useful instructional method but lacks evidence for effective teaching of computer skills. A between-groups design compared the effects of VM, text-based instruction, and no instruction on graphing performance.…

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…

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…

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…

This article is intended to model the ascent of the space shuttle for high school teachers and students. It provides a background for a sufficiently comprehensive description of the physics (kinematics and dynamics) of the March 16, 2009, "Discovery" launch. Our data are based on a comprehensive spreadsheet kindly sent to us by Bill Harwood, the…

The authors describe a collection of dynamic interactive simulations for teaching and learning most of the important ideas and techniques of introductory statistics and probability. The modules cover such topics as randomness, simulations of probability experiments such as coin flipping, dice rolling and general binomial experiments, a simulation…

We discuss the introduction and teaching of partial differential equations (heat and wave equations) via modeling physical phenomena, using a new approach that encompasses constructing difference equations and implementing these in a spreadsheet, numerically solving the partial differential equations using the numerical differential equation…

In this note, we demonstrate with illustrations two different ways that MS Excel can be used to solve Linear Systems of Equation, Linear Programming Problems, and Matrix Inversion Problems. The advantage of using MS Excel is its availability and transparency (the user is responsible for most of the details of how a problem is solved). Further, we…

We describe a computer tutorial that introduces the concept of the steady state in enzyme kinetics. The tutorial allows students to produce graphs of the concentrations of free enzyme, enzyme-substrate complex, and product versus time in order to learn about the approach to steady state. By using a range of substrate concentrations and rate…

This case study investigated the impact of a spreadsheet (EXCEL) exploration on the understanding of statistical graphs among twenty Singapore secondary school students of average ability. Four EXCEL templates were constructed to allow students to explore four aspects of statistical graphs: zero in scale, effect of different scales, size…