• School Mathematics
• /
• v.10 no.1
• /
• pp.1-22
• /
• 2008

The purpose of this study is to search the effective teaching-learning program by considering how affect on formation of linear function using Excel. This study was based on qualitative case study. The teaching experiment using Excel executed with five 8th graders' students for second research content. Teaching experiment was performed for two classes. Collecting the data was conducted via observations and interviews with students. The data include audio and video recording of the students' work, students' worksheets and detailed field notes. The conclusions drawn from teaching experiment are as follows: First, when students explored relevancy content of function in Excel environment, formation of concept of function was facilitated by experiencing operation of algebraic formulas, tables and graphs. We could infer that formation of concept was effected by conjecture activity and iterative process of feedback through Excel environment. Second, the students explored the changes very interestingly making algebraic formulas and presenting tables and graphs. The students were familiarized with observation on algebraic formulas, graphs and tables concurrently. Also, they tried to look for general rules through inductive observation. According to this study, we noticed that exploration teaming environment using Excel could supplement paper-and-pencil environment.

• Journal of Educational Research in Mathematics
• /
• v.15 no.1
• /
• pp.75-105
• /
• 2005

This study explored a mathematical modeling flow and the effect of interactions among students and between a student and Excel on modeling in a small group modeling environment with Excel. This is a case study of three 8th graders' modeling activity using Excel during their extra lessons. The conclusions drawn from this study are as follows: First, small group modeling using Excel was formed by formulating 4∼10 modeling cycles in each task. Students mainly formed tables and graphs and refined and simplified these models. Second, students mainly formed tables, algebraic formulas and graphs and refined tables considering each variable in detail by obtaining new data with inserting rows. In tables, students mainly explored many expected cases by changing the values of the parameters. In Graphs, students mainly identified a solution or confirmed the solution founded in a table. Meanwhile, students sometimes constructed graphs without a purpose and explored the problem situations by graphs mainly as related with searching a solution, identifying solutions that are found in the tables. Thus, the teacher's intervention is needed to help students use diverse representations properly in problem situations and explore floatingly and interactively using multi-representations that are connected numerically, symbolically and graphically. Sometimes students also perform unnecessary activities in producing data by dragging, searching a solution by 'trial and error' and exploring 'what if' modeling. It is considered that these unnecessary activities were caused by over-reliance on the Excel environment. Thus, the teacher's intervention is needed to complement the Excel environment and the paper-and-pencil environment properly.

• The Korean Journal of Applied Statistics
• /
• v.17 no.1
• /
• pp.165-172
• /
• 2004

Recently, there have been several studies to develop the multivariate data analysis system which can be readily used. The common characteristic of these studies is to develop the GUI system to which advanced statistical methods can be conveniently applied. In an extension of these studies, this study aims to supply users in various fields an interactive system with the convenience of the environment of GUI, which is constructed with the Excel macro and VBA, to apply multivariate data analysis methods easily. This system provides a graphic-oriented and menu-centered user interface in the Microsoft Excel which is widely used spreadsheet and analysis program.

• Journal of the Korean School Mathematics Society
• /
• v.10 no.2
• /
• pp.263-288
• /
• 2007

The purpose of this study is to search the effective teaching-learning program by considering how affect on formation of the process-object perspective of linear function using Excel. In this study we analyzed function units in textbook and examined how Excel affect on the formation of the process-object perspective of linear function. Teaching experiment was based on qualitative case study and performed for five classes with five 8th graders. Data were gathered through observations, audio-taped interviews, video recording of the students 'work, students' worksheets, and detailed field notes. Findings indicate that exploration learning environment using Excel could supplement paper-and-pencil environment. We found that intuitive, dynamic, explorative, feedback skills via Excel can play the role of scaffolding supporting formation of process perspective object perspective of linear function.

• School Mathematics
• /
• v.8 no.3
• /
• pp.265-290
• /
• 2006

The purpose of this study is to search an effective teaching & learning program by examining how much does Excel affect on problem solving of linear function. This study was based on qualitative case study. Teaching experiment was performed for seven periods with five students in 8th graders. Pre and posts tests were attempted to analyze the changes of student's ability on problem solving of linear function. The analysis of tests were performed in category with correct process-object perspective, near process-object perspective, incorrect process-object perspective. According to this study, the subjects showed an improvement on problem solving perspective of linear function. This meant that lessons using Excel had influenced on the problem solving of linear function. We noticed that exploring the learning environment with Excel could supplement paper-and-pencil environment. We believed that Excel with an intuitive dynamic and explorative skills can play a role in scaffolding to support problem solving of linear function.

• Journal of Bio-Environment Control
• /
• v.10 no.3
• /
• pp.187-196
• /
• 2001

