• Title/Summary/Keyword: EXCEL

Search Result 829, Processing Time 0.033 seconds

A Comparative Analysis of Patient Visibility, Spatial Configuration and Nurse Walking Distance in Korean Intensive Care Units(ICUs) - Focused on single corridor, Pod and Composite type units

  • Ullah, Ubaid;Park, Jae Seung
    • Journal of The Korea Institute of Healthcare Architecture
    • /
    • v.22 no.4
    • /
    • pp.37-45
    • /
    • 2016
  • Purpose: The purpose of this paper is to analyze a sample of single corridor, pod type and composite type of ICUs in terms of patient visibility, spatial configurations and nurse walking distance focused on Korean cases. Methods: The measures of static visibility were used to quantify the patient visibility (upper third part of the patient bed) from the nurse station. The measure of space programme and area distribution (patient zone percentage, staff zone percentage, circulation zone percentage, corridor length per bed, distance from nurse station (NS) to patient bed and departmental gross square meter (DGSM) per patient bed) were calculated by using AutoCAD and MS Excel programs. In the second step of analysis the values of space distribution were compared among the three type of ICUs as well as the nurse walking distance, DGSM per bed and gross factor. in the third step of analysis regression analysis was conducted for the possible correlation between visibility and space programme and area distribution factors as well as nurse walking distance factors. Results: (1) It was found that on average composite type unit offer highest value of patient visibility followed by pod type, while single corridor type unit offers the minimum value of patient visibility among the three plan typologies. (2) Average patient visibility and DGSM per bed shows a strong positive correlation ($r^2=0.75$) and p=0.026. (3) Average patient visibility and average distance from NS has a strong negative correlation ($r^2=0.78$), and P=0.02. (4) On average composite type unit offer the minimum walking distance from NS (7.22 meter) followed by pod type unit (8.35 meter) and single corridor (9.76 meter). (5) Maximum distance from NS was noted in single corridor (18.19 meter) followed by pod type unit (15.14 meter) and Composite type unit (11.1 meter). Implications: This study may contribute to the visibility analysis of existing and future ICU design in Korea to achieve maximum patient visibility and reduced nurse walking distance.

THE REMINERALIZATION ASPECT OF ENAMEL ACCORDING TO CHANGE OF THE DEGREE OF SATURATION OF THE ORGANIC ACID BUFFERING SOLUTION IN pH 5.5 (pH 5.5에서 유기산 완충용액의 포화도 변화에 따른 법랑질의 재광화 양상)

  • Park, Jin-Sung;Park, Sung-Ho;Park, Jeong-Won;Lee, Chan-Young
    • Restorative Dentistry and Endodontics
    • /
    • v.35 no.2
    • /
    • pp.96-105
    • /
    • 2010
  • The purpose of this study is to observe and compare the remineralization tendencies of artificial enamel caries lesion by remineralization solutions of different degree of saturations at pH 5.5, using a polarizing microscope and computer programs (Photoshop, Image pro plus, Scion Image, Excel). For this study, 48 sound permanent teeth with no signs of demineralization, cracks, or dental restorations were used. The specimens were immersed in lactic acid demineralization solution for 2 days in order to produce artificial dental caries that consist of surface and subsurface lesions. Each of 9 or 10 specimens was immersed in pH 5.5 lactic acid buffering remineralization solution of four different degrees of saturation (0.507, 0.394, 0.301, and 0.251) for 12 days. After the demineralization and remineralization, images were taken by a polarizing microscope (${\times}100$). The results were obtained by observing images of the specimens, and using computer programs, the density of caries lesions were est mated. While the group with the lowest degree of saturation (0.251) showed total remineralization feature from the surface to the subsurface of the lesion, the group with the highest degree of saturation (0.507) showed demineralization mainly on the surface of the lesion at the constant organic acid concentration 0.01 M and pH 5.5.

