The article uses dynamic visualizations in Excel to examine a variety of ways in which students can attain a much greater depth of understanding of optimization problems in introductory calculus. The topics discussed include a variety of common optimization problems that appear in virtually every calculus textbook that can all be enhanced…

This article describes a web-based application that can be used to help teach linear programming (LP) using an active learning approach in business courses such as management science and decision analysis. The software asks 42 integrated questions that guide students in creating product mix models and performing related analysis in Excel with…

Spreadsheets are a core computational tool for practicing engineers and engineering students. While Microsoft Excel, Google Sheets, and other spreadsheet tools have some differences, numerous formulas, functions, and other tasks are common across versions and platforms. Building upon learning science frameworks showing that interactive activities…

Teaching quantitative methods at the undergraduate level is a difficult yet rewarding endeavor due to the challenges instructors face in presenting the material. One way to bolster student learning is through the use of statistical software packages. Google Sheets is a cloud-based spreadsheet program capable of many basic statistical procedures,…

This article illustrates ways that dynamic software using some sophisticated techniques in Excel can be used to demonstrate fundamental ideas related to hypothesis testing to increase student understanding of the concepts and methods in elementary statistics courses. The article considers hypothesis tests for the population mean with large or…

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…

Coding, the analytic task of assigning codes to nonnumeric data, is foundational to writing research. A rich discussion of methodological pluralism has established the foundational importance of systematicity in the task of coding, but less attention has been paid to the equally important commitment to language complexity. Addressing the interplay…

In the context of rapid technological changes and modernization of society, the issue of ensuring adequacy of content in secondary education based on the use of advanced information technologies (ICT) is being updated. The necessity of an appropriate level of primary intellectual activity development in a person in terms of the current trends in…

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…

From its earliest days, practitioners of computer-assisted language learning (CALL) have collected data from computer-mediated learning environments. Indeed, that has been a central aspect of the field from the beginning. Usage logs provided valuable insights into how systems were used and how effective they were for language learning. That…

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…

The present paper aims to review two motivations to conduct "what if" analyses using Excel and "R" to understand the statistical significance tests through the sample size context. "What if" analyses can be used to teach students what statistical significance tests really do and in applied research either prospectively to estimate what sample size…

This paper examined the impact of training strategies on the types of errors that novice users make when learning a commonly used spreadsheet application. Fifty participants were assigned to a counterfactual thinking training (CFT) strategy, an error management training strategy, or a combination of both strategies, and completed an easy task…

Equilibrator is a Microsoft Excel program for learning about chemical equilibria through modeling, similar in function to EQS4WIN, which is no longer supported and does not work well with newer Windows operating systems. Similar to EQS4WIN, Equilibrator allows the user to define a system with temperature, initial moles, and then either total…

Two methods of data analysis are compared: spreadsheet software and a statistics software suite. Their use is compared analysing data collected in three selected experiments taken from an introductory physics laboratory, which include a linear dependence, a nonlinear dependence and a histogram. The merits of each method are compared. (Contains 7…