• Journal of KIISE:Software and Applications
• /
• v.30 no.11
• /
• pp.1102-1111
• /
• 2003

Spreadsheet is one of the most widely used programming tool because of its ease of use, however there have been few researches on applying object-oriented techniques in developing spreadsheet applications. Generally, spreadsheet applications contain a lot of errors, and spreadsheet has some drawbacks such as low reusability and hard maintenance. In order to solve these problems, we introduce an object-oriented spreadsheet system, named XCEL. It enables users to develop applications using systematic techniques with data modelling method, and allows users to apply object-oriented technologies to spreadsheet programming. The data modelling method allows to define classes using XML and flowchart, and the spreadsheet represents an object with contiguous cells. XCEL has advantage that users can apply object-oriented technology to spreadsheet programming.

• Knowledge Management Research
• /
• v.13 no.2
• /
• pp.37-52
• /
• 2012

A spreadsheet is a office automation software which has been widely used in almost all areas in business. A spreadsheet is used for calculation, data analysis, model building and so on. As a result, spreadsheet is a very important tool for generating knowlege in a firm. Errors in a spreadsheet model can cause a serious financial damage in a corporation. However in Korea few researches for reducing errors have been performed. Neither serious efforts to reduce errors have been executed by corporations. In this research we provided summarized the results from a survey for spreadsheet usage, summarized researches on errors in spreadsheet up to now, and suggested a rules and structured development method for reducing errors in a spreadsheet. Errors in spreadsheets are prevalent. To solve this serious problem, we need much more attention on this problem in research area. Corporations must put more efforts on setting policies and rules. And also we need the government's concern and support.

• Journal of Environmental Science International
• /
• v.6 no.6
• /
• pp.645-658
• /
• 1997

A study on ventilation design using the spreadsheet model is carried out to propose means of available design. A sample of complex ventilation system In the non-standard condition Is used to illustrate thins spreadsheet model. In developing the spreadsheet model, this study has attempted to it general by using computional equations and design parameters that can be readily applied to any spreadsheet software. Also, most design data is contained in the spreadsheet template. This template provides the same design information as the ACGIH worksheet, and operates Quickly and emclenuy, and is fiexible enough to use under different conditions. This spreadsheet model allows the ventilation engineer to design quickly and accurately the ventilation system, without spending too much effort In the design process. By storing on computer and diskette, the design data computed finally can be used as a permanent record of specific ventilation system, and because of finally to be able to design over and over again while making only slight changes to the Input data, the spreadsheet model is used availably to accomplish the design optimazation by redesign and troubleshooting by review from field measurements. Also, the spreadsheet model is available for designing ventilation system under different condition or evaluating existing system or design drawing, because changes In the layout or formulae can be readily made to fit the needs of the designer.

• Management & Information Systems Review
• /
• v.6
• /
• pp.63-88
• /
• 2001

This paper presents a case study regarding a simple accounting information analysis method through the practical design using spreadsheet tool-Excel, which can offer to the management with more useful and practical information for the management decision-making. In this study, spreadsheet program is used to constitute case of the accounting information analysis method. Spreadsheet tool-Excel is easy to analyze the accounting information. And it can constitute a necessary program through function menu. In conclusion, the spreadsheet program should be used for quantitative analysis and evaluation on the accounting information. And it should be used to perform management activities. The results of this study may be summarized as follows: First, it is possible to constitute useful and practical case in the accounting information analysis method with spreadsheet program. Second, this study proposes directions for the accounting information analysis method with spreadsheet program.

• Korean Management Science Review
• /
• v.19 no.2
• /
• pp.41-58
• /
• 2002

New attempt has been made on Management Science (MS) education since the end of 1990s. The most distinctive feature of the new attempt is using spreadsheet program like Excel as a teaching tool for MS course. The spreadsheet program gives an excellent tool for modeling and solvina MS problems. In order to improve the pedagogical effect through using the spreadsheet program for MS course, new teaching model based on spreadsheet encompassing new course contents, effective instruction method, and examination method is needed. For this purpose, professors teaching MS should share their own teaching experiences and methods. So this paper explains remarkable functions of Excel and how to use them for the MS tools. This paper also stresses the importance of team project and case study to improve the effect of MS education through the use of Excel and presents some tips on MS education.