The recognition of sexual violence of in Daegu local college students, and relations of sexual education on the coping with sexual violence (대구지역 전문대학생들의 성폭력 인식도 및 성교육이 성폭력 대처에 미치는 관련요인)

  • Kim, Sung-Woo
    • The Journal of Korean Society for School & Community Health Education
    • /
    • v.12 no.2
    • /
    • pp.13-27
    • /
    • 2011
  • Objectives: This study aims to analyze recognition and problems of in Daegu local college students on sexual violence and figure out major factors to prevent sexual violence and to use as necessary basic resources for the improvement of individual and social recognition and effective sexual education. Methods: The Data from 255 students (85%) out of 300 excluding questionnaires with insufficient answers were under analysis using Excel Program and SPSS Win 17.0 for cross-tabulations and correlation analysis. Significance test were performed using $x^2$-test. Results: 1) As to recognition of sexual violence by gender, 88.2%(60) of male and 91.4%(171) of female students conceived the current sexual violence level is hazardous which shows female students had slightly higher recognition. 2) As to recognition of sexual education by gender, both conceived it for equipping proper value system of sex(55.9% of male & 61.5% of female student). 3) As to prevention and coping with sexual violence by gender, 58.8% of male students and 65.2% of female students answered that prevention is possible. 4) As to the correlation between sexual violence factors, it showed positive (+) correlation in the experience of sexual education and the recognition of sexual violence level, in the recognition of sexual violence level and the recognition of sexual violence responsible scope, and in the possibility of sexual violence prevention and the recognition of sexual crime prevention law. 5) As to the recognition and measurement by experience of sexual education, among those who answered the current sexual violence level was hazardous 91.8% had previous sexual education experience and 83.3% had no experience. 6) As to the recognition and measurement of sexual violence by experience of sexual violence (self-determination), those with sexual education experience (79.8%) had little experience in sexual violence than those with not (91.6%). 7) As to the recognition and measurement of sexual violence by the possibility of preventing sexual violence, it showed statistically significant difference in the reason of increase of sexual violence(p<0.01). Conclusions: Accordingly, to provide systematic and sustainable sexual education, individualized education considering gender, individual development rather than standardized group education in its teaching method is necessary, and follow-up evaluation and feed-back system should be implemented to assess achievement and recognition of sexual education.

  • PDF

Analysis of Factors Related to Regional Occurrence Distribution of Scrub Typhus: 2012~2016 (우리나라 쯔쯔가무시증의 지역적 발생분포와 관련된 요인 분석: 2012~2016년)

  • Seo, Choong Won
    • Korean Journal of Clinical Laboratory Science
    • /
    • v.51 no.4
    • /
    • pp.420-427
    • /
    • 2019
  • Scrub typhus is a fever-related disease that is commonly diagnosed during the autumn season. The number of patients affected by this disease continues to increase every year. However, the cause of the disease and the regional differences of its incidence are poorly understood. This study examined the epidemiological features and regional differences in the incidence of scrub typhus. The monthly incidence of cases from all reports rose to more than 90% during the fall season (October~December). Based on the analysis of the 18,851 cases in the epidemiological investigation, 14,777 (78.4%) and 4,074 (21.6%) cases occurred in high and low occurrence areas, respectively. Moreover, there were more female cases than male cases (males: 7,233 [38.4%]; females: 11,618 [61.6%]; P< 0.001). The clinical symptoms, including fever, chills, myalgia, and eschar of the body, were noted in 16,688 (89.1%), 11,533 (61.2%),11,439 (60.7%), and 6,005 (45.4%) cases, respectively. The incidence rates were higher for Gyeongnam, Jeonam, Jeonbuk, and Chungnam provinces. The areas with a high occurrence of scrub typhus were consistent with the areas experiencing a high distribution of Leptotrombidium scutellare. The incidence of scrub typhus has been rising owing to the increasing population of ticks due to global warming and increased agricultural and outdoor activities. Thus, continuous management of patients and preventive environmental measures are needed to control this disease.

Demonstrating Critical Issues and Finding New Directions in Art Education for Gifted Learners (미술영재교육 쟁점 분석을 통한 방향 모색 - A 예술고등학교의 사례에 기초하여 -)

  • Kang, Joohee;Lee, Jiyeon
    • Journal of Gifted/Talented Education
    • /
    • v.23 no.3
    • /
    • pp.355-371
    • /
    • 2013
  • While many research focused learners as those who excel in mathematics or science, the identification of learners with potential or demonstrated talent in visual art has also been the meaningful research topic. Since these learners exhibit high performance capability in intellectual, creative and artistic areas, they require services or programs not ordinarily provided by the schools. This research tried to clarify what high performance means when speaking of learners with outstanding talent in the visual arts based on the relevant literature. Also, this research introduced the recent trends in the field of art gifted and talented education. In order to demonstrate critical issues and find new directions in art education for gifted learners, this research conducted the survey, and this survey target group was arts high school students. Based on the survey analysis, this research conducted the semi-structured interviews with focal participants including the teachers and an artist. Interviewees generated many meaningful issues, and interview analysis reconceptualized art education for gifted learners as following. 1) Gifted education should consider learners' excellence, equity, troubles, and struggles that often go unnoticed. 2) We should reform the criteria, standards, and strategies in finding art gifted learners. 3) In order to facilitate meaningful and creative art education, higher education institutions need to change the current college entrance exam. 4) The goal of gifted art education is not only raising the world-class artists. 5) Meaningful art education for gifted learners is in interaction with the environment including group dynamics, parents influence, and teachers.

