• Title/Summary/Keyword: Scoring Table

Search Result 25, Processing Time 0.026 seconds

Relational Database SQL Test Auto-scoring System

  • Hur, Tai-Sung
    • Journal of the Korea Society of Computer and Information
    • /
    • v.24 no.11
    • /
    • pp.127-133
    • /
    • 2019
  • SQL is the most common language in data processing. Therefore, most of the colleges offer SQL in their curriculum. In this research, an auto scoring SQL test is proposed for the efficient results of SQL education. The system was treated with algorithms instead of using expensive DBMS(Data Base Management System) for automatic scoring, and satisfactory results were produced. For this system, the test question bank was established out of 'personnel management' and 'academic management'. It provides users with different sets of test each time. Scoring was done by dividing tables into two sections. The one that does not change the table(select) and the other that actually changes the table(update, insert, delete). In the case of a search, the answer and response were executed at first and then the results were compared and processed, the user's answers are evaluated by comparing the table with the correct answer. Modification, insertion, and deletion of table actually changes the data table, so data was restored by using ROLLBACK command. This system was implemented and tested 772 times on the 88 students in Computer Information Division of our college. The results of the implementation show that the average scoring time for a test consisting of 10 questions is 0.052 seconds, and the performance of this system is distinguished considering that multiple responses cannot be processed at the same time by a human grader, we want to develop a problem system that takes into account the difficulty of the problem into account near future.

A Study on Securing Objectivity in Small-Scale Environmental Impact Assessments Using Delphi Analysis

  • Dong-Myung CHO;Ju-Yeon LEE;Woo-Taeg KWON
    • Journal of Wellbeing Management and Applied Psychology
    • /
    • v.7 no.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.

A Portfolio Selection Strategy with Consideration of Growth Potential of Corporations (기업의 성장가능성을 고려한 포트폴리오 선택 전략)

  • Choi, Da-Young;Ahn, Beum-Jun;Shin, Hyun-Joon
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.12 no.9
    • /
    • pp.3849-3855
    • /
    • 2011
  • This study presents an efficient strategy for selecting portfolio by evaluating growth potential of a corporation based on dividend. Through preliminary experiments, we extract 4 categories to sort out prospective stocks and develop a scoring table including criteria and formulas used to calculate scores for each category. In order to show the effectiveness of the portfolio selected by scoring table, we constructed 3 portfolios for every 4 years (2007-2010) out of 927 listed companies in KRX and proved that our portfolios are superior to market portfolio in terms of rate of return.

Measurement of Public Research Outcomes: A Technology Valuation Method

  • Park, Jung-Min;Lim, Seong-Il;Seol, Sung-Soo
    • Asian Journal of Innovation and Policy
    • /
    • v.6 no.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.

Diagnostic Potential of Strain Ratio Measurement and a 5 Point Scoring Method for Detection of Breast Cancer: Chinese Experience

  • Parajuly, Shyam Sundar;Lan, Peng Yu;Yun, Ma Bu;Gang, Yang Zhi;Hua, Zhuang
    • Asian Pacific Journal of Cancer Prevention
    • /
    • v.13 no.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.

A Study on Validity, Reliability and Practicality of a Concept Map as an Assessment Tool of Biology Concept Understandings (생물 개념 이해의 평가 도구로서 개념도의 타당도, 신뢰도 그리고 현실 적용 가능성에 대한 연구)

  • Cho, Jung-II;Kim, Jung
    • Journal of The Korean Association For Science Education
    • /
    • v.22 no.2
    • /
    • pp.398-409
    • /
    • 2002
  • The purpose of this study was to investigate the validity, reliability and practicality of a concept map as an assessment tool in the context of biology concept learning. Forty undergraduate students participated in concept mapping, and the maps were scored by preservice science teachers, using one of three different scoring methods, that is, concept map scoring methods developed by Burry-Stock, Novak & Gowin and McClure & Bell. Two scorers were assigned to each scoring method. As far as the validity of the assessment methods was concerned, two of the three methods were found to be very valid, while Burry-Stock's scoring method was shown little valid. As far as the internal consistency of the methods was concerned, considerably high consistencies were shown between every pair of scorers, judging from high correlation coefficients between the pair of scorers for each scoring method. It took from 1.13 minutes to 3.70 minutes to assess a map at the average. It showed that concept mapping could be used in school classrooms with the limited resources of time and people. These findings suggest that the concept mapping can be an appropriate tool for assessing biology concept understandings.

Physical activity classification table for Korean youth: using the Youth Compendium of Physical Activities in the United States (한국 소아청소년을 위한 신체활동분류표: 미국의 청소년 신체활동목록 (Youth Compendium of Physical Activities)을 이용하여)

  • Kim, Eun-Kyung;Gwak, Ji-Yeon;Jun, Ha-Yeon
    • Journal of Nutrition and Health
    • /
    • v.55 no.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.

Prioritization of Anti-Icing Spray System for Active Snow-Removal Works (능동적 제설작업을 위한 염수분사장치 설치 우선순위 선정)

  • Yang, Choong Heon;Kim, In Su
    • International Journal of Highway Engineering
    • /
    • v.17 no.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.

Development and Application of Protein-Protein interaction Prediction System, PreDIN (Prediction-oriented Database of Interaction Network)

  • 서정근
    • Proceedings of the Korean Society for Bioinformatics Conference
    • /
    • 2002.06a
    • /
    • 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.

  • PDF

A Study on the Quality Improvement of College Scholastic Ability Test Scoring System (대학수학능력시험 점수산정시스템의 품질 제고를 위한 연구)

  • Park, Youngsun
    • Journal of Korean Society for Quality Management
    • /
    • v.50 no.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.