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…

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…

Describes the development and integration of UDEMOG, a computer-assisted instruction system for teaching demographic related topics that was designed at the University of Delaware. Software programs and spreadsheet data files are described, hardware based on IBM equipment is discussed, and use in the classroom and in computer laboratories is…

Describes the use of microcomputer-based software in an introductory statistics course at Vanderbilt University. The use of Wingz spreadsheet and Data Desk statistics software is described, objectives for the course are explained, possible objections to computer-assisted instruction for statistics are addressed, and student reactions are reported.…

Discusses the use of microcomputer applications software in education, reviews the literature involving studies on the development of problem-solving skills and on the instructional use of spreadsheets, and describes a project for secondary school students using spreadsheets that provides cognitive support. (Contains 35 references.) (LRW)

Describes a spreadsheet system that enables students, teachers, and curriculum developers to use Microsoft EXCEL's database and graphics capabilities in the science classroom. System design goals are explained, examples of system applications are given, and possible future developments are discussed. (15 references) (LRW)

Believes that the World Wide Web has great potential for delivering interactive computer-aided instruction using programming language like Java and Javascript. Describes a website on object-oriented microeconomics that integrates a textbook, mini-lecture series, graphical calculator, animated drawing program, spreadsheet, and regression package.…