A Study of the Nonlinear Characteristics Improvement for a Electronic Scale using Multiple Regression Analysis (다항식 회귀분석을 이용한 전자저울의 비선형 특성 개선 연구)

  • Chae, Gyoo-Soo
    • Journal of Convergence for Information Technology
    • /
    • v.9 no.6
    • /
    • pp.1-6
    • /
    • 2019
  • In this study, the development of a weight estimation model of electronic scale with nonlinear characteristics is presented using polynomial regression analysis. The output voltage of the load cell was measured directly using the reference mass. And a polynomial regression model was obtained using the matrix and curve fitting function of MS Office Excel. The weight was measured in 100g units using a load cell electronic scale measuring up to 5kg and the polynomial regression model was obtained. The error was calculated for simple($1^{st}$), $2^{nd}$ and $3^{rd}$ order polynomial regression. To analyze the suitability of the regression function for each model, the coefficient of determination was presented to indicate the correlation between the estimated mass and the measured data. Using the third order polynomial model proposed here, a very accurate model was obtained with a standard deviation of 10g and the determinant coefficient of 1.0. Based on the theory of multi regression model presented here, it can be used in various statistical researches such as weather forecast, new drug development and economic indicators analysis using logistic regression analysis, which has been widely used in artificial intelligence fields.

Development of a Tree Ring Measuring Program Using Smartphone-Captured Images (스마트폰 촬영 이미지를 활용한 나이테 검출 및 분석 프로그램 개발)

  • Kim, Dong-Hyeon;Kim, Tae-Lee;Cho, Hyung-Joo;Kim, Dong-Geun
    • Journal of Korean Society of Forest Science
    • /
    • v.109 no.4
    • /
    • pp.484-491
    • /
    • 2020
  • In this study, to solve the existing inefficient stem analysis process and expensive equipment cost problems, a method for detecting and analyzing tree rings using smartphone images was proposed and a semi-automated computer program (TRIO, Tree Ring Information) was developed. TRIO can measure the annual ring radius and save the results to Excel. Since TRIO uses smartphone images, the results may vary depending on the quality of the smartphone camera. Therefore, using the Samsung Galaxy S10 and Tap 2, 30 dics images of Pinus rigida were acquired and analyzed, and these were compared with WinDENDROTM. As a result of the study, both Samsung Galaxy S10 and S2 showed significant results with WinDENDROTM, and the R2 value of S10 had a high correlation as 0.976, and RMSE was analyzed as 0.4199, and very similar results were output. The R2 value of S2 was 0.975 and the RMSE was 0.4232, showing no significant difference from S10. Accordingly, the TRIO developed in this study analyzed the annual radius value very similar to WinDENDROTM.

Veterans Hospital Medical Expenses Increase & Decrease Characteristics and Convergence Phenomenon-Focusing on the implications of the medical support system for national veterans-

  • Yu, Tae Gyu
    • International Journal of Advanced Culture Technology
    • /
    • v.9 no.1
    • /
    • pp.16-21
    • /
    • 2021
  • As the average age of national veterans has increased from 69 years old(2011) to 71 years old(since 2015) over the past five years, the overall medical service cost of veterans has increased by about 20%. The main cause of this phenomenon is 'ultra-aging', which accounts for 67% of veterans, while the proportion of health insurance patients aged 70 or older is 9%. Therefore, it is judged that the analysis of the trend of use of medical services at veterans hospitals in each region that is in charge of severe medical services of national veterans can serve as an opportunity to seek countermeasures for the severe medical system of national veterans. First of all, based on the details of major medical expenses (hospitalization, outpatient, pharmaceutical expenses) by region for the last 10 years(2010-2019), data significance was performed through a chi-square test, and the Central Veterans Hospital and Non-Central Veterans Hospital using EXCEL. 'Expected frequency' was calculated by year. By applying the CHITEST(observation frequency, expected frequency) function again, the p-value(p<0.05) was calculated, and the profit bias of each region's veterans hospital could be determined. The specific research method is for the last 10 years(2010-2019) for state-sponsored patients_outpatient treatment income, state-sponsored patients_hospitalization income, exempt patients_outpatients at the Central Veterans Hospital, Busan Veterans Hospital, Gwangju Veterans Hospital, Daegu Veterans Hospital, and Daejeon Veterans Hospital. A one-way analysis of variance was conducted to verify the significance of the difference between group averages on the status of 5 medical revenues of veterans hospitals in each of the 5 regions, including medical treatment income, reduced patients_hospitalization income, and reduced patients_medicine expenses. It was found to be significant(p<0.05) at all levels, including region and type. Finally, the bias in the profit structure of regional veterans hospitals was the highest in 2017(p=0.0004) and the lowest in 2013(p=0.0349). In addition, in the profit structure of the Veterans Hospital, the year in which the'regional' variable worked the most was 2019, and the year with the least affected was 2010. The order of the former is Jungang(=31,674,713), Busan(=12,314,614), Gwangju(=11,957,038), Daegu(=10,168,015), and Daejeon(=6,991,034), and the order of the latter is Jungang(=57,868,791), and Busan(=19,183,194). Gwangju(=17,904,712), Daegu(=15,656,034), and Daejeon(=14,377,395). In conclusion, the profit bias of veterans hospitals repeatedly raced the lowest(p=0.01986) and highest(p=0.03499) for the past five years(2010-2014) year by year, with the 'regional' variable being the most in the veterans hospital's profit structure It was identified as a major influence factor. On the other hand, for the last 5 years (2015-2019), the influence factors of the'regional' variable every year were in 2015(p=0.02015), 2016(p=0.01741), 2017(p=0.00045), and 2018(p=0.00394). in 2019(p=0.00227), a significant difference was confirmed at a very low level.

