• Title/Summary/Keyword: Excel 분석도구

Search Result 29, Processing Time 0.022 seconds

A Study on the Measurement and Improvement of Academic Library Service Quality by ISA(Importance-Satisfaction Analysis) (ISA를 적용한 대학도서관 서비스 품질 측정과 개선방안 도출)

  • Jung, Young-Mi;Kim, Young-Kee;Lee, Soo-Sang
    • Journal of Korean Library and Information Science Society
    • /
    • v.41 no.1
    • /
    • pp.255-272
    • /
    • 2010
  • This paper aims to describe the measurement and improvement of academic library service quality by ISA (Importance-Satisfaction Analysis). This research established service quality model on based LibQUAL+(R). It consisted of 18 items that formed three dimensions, affect of service quality, information control quality, and library as place quality. To execute this research, the service quality according the users' importance and satisfaction of library service is measured through Gaps model and ISA. The data for this case study was collected through the survey conducted the users of the H University library. By applying SPSS 17.0 and Excel 2007, the final 113 surveys were used for analysis.

  • PDF

A Simulator for the Design and Operation of the Steel Mill (제강.연주 공장 설계와 운영을 위한 시뮬레이터)

  • Choi, Seong-Hoon
    • Journal of the Korea Society for Simulation
    • /
    • v.20 no.2
    • /
    • pp.49-57
    • /
    • 2011
  • Stiff competition and skyrocketing prices of raw materials are increasingly demanding the optimal design and operation of iron and steel mills minimizing trial and error. Computer simulation can provide the methodology in accordance with requirements. The purpose of this paper is to suggest a simulator for the design and operation of the steelmaking and continuous casting mill. The simulator was developed using Arena, popular simulation software and input and output interface based on MS Excel. It allows easy access for the maintenance and extension of the model. One of distinct features of the proposed simulator is the inclusion of complex transportation modules composed of transfer cars and overhead cranes. The simulator can be used for evaluating various alternative designs of a projected mill via throughput analysis and material flow analysis. Also, one can utilize it effectively to search for the best product mix suitable for many types of situations. It could be an invaluable tool evaluating the performance of operation patterns and improving the accuracy.

Translation Study of Miller Assessment of Preschoolers (MAP) for Using in Korea (Miller Assessment for Preschoolers(MAP)의 국내 적용을 위한 번역 연구)

  • Hong, Eunkyoung;Kim, Kyeong-Mi
    • The Journal of Korean Academy of Sensory Integration
    • /
    • v.16 no.1
    • /
    • pp.35-44
    • /
    • 2018
  • Objective : This study aimed to perform a translation, backward translation, item modification, and test of content validity for Korean version of Miller Assessment for Preschoolers (MAP). Methods : Professors in department of occupational therapy, translators, or occupational therapists participated in the processes of translation, comparison and synthesis I, backward translation, comparison and synthesis II, test of understanding, and modify of items. Content Validity Indices (CVI) was calculated for data analysis by using Microsoft Office Excel. Results : Results of comparison between the original MAP and Korean MAP in professor panels were mean $3.66{\pm}0.40$, item-level CVI (I-CVI) 0.94, and overal scale CVI (S-CVI) 0.83. In agreement, result of comparison between of the original MAP and backward translated MAP (version English) was mean 3.14. The erroneous content was omission 13 times, the addition 3 times, the substitution 6 times, erroneous terms 11 times, and reordering 6 times. Average of understanding test in the therapist panels was $3.66{\pm}0.27$. The agreements were I-CVI 0.93 and S-CVI 0.58. Conclusion : Using assessment tools that developed in another country is important to do test of content validity and systematic translation process in Korea. For developing Korean version of MAP, validity and reliability studies need to be followed in near future.

