积分循环赛在学校篮球竞赛中的应用研究

为了在学校篮球竞赛中引入积分循环赛，文章针对棋类积分编排存在的三个方面问题，通过采用每轮比赛排名作为配对排序的条件，并对棋类积分编排方法进行了一定的简化移植，经过多次试验性编排，运用电子表格技术设计出了一整套篮球积分编排方法。这种方法可实际运用于篮球积分循环赛的手工编排，并能为实现计算机篮球积分编排提供理论依据。     

关于复数运算在高次方程中的运用

随着office2010版开发,复数函数的运算的完善为高次方程的完整解提供了技术上的有力保障。     

The use of computer spreadsheets for overbooking optimization and analysis

The policy of overbooking is a rational strategy for minimizing costs in a situation where reserved service is not always honored. Finding the proper level of overbooking is simplified through the use of computer spreadsheet software. Data requirements include the specification of short costs, long costs, and no-show probabilities. Construction of the spreadsheet involves a straightforward entering of expected cost relationships for each overbooking alternative. Once established, the spreadsheet can rapidly calculate and find the optimal overbooking strategy. The spreadsheet is also useful for making rapid recalculations under changing conditions.     

Examining critical and near-critical paths: an Excel-based classroom exercise

The author’s goals in this exercise were to use an Excel project to teach students about the effects of changing states of nature on critical path emergence as well as compare the impact of the PERT beta and triangular distributions on project completion times. Previous research into the PERT (program evaluation and review technique) beta distribution indicated a tendency for this distribution to overstate the impact of the dominant critical path on project completion times. The author used a Monte Carlo simulation and a new Excel function to explore the effects of random variation on critical path emergence. He used both the triangular distribution and the PERT beta distribution to calculate project completion times. The author found that three of the possible five paths became critical in both the PERT beta and triangular distributions. However, the triangular distribution moderated the PERT beta distribution’s tendency toward the dominate critical path.     

Introducing spreadsheets into an intermediate financial accounting course: the results of a quasi-experiment

Previous research has revealed a measurable decrease in student attitude towards the use of computers when they are integrated into teaching. This fall in attitude is thought to reflect the initial diffculties encountered when attempting to use computers and learn acounting techniques at the same time. However, it is postulated that once the students' computer ability has achieved an adequate level, then attitude will recover. This paper reports the results of a continuing investigation into the attitude of second-year undergraduate accounting students towords the use of computers in their studies. The method used was to ask students to complete a questionnaire about their attitudes and self-assessed ability and to undergo a written test of their computer/spreadsheet Knowledge. These data were merged with those from earlier testing to give a two-year data set. The results indicate that the attitude of students to using computers generally continued to fall significantly. However, their ability to use computers and spreadsheets rose. In the case of spreadsheets, this rise in ability was significant. It was found that students who took, as options, additional courses which integrated computers had more positive attiudes and achieved higher scores in the computer Knowledge test than those who did not. This implies that the initial fall in attitude experienced in previous studies was not an isolated temporary phenomenon. The imporvement in ability is observed, but this did not have the expected effect.     

EXCEL电子表格在护理管理中应用

目的:探讨EXCEL电子表格在护理管理中应用。方法:由护理部使用EXCEL电子表格设计统一的报表,由各病区将所需信息及时进行输入,通过电脑联网实现护理信息的层层上传及下达,便于信息、数据的及时交流及反馈,并比较2008年、2009年各科室的护理质量。结果:2009年各科室护理质量与2008年相比均有明显上升,经比较均(p<0.05)差异有统计学意义。结论:在护理管理中应用EXCEL电子表格可有效节约人力和时间,提高工作效率和管理质量。     

Creating interactive spreadsheets to provide immediate feedback

Features available with electronic spreadsheets enable accounting educators to create interactive spreadsheets that provide students with immediate feedback regarding the accuracy of their solutions. Providing immediate feedback using an answer-until-correct approach can help students acquire and retain knowledge. In this approach students open an incomplete spreadsheet and create formulas to complete the accounting problem. Correct solutions are denoted by a change in font color. Security features prevent students from locating the correct answers stored in an adjacent area. Problems illustrated in this paper relate to principles of financial accounting. However, interactive spreadsheets can also be used in other accounting courses such as managerial, cost, and intermediate accounting.     

An International Capital Budgeting Experiential Exercise

This article describes an experiential exercise that uses a brief simulation model intended to introduce undergraduate international finance students to the complexities in corporate investments in foreign countries. Use of the model requires one or preferably two class periods. Student learning goals include: (a) understanding how different patterns of deviations from purchasing power parity can alter an international capital investment's profitability in dollars, (b) evaluating the tradeoffs of different financing options under violations of interest rate parity, (c) promoting discussion of ethical considerations in international investments by asking the student to decide whether to engage in local infrastructure investments and facilitation payments, and (d) gain experience in foreign investing under uncertain conditions.     

Beyond the mechanics of spreadsheets: using design instruction to address spreadsheet errors

Given that the usage and complexity of spreadsheets in the accounting profession are expected to increase, it is more important than ever to ensure that accounting graduates are aware of the dangers of spreadsheet errors and are equipped with design skills to minimize those errors. Although spreadsheet mechanics are prevalent in accounting curricula, less attention has been given to design considerations that can reduce the incidence of spreadsheet errors. The extant literature provides evidence of the most common types of spreadsheet errors and explanations as to why they occur. Using the work of Panko and others, this paper outlines a three-step approach for introducing spreadsheet design practices to novice spreadsheet developers. To facilitate design instruction, this paper provides a summary of foundational readings related to spreadsheet errors as well as specific teaching strategies for addressing the most common spreadsheet errors identified in the literature.     

基于神经网络的工程造价估算方法及其Excel实现

建立了建筑工程成本的神经网络预到模型，并在微软Excel电子表格上模拟运行，对权值的优化，运用Ex—cel“加戴宏”程序，可以直接在电子表格上进行，实践结果表明预测结果满意，预测误差达到0．4％。为了更好地预到新的工程项目，模型中还包含了敏感性分析模块，以提高模型的泛化能力。