Microsoft Excel and Access are widely used in introductory courses designed to teach the fundamentals of spreadsheet and relational database modeling skills in various disciplines. To achieve the targeted learning outcomes, instructors of these courses strive to provide students with guided, frequent, and incrementally fruitful practice with the…

The COVID-19 pandemic has made mathematical epidemiology a topic of critical importance, providing mathematics educators with an unparalleled opportunity. This opportunity is accompanied by a challenge: how do mathematics educators, some of whom have little personal experience with mathematical modeling, teach mathematical epidemiology to their…

We present a simple activity based on the liquid-drop model which allows secondary school students to explore the uses of mathematical models and gain an intuitive understanding of the concept of binding energy, and in particular the significance of positive binding energy. Using spreadsheets provided as supplementary material, students can…

This chapter advocates a teaching approach for the statement of cash flows (SCF) that includes introduction of the SCF early in the curriculum using the accounting equation format, which helps students visualize the cash and accrual activities. We then adapt this accounting equation format to a worksheet model that can be used later in the…

In Costa Rica, before 2016 the subject of statistics was not included in the national high school tests in Mathematics. As of 2016, the test, consisting of 60 items, includes 9 statistical items. On the other hand, teachers in their lessons usually use traditional expository methods, mediated by the use of a blackboard and printed materials. In…

This work aims to demonstrate the use of Excel spreadsheets for solving L-L extraction problems. The key to solving the problems successfully is to be able to determine a tie line on the ternary diagram where the calculation must be carried out. This enables the reader to analyze the extraction process starting with a simple operation, the…

The article presents the results of an experiment in which Excel applications that depict rotatable and sizable orthographic projection of simple 3D figures with face overlapping were developed with thirty gymnasium (high school) students of age 17-19 as an introduction to 3D computer graphics. A questionnaire survey was conducted to find out…

We have designed an exercise suitable for a lab or project in an undergraduate physical chemistry course that creates a Microsoft Excel spreadsheet to calculate the energy of the S[subscript 0] ground electronic state and the S[subscript 1] and T[subscript 1] excited states of H[subscript 2]. The spreadsheet calculations circumvent the…

Despite their technological savvy, most students entering university lack the necessary computer skills to succeed in a quantitative analysis course, in which they are often expected to input, analyze, and plot results of experiments without any previous formal education in Microsoft Excel or similar programs. This lack of formal education results…

The goal of this paper is to evaluate the contribution of the anthropological approach (AA) concurrently to Activity Theory (AT) in view of overarching questions about classroom use of technology for teaching and learning mathematics. I will do it first from a philosophical point of view, presenting the main notions of AA that have been used to…

SpaceShipTwo is a private spaceplane project which is intended for space tourism. Very few details about its construction and flight characteristics are available for the public, but with proper numerical methods some interesting results can be obtained using secondary school mathematics. An exercise about SpaceShipTwo can be used as a…

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…

An approach is presented that utilizes a spreadsheet to allow students to explore different means of calculating and visualizing how the charge on peptides and proteins varies as a function of pH. In particular, the concept of isoelectric point is developed to allow students to compare the results of their spreadsheet calculations with those of…

Logistic growth displays an interesting pattern: It starts fast, exhibiting the rapid growth characteristic of exponential models. As time passes, it slows in response to constraints such as limited resources or reallocation of energy. The growth continues to slow until it reaches a limit, called capacity. When the growth describes a population,…

A freely available, easy-to-use Excel spreadsheet for performing linear least-squares fits for (x, y) data with errors in both coordinates is described. (Contains 1 table and 1 figure.)