Relative quantification is a popular analysis in gene expression studies using quantitative real-time PCR (qPCR). However, the calculation steps using the major algorithms for this analysis are rather complicated. In this study, we developed an easy-to-use spreadsheet-based method for relative quantification. The inputs from end-users are the…

Microsoft Excel and Access are widely used in introductory courses designed to teach the fundamentals of spreadsheet and relational database modeling skills in various disciplines. To achieve the targeted learning outcomes, instructors of these courses strive to provide students with guided, frequent, and incrementally fruitful practice with the…

The COVID-19 pandemic has made mathematical epidemiology a topic of critical importance, providing mathematics educators with an unparalleled opportunity. This opportunity is accompanied by a challenge: how do mathematics educators, some of whom have little personal experience with mathematical modeling, teach mathematical epidemiology to their…

The author focused on solving problems of third-degree price discrimination under a monopoly by integrating microeconomic theory and spreadsheet modeling. Price discrimination refers to a firm situation in which the same good is sold to different groups of consumers at different prices. First, the author included an introductory math background…

Students today are often assumed to be digitally literate and prepared for college, but that is not always the case. Introductory technology courses at the college level provide students with the technology and digital skills necessary for them to succeed in college. This study, conducted at a small New England "business school" that…

A laboratory experiment characterized by a whole-class data-pooling approach to generate a data set that can be used to test a model of the influence of ionic strength on electrolyte solubility is described and discussed. The design of the experiment makes efficient use of the laboratory period and releases time for instructional and dialogic…

Powder diffraction is one of the most widely used analytical techniques for characterizing solid state materials. It can be used for phase or polymorph identification, quantitative analysis, cell parameter determination, or even full crystal structure analysis using the powerful Rietveld refinement method. As with much of modern crystallography,…

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

We present a simple activity based on the liquid-drop model which allows secondary school students to explore the uses of mathematical models and gain an intuitive understanding of the concept of binding energy, and in particular the significance of positive binding energy. Using spreadsheets provided as supplementary material, students can…

The invention of the computer has led to the establishment of a new research paradigm, computation, which has recently become more and more popular in scientific exploration. However, computation is not well represented in high school and university curricula in science and engineering, although it applies to a wide range of disciplines beyond…

This chapter advocates a teaching approach for the statement of cash flows (SCF) that includes introduction of the SCF early in the curriculum using the accounting equation format, which helps students visualize the cash and accrual activities. We then adapt this accounting equation format to a worksheet model that can be used later in the…

The scale-invariant way to analyze two-dimensional experimental and theoretical data with statistical errors in both the independent and dependent variables is revisited by using what we call the triangular linear regression method. This is compared to the standard least-squares fit approach by applying it to typical simple sets of example data…

In Costa Rica, before 2016 the subject of statistics was not included in the national high school tests in Mathematics. As of 2016, the test, consisting of 60 items, includes 9 statistical items. On the other hand, teachers in their lessons usually use traditional expository methods, mediated by the use of a blackboard and printed materials. In…

This work aims to demonstrate the use of Excel spreadsheets for solving L-L extraction problems. The key to solving the problems successfully is to be able to determine a tie line on the ternary diagram where the calculation must be carried out. This enables the reader to analyze the extraction process starting with a simple operation, the…

Plenty of material exists to help with the writing process, but sometimes the writer needs tools to help organize the process. This paper reviews some of the tools needed to organize articles and other references. A discussion of keywords, note taking, and document organization provides examples on the choice use of technology tools to support the…