The Study on Using Spreadsheet in Probability and Statistics Area of High School (고등학교 확률 통계 영역에서 스프레드시트 활용에 대한 연구)

  • Lee, Jong-Hak
    • School Mathematics
    • /
    • v.13 no.3
    • /
    • pp.363-384
    • /
    • 2011
  • This study is based on the recognition that the school mathematics education should reinforce the heuristic and constructional aspects related with discoveries of mathematical rules and understanding of mathematical concepts from real world situations as well as the deductive and formal aspects emphasizing on mathematical contents precisely. The 11th grade students of one class from a city high school with average were chosen. They were given time to learn various functions of Excel in regular classes of "Information Society and Computer" subject. They don't have difficulty using cells, mathematical functions and statistical functions in spreadsheet. Experiment was performed for six weeks and there were two hours of classes in a week. Considering the results of this research, teaching materials using spreadsheets play an important role in helping students to experience probabilistic and statistical reasoning and construct mathematical thinking. This implies that teaching materials using spreadsheet provide students with an opportunity to interact with probabilistic and statistical situations by adopting engineering which can encourage students to observe and experience various aspects of real world in authentic situations.

  • PDF

A Study on the Computer Application and Learning Model in the CAQC Education (CAQC교육에 있어서 컴퓨터 활용과 학습모델에 관한 연구 - 히스토그램을 중심으로 한 학습모델 -)

  • Choi Myung-Ho
    • Journal of Engineering Education Research
    • /
    • v.3 no.2
    • /
    • pp.3-13
    • /
    • 2000
  • The paper has analyzed and summarized about the theoretical problem occurred in the CAQC, and has developed the learning model focused on the histogram as a case study. The range of study is to systematize the basic method of histogram generally used, and to make step by step procedures under the interactive relation with the improvement of the theory that must be added in case of the calculation by the aided of MS-Excel software. A histogram is the theory to understand the population distribution from which samples are extracted, so alternative methods are presented to estimate the population shape through an experiment and a practice. In order to enlarge the application area of the histogram in the factory, the theory of normal test, the criteria of process capability index and the probability calculation of PPM are added to the histogram. The learning model of CAQC education is proposed that is consistent with the target of histogram to control and search the cause of item defectives fast and correctly.

  • PDF

Actual Condition and Realization of Important on Laboratory Safety Management in Chemical Laboratories (화학물질 사용 실험실의 안전관리 실태와 인식도)

  • Lee, Keun-Won;Choi, Yi-Rac
    • Journal of the Korean Institute of Gas
    • /
    • v.16 no.2
    • /
    • pp.60-66
    • /
    • 2012
  • With diversification of research and development activity according to fusion of state-of-the-art technology, potential hazard and risk factors in new forms have been increased in the laboratories. Also, as there are many cases where the experimental condition is extremely high/low temperature and pressure, many many accidents producing loss of life and/or injuries occur due to the extreme condition. In this study, The common fact questionnaire as the survey tool for the establishment of the accident prevention countermeasure in laboratory have been developed to safety security of the laboratory workers. The current status of chemical materials and the realization of important on laboratory safety management using the questionnaire investigated by an electronic mail and visiting survey in the laboratories and universities. The collected data was analyzed with Excel program and it can be utilized as basic data for accident prevention in laboratories.

