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…

Science is full of amazing facts, but at times it may be difficult to fully appreciate their significance without an understanding of the scientific practices that gave them meaning. The teaching of evolution may be an example of this situation; there are many interesting facts to consider, but it is equally important for students to learn where…

Data literacy is a growing area of focus across multiple disciplines in higher education. The dominant forms of introduction focus on computational toolchains and statistical ways of knowing. As data driven decision-making becomes more central to democratic processes, a larger group of learners must be engaged in order to ensure they have a seat…

Here, students determine aspirin (acetylsalicylic acid) mass in pharmaceutical tablets using a colorimetric method. Aspirin, salicylate, and salicylic acid do not absorb visible light. Thus, in alkaline medium, acetylsalicylic acid was hydrolyzed to salicylate; then, it was reacted with an acidic Fe(III) solution, and a violet complex was formed.…

A semester-long, project-based series of laboratory exercises is described that provides practical experience of the upstream and downstream processes involved in monoclonal antibody production. This 6 week project is aimed at final year undergraduate students undertaking primary degrees in biotechnology, biochemistry, or related disciplines.…

The effects of substitution on reaction rates are at the heart of both physical chemistry and organic chemistry. In this paper, we present a computational laboratory module to explore the effects of group substitution and isotopic substitution on reaction rates by using a readily accessible graphical interface, a computational engine, and…

In the field of physics teaching, the simple pendulum provides a very simple way to study the harmonic oscillator, the source of some fundamental concepts such as periodicity, relaxation time and anharmonicity. As such, its experimental study is frequently integrated into high school or first year university programs. With this in mind, in this…

Excel spreadsheets are used as an excellent tool in physics laboratory experiments related to wave optics. This paper presents a simple way to simulate diffraction of waves through a slit using Excel spreadsheets without any tedious programming. These simulations are used to visualize the effect of variation of different parameters such as number…

This article describes the use of a spreadsheet to reinforce basic calculus that is expected of all university-level chemistry majors. The example provided shows a calculation using Excel to estimate, using a Riemann summation, the radiant exitance of a hot object using Planck's Law of Blackbody Radiation. The approach reinforces the elementary…

Dashboards allow managers to interact with data, asking "what if" questions and looking for patterns. This topic is typically mentioned in information systems courses; however, many students will not have experience with developing dashboards or using them to answer business questions. The purpose of this assignment is to provide…

This study describes a teaching process that offers teachers and pupils ways of constructing the division operation through illustration based on defining the reference unit (divisor), the reference whole1 and the dividend. We introduce a computerized dynamic environment, using an Excel spreadsheet, in which both teachers and pupils can…

The Monte Carlo method and related multiple imputation methods are traditionally used in math, physics and science to estimate and analyze data and are now becoming standard tools in analyzing business and financial problems. However, few sources explain the application of the Monte Carlo method for individuals and business professionals who are…