Calculation of Expected Life of Hydrogen Pressure Vessels by Fracture and Fatigue Mechanics assuming Semi-elliptical Cracks and Analysis of the Effect of Thickness and Radius (반타원형 균열을 가정한 파괴 및 피로역학에 의한 수소 압력용기의 예상 수명 계산과 두께와 내경이 미치는 영향 분석)

  • Kim, Jeong Hwan;Lee, Hwa Young;Lee, Min-Kyung;Lee, Jae-Hun;Lyu, Geunjun
    • Journal of the Korean Institute of Gas
    • /
    • v.25 no.6
    • /
    • pp.53-65
    • /
    • 2021
  • While the hydrogen refueling station is rapidly expanded and installed, the safety inspection of the hydrogen pressure vessel in the station should be very important. Of these, according to ASME, hydrogen embrittlement tests must be performed for hydrogen vessel that store hydrogen above a certain pressure. The main test method for hydrogen embrittlement inspection is to carry out fracture tests and fatigue fracture tests in a high pressure hydrogen atmosphere, which allows the durability limit of the pressure vessel to be measured and the endurable limit to be determined in the hydrogen atmosphere. In detail, the critical crack depth can be calculated by the stress intensity factor(K), and the service life can be determined by da/dN (fatigue growth rate). API579-1/ ASME FFS-1 part 9 exemplifies the calculation method according to the mode of crack-like flaws, but for various shapes such as plates and cylinders, there are about 55 modes according to the shape and location of the crack. Due to the fairly complex formula, it is not easily accessible. In this study, we will show you how to calculate fracture mechanics numerically via Excel and VBA. In addition, this was applied to analyze the effects of the thickness and inner diameter of the pressure vessel on the service life.

Translation and Cross-Cultural Adaptation Study on a Korean of Sensory Processing Measure Home Form (가정용 Sensory Processing Measure(SPM)의 국내적용을 위한 번역연구)

  • Lee, Hye-Rim;Yoo, Eun-Jung;Kim, Kyeong-Mi
    • The Journal of Korean Academy of Sensory Integration
    • /
    • v.19 no.3
    • /
    • pp.22-31
    • /
    • 2021
  • Purpose : This study aimed to conduct a translation, backtranslation, and content validity test of the Sensory Processing Measure (SPM) for Korean children. Methods : The translation and content validation process involved direct and backward translation; a test of equivalence between the two versions (the original SPM and the Korean version SPM; K-SPM) was performed using content-related evidence collected by a group of experts and a group of parents. Data analysis was carried out using Excel Content validity indices (CVI), mean, and standard deviation were used for the analysis of content validity. Results : The result of the comparison between the original SPM and K-SPM in the group of experts was 3.54 ± .74, the S-CVI/Avg for semanticity was .92, and the S-CVI/Avg for structure was .86. The results for the mean of the understanding test and the S-CVI/Avg were 3.48 ± .63 and .94, respectively. Conclusion : K-SPM will considerately be used as an assessment to identify sensory processing, praxis, and social participation issues for children in Korea. Further studies are suggested to increase the age range and the sample size for a more comprehensive applicability of the K-SPM to Korean children.