• Proceedings of the Korea Contents Association Conference
• /
• 2004.05a
• /
• pp.207-214
• /
• 2004

The Qis visualizational spreadsheet environment is shown to be extremely effective in supporting the visualization of multi-gigabyte multi-dimensional data sets. The Qis has a novel framestack that is the 3-D arrangement of spreadsheet elements. It enables the visualization spreadsheet to effectively manage, rapidly organize, and compactly encapsulate multi-dimensional data sets for visualization. Using several experiments with scientific users, the Qis has been demonstrated to be a highly interactive visual browsing tool for the analysis o( multidimensional data, displaying 2-D 3-D graphics, and rendering in each frame of the spreadsheet.

• The Journal of the Korea Contents Association
• /
• v.6 no.1
• /
• pp.14-22
• /
• 2006

The multimedia visualizational spreadsheet environment is shown to be extremely effective in supporting the organized visualization of multi-dimensional data sets. In this paper, we designed the visualization model that consists of the configurational 2D arrangement of spreadsheet elements at run time and each spreadsheet element has a novel framestack. As the feature, it supports 3D data structure of each element on the proposed model. It enables the visualization spreadsheet 1) to effectively manage, organize, and compactly encapsulate multi-dimensional data sets, 2) to reconfigure cell-structures dynamically according to client request, and 3) to rapidly process interactive user interface. Using several experiments with scientific users, the model has been demonstrated to be a highly interactive visual browsing tool for 2D and 3D graphics and rendering in each frame.

• Journal of the Institute of Electronics Engineers of Korea CI
• /
• v.42 no.5
• /
• pp.79-86
• /
• 2005

The Qis visualizational spreadsheet environment is shown to be extremely effective in supporting the organized visualization of multi-dimensional data sets. The Qis consists of the reconfigurative 2D arrangement of spreadsheet elements at run time and each spreadsheet element has a novel framestack. As the feature, it supports 3D data structure of each element on the Qis. It enables the visualization spreadsheet to effectively manage, rapidly organize, and compactly encapsulate multi-dimensional data sets for visualization. Using several experiments with scientific users, the Qis has been demonstrated to be a highly interactive visual browsing tool for the analysis of multidimensional data, displaying 2D and 3D graphics, and rendering in each frame of the spreadsheet.

• School Mathematics
• /
• v.7 no.4
• /
• pp.427-444
• /
• 2005

The Purpose of this study is to explore he mathematical discovery and justification of six 10th grade students through mathematical modeling activities in spreadsheet environments. The students investigated problem situations with a spreadsheet, which seem to be difficult to solve in paper and pencil environment. In spreadsheet environments, it is easy for students to form a data table and graph by inputting and copying spreadsheet formulas, and to make change specific variable by making a scroll bar. In this study those functions of spreadsheet play an important role in discovery and justification of mathematical rules which underlie in the problem situations. In modeling activities, the students could solve the problem situations and find the mathematical rules by using those functions of spreadsheets. They used two types of trial and error strategies to find the rules. The first type was to insert rows between two adjacent rows and the second was to make scroll bars connecting specific variable and change the variable by moving he scroll bars. The spreadsheet environments also help students to justify their findings deductively and convince them that their findings are true by checking various cases of the Problem situations.

• Korean Management Science Review
• /
• v.11 no.1
• /
• pp.59-72
• /
• 1994

In this paper we examine potentials of a spreadsheet program, one of the most widly available software system, as a mathematical optimization modeling tool. For an illustrative example, a shortest path problem is modeled on Lotus-123 for practical use and an implementational framework and a general guide to the spreadsheet modeling of network analysis is provided.