• Title/Summary/Keyword: Excel program

Search Result 241, Processing Time 0.027 seconds

GIS Database and Google Map of the Population at Risk of Cholangiocarcinoma in Mueang Yang District, Nakhon Ratchasima Province of Thailand

  • Kaewpitoon, Soraya J;Rujirakul, Ratana;Joosiri, Apinya;Jantakate, Sirinun;Sangkudloa, Amnat;Kaewthani, Sarochinee;Chimplee, Kanokporn;Khemplila, Kritsakorn;Kaewpitoon, Natthawut
    • Asian Pacific Journal of Cancer Prevention
    • /
    • v.17 no.3
    • /
    • pp.1293-1297
    • /
    • 2016
  • Cholangiocarcinoma (CCA) is a serious problem in Thailand, particularly in the northeastern and northern regions. Database of population at risk are need required for monitoring, surveillance, home health care, and home visit. Therefore, this study aimed to develop a geographic information system (GIS) database and Google map of the population at risk of CCA in Mueang Yang district, Nakhon Ratchasima province, northeastern Thailand during June to October 2015. Populations at risk were screened using the Korat CCA verbal screening test (KCVST). Software included Microsoft Excel, ArcGIS, and Google Maps. The secondary data included the point of villages, sub-district boundaries, district boundaries, point of hospital in Mueang Yang district, used for created the spatial databese. The populations at risk for CCA and opisthorchiasis were used to create an arttribute database. Data were tranfered to WGS84 UTM ZONE 48. After the conversion, all of the data were imported into Google Earth using online web pages www.earthpoint.us. Some 222 from a 4,800 population at risk for CCA constituted a high risk group. Geo-visual display available at following www.google.com/maps/d/u/0/edit?mid=zPxtcHv_iDLo.kvPpxl5mAs90&hl=th. Geo-visual display 5 layers including: layer 1, village location and number of the population at risk for CCA; layer 2, sub-district health promotion hospital in Mueang Yang district and number of opisthorchiasis; layer 3, sub-district district and the number of population at risk for CCA; layer 4, district hospital and the number of population at risk for CCA and number of opisthorchiasis; and layer 5, district and the number of population at risk for CCA and number of opisthorchiasis. This GIS database and Google map production process is suitable for further monitoring, surveillance, and home health care for CCA sufferers.

Development of Movement Analysis Program and its Feasibility Test in Streotactic Body Radiation Threrapy (복부부위의 체부정위방사선치료시 호흡에 의한 움직임분석 프로그램 개발 및 유용성 평가)

  • Shin, Eun-Hyuk;Han, Young-Yih;Kim, Jin-Sung;Park, Hee-Chul;Shin, Jung-Suk;Ju, Sang-Gyu;Lee, Ji-Hea;Ahn, Jong-Ho;Lee, Jai-Ki;Choi, Doo-Ho
    • Progress in Medical Physics
    • /
    • v.22 no.3
    • /
    • pp.107-116
    • /
    • 2011
  • Respiratory gated radiation therapy and stereotactic body radiation therapy require identical tumor motions during each treatment with the motion detected in treatment planning CT. Therefore, this study developed a tumor motion monitoring and analysis system during the treatments employing RPM data, gated setup OBI images and a data analysis software. A respiratory training and guiding program which improves the regularity of breathing was used to patients. The breathing signal was obtained by RPM and the recorded data in the 4D console was read after treatment. The setup OBI images obtained gated at 0% and 50% of breathing phases were used to detect the tumor motion range in crenio-caudal direction. By matching the RPM data recorded at the OBI imaging time, a factor which converts the RPM motion to the tumor motion was computed. RPM data was entered to the institute developed data analysis software and the maximum, minimum, average of the breathing motion as well as the standard deviation of motion amplitude and period was computed. The computed result is exported in an excel file. The conversion factor was applied to the analyzed data to estimate the tumor motion. The accuracy of the developed method was tested by using a moving phantom, and the efficacy was evaluated for 10 stereotactic body radiation therapy patients. For the sine wave motion of the phantom with 4 sec of period and 2 cm of peak-to-peak amplitude, the measurement was slightly larger (4.052 sec) and the amplitude was smaller (1.952 cm). For patient treatment, one patient was evaluated not to qualified to SBRT due to the usability of the breathing, and in one patient case, the treatment was changed to respiratory gated treatment due the larger motion range of the tumor than treatment planed motion. The developed method and data analysis program was useful to estimate the tumor motion during treatment.