The Effects of Urban Park and Vegetation on Crime in Seoul and Its Planning Implication to CPTED (CPTED 요소로써 서울시 공원·녹지의 효과와 계획적 함의)

  • Cho, Min-gyun;Park, Chan;Jang, Jeong-in
    • Journal of the Korean Institute of Landscape Architecture
    • /
    • v.46 no.3
    • /
    • pp.27-35
    • /
    • 2018
  • In the mandatory application of the CPTED, only negative parts of urban parks and vegetation were reflected. Therefore, this study tries to present the positive effects of urban parks and vegetation. The purpose of this study is to demonstrate the effects of urban parks and vegetation on crime occurrence and to suggest the planning implications of this to CPTED based on theory related to crime, environmental psychology, and crime occurrence analysis. This study used the crime occurrence data of Seoul, NDVI, population, distance from urban park, floating population, and the like. This study collected data from the Statistics Korea, the local government, and Landsat 8 satellite images provided by the USGS and created data of environmental variables and social variables by district using ArcGIS and statistical program. Literature analysis, correlation analysis, regression analysis, and geographically weighted regression were used to determine the relationship between crime occurrence and environmental variables, and to discuss its implication. It was found that crime occurrence has a relationship with the total population (${\beta}=.663$), the number of amusement facilities (${\beta}=.447$) and the area of a police station jurisdiction (${\beta}=.395$). This confirms that a crime rate is low when the floating population is large (${\beta}=-.241$) and vegetation vitality is high (NDVI, ${\beta}=-.281$). Vegetation vitality (NDVI) is effective in lowering violence through psychological stabilization, strengthening territoriality and improving regional image. The implications for the allocation of urban park and vegetation, program and management plan of urban park and vegetation to reduce crime occurrence have therefore been presented.

Sensitivity analysis for freight rate change in liner shipping industry - Comparison between slot chartering model and non-collaborating model - (정기선 해운사의 해상운송 요율 변화에 대한 민감도 분석 - 단독 운송과 제휴 운송 비교 -)

  • Chung, Ki-Ho
    • Management & Information Systems Review
    • /
    • v.34 no.4
    • /
    • pp.1-13
    • /
    • 2015
  • This paper presents a mathematical formulation for container slot chartering model through strategic alliance between liner shipping companies. This paper develops a solution procedure to apply the model to real world problems and its applicability is demonstrated by a numerical example. The model presented in this paper has some important features which have never been considered in the previous researches. The model is linear model and pursuits profit maximization. And also it considers slot chartering capacity selection. This paper attempts to perform sensitivity analysis and compares slot chartering model with basic non-collaborating model in which there is no alliance and collaboration. As a result of sensitivity analysis, some interesting findings are obtained; Even though freight rate is more and more decreasing, the profit by slot chartering model is always higher than the basic model but the profit gaps become smaller. But The ratio of the profit gap to the profit of basic model is more increasing.

  • PDF

Mapping and Assessment of Forest Biomass Resources in Korea (우리나라 산림 바이오매스 자원량 평가 및 지도화)

  • Son, Yeong Mo;Lee, Sun Jeoung;Kim, Sowon;Hwang, Jeong Sun;Kim, Raehyun;Park, Hyun
    • Journal of Korean Society of Forest Science
    • /
    • v.103 no.3
    • /
    • pp.431-438
    • /
    • 2014
  • This study was conducted to assess forest biomass resource which is a carbon sink and a renewable resource in Korea. The total forest biomass resource potential was 804 million tons, and conifers, broadleaved forest and mixed forest accounted for 265 million tons, 282 million tons, and 257 million tons, respectively. Proportionately to regional forest stocks, biomass potential of Gangwon-do had most biomass potential, followed by Gyeongsangbuk-do and Gyeongsangnam-do. The woody biomass from the byproduct of sawn timber in commercial harvesting was 707 thousand ton/year, and that from the byproduct of forest tending was 592 thousand ton/year. The amount resulted in about 1,300 thousand ton/year of potential supplies from forest biomass resource into the energy market. It's tonnage of oil equivalent(toe) was 585 thousand ton/year. In this study, we developed a program (BiomassMap V2.0) for forest biomass resource mapping. Used system to develop this program was Microsoft Office Excel, Microsoft Office Access ArcGIS and Microsoft Visual Basic 6.0. Additionally, This program made use of tool such as ESRI MapObjects2.1 in order to take advantage of spatial information. This program shows the map of total biomass stock, annual biomass growth at forest land in Korea, and biomass production from forest tending and commercial harvesting. The information can also be managed by the program. The biomass resource map can be identified by regional and forest type for the purpose of utilization. So, we expect the map and program to be very useful for forest managers in the near future.