287 hasil
Menampilkan 1–20 · 0,49 detik · RSS
Spreadsheets in Education (2026)
ISSN 1448-6156 · McMaster University · 287 artikel di indeks
-
Artikel Jurnal
A Further Spreadsheet-Based Illustration of the Convergence of the Cox-Ross-Rubinstein Binomial Option Pricing Model to the Black-Scholes-Merton Version
The Cox-Ross-Rubinstein binomial pricing model, which retains the economic insights of the Black-Scholes-Merton version without requiring the use of advanced mathematical tools, is suitable for coverage in finance courses when the topic of options is covered. If the number of time steps in the…
-
Artikel Jurnal
An Interactive Spreadsheet for Teaching the Search and Matching Model
This paper presents an interactive spreadsheet model designed to teach undergraduate students the core mechanisms of the search and matching model in labor economics. The model simplifies the traditional Diamond-Mortensen-Pissarides (DMP) approach into two equilibrium conditions--the unemployment…
-
Artikel Jurnal
Thermodynamic analysis of a combined ORC-TFC cycle for power generation from low-temperature energy sources by using Excel
This paper presents a thermodynamic evaluation of a combined power generation cycle for utilizing the energy of low-temperature heat sources such as solar energy and industrial waste energy. The cycle connects the simple Organic Ranking Cycle (ORC) with the Trilateral Flash Cycle (TFC) via a…
-
Artikel Jurnal
Nonlinear Regression: Estimation of Parameters' Confidence Intervals
In nonlinear regression the experimental data are represented by a nonlinear function that is a combination of one or more independent variables and the model equation. Nonlinear least square fitting in Microsoft Excel can be achieved by minimizing the sum of squared residuals of experimental data…
-
Artikel Jurnal
A Spreadsheet Algorithm to Solve Equation of Motion for Tracing Charged Particle Trajectories in an Electromagnetic Field Using 4th Order Runge-Kutta Method
This paper presents the use of Excel spreadsheets to obtain solutions for simulating the complex trajectories of a charged particle in the presence of electric and magnetic fields. A spreadsheet-based algorithm is developed to solve a system of coupled second-order ordinary differential equations…
-
Artikel Jurnal
A Spreadsheet-Based Illustration of the Sum of Reciprocals of Centered Polygonal Numbers
Polygonal numbers and centered polynomial numbers differ in how successive layers of regular polygons are generated. This pedagogic note considers the sum of reciprocals of the latter numbers. In contrast to the sum of reciprocals of the former numbers, for which publication venues are typically…
-
Artikel Jurnal
Utilizing Excel's Capacity to Handle Complex Numbers
My experience is that many scientists and science teachers are not aware of the fact that Excel and other spreadsheet programs can handle complex numbers. It is natural that students who are otherwise well trained in Excel should also take advantage of Excel's capability to handle complex numbers…
-
Artikel Jurnal
Interactive Machine Learning Education for Non-Programmers: A Spreadsheet-Based Approach with Complete Training Implementation
Machine learning (ML) education for non-programming students faces significant barriers when traditional approaches rely heavily on coding skills. This paper presents a novel spreadsheet-based curriculum that implements complete ML training algorithms without programming requirements. We introduce…
-
Artikel Jurnal
A Further Spreadsheet-based Illustration of the Convergence of the Black-Scholes-Merton and Cox-Ross-Rubinstein Option Pricing Models
The Cox-Ross-Rubinstein binomial option pricing model, which retains the economic insights of the Black-Scholes-Merton version without requiring advanced mathematical tools, is suitable for coverage in finance courses where the topic of options is covered. If the number of time steps in the…
-
Artikel Jurnal
Promoting the Aha Experience Using Spreadsheets
The purpose of this paper is to give an example of guided problem solving and using a spreadsheet to help solve a related series of mathematical problems. The context is that of side totals, where the numbers 1 - 2n are arranged three on each side of an n-sided polygon. The context allows for the…
-
Artikel Jurnal
Interactive Graphical Analysis of Classical Oscillator and Radioactive Phenomena Using Spreadsheets
The insight into physical phenomena can be understood better using graphs, which show their unique behavior. Two of these are oscillations (damped and driven) and radioactivity (decay and equilibrium). Manually plotting their graphs could be cumbersome work, and users or learners do not have the…
-
Artikel Jurnal
The Sum of Reciprocals of Polygonal Numbers: A Spreadsheet Based Illustration
This pedagogic note considers the sum of reciprocals of polygonal numbers. Closed form expressions of the sum are currently available for twelve specific cases, from triangles to 26-sided polygons. Several of these expressions are from featured solutions to posted questions in college mathematics…
-
Artikel Jurnal
Indexing the X-Ray Diffraction Patterns of Cubic and Hexagonal Structures Using Spreadsheets
X-ray diffractometry is one of the most useful nondestructive techniques used to characterize crystalline substances. One can gain knowledge of structures and structure parameters, phases and texture, average grain size, crystalline stain and defects, from an XRD pattern. In this study, we develop…
-
Artikel Jurnal
Spreadsheet Simulation for Order Statistics Probabilities
Spreadsheet simulation models provide a powerful method for estimating many different types of probabilities. Here we focus on estimating probabilities involving order statistics. We look at what happens to the distributions for a complete range of order statistics and consider applications using…
-
Artikel Jurnal
Using Spreadsheets for Analysing the Influence of Bleed Pressure on Rankine Cycle Performancee
The objective of this article is to showcase the capabilities of the Microsoft Excel package in simulating the performance of the Rankine Cycle with a single bleed point. Thermodynamic properties are derived using specialized Excel tools designed for thermodynamics, with Microsoft Excel serving as…
-
Artikel Jurnal
The 1/N Investment Strategy from a Pedagogic Perspective: A Spreadsheet-Based Illustration
The surprising empirical finding in the finance literature that the 1/N investment strategy outperforms portfolio optimization, followed by some intense debate on the topic, has given credence to this simple approach in the investment world . This paper, which draws on an Excel-based assignment in…
-
Artikel Jurnal
Exploring the capability of MS EXCEL for constructing bias-corrected and accelerated (BCA) bootstrap confidence intervals to aid in decision-making during an emergency
Decision-making during an emergency requires obtaining reliable information in a short span of time from available data or by collecting new data. However. decison-making during an emergency can be impeded by a lack of data, specialized software, or a lack of staff with expertise in statistical…
Juga tersedia di: DOAJ
-
Artikel Jurnal
Introducing Visual Basic for Application in a Spreadsheet Modeling Course
Spreadsheet modeling courses often introduce students enrolled in undergraduate and master's degree programs in decision sciences and data analytics to key concepts in optimization and simulation. Use of Visual Basic for applications (VBA) can significantly extend Excel's capabilities. For…
-
Artikel Jurnal
An Event Model for the Application of Problem-based Learning/e-learning in Thermodynamics
Thermodynamics is an essential topic in Engineering education. Difficulties in teaching and learning thermodynamics are well known, and many efforts have been developed to improve the teaching of thermodynamic subjects. The solution of problems is the main task in Engineering education, and much…