A key issue in exponential smoothing is the choice of the values of the smoothing constants used. One approach that is becoming increasingly popular in introductory management science and operations management textbooks is the use of Solver, an Excel-based non-linear optimizer, to identify values of the smoothing constants that minimize a measure…

This paper gives the solution and analysis of projectile motion in a vacuum if the launch and impact heights are not equal. Formulas for the maximum horizontal range and the corresponding angle are derived. An Excel application that simulates the motion is also presented, and the result of an experiment in which 38 secondary school students…

The paper presents the use of spreadsheets integrated with digital tools capable of symbolic computations and graphic constructions in a master's level capstone course for secondary mathematics teachers. Such use of spreadsheets is congruent with the Type II technology applications framework aimed at the development of conceptual knowledge in the…

In the Manchester Pharmacy School, we first adopted summative on-line examinations in 2005. Since then, we have increased the range of question types to include short answers, short essays and questions incorporating chemical structures and we achieve time savings of up to 90% in the marking process. Online assessments allow two novel forms of…

The "individualised accounting questions" (IAQ) technique set out in this paper encourages independent active learning. It enables tutors to set individualised accounting questions and construct an answer grid that can be used for any number of students, with numerical values for each student's answers based on their student enrolment…

This paper investigates some of the physics behind the remarkable supersonic freefall of Felix Baumgartner accomplished with the "Red Bull Stratos" project on 14 October 2012. The underlying problem is complex: a freefall with air resistance through a medium of changing density. We developed a model for the motion within the framework of…

A simple organic chemistry experiment is described that investigates the kinetics of the reaction between 1-bromobutane (BuBr) and iodide (I[superscript -]) as followed by observing the disappearance of BuBr and the appearance of 1-iodobutane (BuI) using [superscript 1]H NMR spectroscopy. In small groups of three to four, students acquire data to…

This paper provides the formula for the elevation angle at which a projectile has to be fired in a vacuum from a general position to hit a target at a given distance. A spreadsheet application that models the trajectory is presented, and the problem of finding the points of shot and impact of a projectile moving in a vacuum if three points of the…

When students are first introduced to the idea of radioactive decay, a large conceptual hurdle must be overcome. The thought that an object's age has no bearing on the chance it will "die" (decay in this case) on a particular day is completely at odds with biological notions of life and death. Through the use of a simple…

3-D topographic surfaces ("topos") can be generated to visualize how pH behaves during titration and dilution procedures. The surfaces are constructed by plotting computed pH values above a composition grid with volume of base added in one direction and overall system dilution on the other. What emerge are surface features that…

An assignment incorporating posters into a second-year analytical chemistry lab is described. Students work in groups and are assigned one of the application-themed weekly laboratories as a topic. Course data acquired for these weekly laboratories are compiled into spreadsheets that the poster group then analyzes to present in an on-campus poster…

With 27 million users, Excel (Microsoft Corporation, Seattle, WA) is the most common business data analysis software. However, audits show that almost all complex spreadsheets have errors. The author examined textbooks to understand why responsible data analysis is taught. A purposeful sample of 10 textbooks was coded, and then compared against…

A visual regression analysis using the least absolutes method (LAB) was developed, utilizing an interactive approach of visually minimizing the sum of the absolute deviations (SAB) using a bar graph in Excel; the results agree very well with those obtained from nonvisual LAB using a numerical Solver in Excel. These LAB results were compared with…

This paper reports on the initial stages of a small-scale project involving the use of "spreadsheet algebra programs" in the professional development of eight teachers from three township high schools. In terms of the education context, the paper draws on social practice theory. It then details what is meant by spreadsheet algebra. An…

The purpose of this study was to examine the impact on program improvement of systematically gathering P-12 student learning data over a 5-year period. This study was completed over 5 academic years (2008-2009 to 2012-2013) in a teacher preparation program in northwest Oregon. Data were gathered from two student teaching experiences of teacher…