• The Journal of Korean Association of Computer Education
• /
• v.3 no.2
• /
• pp.59-66
• /
• 2000

This study is to design and implement Excel 2000 WBI applying the Cognitive Apprentice Model. Excel 2000 is the most used Spread Sheet program and indispensable for increasing teachers' information literacy. The Cognitive Apprentice Model is one of Constructivism learning models. Constructivism is a new educational paradigm and mainly applied in education fields. This WBI is designed and implemented according to the Cognitive Apprentice Model and composed of practical contents according to Constructivism learning principle which insists learning is occurred in real situation. For more effective interaction the teacher(computer) guides the learners individually and uses a bulletin board, E-mail and chatting room.

• 한국정보통신설비학회:학술대회논문집
• /
• 2009.08a
• /
• pp.36-39
• /
• 2009

We developed an optimal design interface based on VBA(Visual Basic Application) that takes advantage of API(Application Program Interface) function of commonly used EM analysis software. The developed interface is adopted for an optimal design of a septum in a waveguide tee junction using PSO(Particle Swarm Optimization) algorithm. The objective function of the optimal design is defined by $S_{11}$-parameter of the waveguide tee junction Design variables are established as position of the septum, that are changed to satisfy the design goal Using the developed design interface and PSO algorithm, the objective function converged to the smallest value, showing the validity of the proposed method. The design interface was developed using Microsoft Excel software, enabling easy control of design parameters for user. Also, various analysis parameters can be set in the Excel interface, including waveguide input mode and frequency. After completion of the design, field solutions at user-specified positrons can be extracted to the output files in complex number form.

• Journal of Engineering Education Research
• /
• v.15 no.5
• /
• pp.108-118
• /
• 2012

The purpose of this study was to provide analytic rubrics for measuring teamwork(PO6), communication and presentation skills(PO7), and life-long learning(PO8) based on theoretical concepts of performance assessment and rubrics. Also, this study analyzed data about performance assessment and rubics from courses offered through college of engineering. Participants were 34 senior engineering students who took the course 'Technical writing and presentation'. In the second week of the course, students were given the pre-test instrument which was developed for measuring students' understanding of program outcomes for this study. After performing project activities using rubrics, students were encouraged to complete the post-test instrument and the reaction questionnaire during the ninth week. The data were analyzed by using SPSS 14.0 and Microsoft Excel. The research findings are as follows. First, to promote and evaluate program learning outcomes appropriately, performance assessment-based on rubircs should be implemented. Second, in the reaction questionnaire about the rubircs, students answered that using rubircs for performing the project was very useful for understanding the performance procedures and assessment criteria. Third, the mean of understanding of program outcomes of students in post-test was significantly increased than in the pre-test(p<.0001). From the findings, performance assessment and rubrics should be used as evaluation tools at course levels in terms of promoting program learning outcomes for engineering education.

• Journal of Korean Society of Water and Wastewater
• /
• v.29 no.1
• /
• pp.123-131
• /
• 2015

A CCTV inspection method has been widely used to assess sewer condition and performance, but Korea lacks a proper decision support system for prioritizing sewer repair and rehabilitation (R&R). The objective of this paper is to introduce the results that we have developed in the Sewer Condition Assessment and Rehabilitation Decision-making (SCARD) Program using MS-EXCEL. The SCARD-Program is based on a standardized defect score for sewer structural and hydraulic assessment. Priorities are ranked based on risk scores, which are calculated by multiplying the sewer severity scores by the environmental impacts. This program is composed of three parts, which are decision-making for sewer condition and performance assessment, decision-making for sewer R&R priority assessment, and decision-making for optimal budget allocation. The SCARD-Program is useful for decision-makers, as it enables them to assess the sewer condition and to prioritize sewer R&R within the limited annual budget. In the future, this program logic will applied to the GIS-based sewer asset management system in local governments.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.18 no.3
• /
• pp.657-665
• /
• 2017

The aim of this study was to develop and distribute a dedicated program that can easily calculate the effective dose of a patient undergoing nuclear medicine examinations, and assist in the study of dose of nuclear medicine examinations and information disclosure. The program produced a database of the effective dose per unit activity administered (mSv/MBq) of the radiopharmaceuticals listed in ICRP 80, 106 Report and the fourth addendum, was designed through Microsoft Visual Basic (In Excel) to take the effect of 5 different (Area, Clark, Solomon(=Fried), Webster, Young) of pediatric dose calculation methods and 7 different body surface area calculation methods. The program calculates the effective dose (mSv) when the age, radionuclide, substance, and amount injected in the human body is inputted. In pediatric cases, when the age is entered, the pediatric method is activated and the pediatric method to be applied can be selected. When the BSA (Body Surface Area) formula is selected in the pediatric calculation method, a selection window for selecting the body surface area calculation method is activated. When the adult dose is input, the infant dose and the effective dose (mSv) are calculated automatically. The patient effective dose calculation program of the nuclear medicine examinations produced in this study is meaningful as a tool for calculating the internal exposure dose of the human body that is most likely to be obtained in nuclear medicine examinations, even though it is not the actual measurement dose. In the future, to increase the utilization of the program, it will be produced as an application that can be used in mobile devices, so that the public can access it easily.

