• Horticultural Science & Technology
• /
• v.33 no.6
• /
• pp.911-922
• /
• 2015

This study was carried out to evaluate growth characteristics of Kimchi cabbage cultivated in various highland areas, and to create a predicting model for the production of highland Kimchi cabbage based on the growth parameters and climatic elements. Regression model for the estimation of head weight was designed with non-destructive measured growth variables (NDGV) such as leaf length (LL), leaf width (LW), head height (HH), head width (HW), and growing degree days (GDD), which was $y=6897.5-3.57{\times}GDD-136{\times}LW+116{\times}PH+155{\times}HH-423{\times}HW+0.28{\times}HH{\times}HW{\times}HW$, ($r^2=0.989$), and was improved by using compensation terms such as the ratio (LW estimated with GDD/measured LW ), leaf growth rate by soil moisture, and relative growth rate of leaf during drought period. In addition, we proposed Excel spreadsheet model for simulation of yield prediction of highland Kimchi cabbage. This Excel spreadsheet was composed four different sheets; growth data sheet measured at famer's field, daily average temperature data sheet for calculating GDD, soil moisture content data sheet for evaluating the soil water effect on leaf growth, and equation sheet for simulating the estimation of production. This Excel spreadsheet model can be practically used for predicting the production of highland Kimchi cabbage, which was calculated by (acreage of cultivation) ${\times}$ (number of plants) ${\times}$ (head weight estimated with growth variables and GDD) ${\times}$ (compensation terms derived relationship of GDD and growth by soil moisture) ${\times}$ (marketable head rate).

• Journal of The Korean Association of Information Education
• /
• v.13 no.3
• /
• pp.325-339
• /
• 2009

Many current researches are limited in the statistics field, which is a part of mathematics class in the secondary school. Moreover, it's hard to apply to the elementary school since they are written in English. To overcome this limitations, the objectives from the unit that is suitable for using EXCEL in the elementary mathematics lessons are selected in this research. And a problem-based learning model for these lessons would be introduced that it can help students to focus on solving substances of the problems by reducing the time for arithmetic calculation.