Analysis of North Korean Primary English Curriculum (북한의 소학교 영어과 교육과정 분석)

  • Kim, Jeong-ryeol
    • The Journal of the Korea Contents Association
    • /
    • v.20 no.4
    • /
    • pp.582-590
    • /
    • 2020
  • This paper aims to analyze and introduce the primary English curriculum of North Korea reformulated according to the New Educational Program. Sources for analysis are the 4th and 5th primary school English syllabus based on the New Educational Program, explanations of the New Educational Program appeared in People's Education and Kim, Jeong-Il's selected writings. The analytical sources are classified into characteristics, objectives, contents, methods and evaluation. The findings are as follows: The primary English education aims to reach to the basis of middle school English by learning English alphabets and basic English expressions. 4th graders learn basic oral English such as pronunciation, stress and intonation for the first semester and learn English alphabets and their sounds for the second semester. 5th graders learn familiar topics in English and repeatedly practice the important components of English such as pronunciation, vocabulary and grammar. The method is to maintain students' interests in English and encourage students to use classroom English. Also, structural practice is an important part of the method. Evaluation is primarily process-oriented and must motivate students to excel in English rather than fail in English.

Analysis of Weight Maintenance Behavior among Female University Students (여대생 체중유지자들의 일상 생활 습관 분석)

  • Baek, Seol-Hyang;Kim, Eun-Jeong
    • Korean Journal of Community Nutrition
    • /
    • v.12 no.2
    • /
    • pp.150-159
    • /
    • 2007
  • Since the 1980's, despite the conclusion of a number of studies in Western countries focusing upon weight maintenance there has been no similar research in Korea which takes into account the contrasts of culture and eating habits between east and west. In order to identify eating, snacking and exercise behaviors, 24 female university students who have maintained weight for at least a year were enrolled fur an 11 day study. Participants were required to sign into the program and complete the questionnaire, answering questions by concerning what they ate and did everyday. After excluding unanswered questions, data over 11 days were exported into the Microsoft Excel spreadsheet, then both ANOVA and Kendall's tau correlation were applied with SPSS. 75% of weight maintainers had normal BMI (18-23.5) in relation to Korean standard, and appeared to eat a main meal smaller than moderate in portion size. Only two days showed that amount of breakfast eaten negatively correlated with lunch (p < 0.05), while no correlations between amounts of lunch and dinner eaten over all study period. Compared with breakfast or lunch, dinner was usually larger in portion size, but some variables such as TV viewing, restaurant meals, number of people at dinner table seemed not correlated with amount of dinner eaten. In addition, the weight-maintainers reported they rarely consumed snacks or sweetened beverages. Unlike their western counterparts, ffw participants reported that they took part in regular exercise during the day, which may lead us to the conclusion that these young female weight maintainers seem to maintain their weight with eating behaviours such as 'eat small portion', 'avoid snacking' and 'avoid soft drinks' rather than doing regular exercise. The study did not include a control group, and was foreshortened due to technical difficulties so it may be necessary to repeat the study while considering these two points.

Quality of Same-Day Sputum Smears Microscopy and Presumptive Tuberculosis Patients Drop-out at Health Facilities of Addis Ababa, Ethiopia

  • Taddese, Boja Dufera;Misganaw, Abay Sisay
    • Tuberculosis and Respiratory Diseases
    • /
    • v.83 no.1
    • /
    • pp.89-95
    • /
    • 2020
  • Background: Same-day sputum microcopy is recommended in areas where sputum smear microscopy external quality assessment (EQA) is effectively implemented and sturdy. In Addis Ababa, the status of EQA and drop-out of same-day sputum smear microcopy has not yet been assessed. The objective of this study was to assess the quality of same-day sputum smear microscopy and diagnostic drop-out of presumptive tuberculosis (TB) patients in health facilities (HFs) across Addis Ababa, Ethiopia. Methods: Amulti-analysis was conducted from September 2016 to July 2017 to determine the status of external quality assessment and diagnostic drop-out of presumptive TB patients registered for same-day sputum smear microscopy. Data was coded and entered in Microsoft Excel, and subsequently transferred and analyzed using SPSS version 20.0. Results: The drop-out of same-day sputum smear microscopy was 209 (6.2%). More than 33% of the specimens collected for purposes of same-day sputum smears were of poor quality. Among the selected HFs for the study: 13 (46.4%) used filter reagents prior to sputum smear staining while 75% of the selected HFs for the study used smear microscopy services interruption in a year. The sensitivity and specificity of the HFs participating in regional quality assessment scheme for the diagnosis of TB was 97.4% and 99.6%, respectively. Conclusion: The diagnostic drop-out of same-day sputum smear microscopy was high in Addis Ababa. Strengthening EQA, competency-based laboratory professionals training on sputum smear microscopy might reduce the reading errors in sputum smear. Awareness creation of the community on the benefits gained from completion of specimen provision for the same-day approach decreases diagnostic drop-out and enhances TB control program.

