Early education has classically introduced reading, writing, and mathematics. Recent literature discusses the importance of adding "computational thinking" as a core ability that every child must learn. The goal is to develop students by making them equally comfortable with computational thinking as they are with other core areas of…

This work aims to demonstrate the use of Excel spreadsheets for solving L-L extraction problems. The key to solving the problems successfully is to be able to determine a tie line on the ternary diagram where the calculation must be carried out. This enables the reader to analyze the extraction process starting with a simple operation, the…

Financial analysts generally create static formulas for the computation of NPV. When they do so, however, it is not readily apparent how sensitive the value of NPV is to changes in multiple interdependent and interrelated variables. It is the aim of this paper to analyze this variability by employing a dynamic, visually graphic presentation using…

Instructors often use spreadsheet software (e.g., Microsoft Excel) in their statistics courses so that students can gain experience conducting computerized analyses. Unfortunately, students tend to make several predictable errors when programming spreadsheets. Without immediate feedback, programming errors are likely to go undetected, and as a…

A visual regression analysis using the least absolutes method (LAB) was developed, utilizing an interactive approach of visually minimizing the sum of the absolute deviations (SAB) using a bar graph in Excel; the results agree very well with those obtained from nonvisual LAB using a numerical Solver in Excel. These LAB results were compared with…

This paper presents a simplified approach for the application of material efficiency metrics to linear and convergent synthesis plans encountered in organic synthesis courses. Computations are facilitated and automated using intuitively designed Microsoft Excel spreadsheets without invoking abstract mathematical formulas. The merits of this…

This paper uses Excel to enhance the pedagogy of capital structure theory for corporate finance instructors and students. We provide a lesson plan that utilizes Excel spreadsheets and graphs to develop understanding of the theory. The theory is introduced in three scenarios that utilize Modigliani & Miller's Propositions and…

It is common for both algebra and calculus instructors to use power functions of various degrees as well as exponential functions to examine and compare rates of growth. This can be done on a chalkboard, with a graphing calculator, or with a spreadsheet. Instructors often are careful to connect the symbolic and graphical (and occasionally the…

Business students taking data mining classes are often introduced to artificial neural networks (ANN) through point and click navigation exercises in application software. Even if correct outcomes are obtained, students frequently do not obtain a thorough understanding of ANN processes. This spreadsheet model was created to illuminate the roles of…

This paper presents learners' task results gathered by means of an example task-oriented environment for knowledge testing and processed by EXCEL. The processing is domain- and task-independent and includes automatic calculation of several important task and session's parameters, drawing specific graphics, generating tables, and analyzing the…

Discussion of decision analysis and its importance in a business curriculum focuses on the use of spreadsheets instead of commercial software packages for computer assisted instruction. A hypothetical example is given of a company drilling for oil, and suggestions are provided for classroom exercises using spreadsheets. (seven references) (LRW)

Investigates the use of personal computer (PC) programs to help participants in simulation exercises transform their experiences into knowledge, skills, and attitudes. Six programs developed at Queensland Institute of Technology are described that involve operations management, strategic management, and macroeconomics. Examples of spreadsheets are…

The paper starts from classroom situations about the study of a functional relationship with help of technological tools as a "transposition" of experimental approaches from research mathematical practices. It considers the limitation of this transposition in existing curricula and practices based on the use of non-symbolic software like dynamic…

Creating a stock market simulation for the classroom computer reinforces math skills and can help students gain a good sense of how current events affect the economy, how to manage money and understand profit and loss, and how to use spreadsheet software. (IAH)

Reports on the results of a 1985 survey of two-year community colleges that was conducted to determine the use of personal computers in accounting courses. Types of hardware and software used are discussed, planned purchases are indicated, courses using microcomputers are described, and future use is explored. (four references) (LRW)