We present a complete, soup to nuts, modeling activity of a falling column of water. Many colleagues have used this material in teaching applications of first order separable differential equations. We describe how the material can be presented with students collecting their own data from online videos. One can then either offer the differential…

As educational systems move from onsite to online due to the COVID-19 pandemic, teachers face the difficulty of designing online examination formats which minimize opportunities for dishonesty. In this paper, we expose our design of such a format: a protected Microsoft Excel spreadsheet containing short-answer questions, which was implemented in a…

Biological systems exhibit strong dynamic variations; for example, a system may have a tendency towards either a steady state, periodic behaviour or chaotic oscillations. These findings, explained by dynamic systems theory, have allowed researchers to formally relate a wide variety of systems, such as the theory of rumour propagation, glucose…

This article uses dynamic software in Excel to demonstrate several ways in which graphical and numerical approaches can be introduced both to enhance student understanding of l'Hopital's Rule and to explain why the Rule actually works to give the "right" answers. One of the approaches used is to visualize what is happening by examining…

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…

This note gives the analytical solution to projectile motion with quadratic drag by decomposing the velocity vector to "x," "y" coordinate directions. The solution is given by definite integrals. First, the impact angle is estimated from above, then the projectile coordinates are computed, and the trajectory is graphed at various launch angles and…

We consider a problem appearing in an Australian Mathematics Challenge in 2003. This article considers whether a spreadsheet might be used to model this problem, thus allowing students to explore its structure within the spreadsheet environment. It then goes on to reflect on some general principles of problem decomposition when the final goal is a…

This note demonstrates multiple representations (numerical and graphical) of spreadsheet-based quadratic sequences together with prospective teachers' pencil-paper transformations of these numerical sequences into a corresponding symbolization as algebraic expressions. With the majority of prospective teachers, the experience of school mathematics…

In this article an application of conformal mapping to aerofoil theory is studied from a geometric and calculus point of view. The problem is suitable for undergraduate teaching in terms of a project or extended piece of work, and brings together the concepts of geometric mapping, parametric equations, complex numbers and calculus. The Joukowski…

This classroom note shows how Fibonacci numbers with negative subscripts emerge from a problem-solving context enhanced by the use of an electronic spreadsheet. It reflects the author's work with prospective K-12 teachers in a number of mathematics content courses. (Contains 4 figures.)

This note gives a power series solution to the pendulum equation that enables to investigate the system in an analytical way only, i.e. to avoid numeric methods. A method of determining the number of the terms for getting a required relative error is presented that uses bigger and lesser geometric series. The solution is suitable for modelling the…

This note gives the solution to the motion of a perfectly hard ball that was launched against a perfectly hard inclined plane. The solution comprises recurrent formulas that give the parts of the trajectory between the impacts, which are parabolas. In the upward part of the motion, the parabolas become higher and narrower, in the downward part…

This note presents two demonstrations of the known formula for the sum of squares of the first n natural numbers. One demonstration is based on geometrical considerations and the other one uses elementary integral calculus. Both demonstrations are very easy to understand, even for high school students, and may be good examples of how to explore…

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…

This paper shows how the computational and graphical capabilities of spreadsheets allow for interactive analytic and geometric constructions from numerical modelling of homogeneous Diophantine equations of the second order. Suggested activities, designed for prospective teachers of mathematics and made possible by what is referred to in the paper…