• Journal of radiological science and technology
• /
• v.29 no.3
• /
• pp.133-139
• /
• 2006

By using CR image pixel data, We examined the way how to calculate the MTF and digital characteristic curve. It can be changed to the text-file(Excel) from a pixel data which was printed with a digital x-ray equipment. In this place, We described the way how to figure out and correct the sharpness of a digital images of the MTF from FUJITA. Excel program was utilized to calculate from radiography of slit. Digital characteristic curve, Line Spread Function, Discrete Fourier Transform, Fast Fourier Transform digital specification curve, were indicated in regular sequence. A big advantage of this method, It can be understood easily and you can get results without costly program and without full knowledge of computer language. It shows many different values by using different correction methods. Therefore we need to be handy with appropriate correction method and we should try many experiments to get a precise MTF figures.

• KIEAE Journal
• /
• v.16 no.6
• /
• pp.151-157
• /
• 2016

Purpose: The purpose of this study is to develop and apply an environmental impact assessment program for apartment building elements, based on the building materials of the LCI DB, which can link the LCA results of building materials and buildings. Method: For this purpose, a framework for building elements was established, and several building material combinations were developed. In addition, the LCA method for quantifying environmental load emissions from the building materials of each site was applied to establish an environmental impact database of the building materials of the LCI DB. Result: An environmental impact assessment program, based on a Microsoft Excel worksheet, was developed for apartment building elements. This program can link the environmental impact assessment of building materials and building units. To validate the program evaluation results that were obtained in this study, a comparative analysis was carried out using the results of existing evaluation methods. The error rate was estimated to be 5% for environmental impact assessment using existing evaluation methods.

• Journal of Korean Society of Water and Wastewater
• /
• v.29 no.1
• /
• pp.97-106
• /
• 2015

A CCTV inspection method has been widely used to assess sewer condition and performance, but Korea lacks a proper decision support system for prioritizing sewer repair and rehabilitation (R&R). The objective of this paper is to introduce the results that we have developed in the Sewer Condition Assessment and Rehabilitation Decision-making (SCARD) Program using MS-EXCEL. The SCARD-Program is based on a standardized defect score for sewer structural and hydraulic assessment. Priorities are ranked based on risk scores, which are calculated by multiplying the sewer severity scores by the environmental impacts. This program is composed of three parts, which are decision-making for sewer condition and performance assessment, decision-making for sewer R&R priority assessment, and decision-making for optimal budget allocation. The SCARD-Program is useful for decision-makers, as it enables them to assess the sewer condition and to prioritize sewer R&R within the limited annual budget. In the future, this program logic will applied to the GIS-based sewer asset management system in local governments.

• Computers and Concrete
• /
• v.25 no.4
• /
• pp.327-341
• /
• 2020

Advanced forms of structural design (e.g., displacement-based methods) require knowledge of the non-linear force-displacement behavior of both the overall building and individual lateral load resisting elements, i.e., walls or building cores. Similarly, understanding the non-linear behaviour of the elements in a structure can also allow for a less conservative structural response to be calculated by better understanding the cracked (i.e., effective) properties of the various RC elements. Calculating the non-linear response of an RC section typically involves using 'black box' analysis packages, wherein the user may not be in complete control nor be aware of all the intricate settings and/or decisions behind the scenes. This paper introduces a user-friendly and transparent analysis program for predicting the back-bone force displacement behavior of slender (i.e., flexure controlled) RC walls, building cores or columns. The program has been validated and benchmarked theoretically against both commonly available and widely used analysis packages and experimentally against a database of 16 large-scale RC wall test specimens. The program, which is called WHAM, is written using Microsoft Excel spreadsheets to promote transparency and allow users to further develop or modify to suit individual requirements. The program is available free-of-charge and is intended to be used as an educational tool for structural designers, researchers or students.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.22 no.2
• /
• pp.104-112
• /
• 2021

For extrusion processes in the process industry, the need to build smart factories is increasing. However, in most extrusion production sites, the production method is continuous, and because the properties of the data are undeed, it is difficult to process the data. In order to solve this problem, we present a methodology utilizing a near field communication (NFC) sensor rather than water-based data entry. To this end, a wireless network environment was built, and a data management method was designed. A non-contact NFC method was studied for the production performance-data input method, and an analysis method was implemented using the pivot function of the Excel program. As a result, data input using NFC was automated, obtaining a quantitative effect from reducing the operator's data processing time. In addition, using the input data, we present a case where a bottleneck is improved due to quality problems.