• 한국컴퓨터정보학회논문지
• /
• 제24권11호
• /
• pp.127-133
• /
• 2019

오늘날 데이터 처리에 있어 가장 보편적인 언어가 SQL이다. 이를 위해 SQL 교육이 대학에서 진행되고 있다. 따라서 이번 연구에서는 SQL교육의 학습효과를 극대화하기 위한 SQL의 퀴즈 자동 채점 시스템을 제안한다. 본 시스템은 SQL 퀴즈의 자동 채점을 위해 데이터베이스관리시스템을 활용한 알고리즘을 이용하였으며, 만족할 만한 결과를 도출하였다. 본 시스템을 위해 학사관리, 인사관리 데이터베이스에 대해 학사관리의 문제로 문제 은행을 구축하고, 사용자에게 매번 다른 문제를 제공할 수 있도록 하였다. 채점은 테이블에 변화가 없는 검색과 테이블이 변화하는 수정, 삽입, 삭제로 나누어 처리하였다. 검색의 경우 정답과 응답을 실행한 후 실행 결과를 비교하여 처리하였으며, 수정, 삽입, 삭제는 정답과 오답을 실행한 후 테이블을 검색하여 비교함으로써 정답을 확인하도록 하였다. 수정, 삽입, 삭제는 테이블이 변화하였으므로 트랜젝션(transaction) 제어어인 ROLLBACK 명령어를 이용하여 데이터를 원래대로 복원하였다. 본 시스템을 구현하고, 우리대학 컴퓨터정보과 2학년 88명을 대상으로 772회 시행하였다. 시행결과 1회 10문항으로 구성된 시험에 대한 평균 채점 소요시간은 0.052초로 매우 효과적인 것으로 나타났으며, 채점관의 경우 동시에 여러개의 응답을 동시에 처리할 수 없음을 고려한다면 본 시스템의 성능이 월등함을 확인하였다. 향후 정답율을 기초로 문제 난이도를 고려한 문제 시스템으로 발전시키고자 한다.

• 웰빙융합연구
• /
• 제7권3호
• /
• pp.73-95
• /
• 2024

Purpose: Since August 2000, the small-scale environmental impact assessment system has prevented indiscriminate development. However, its qualitative reports lack objectivity and consistency. This study analyzes these issues through literature and expert surveys and proposes improvements. Research Methodology: Samples were selected based on regional consultation numbers. Mitigation measures were categorized into qualitative and quantitative factors. Issues were identified, and improvements suggested. The Delphi method helped select evaluation items and propose a scoring table. Results and Conclusions: The Delphi method selected 14 absolute and 22 relative evaluation items, excluding 3 invalid ones. A 100-point scoring table was created, with points assigned based on element significance. A 1-point bonus was added for top-scoring elements to promote eco-friendly planning.

• 한국산학기술학회논문지
• /
• 제12권9호
• /
• pp.3849-3855
• /
• 2011

본 연구에서는 배당을 중심으로 한 기업의 성장가능성을 평가하여 효율적 포트폴리오를 선택하는 전략을 제시한다. 이를 위해 선행실험을 통해 양질의 성장주를 가려내기 위한 4 개의 범주(category)를 선정하고, 각 범주별 점수 산출식을 포함하는 스코어링 테이블을 개발하였다. 스코어링 테이블에 의해 구성된 포트폴리오의 효과를 보이기 위해 한국거래소에 상장된 KOSPI 및 KOSDAQ의 927개 주식을 대상으로 2007~2010년의 4년 동안 매해 3 그룹의 포트폴리오를 구성하였고, 각 포트폴리오의 수익률을 시장수익률과 비교 분석을 실시하여 그 성능을 입증하였다.

• Asian Journal of Innovation and Policy
• /
• 제6권2호
• /
• pp.206-224
• /
• 2017

This article proposes a logic model for assessing the performance of the outcome of public research as a technology valuation method. It consists of two parts and eight steps. The first part is a scoring system and the second part is a validation process of the performance index derived from scoring by valuation method. The scoring in the first part generally requires a focus group method to find out the value drivers and make an evaluation table. The reason why we call it the technology valuation method is that the first part is derived from the simple evaluation of technology value using checklists for value drive. The second part is the regular technology valuation process. The model is designed for the measurement of unquantifiable outcome. Is knowledge or scientific outcome comparable to the measured outcome? If possible, how big is the unquantifiable outcome? This model is based on financial valuation techniques with clear or acceptable market data. Therefore, it cannot work solely for unquantifiable outcomes without comparable measurable outcomes, unlike economic valuation.

• Asian Pacific Journal of Cancer Prevention
• /
• 제13권4호
• /
• pp.1447-1452
• /
• 2012

