As the use of data in courses that incorporate statistical methods has become more prevalent, so has the need for tools for working with such data, including those for data creation and adjustment. While numerous tools exist that support faculty who teach statistical methods, many are focused on data analysis or theoretical concepts, and there…

This article describes a web-based application that can be used to help teach linear programming (LP) using an active learning approach in business courses such as management science and decision analysis. The software asks 42 integrated questions that guide students in creating product mix models and performing related analysis in Excel with…

In this technology intensive society, most students are required to be proficient in computer skills to compete in today's global job market. These computer skills usually consist of basic to advanced knowledge in word processing, presentation, and spreadsheet applications. In many U.S. states, students are required to demonstrate computer…

This paper describes a personal computer spreadsheet set up to carry out hierarchical log-linear analyses, a type of analysis useful for institutional research into multidimensional frequency tables formed from categorical variables such as faculty rank, student class level, gender, or retention status. The spreadsheet provides a concrete vehicle…

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…

Item response theory models arose from the inherent limitations of classical test theory methods of test analysis. A brief description of those limitations and the corresponding enhancements provided by item response models is provided. Further, an examination of the popular Rasch one-parameter latent trait model is undertaken. Specific…

Describes the creation of a company purchase order complete with the names of items to be purchased, cost, quantity, discounts, sales tax, and balance due. It requires students to apply their knowledge and understanding of percentages and also gives students an opportunity to understand the mathematics they use with algebraic formulas. (AIM)

This paper shows that multiple sources of data reflecting educational progress may be used with relative ease to systematically, objectively, and accurately place students in selective educational programs, such as those funded under Chapter 1 of the Education Consolidation and Improvement Act, using readily available commercial microcomputer…

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…

Summarizes the action plan and final recommendations of the Association of School Business Officials International's (ASBO) Technology Task Force. Also highlights the findings of surveys completed by all ASBO Committee leaders, a sample of general members, and the officers of ASBO's affiliates. A list of task force members is included. (LMI)

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 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)…

This report discusses the methods, techniques, and software applications used in processing the data gathered in a survey of the physical condition and health of students in Guangdong Province, China. The introduction provides background on the survey. Survey grouping, data items, and survey procedures are then described. A discussion 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…