This article describes a web-based application that can be used to help teach linear programming (LP) using an active learning approach in business courses such as management science and decision analysis. The software asks 42 integrated questions that guide students in creating product mix models and performing related analysis in Excel with…

This paper presents the usage of an Excel spreadsheet for studying charged particle dynamics in the presence of uniform electric and magnetic fields. The equation of motion of the charged particle is developed under different conditions and the data is obtained in an Excel spreadsheet under variation of parameters such as the velocity of charged…

A bachelor's degree program in chemistry typically starts with basic concepts in mathematics, physics, and chemistry. Those principles are very important because they pave the ground for future advanced studies and, therefore, one needs to present them in a clear but rigorous way. One example is provided by the mathematical notion of an iterative…

In the context of rapid technological changes and modernization of society, the issue of ensuring adequacy of content in secondary education based on the use of advanced information technologies (ICT) is being updated. The necessity of an appropriate level of primary intellectual activity development in a person in terms of the current trends in…

From its earliest days, practitioners of computer-assisted language learning (CALL) have collected data from computer-mediated learning environments. Indeed, that has been a central aspect of the field from the beginning. Usage logs provided valuable insights into how systems were used and how effective they were for language learning. That…

The present paper aims to review two motivations to conduct "what if" analyses using Excel and "R" to understand the statistical significance tests through the sample size context. "What if" analyses can be used to teach students what statistical significance tests really do and in applied research either prospectively to estimate what sample size…

Discrete Mathematics instructors and students have long been struggling with various labelling and scanning algorithms for solving many important problems. This paper shows how to solve a wide variety of Discrete Mathematics and OR problems using assignment matrices and linear programming, specifically using Excel Solvers although the same…

The current research article is based on a simple and practical way of employing the computational power of widely available, versatile software MS Excel 2007 to perform interactive computer simulations for undergraduate/graduate students in biology, biochemistry, biophysics, microbiology, medicine in college and university classroom setting. To…

In this article, the author explores how to use "PowerPoint" to support the mathematics itself, not just to "present" but actually to "enhance" learning. For the purposes of this article, she has explored three tools: colour, animation and hyperlinks. (Contains 1 note.)

Exploring student test, homework, and other assessment scores is a challenge for most teachers, especially when attempting to identify cross-assessment weaknesses and produce final course grades. During the course, teachers need to identify subject weaknesses in order to help students who are struggling with a particular topic. This identification…

Chemical process simulation is one of the most fundamental skills that is expected from chemical engineers, yet relatively few graduates have the opportunity to learn, in depth, how a process simulator works, from programming the unit operations to the sequencing. The University of Calgary offers a "hands-on" postgraduate course in…

Standard spreadsheet functions cannot compute bond yields if both the settlement and maturity dates fall on other than an interest payment date. Using reciprocal cell references, the RATE function is enhanced to overcome this limitation. An appendix extends the enhancement procedure to the IRR function. The procedure demonstrated has applications…

Developing personalized fitness programs to meet individual needs of students can be an overwhelming task for the physical educator. The National Standards for Physical Education (NASPE) indicate that students should achieve and maintain appropriate levels of physical fitness. To effectively meet standards with the growing diversity of curricular…

In this brief article, the author instructs teachers on how to produce an interactive spreadsheet from scratch in about 20 minutes and en route equip themselves and their students, with handy "Excel" skills. The aim is to introduce the basics of "Excel," plus some fun bits, speedily and with a purpose; producing something that is useful in its own…

A simple interface between VPython and Microsoft (MS) Office products such as Word and Excel, controlled by Visual Basic for Applications, is described. The interface allows the preparation of content-rich, interactive learning environments by taking advantage of the three-dimensional (3D) visualization capabilities of VPython and the GUI…