In the modern, information driven society managing and handling data is unavoidable. The most common form of data handling is to organize data into tables and complete operations on them in spreadsheets. Sprego (Spreadsheet Lego) is a programming-oriented methodology focusing on schemata construction and authentic problem-solving working with only…

Quantitative decision making (management science, business statistics) textbooks rarely address data cleansing issues, rather, these textbooks come with neat, clean, well-formatted data sets for the student to perform analysis on. However, with a majority of the data analyst's time spent on gathering, cleaning, and pre-conditioning data, students…

A simple organic chemistry experiment is described that investigates the kinetics of the reaction between 1-bromobutane (BuBr) and iodide (I[superscript -]) as followed by observing the disappearance of BuBr and the appearance of 1-iodobutane (BuI) using [superscript 1]H NMR spectroscopy. In small groups of three to four, students acquire data to…

Researchers are often distressed to discover that the data they wanted to use in their landmark study is not configured in a way that is usable by a Statistical Analysis Software Package (SASP). For example, the data needed may come from two or more sources and it may not be clear to the researcher how to get them combined into one analyzable…

Describes the applications of "Quicken," a software package developed by Intuit, for use by school-business officials. The program can be used for activity-fund and student-activity accounting and for printing checks. Five figures that illustrate screen activities are included. (LMI)

Many teachers have found that, no matter how enjoyable ecological studies are, students tend to dislike the computation of the large amounts of data gathered. Included is a description of an experiment that utilized time-saving features as well as the instructional and motivational benefits of using a computer spreadsheet program to analyze and…

Describes some of the available software and hardware tools that can be used to develop a decision support system implemented on microcomputers. Activities that should be supported by software are discussed, including data entry, data coding, finding and combining data, and data compatibility. Hardware considerations include speed, storage…

Content analysis of 13 textbooks and 2 Department of Education documents was conducted to ascertain common word processing, database, and spreadsheet software skills in order to determine which specific skills should be taught in a high school computer literacy course. Aspects of a basic computer course, created from this analysis, are described.…

Illustrates how teachers or students can use spreadsheets. Shows the layouts, formulas, and data of two cases: budget manager and data manager. Seven references are listed. (YP)

Describes an effort to quantify annual collection expansion and shelf space capacities with a computer spreadsheet program. Methods used to quantify the space taken at the beginning of the project; to estimate annual rate of collection growth; and to plot stack space and usage, volume equivalents and usage, and growth capacity are covered.…