A mechanism for using personal computer spreadsheet software to generate unique laboratory and problem assignments in optics for each student and provide corresponding solutions that can be checked quickly is described. The method minimizes some students' tendency to inspect others' solutions without solving problems themselves. Another…

Spreadsheets can help teachers manage a variety of routine tasks with ease. From creating class lists to taking surveys and graphing results, spreadsheet programs have limitless classroom potential. This article offers six ways to put spreadsheets to work, including class lists, all-about-me surveys, name tags, calendars, skill-building games, and…

To answer students' questions about predicting grade averages or projecting grades needed to attain specific grade goals, academic advisors can use computerized grade calculations. Spreadsheet and HyperCard versions of grade calculation software are discussed and illustrated, and suggestions are offered for using them in specific advising…

This guidebook and teacher's guide accompany a personal computer software program and introduce the key elements of financial projection modeling to project the financial statements of an industrial enterprise. The student will then build a model on an electronic spreadsheet. The guidebook teaches the purpose of a financial model and the steps…

Microsoft Excel is a sophisticated and flexible reporting, planning, and presentation tool that teachers can use effectively for curriculum prep, class projects, budget planning and reporting, and even as a database. This book, a how-to guide for teachers at all grade levels, provides information on the fundamentals of creating powerful…

Described are the use of spreadsheet programs in chemical engineering calculations using Lotus 1-2-3 macros. Discusses the macro commands, subroutine operations, and solution of partial differential equation. Provides examples of the subroutine programs and spreadsheet solution. (YP)

This document is designed for high school teachers to use in teaching a course that introduces students to computing through hands-on experience with databases, spreadsheets, desktop publishing, and word processing. The document begins with a rationale, brief course description, list of course objectives, and list of 10 innovative teaching…

This document contains 12 modules: 4 on business analysis and 8 on business computer applications. The business analysis modules are as follows: (1) the framework of business; (2) universal activities of business; (3) selected business subsystems; and (4) your place in business. Computer applications modules are on the following topics: (1)…

Presents several examples of the iteration method using computer spreadsheets. Examples included are simple iterative sequences and the solution of equations using the Newton-Raphson formula, linear interpolation, and interval bisection. (YP)

"Spreadsheets in Physical Chemistry" contains reviewed and classroom tested Lotus 1-2-3 and SuperCalc IV templates and handouts designed for use in physical chemistry courses. The 21 templates keyed to Atkins' physical chemistry textbook, the 7 numerical methods templates, and the 10 simulation templates are discussed. (MVL)

This instructor guide for a unit on financial analysis in the PACE (Program for Acquiring Competence in Entrepreneurship) curriculum includes the full text of the student module and lesson plans, instructional suggestions, and other teacher resources. The competencies that are incorporated into this module are at Level 2 of learning--planning for…

This document contains a curriculum model that is designed to provide high school computer teachers with practical ideas for a 1-year computer applications course combining 3 quarters of instruction in keyboarding and 1 quarter of basic instruction in databases and spreadsheets. The document begins with a rationale and a 10-item list of…

This document, which is designed to provide classroom teachers at all levels with practical ideas for a computer applications course, examines curricular considerations, teaching strategies, delivery techniques, and assessment methods applicable to a course focusing on applications of computers in business. The guide is divided into three…

Designed to promote Manitoba students' familiarity with computer technology and their ability to interact with that technology, the Computer Applications and Technology 105 course is a one-credit course presented in 15 topical, non-sequential units that require 110-120 hours of instruction time. It has been developed with the assumption that each…

This teacher's guide provides office education instructors with detailed units of instruction correlated directly to the essential elements of a course in microcomputer applications as mandated by the Texas Education Agency. Sixteen instructional units are organized into six sections on the following topics: introduction to microcomputers, word…