Asparagus varieties popular in the foreign countries were collected and tested on their productivities and qualities for five years under rain shelter and open field conditions. Among the tested varieties, cultivars of UC309 and Excel showed superior productivity to the others in spear weight but the initial growth was not different among the tested varieties. However, the growth index was higher than the other varieties. According to the result from eight-year experiment, the best variety in productivity and quality were UC309 and Excel both for rain shelter and open field cultivations. To avoid the damage caused by stem blight, rain shelter and soil surface mulching treatments were tested with var. Excel. The spear sprouting and first harvesting date were a few days earlier in rain shelter cultivation than in open field, but there were no differences among the mulching materials. The number of spears and the spear weight per plant were increased in rain shelter cultivation, especially with rice straw and black P.E. mulching treatments. Marketable yield also increased by 253% in black P.E film mulching in rain shelter cultivation compared to non-mulching in open field. The stem blight examined in the autumn, 1997 was not observed under rain shelter treatment, but severe damage was observed in the open field regardless of the mulching materials. In the experiments, high asparagus yield could be achieved by black P.E. film mulching in rain shelter cultivation without the occurrence of stem blight.

• School Mathematics
• /
• v.6 no.4
• /
• pp.411-433
• /
• 2004

Many researchers have reported that 7th graders have severe difficulties in using letters and algebraic expressions. This study investigated the way Microsoft Excel contributes to student's understanding of letters and algebraic expressions. For six hours through two weeks, four 7th grade students experienced various activities with Excel after school and both before and after the experimentation, the interviews to check their understanding was conducted. The results were as follows; First, after the experimentation, students used various letters to express formulas and recognized that letters represent not only some objects but also changing objects. Also they accepted that same objects could be represented by different letters and different objects could be represented by the same letters. Second, Excel improved students' abilities to discriminate variables and invariables in the problem and to find mathematical relationships among variables. And with Excel students could divide the whole calculation procedure into several steps in order to handle it more easily. Also, Excel made immediate numerical feedback possible and it made students express the calculation in a more formalized way than a paper and pencil environment did.

• Journal of Wetlands Research
• /
• v.18 no.3
• /
• pp.226-231
• /
• 2016

Land Generated Waste Load Unit(LGWLU) estimation based on land use data is required to understand the impact of land use on water quality. The method of estimating LGWLU based on the monitoring data requires a lot of time and manpower. In this study, we propose a method of land pollution unit load estimation based on land use data with LP optimization. Optimization is the process to obtain the best possible optimal solution in a given condition. This study carried out optimization by using excel solver in Microsoft Excel. This study derived LGWLU of BOD, T-N, T-P in Gongju-Si and Seocheon-Gun by using the 2012 land use map made by ministry of environment based on 2010 satellite image. This study about LGWLU estimation is expected to be able to determine more clearly the water pollution caused by land use changes.

• Journal of the Korea Society for Simulation
• /
• v.31 no.4
• /
• pp.1-10
• /
• 2022

This paper describes the development of a modular simulation environment to analyze the performance of guided weapons. For the reusability of the simulation environment, components of the guided weapon simulation are modularized based on MATLAB Simulink. And the module management system is implemented based on Excel and MATLAB GUI for simulation interface and module management. In addition, a method of integration for modules with different interface and a method to set up the guidance and control phase for designing a guided flight scenario are suggested. Finally, to verify the performance of the implemented simulation environment, it was compared with the existing simulation results.

• Korean Journal of Agricultural and Forest Meteorology
• /
• v.20 no.2
• /
• pp.228-232
• /
• 2018

Process-based crop models have been used to assess the impact of climate change on crop production. These models are implemented in procedural or object oriented computer programming languages including FORTRAN, C++, Delphi, Java, which have a stiff learning curve. The requirement for a high level of computer programming is one of barriers for efforts to develop and improve crop models based on biophysical process. In this study, we attempted to develop a Chinese cabbage model using Microsoft Excel with Visual Basic for Application (VBA), which would be easy enough for most agricultural scientists to develop a simple model for crop growth simulation. Results from Soil-Plant-Atmosphere-Research (SPAR) experiments under six temperature conditions were used to determine parameters of the Chinese cabbage model. During a plant growing season in SPAR chambers, numbers of leaves, leaf areas, growth rate of plants were measured six times. Leaf photosynthesis was also measured using LI-6400 Potable Photosynthesis System. Farquhar, von Caemmerer, and Berry (FvCB) model was used to simulate a leaf-level photosynthesis process. A sun/shade model was used to scale up to canopy-level photosynthesis. An Excel add-in, which is a small VBA program to assist crop modeling, was used to implement a Chinese cabbage model under the environment of Excel organizing all of equations into a single set of crop model. The model was able to simulate hourly changes in photosynthesis, growth rate, and other physiological variables using meteorological input data. Estimates and measurements of dry weight obtained from six SPAR chambers were linearly related ($R^2=0.985$). This result indicated that the Excel/VBA can be widely used for many crop scientists to develop crop models.