Aim: To evaluate the differential diagnostic potential of lesion stiffness assessed by the sonoelastographic strain index ratio (SR) and elastographic color scoring system (UE) for breast lesions. Materials and Methods: Three hundred and forty two breast masses (158 benign and 184 malignant) from 325 consecutive patients (mean age 44.2 years; range 16-81)who had been scheduled for a sonographically guided core biopsy were examined proposed by Itoh et al, with scoring 1-3=benign and 4-5=malignant. Strain and area ratios of each lesion were calculated within the same machine. Histological diagnosis was used as the reference standard. The area under the curve (AUC) and cut-off point were obtained by receiver operating curve and the cross table Fischer Test was carried out for assessing diagnostic value. Sensitivity, specificity, PPV, NPV, accuracy and false-discovery rates were compared. Results: The mean strain ratios for benign and malignant lesions were 1.87 and 7.9 respectively. (P<0.0001). When a cutoff point of 3.54 was used, SR had a sensitivity of 94.6%, a specificity 94.3%, a PPV of 95.1%, an NPV of 93.7% and an accuracy of 94.4%. The AUC values were 0.90 for the 5 point scoring system (UE) and 0.96 for the strain index ratio. The overall diagnostic performance was SR method was better (P<0.05). Conclusions: Strain ratio measurement could be another effective predictor in elastography imaging besides 5 the point scoring system for differential diagnosis of breast lesions.

• 한국과학교육학회지
• /
• 제22권2호
• /
• pp.398-409
• /
• 2002

본 연구는 개념도 채점 방법의 타당도, 신뢰도 그리고 평가 도구로서 개념도의 현실 적용가능성을 알아보는데 목적이 있다. Burry-Stock의 채점 방법, Novak과 Gowin의 채점 방법, McClure와 Bell의 채점 방법을 모두 사용했고, 각 채점 방법에 대해 2명의 채점자를 배정하였다. 채점자는 지방 국립 사범대 과학교육학부 4학년 학생들이었다. Burry-Stock의 채점 방법을 제외하고는 과제의 제시 유형에 상관없이 두 채점자간의 정수 차이가 크지 않았고, 점수 차이가 통계학적으로도 유의하지 않았다. Novak과 Gowin과 McClure와 Bell의 채점 기준을 따를 때 개념도는 타당도가 높은 평가 도구인 것으로 나타났다. Burry-Stock의 채점 방법은 개념을 주고 개념도를 만들도록 한 과제를 위해 개발된 것인 만큼 그 유형의 과제를 가지고 개념도를 만들도록 했을 때는 타당도가 있었다. 각각 3가지 채점 방법에 따른 Pearson의 단순 적률상관 계수를 이용하여 채점자간 신뢰도롤 분석한 결과 신뢰도는 $.449{\sim}.975$의 범위였다. Novak과 Gowin의 채점 방법을 사용할 때는 .94 이상의 높은 일치도를 보여주었다. McClure와 Bell의 채점 방법 또한 환경 오염에서 .816의 비교적 높은 상관 관계를 보여 주었다. 채점자들이 개념도률 채점하는데 걸린 시간은 최소 1.13분에서 최대 3.70분까지 소요되었다. 본 연구 결과 개념도가 생물 개념 평가 도구로서 타당도 신뢰도 그리고 현실적용 가능성이 충분히 있다고 사료된다. 작성하는데 필요한 시간은 평균 29분이었다(n=40. S.D=5.10). 채점자들이 40개의 개념도를 채점하는데 필요한 시간을 기록하였다. Table 5는 각 평가 방법에 따른 개념도 채점에 평균 소요 시간을 나타낸 것이다. 전체적으로 1.13분에서 3.70분까지 소요되었다. 채점자에 따라 채점 시간에서 차이를 보였다.

• Journal of Nutrition and Health
• /
• 제55권5호
• /
• pp.533-542
• /
• 2022

The total energy expenditure (TEE) consists of the basal energy expenditure (BEE), physical activity energy expenditure (PAEE) and the thermic effect of food. The PAEE accounts for a significant portion of the TEE and can be changed according to individual efforts, and the difference between individuals of PAEE is large. Even for the same physical activity, there is a difference in energy expenditure between adults and children. Therefore, a physical activity classification table for youth is needed to classify the physical activity recorded in the physical activity diary prepared to evaluate children's energy expenditure. It is also necessary to calculate the physical activity level required to set the estimated energy requirement in the Dietary Reference Intakes for children and adolescents in Korea. This paper reports a physical activity classification table for Korean youth using the 2017 Youth Compendium of Physical Activities in the United States. This physical activity classification table includes 110 specific activities classified into 14 major categories by four age groups (6-9, 10-12, 13-15, and 16-18 years old) and their metabolic equivalent values. Of these, 87 physical activities were selected from the 2017 Youth Compendium reported in the United States. Nine physical activities such as washing and going to the bathroom, which are daily activities of children and adolescents not included among them, were selected from the another list (2008) of physical activities in America. The remaining 15 physical activities were selected from the research results, which measured the energy expenditure of Korean children and adolescents. Activity categories were divided into 4 areas: daily activity (A), movement (B), school work (C), exercise and sports (D). This physical activity classification table will help standardize the interpretation and scoring process of physical activity of youth in related studies and community health surveys.

