A spreadsheet-based exercise for students is described in which they are challenged to explain and reproduce the disparate temperature dependencies of the heat capacities of gaseous F[subscript 2] and N[subscript 2]. For F[subscript 2], C[subscript p,m] increases from 300 K, reaches a maximum at 2200 K, and then decreases to 74% of the maximum…

Accrediting organizations in higher education have shifted emphasis from indirect measures such as student course evaluations, focus-group interviews, and employer surveys to direct measurement of student performance using appropriate assessment instruments. In response, we developed a spreadsheet tool for reports and analysis of test assessments…

Since motivation is known to be a critical factor, approaches, methods, techniques, and materials that would affect motivation positively are utilized in learning and teaching processes. Gamification is used by including game components into teaching processes to enhance students' motivation, attract their attention to the lesson and boost…

In this research we investigate how mathematics teachers, as graduate students, estimate the value of [pi] by exploring the problem of "squaring the circle" using digital technology. Initially, we mention some aspects of teaching and learning of calculus in the literature, emphasizing studies that use the notion of humans-with-media to…

The ways teachers converse about their work in relation to information and communications technologies (ICTs) are worth studying. We analyse how a teacher converses about her local practices in relation to two spreadsheet algebra programs (SAPs) on variables. During the conversations we noticed that the teacher keeps different policy documents --…

Scientific Data Analysis Toolkit (SDAT) is a rigorous, versatile, and user-friendly data analysis add-in application for Microsoft Excel for Windows (PC). SDAT uses the familiar Excel environment to carry out most of the analytical tasks used in data analysis. It has been designed for student use in manipulating and analyzing data encountered in…

In this age of easy access to the internet and to spreadsheets, easy-to-apply numerical methods exist that are vastly superior to Simpson's rule and the (corrected) trapezoidal rule. Gaussian quadrature (GQ) is such a method. What follows tells how enthusiastic Year 9 students with a physics problem provoked a science teacher into re-discovering a…

This teaching brief describes an engaging, in-class exercise that introduces genetic algorithms as well as advanced Excel functions and capabilities by modeling the familiar Sudoku puzzle. Student groups are first asked to manually solve a given puzzle and then translate that solution methodology to a spreadsheet model. This exercise can be used…

The foreign exchange (FX) market is an important chapter in international finance. Understanding the market microstructure is critical for learning the FX market. To assist students better understand the FX market microstructure, an instructor can use an event study with minute-by-minute quote data provided in the Excel assignment, asking students…

Data-handling, processing, and analysis skills are an integral part of a chemist's skill set and, more generally, are highly sought by employers. We report a self-directed workshop to develop and advance these key skills using the popular spreadsheet program Microsoft Excel. Making use of its accessible user interface, various contextualized…

"Cap and trade" is one of the most innovative policy options developed by environmental economists. By placing a cap on a social bad and allowing firms to buy and sell the right to generate it, policymakers combine government intervention with market-based incentives to improve welfare and internalize the externality. Such programs…

EXCEL spreadsheet algorithms were developed at Villanova University to efficiently and consistently retrieve information from ASPEN® flowsheets and used for grading work in senior design. The challenge is to take a large volume of data that is in the stream and unit operations reports and quickly and consistently calculate a list of key grading…

This article provides two activities, exploring genetic drift of small breeding populations, highlighting the black-footed ferret ("Mustela nigripes"). According to the U.S. Fish and Wildlife service, all black-footed ferrets are descended from 18 individuals, making them extremely vulnerable to genetic drift. They were thought to be…

Students' procedural knowledge and conceptual understanding of matrices can improve when they use technology, in particular spreadsheets, as a tool. Complex real-world applications of matrix calculations are time-consuming and prone to errors if done by hand, yet calculations can be performed easily with spreadsheets. In this article, the author…

Exploration with spreadsheets and reliance on previous skills can lead students to determine the line of best fit. To perform linear regression on a set of data, students in Algebra 2 (or, in principle, Algebra 1) do not have to settle for using the mysterious "black box" of their graphing calculators (or other classroom technologies).…