• 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.

• 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.

• 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.

• Proceedings of the Korea Society for Industrial Systems Conference
• /
• 2006.05a
• /
• pp.402-406
• /
• 2006

본 논문은 XSD(XML Schema Definition)기반의 XML 문서를 웹, 엑셀 환경에서 다양한 관점으로 볼 수 있도록 템플릿 서비스를 제공하기 위한 시스템이다. 템플릿 서비스는 데이터스킨 서버에서 스킨을 통하여 서비스되며, XML 문서를 다양한 문서로 변환할 수 있도록 한다. 예로 XML 문서를 HTML로 변경하는 경우 XSLT(Extensible Style Language Transformation) 를 사용할 수 있고, 엑셀 문서로 변환할 경우 엑셀 템플릿을 만들어 스킨으로 제공할 수 있다. 스킨은 다양한 방법으로 구현될 수 있으며, XML 문서에서 사용자가 원하는 문서로 만들기 위한 미들웨어 역할을 한다. 사용자는 데이터스킨 변환 서버에 접속하여 가지고 있는 XML 정보들을 차트, 그래프, 수식 등으로 쉽게 변환할 수 있을 뿐만 아니라 OWC(Office Web Component)로 쉽고 빠르게 문서를 변환 할 수 있도록 한다.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.19 no.7
• /
• pp.1-8
• /
• 2018

This paper describes new communication methods for transmitting torque commands between the vehicle controller that determines the amount of power generation in a range-extended electric vehicle and the engine controller that performs it. Generally, vehicles use CAN communication, but in this case, the hardware and software of the existing engine controller must be modified. For this reason, it is not easy to apply CAN communication to small and medium sized automotive reorganize companies. Therefore, this research presents a pin-pin communication method for applying the existing mass produced engine controller to range-extended electric vehicles. The pin-pin communication method converts the driver's demand torque control map inside an mass produced engine controller into a virtual accelerator opening position according to the target speed and target torque of the engine, and converts this to a voltage signal for the existing mass produced engine controller to recognize it. The virtual accelerator opening positions are mounted in the form of a control map in the vehicle controller through the reverse conversion process in an offline environment and are determined by the engine generating power requirements and engine optimal operating point algorithm. These algorithms and signal conversion circuits for engine torque transmission have been mounted on the vehicle controller to conduct the virtual accelerator opening position conversion process according to the engine target torque and to establish the virtual accelerator voltage signal using the signal converter.

• 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.

• Proceedings of the Korean Society of Computer Information Conference
• /
• 2021.07a
• /
• pp.573-574
• /
• 2021

본 논문에서는 게임 개발의 효율성을 증대하기 위한 데이터베이스 툴을 제안한다. 이 데이터베이스 툴은 엑셀을 기반으로 데이터의 모듈화와 VBA를 통한 자동화를 진행하여 데이터베이스 입력을 간략화 한다. 또한 별도의 스프레드시트를 통한 백업, 불러오기와 csv추출을 통해 관리적인 측면에서도 효율성을 보이게 된다. 해당 작업을 통해 실제 개발 환경에서의 실용성과 이점을 파악함과 동시에 문제파악을 통한 개선안을 낼 수 있도록 하였다. 본 논문에서는 데이터베이스 툴 설계과정에서의 이점과 전반적인 툴의 효율성에 대해 게임 개발의 관점으로 연구가 진행되었다.

• Proceedings of the Korea Water Resources Association Conference
• /
• 2010.05a
• /
• pp.832-836
• /
• 2010

물 부족에 대비한 대체수자원 개발과 함께 최근 들어 환경성과 생태계를 고려한 녹색도시 조성이 부각되면서 빗물이용을 통한 용수확보가 지속적으로 추진되고 있다. 녹색도시 조성은 조경시설 및 수경시설에서의 용수 사용량을 증가시키므로 용수확보에 대한 부담을 경감시키고 대상 사업의 환경성을 강조하기 위한 것으로 판단된다. 그러나 최근의 빗물이용시설의 도입 현황을 살펴보면 설계 시 집수면적이나 대지면적의 일정비율 이상을 설치하는 간편식이 주로 이용하고 있다. 간편식을 이용한 방법은 집수면의 토지이용 특성, 물 사용량을 고려할 수 없기 때문에 시설이 설치된 후 운영효율 저하가 우려된다. 본 연구에서는 간편식 법의 문제점 개선과 함께 시설 설계 시 편리하게 활용할 수 있도록 엑셀기반의 저류용량 계획선도를 개발하였다. 본 계획선도는 대상지역의 강우량과 토지이용 특성을 입력한 후 용수 공급 패턴(매일 일정량 활용, 무강우 시 일정량 활용, 하절기에 중점적으로 활용)에 따라 빗물이용시설 용량을 결정할 수 있다. 인터넷을 통해 기상청 등의 강우자료 서비스가 진행 중이므로 공간적인 제약 없이 전국적으로 활용도가 높을 것으로 기대된다.

• School Mathematics
• /
• v.13 no.3
• /
• pp.525-542
• /
• 2011

As teachers need to understand how to select and use technology in mathematics education, analysis on history, characteristics, and effects of various technology used in school mathematics will facilitate effective use of technology. This thesis aims to analyze through literary studies the history, characteristics, and effects of using spreadsheets Excel, dynamic geometry softwares GSP, Cabri and CAS, the most commonly used technology in teaching and learning mathematics in Korea. And we also study the current trends on using technology in mathematics education in Korea by investigating research trend, secondary mathematics curriculums past and present in Korea, mathematics textbooks, and classroom environments.

• Journal of the Korea Society for Simulation
• /
• v.29 no.2
• /
• pp.11-20
• /
• 2020

As the manufacturing environment becomes more complex, traditional simulation models alone are having a lot of difficulties in reflecting real-time manufacturing situations. Although the Digital Twin concept is actively discussed as an alternative to overcome theses issues, many studies are being carried out only in the product design phase. This research presents a Digital Twin-based manufacturing environment framework for applying the Digital Twin concept to the manufacturing process. Twin model that is operated in virtual space, physical system and databases describing the actual manufacturing environment, are proposed as detailed components that make up the framework. To check the applicability of proposed framework, a simple Digital Twin-based manufacturing system was simulated in a conveyor system using Arena software and Excel VBA. Experiment results have shown that the twin model is transmitted real time data from the physical system via DB and were operating in the same time unit. The Excel VBA fitted parameters defined by cycle time based on historical data that real-time and training data are being accumulated together. This study proposes operating method of digital twin model through the simple experiment examples. The results lead to the applicability of Digital twin model.