NotesFAQContact Us
Collection
Advanced
Search Tips
ERIC Number: ED255174
Record Type: RIE
Publication Date: 1984-Oct
Pages: 25
Abstractor: N/A
Reference Count: 0
ISBN: N/A
ISSN: N/A
The Spreadsheet in an Educational Setting. Microcomputing Working Paper Series F 84-4.
Wozny, Lucy
This overview of a specific spreadsheet, Microsoft's Multiplan for the Apple Macintosh microcomputer, emphasizes specific features that are important to the academic community, including the mathematical functions of algebra, trigonometry, and statistical analysis. Additional features are summarized, including data formats for both numerical and textual data, and instructions on how to use a simple spreadsheet are provided. The following examples of spreadsheets are described and illustrated with figures: (1) Grade Tally, for computing grades; (2) Production Decisions, a decision analysis tool which compares the costs of four different methods of making the same quantity of a product to determine the least costly method; (3) Nutritional Analysis, a database of foods and their nutritional value; (4) Chemical Equilibrium Calculations, three spreadsheets that use Multiplan to perform calculations on the properties of solutions of weak acids and bases, including buffer solutions; (5) Least Squares Analysis, or linear regression, a statistical tool to judge how observed pairs of data best fit a straight line; and (6) Production Possibility Curve, which students create as a homework assignment. (LMM)
Working Paper Series, Microcomputing Program, Office of the Vice President for Academic Affairs, Drexel University, 32nd and Chestnut Streets, Philadelphia, PA 19104.
Publication Type: Guides - Non-Classroom; Reports - Descriptive
Education Level: N/A
Audience: Practitioners
Language: English
Sponsor: N/A
Authoring Institution: Drexel Univ., Philadelphia, PA. Microcomputing Program.
Identifiers: Apple Macintosh; Drexel University PA; Spreadsheets
Note: For related documents, see IR 011 540-544.