We present an interactive spreadsheet that supports teaching essential concepts in classification using the logistic regression (LoR) model for binary classification. The interactive spreadsheet demonstrates the capabilities of LoR by integrating computation with visualization. Students will reinforce concepts like probabilities, maximum…

This paper develops a spreadsheet simulation methodology for teaching simulation and performance analysis of priority queues with multiple servers, without resorting to macros, add-ins, or array formula. The approach is made possible by a "single overtaking" simplifying assumption under which any lower-priority customer may be passed in…

This paper presents a dynamic Excel visual. The visual has three graphs that are all driven by the same data, so students can see how changes (via Slider controls) in data appear on a univariate graph, a bivariate graph, and a graph that shows a ratio of two variables on one axis. The visual has macros that let a statistics teacher reveal parts of…

During the pandemic and lockdown situations of the last few years, we transitioned to online, physical, and hybrid education approaches at various times. We had difficulty teaching multiple calculus and analytical geometry units online. In light of the current situation, a graphical user interface (GUI) teaching tool has been developed to teach…

Computational thinking (CT) is gaining attention in education as a part of digital literacy and can be addressed in several disciplines, including mathematics. Through the lens of Brennan and Resnick's framework, we investigated how computational concepts, practices, and perspectives can be addressed in upper-secondary statistics lessons using…

Purpose: The lecture method has been compared with teaching methods such as flip learning, cooperative learning and simulations to establish which holds the key to students' understanding of concepts. What is bereft in the education literature is its comparative efficiency with the culturo-techno contextual approach (CTCA) in the teaching of…

Solution equilibria diagrams are excellent tools for understanding chemical speciation in multireaction chemical systems. They are usually plotted using software packages that efficiently perform advanced calculations, giving the possibility to graphically visualize thermodynamic and composition information. However, this approach frequently…

Examples of applications of equilibrium-based methods for multicomponent separations usually require the use of simulation packages, which do not allow students to follow the involved algorithms step by step. Excel spreadsheets with examples of six such rigorous methods have been used with MSc students of Chemical Engineering of the University of…

Background/purpose: This study addresses the lack of statistical thinking skills among Applied College students, a key requirement for professional success. Traditional statistics education focuses on procedural and computational methods rather than conceptual understanding, leading to misconceptions and difficulties in data organization,…

Countercurrent multiplication (CCM) is widely accepted as the mechanism for the generation of the corticopapillary osmotic gradient in the outer medulla of mammalian kidneys. However, several issues in the literature cause the current explanations of CCM to be inefficient and incomplete. As a result, it is challenging to clearly explain CCM in…

This study investigated pedagogical agent (with/without) and feedback (explanatory/confirmatory) types on achievement, flow experience, and cognitive load in a digital game-based learning environment. We developed a game about spreadsheets and prepared four versions of the game in the context of pedagogical agent and feedback types. Through the…

In many science and engineering undergraduate programmes, physics courses are fundamental and can be seen as a potential place where students can develop complementary abilities such as the computational thinking process. The present work proposes and describes the learning science and engineering with electronic spreadsheets cycle (LSEESC)…

NoSQL databases have been used in organizations for decades. Few database textbooks on the market, however, have suitable materials about NoSQL beyond general introductions for typical business students. In fact, users of the typical NoSQL systems on the software market need to have certain computer programming skills. This teaching tip introduces…

Data Analytics has grown dramatically in importance and in the level of business deployments in recent years. It is used across most functional areas and applications, some of the latter including market campaigns, detecting fraud, determining credit, identifying assembly line defects, health services and many others. Indeed, the realm of…

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…