• Journal of The Korean Society of Agricultural Engineers
• /
• v.51 no.2
• /
• pp.43-49
• /
• 2009

Many researcher uses simulation techniques for understanding the phenomenon and expecting the response. Simulation techniques have many advantages which is less time-consuming, easy to control constraints, and cheaper than experimental study. However Researches usually are not good at programming the model, it's hard to implement simulation model using computer language. They use spreadsheet program like Microsoft $excel^{TM}$ Although a spreadsheet program is good for modeling, it's cumbersome to describe expressions which consist of not variable name but location indicator. This study suggests the program which helps researcher developing model using graphical interface and variable name. For verifying usability, the model which is implemented by developed modeler were compared with by spreadsheet program.

• International conference on construction engineering and project management
• /
• 2009.05a
• /
• pp.658-668
• /
• 2009

Earth-moving operation has a great impact on the overall budget and schedule of any heavy civil projects. More often than not, the operational decisions are made largely based on field personnel's experience and judgment. In particular, decisions on earth moving operations by scraper-dozer fleets have been heavily influenced by the following belief: "The longer a dozer pushes a scraper for loading, the better earth-moving productivity is gained by the fleet." Even though there is some truth to this notion, scraper-dozer earth moving operations involve a much complex process that requires a systematic analysis for predicting the maximum production. To this end, this paper presents a spreadsheet-based scraper-dozer fleet operation model for its production optimization. Various optimization techniques, including a genetic-algorithm method, are presented for comparison and each technique's pros and cons are discussed.

• School Mathematics
• /
• v.3 no.1
• /
• pp.109-129
• /
• 2001

The concern of this paper is to provide learning opportunities to participate in the class of statistics with interest for the students who dislike mathematics and especially find difficulty in understanding statistics. The students were encouraged to arrange data collected in their daily life by the use of spreadsheet program and to interpret the result of data with graphs, so that they could have a great interest in statistics and make steady progress in their voluntary study. The further study to use computers in teaching mathematics should be continued and recommended in the rapid age of information and knowledge-based.

• School Mathematics
• /
• v.13 no.3
• /
• pp.363-384
• /
• 2011

This study is based on the recognition that the school mathematics education should reinforce the heuristic and constructional aspects related with discoveries of mathematical rules and understanding of mathematical concepts from real world situations as well as the deductive and formal aspects emphasizing on mathematical contents precisely. The 11th grade students of one class from a city high school with average were chosen. They were given time to learn various functions of Excel in regular classes of "Information Society and Computer" subject. They don't have difficulty using cells, mathematical functions and statistical functions in spreadsheet. Experiment was performed for six weeks and there were two hours of classes in a week. Considering the results of this research, teaching materials using spreadsheets play an important role in helping students to experience probabilistic and statistical reasoning and construct mathematical thinking. This implies that teaching materials using spreadsheet provide students with an opportunity to interact with probabilistic and statistical situations by adopting engineering which can encourage students to observe and experience various aspects of real world in authentic situations.

• Journal of The Korean Association of Information Education
• /
• v.23 no.4
• /
• pp.293-302
• /
• 2019

In this study, we developed the google spreadsheet education program which focuses on the education data visualization. And we applied it to forth and fifth grade students, and then verified its effect. The developed program was applied to 29 forth and fifth grade students for 36 classes in six days. Application of the program In order to verify the effect on creativity, Torrance Tests of Creative Thinking Figures A and B were introduced and pretests and post tests were carried out. As a result of the verification, it was found that the google spreadsheet education program which focuses on the education data visualization has positive effects on the creativity factors of the elementary school forth and fifth grade students.

• The Mathematical Education
• /
• v.50 no.2
• /
• pp.185-212
• /
• 2011

The purpose of this study is to analyze whether spreadsheet-used instruction can improve statistical thinking ability and attitude and also to identify what characteristics of statistical thinking is constructed. For this study, a subject of 2 classes were randomly selected among the 12 classes of the 11th grader in D high school and designated one class as the experimental group and the other class as the control group. Eight hours of the spread sheet-used instruction and the traditional textbook-oriented instruction had been carried out in each class. The research findings are as follows. First, the spread sheet-used instruction is shown to be more effective in enhancing statistical thinking than the traditional textbook-oriented instruction. Second, the spread sheet-used instruction is shown to be more effective in improving statistical attitude than the traditional textbook-oriented instruction. Third, students have shown the various characteristics of statistical thinking in the data descriptive process, data arrange-summary process, data representing process, and data analying process through the spread sheet-used instructions. Hence, the spread sheet-used instruction is recommended in teaching statistics.

• The Journal of Information Systems
• /
• v.2
• /
• pp.29-52
• /
• 1993

• Proceedings of the Korean Geotechical Society Conference
• /
• 1993.06b
• /
• pp.1-18
• /
• 1993

• 한국신재생에너지학회:학술대회논문집
• /
• 2010.11a
• /
• pp.177.1-177.1
• /
• 2010

Large offshore wind farms have actively been developed in order to meet the needs for wind energy since the land-based wind farms have almost been fully developed especially in Europe. The key problem for the construction of offshore wind farms may be on the high cost of energy compared to land-based ones. NREL (National Renewable Energy Laboratory) has developed a spreadsheet-based tool to estimate the cost of wind-generated electricity from both land-based and offshore wind turbines. Component formulas for various kinds and scales of wind turbines were made using available field data. Annual energy production has been estimated based on the Weibull probability distributions of wind. In this paper, this NREL estimation model is introduced and applied to the offshore wind turbines now under designing or in production in Korea, and the result is discussed.

• Industrial Engineering and Management Systems
• /
• v.6 no.2
• /
• pp.106-118
• /
• 2007

This paper present a new optimization model to generate aggregate production planning by considering electric cost. The new Time Of Switching (TOS) electric type is introduced by switching over Time Of Day (TOD) and Time Of Use (TOU) electric types to minimize the electric cost. The fuzzy demand and Dynamic inventory tracking with multiple plant capacity are modeled to cover the uncertain demand of customer. The constraint for minimum hour limitation of plant running per one start up event is introduced to minimize plants idle time. Furthermore; the Optimal Weight Moving Average Factor for customer demand forecasting is introduced by monthly factors to reduce forecasting error. Application is illustrated for multiple cement mill plants. The mathematical model was formulated in spreadsheet format. Then the spreadsheet-solver technique was used as a tool to solve the model. A simulation running on part of the system in a test for six months shows the optimal solution could save 60% of the actual cost.