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…

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

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…

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…