This experiment investigates the effectiveness of Excel spreadsheets in a high school algebra class. Students in the experiment group convincingly outperformed the control group on a post lesson assessment. The student responses, teacher observations involving Excel spreadsheet revealed that it operated as a mindtool, which formed the users'…

In this paper we give a general solution to the problem of the damped harmonic oscillator under the influence of an arbitrary time-dependent external force. We employ simple methods accessible for beginners and useful for undergraduate students and professors in an introductory course of mechanics.

A general systematic approach is proposed for the numerical calculation of multi-equilibrium problems. The approach involves several steps: (i) the establishment of balances involving the chemical species in solution (e.g., mass balances, charge balance, and stoichiometric balance for the reaction products), (ii) the selection of the unknowns (the…

Seasoned educators use an assortment of student-centered methods and tools to enhance their student's learning environment. In respects to methodologies used in accounting, educators have utilized and created new forms of problem-based learning exercises, including case studies, simulations, and other projects, to help students become more active…

Dice are considered one of the oldest gambling devices and thus many mathematicians have been interested in various dice gambling games in the past. Dice have been used to teach probability, and dice rolls can be effectively simulated using technology. The National Council of Teachers of Mathematics (NCTM) recommends that teachers use simulations…

Students often enter biology programs deficient in the math and computational skills that would enhance their attainment of a deeper understanding of the discipline. To address some of these concerns, I developed a series of spreadsheet simulation exercises that focus on some of the mathematical foundations of scientific inquiry and the benefits…

The purpose of this study is to investigate the effects of screencasts on the Turkish undergraduate students' achievement and knowledge acquisitions in spreadsheet applications. The methodology of the study is based on a pretest-posttest experimental design with a control group. A total of 66 undergraduate students in two groups (n = 33 in…

The Early Warning System (EWS) Tool v2.0 is a Microsoft Excel-based tool developed by the National High School Center at the American Institutes for Research in collaboration with Matrix Knowledge Group. The tool enables schools, districts, and states to identify students who may be at risk of dropping out of high school and to monitor these…

Titration experiments are ideal for generating large data sets for use in quantitative-analysis activities that are meaningful and transparent to general chemistry students. We report the successful implementation of a sophisticated quantitative exercise in which the students identify a series of unknown acids by determining their molar masses…

It is common to consider Tukey's schematic ("full") boxplot as an informal test for the existence of outliers. While the procedure is useful, it should be used with caution, as at least 30% of samples from a normally-distributed population of any size will be flagged as containing an outlier, while for small samples (N less than 10) even extreme…

How useful are the standard deviations per se, and how reliable are results derived from several least-squares coefficients and their associated standard deviations? When the output parameters obtained from a least-squares analysis are mutually independent, as is often assumed, they are reliable estimators of imprecision and so are the functions…

This study sought to assess required information and communication technology (ICT) tasks in selected undergraduate agriculture courses in a land-grant university during a 10-year period. Selected agriculture faculty members in the fall 1999 (n = 63), 2004 (n = 55), and 2009 (n = 64) semesters were surveyed to determine the ICT tasks they required…

Many potential employers expect that newly hired students will arrive on-the-job with the ability to analyze data, utilize spreadsheets, and communicate findings and recommendations. We designed the Ocean State Circuits, Inc. Forecasting Project to address these gaps in our students' knowledge of analytical tools (such as the "vlookup()"…

Today's library should be part of the online social networks so it can connect with patrons and inform them of new services and opportunities. But this need to utilize new technology must be balanced against shrinking budgets and increased costs. One way libraries can juggle these demands is to spend more time on creating content, using a mix of…

The reciprocal method of service department cost allocation requires linear equations to be solved simultaneously. These computations are often so complex as to cause the abandonment of the reciprocal method in favor of the less sophisticated direct or step-down methods. Here is a short example demonstrating how Excel's sometimes unknown matrix…