Dietary Quality Estimation of Military Foodservice Menu (군 급식 제공 메뉴 분석에 의한 식사의 질 평가)

  • Baek, Seung-Hee;Kim, Soo-Yeon
    • The Korean Journal of Food And Nutrition
    • /
    • v.23 no.4
    • /
    • pp.641-648
    • /
    • 2010
  • This study attempted to estimate the dietary quality and the food diversity by analyzing the military foodservice menu. To evaluate the dietary quality, an analysis of NAR(Nutrient Adequacy Ratio) and MAR(Mean Adequacy Ratio) were carried out. DDS(Dietary Diversity Score), DVS(Dietary Variety Score) and DMGFV(Dairy Product, Meat, Grain, Fruit, Vegetable group) were used for assessment of food diversity. A Can-pro 3.0 and an excel were used for dietary data analysis and SPSS 12.0 program was used for statistical analysis. The results were as follows. The NAR of the 9 nutrients was above the RDAs and MAR was $1.71{\pm}0.19$. For 19 days(61.3%), DDS was 5 and for 12 days(38.7%), DDS was 4. The average of DDS was $4.6{\pm}0.25$. The Fruit & vegetable groups were not often served compared to other groups and especially fresh fruit were not given enough. The average of DVS and DVSS were $22.48{\pm}0.61$ and $29.26{\pm}0.66$ each. The most frequent food pattern was 'DMGFV=11111' which was served for 19 days(61.3%) and second frequent pattern 'DMGFV=11101' was served for 12 days(38.7%). DDS was significantly associated with Vit. C intake and DVS and DVSS was significantly related to Vit. $B_1$ and Vit. $B_2$ intakes. The MAR was significantly correlated with only DVSS. It could be interpreted that DVSS is a useful parameter for evaluating nutrient intakes as previous studies verified. Based on these findings, it can be said that military foodservice was provided with adequate nutrition and diversity. Menu was well composed of various foods which met the nutrition standards, but should provide more fresh fruits for adequate provision of vitamins and minerals.

A Planning Study on the Improvement of Public Hospital Patient Room based on the Understanding of User - Focused on the Case Study of District-Based Public Hospital in Korea (사용자 이해에 기반한 공공병원 병실환경 개선에 관한 계획적 연구 - 지역 거점 공공병원의 사례연구를 중심으로)

  • Oh, Kyoung Mi;Park, Jae Seung
    • Journal of The Korea Institute of Healthcare Architecture
    • /
    • v.20 no.4
    • /
    • pp.49-56
    • /
    • 2014
  • Purpose : This purpose of this study is to make a better public hospital patient room to reflect the views of the patient. Methods: Survey to examine patient experience on healing environment in public hospital have been conducted for the data collection. 229 open-ended answers have been analysed statistically by MS Excel program. Results : 1) If there is no toilet space in the six-patient room, installation of toilet in the patient room is necessary. 2) The most Frequently used patient furnitures are necessary to accomodate the patients needs. Depending on the patient condition, installation of a portable or fixed the room furniture for the convenience to the using furniture. 3) According to the flow of modern times, wireless internet access is required to install of expand the space. Also be used to establish a regulations of internet space. 4) To create healing environment infection free environment should be provided. 5) Need for improvements of patient room for relatives of patient. It is necessary to secure a comfortable space to stay. 6) Separation is needed among the patients through therapeutic classification. Implication : In order to provide a better patient room environment, it is necessary to reflect the patient's opinion.