• 한국도로학회논문집
• /
• 제17권4호
• /
• pp.99-105
• /
• 2015

PURPOSES: This study aims to establish the priority of introducing anti-icing spray system for regions of the National Highways in South Korea. Using this study, a logical plan for instituting such an anti-icing spray system can be established for the National Highways. METHODS : The Analytical Hierarchy Process (AHP) was employed to prioritize the implementation of an anti-icing spray system on Korean highways. For this purpose, an existing scoring table developed by the Ministry of Land, Infrastructure Transport Affair was slightly modified in order to reflect recent trends in winter maintenance. A survey was conducted to gather the preferences regarding the developed hierarchy of road experts and agencies. Finally, the final score was produced by integrating the scoring results with estimated weights for each evaluation criterion. RESULTS: In general, Honam and the metropolitan areas have relatively high priority while other areas such as Chungcheong, Young Nam, and Gang Won appear to be uniform in importance in terms of establishing an anti-icing spray system. This result may indicate that historical weather data and traffic volumes are significant factors in deciding in winter maintenance polices CONCLUSIONS : In this study, useful insights are suggested regarding winter maintenance by simultaneously performing rapid snow removal and proactive treatment. Issues of resource allocation may be potential research items in the field transportation engineering.

• 한국생물정보학회:학술대회논문집
• /
• 한국생물정보시스템생물학회 2002년도 제1차워크샵
• /
• pp.5-23
• /
• 2002

Motivation: Protein-protein interaction plays a critical role in the biological processes. The identification of interacting proteins by bioinformatical methods can provide new lead In the functional studies of uncharacterized proteins without performing extensive experiments. Results: Protein-protein interactions are predicted by a computational algorithm based on the weighted scoring system for domain interactions between interacting protein pairs. Here we propose potential interaction domain (PID) pairs can be extracted from a data set of experimentally identified interacting protein pairs. where one protein contains a domain and its interacting protein contains the other. Every combinations of PID are summarized in a matrix table termed the PID matrix, and this matrix has proposed to be used for prediction of interactions. The database of interacting proteins (DIP) has used as a source of interacting protein pairs and InterPro, an integrated database of protein families, domains and functional sites, has used for defining domains in interacting pairs. A statistical scoring system. named "PID matrix score" has designed and applied as a measure of interaction probability between domains. Cross-validation has been performed with subsets of DIP data to evaluate the prediction accuracy of PID matrix. The prediction system gives about 50% of sensitivity and 98% of specificity, Based on the PID matrix, we develop a system providing several interaction information-finding services in the Internet. The system, named PreDIN (Prediction-oriented Database of Interaction Network) provides interacting domain finding services and interacting protein finding services. It is demonstrated that mapping of the genome-wide interaction network can be achieved by using the PreDIN system. This system can be also used as a new tool for functional prediction of unknown proteins.

• 품질경영학회지
• /
• 제50권2호
• /
• pp.199-220
• /
• 2022

Purpose: The purpose of this study is to analyze the score data released by the Korea Institute of Curriculum and Evaluation to find out the problems with the current scoring system provided by the College Scholastic Ability Test and to suggest improvement measures to solve these problems. Methods: We calculated the descriptive statistics of the standard scores using the frequency distribution table of the standard scores and identified the characteristics of the standard scores by expressing the distribution as a graph. Also, we developed an index to evaluate whether each stanine level was stably assigned and calculated the indexes for each area/subject by using the data on the number of examinees for each level. Results: We found that the relationship of conversion from raw scores to integerized standard scores is different depending on the size of the standard deviation of the raw scores, and identified the problem that the raw score information is not fairly reflected in the calculation of the percentile and level as the two raw scores are converted to one standard score. This problem can be solved by calculating the standard score to a decimal point. Conclusion: In this study, as a way to improve the quality of the scores of the current CSAT, the standard score and percentile decimal notation, the specific regulations of the standard score and stanine level calculation method, and the expansion of the open range of the scores were suggested.