This guide was developed as a "how to" training device for printing AppleWorks version 2.0 spreadsheet files using the Apple IIGS computer with two disk drives. Step-by-step instructions are provided for loading spreadsheet files; selecting the print option; printing entire files; and for printing specific rows, columns, or blocks of the…

This guide was developed as a "how to" training device for constructing spreadsheet files using AppleWorks version 2.0 and the Apple IIGS computer with two disk drives. Step-by-step instructions are provided for program loading, selecting the spreadsheet option, setting column widths, naming columns and fields, entering category…

This guide was developed as a "how to" training device for printing spreadsheet files using AppleWorks on the Apple IIe computer with a Duodisk or two disk drives. Step-by-step instructions are provided for selecting the print option; printing entire files; and for printing specific rows, columns, or blocks of the file. For each step, a…

This guide was developed as a "how to" training device for constructing spreadsheet files using AppleWorks on the Apple IIe computer with a Duodisk or two disk drives. Step-by-step instructions are provided for program loading, selecting the spreadsheet option, setting column widths, naming columns and fields, justifying labels and…

The extensive computational and formatting capabilities of today's spreadsheets enable users to create sophisticated analytical models with professionally formatted outputs. But good-looking reports can mask a host of input errors, formula mistakes, and computational problems. This article examines the subject of spreadsheet error detection in…

Describes how to build a Gantt chart using a spreadsheet program to manage a school building project. (PKP)

An Excel file that performs self-consistent field (SCF) calculations for the two-electron atoms is described. It is readily constructed and is relatively simple to use, providing a visual demonstration of how the self-consistent field (SCF) procedure is applied and what issues are involved.

Purpose: We examined the feasibility of creating a generic training curriculum for volunteers in health promotion programs for older adults by identifying common core content topics across 10 national programs. We also considered additional material that could augment common core content topics. Design and Methods: We reviewed in detail program…

This is a must-have resource for all K-12 teachers and administrators who want to really make the best use of available technologies. Written by Doug Johnson, an expert in educational technology, "The Classroom Teacher's Technology Survival Guide" is replete with practical tips teachers can easily use to engage their students and make their…

Purpose: The purpose of this paper is to report on the rationale behind the use of a unique paper-based individualised accounting assignment, which automated the provision to students of immediate formative and timely summative feedback. Design/methodology/approach: As students worked towards completing their assignment, the package provided…

We discuss the introduction and teaching of partial differential equations (heat and wave equations) via modeling physical phenomena, using a new approach that encompasses constructing difference equations and implementing these in a spreadsheet, numerically solving the partial differential equations using the numerical differential equation…

In this note, we demonstrate with illustrations two different ways that MS Excel can be used to solve Linear Systems of Equation, Linear Programming Problems, and Matrix Inversion Problems. The advantage of using MS Excel is its availability and transparency (the user is responsible for most of the details of how a problem is solved). Further, we…

In this paper I will illustrate how to extend the capabilities of Microsoft Excel spreadsheets with add-ins created by MATLAB. Excel provides a broad array of fundamental tools but often comes up short when more sophisticated scenarios are involved. To overcome this short-coming of Excel while retaining its ease of use, I will describe how…

Describes and gives examples of using spreadsheets for statistical resampling. Compares advantages and disadvantages of classical parametric versus spreadsheet methods of problem solving. (SK)

A description of the Microsoft Excel spreadsheet simulation, Anharmonicity.xls that can be used to smoothly and continuously switch a plotted function and its quadratic approximation is presented. It can be used in a classroom demonstration or incorporated into a student-centered computer-laboratory exercise to examine the qualitative behavior of…