A Study on the Use of General Social Welfare Facilities for the Planning of Integrated Care Center - Focused on four social welfare facilities in Southern Gyeonggi-do (통합돌봄센터 계획을 위한 고령인구의 종합사회복지관 이용실태 연구 - 경기도 남부 4개 사회복지관을 대상으로)

  • Han, Eunbee;Zhang, Jinxiang;Kwon, Soonjung
    • Journal of The Korea Institute of Healthcare Architecture
    • /
    • v.26 no.2
    • /
    • pp.71-79
    • /
    • 2020
  • Purpose: The purpose of this study is to derive basic data for desirable location and functions of the integrated care center. Methods: Survey, Questionaire and statistical analysis are the main research method of this study. In order to collect data related to utilization pattern and favorite functions of the senior people, researchers have visited 4 social welfare facilities located in Southern Gyeonggi Province. 403 questionaires have been gathered from 4 facilities and they have been analyzed by using Excel Program of MS. Results: First, compared to other services, healthcare services have been preferred by many older people in Social welfare Facilities. This means that integrated care centers providing healthcare services for older people rather than services for children or disabilities is desirable. Second, Integrated Care Centers had better be established within the walk distance of elderly people. If it is not easy, the introduction of shuttle bus for older people is desirable. Especially, in case of large Care Center. Implications: This study shows that small facility with community care rather than big facility is desirable for small community in the point of friendliness, convenience, economy, etc.. However it is necessary to combine welfare service and healthcare service even in small centers.

The Major Causes and Prescriptions for Head Symptoms in Donguibogam Simplified by Network Analysis (동의보감(東醫寶鑑) 두문(頭門) 처방의 네트워크 분석을 통해 간략화한 두부(頭部) 증상의 주요 원인 및 처방)

  • Kim, Cheol-hyun;Chu, Hong-min;Moon, Yeon-ju;Sung, Kang-keyng;Lee, Sang-kwan
    • The Journal of Internal Korean Medicine
    • /
    • v.38 no.6
    • /
    • pp.1000-1006
    • /
    • 2017
  • Objectives: Head symptoms, such as headache and dizziness, are commonly presented in clinical practice. Although Donguibogam, the representative book of Korean medicine, contains many prescriptions for head symptoms, they are difficult to learn and apply because of the vast numbers. The aim of this study was to simplify and visualize the vast contents of Donguibogam by network analysis. Methods: 127 prescriptions for head symptoms, found in Donguibogam, were entered into a Microsoft office Excel 2013 file. This was used as a database for network analysis using the NetMiner 4 program. Results: Through network analysis, six networks for prescriptions for head symptoms in Donguibogam were established. The first network is similar to the herb composition of Cheongsangsahwa-tang (prescriptions for hwa-yeol syndrome). The second network is similar to the herb composition of Yanghyulgupung-tang (prescriptions for hyul-heo syndrome). The third network is similar to the herb composition of Sangcheongbaekbuja-hwan (prescriptions for dam-eum syndrome). The fourth network is similar to the herb composition of Heukseok-dan (prescriptions for yang-heo syndrome). The fifth network is similar to the herb composition of Boheo-eum (prescriptions for chil-jeong syndrome). The sixth network is similar to the herb composition of Bangpungtongseong-san (prescriptions for hwa-yeol syndrome). Conclusions: The results of the network analysis of 127 prescriptions for head symptoms in Donguibogam suggest that there are five major causes of head symptoms (hwa-yeol, hyul-heo, dam-eum, yang-heo, and chil-jeong), and that it is possible to prescribe Cheongsangsahwa-tang, Bangpungtongseong-san, Yanghyulgupung-tang, Sangcheongbaekbuja-hwan, Heukseok-dan, or Boheo-eum depending on the major causes.

The sensibility evaluation of Tone in Tone combination and Tone on Tone combination (톤 인 톤 배색과 톤 온 톤 배색의 감성 평가)

  • Kim, Ji-Hye
    • Science of Emotion and Sensibility
    • /
    • v.13 no.2
    • /
    • pp.301-308
    • /
    • 2010
  • The sensibility effects of color combinations was studied utilizing tone on tone combination and tone in tone combination. A total of 24 color combinations were rated by 10 college students using Semantic Differential Method. The data was analyzed by using Excel statistics program 2004. Analysis method was factor analysis. Theresults of this study were as follow. Color combinations utilizing tone on tone and color combinations utilizing tone in tone was evaluated a very different impression. Thus these were found to have an influence on sensibility effects of color combinations. In comparison with appearance of color combination using colored paper and that of product to apply to color combination using colored paper, it was showed to be evaluated mostly similar impression. However By characteristic with product, shape, size and texture, appearance of color combination is likely to be evaluated very difference impression. The results of these studies will serve as a basis of color combination image or color design.

  • PDF