This article illustrates ways that dynamic software using some sophisticated techniques in Excel can be used to demonstrate fundamental ideas related to sampling distributions and their properties to increase student understanding of the concepts and methods in elementary statistics courses. The article considers such sampling distributions as the…

Teaching quantitative methods at the undergraduate level is a difficult yet rewarding endeavor due to the challenges instructors face in presenting the material. One way to bolster student learning is through the use of statistical software packages. Google Sheets is a cloud-based spreadsheet program capable of many basic statistical procedures,…

Harmonics arise naturally from the resonances in strings and pipes. A video demonstration (Ruiz 2016 "YouTube: Tuba Harmonics" (https://youtu.be/souhEzOP9c4)) is provided where a tubist (coauthor Holmes) produces a phenomenal 24 harmonics using a single tuba pipe length by controlling the buzz of his lips. The frequencies of the…

This article illustrates ways that dynamic software using some sophisticated techniques in Excel can be used to demonstrate fundamental ideas related to regression and correlation analysis to increase student understanding of the concepts and methods in elementary statistics courses and in courses at the college algebra/precalculus level that…

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

This article describes a modeling project the author did with his algebra, geometry, and applications students in grades 9, 10, and 11 as an enrichment and exploration of an extremely relevant real-world phenomenon and introduction to the adult profession of epidemiologist. With discussion and exploration, this project consumed two periods of 88…

This article illustrates ways that dynamic software using some sophisticated techniques in Excel can be used to demonstrate fundamental ideas related to hypothesis testing to increase student understanding of the concepts and methods in elementary statistics courses. The article considers hypothesis tests for the population mean with large or…

This document presents a literature review that analyzes the articulation of modeling and digital technologies in the field of Mathematics Education. The review aims to find evidence of the use of digital technologies in modeling processes and how these practices can change some ways of working with students in the classroom. The results show, on…

When students of the of the physical sciences transition from school to university, they discover that knowledge of calculus is as vital as arithmetic, and that there is precious little useful information written without calculus. However, the lack of calculus in pre-university physics studies persists, especially in its application to the…

Electricity is taught in junior high school science in Australia and many other countries. While electricity is all around us and one would say that its context and relevance are obvious, students generally do not find learning about electricity engaging. The objective of this paper is to describe the development and evaluation of an open inquiry…

Despite the importance of artificial intelligence in our daily lives, it has yet to be integrated into K-12 classrooms in a meaningful way. This article explores a lesson in which geometry students use Euclidean distance to implement a functional machine learning algorithm in Google Sheets™. The assignment requires students to apply the distance…

For the least-squares analysis of data having multiple uncertain variables, the generally accepted best solution comes from minimizing the sum of weighted squared residuals over all uncertain variables, with, for example, weights in x[subscript i] taken as inversely proportional to the variance [delta][subscript xi][superscript 2]. A complication…

Physicists create spreadsheets customarily to carry out numerical calculations and to display their results in a meaningful, nice-looking way. Spreadsheets can also be used to display a vivid geometrical model of a physical system. This statement is illustrated with an example taken from geometrical optics: images formed by a thin lens. A careful…

Asking questions about your data is a constant application of all business organizations. To facilitate decision making and improve business performance, a business intelligence application must be an integral part of everyday management practices. Microsoft Excel added PowerPivot and PowerPivot officially to facilitate this process with minimum…

Baseball's flirtation with technology began in 2005 when PITCHf/x® by Sportvision started to be installed in major league ballparks. Every stadium had the system operational by 2007. Since then, the trajectories of over six million pitches have been measured to within about half an inch using three 60-Hz video cameras to track the position of the…