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…

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…

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…

We develop a spreadsheet-based game to illustrate fundamental statistical concepts in the first class of an undergraduate Statistics course to motivate students about the topics that they will learn in upcoming classes. This game has been implemented by Google Forms and Google Sheets and can be played in both online and in-person classes of small…

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

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…

Supply chain management students are introduced to a variety of modeling concepts. Yet learning facility location and capacity allocation modeling to the level of application and mastery proves difficult for the typical undergraduate business student. Spreadsheets facilitate the teaching of optimization modeling; however, providing feedback to…

Chemistry is increasingly data centric and the undergraduate curriculum needs to adjust to keep up. To address this, we created the "Air Quality Activity," a new first-year undergraduate activity where students use Microsoft Excel to analyze a unique subset of atmospheric ozone (O[subscript 3]) and nitrogen dioxide (NO[subscript 2])…

Over the past few years, academics have undertaken initiatives to bridge the gap between theory and practice in the ever-growing field of business analytics, including implementing real-life student projects in all shapes and forms. Every year since 2015, Manhattan College has invited student teams from across North America and elsewhere in the…

Data literacy has become a much sought after skill by organizations as the importance of data driven decision making continues to rise in importance. This study explores the teaching of Tableau as a supplement to Excel to enhance the data literacy skills of students. Twenty-eight students taking an introductory course in Business Analytics and…

As educational systems move from onsite to online due to the COVID-19 pandemic, teachers face the difficulty of designing online examination formats which minimize opportunities for dishonesty. In this paper, we expose our design of such a format: a protected Microsoft Excel spreadsheet containing short-answer questions, which was implemented in a…

The benefits of using Microsoft Excel built-in functions in an undergraduate Multistage Separations course are analyzed based on 15 years of experience teaching mass transfer in Chemical Engineering programs at both the Bachelor's and Master's levels. Eight reasons for using spreadsheets in a Mass Transfer virtual course are given. Through the…

In this paper the authors present a unique approach to teaching introductory statistics at both the undergraduate and graduate levels. The approach uses a feature in Excel called "spinners" to dynamically adjust key variables, such as sample size, confidence levels, and probabilities, among others, to enable an expanded discussion of…

In this teaching case, we describe an experiential learning project that allows students to perform sentiment analysis on a set of tweets (posts made on the social media platform, Twitter) by collecting and analyzing posts that include key words selected by the students. Sentiment analysis refers to the process of identifying and categorizing…

Addressing societal issues in civil and environmental engineering increasingly requires skills in data science and programming. To date, there is not much known about the extent students are learning these skills in current civil and environmental engineering curricula. We conducted a survey of accredited civil and environmental engineering…