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…

Technological Pedagogical Content Knowledge (TPACK) is defined as the teacher knowledge needed for effective technology integration. This study aimed to investigate preservice elementary mathematics teachers' TPACK development. TPACK survey was administered to 33 preservice teachers (PSTs), and six of them were selected via maximum variation…

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…

This study describes a teaching process that offers teachers and pupils ways of constructing the division operation through illustration based on defining the reference unit (divisor), the reference whole1 and the dividend. We introduce a computerized dynamic environment, using an Excel spreadsheet, in which both teachers and pupils can…

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…

Software, particularly spreadsheet software, is ubiquitous in the financial services workplace. Yet little is known about the extent to which universities should, and do, prepare graduates for this aspect of the modern workplace. We have investigated this issue through a survey of financial services employers of graduates, the results of which are…

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…

The role of universities in preparing students to use spreadsheet and other technical software in the financial services workplace has been investigated through surveys of university graduates, university academics, and employers. It is found that graduates are less skilled users of software than employers would like, due at least in part to 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…

Software may be used in university teaching both to enhance student learning of discipline-content knowledge and skills, and to equip students with capabilities that will be useful in their future careers. Although research has indicated that software may be used as an effective way of engaging students and enhancing learning in certain scenarios,…

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.)