• Title/Summary/Keyword: EXCEL

Search Result 829, Processing Time 0.027 seconds

Composition of Visit-customized Movement Program Utilizing Care Workers for the Home-cared Elderly with Dementia (방문요양보호사를 활용한 재가 치매노인대상 방문 맞춤형 움직임 프로그램 구성요소)

  • Hong, Misung
    • 한국체육학회지인문사회과학편
    • /
    • v.58 no.5
    • /
    • pp.201-217
    • /
    • 2019
  • The purpose of this study was to consider composition of the movement program for the elderly with dementia to develop visit-customized movement program. For the study, 20 experts were selected including 8 dance therapists, 2 dementia-specialized doctors, 5 physical education leaders of the elderly, and 5 geriatric care helpers. First Delphi data, which listed items, was used to analyze content. Second and third Delphi questionnaires, which evaluated importance in Likert scale, was used to calculate content validity rate, average, standard deviation, quartile, convergence degree, and concurrence degree of each composition. 46 core composition of movement program for the elderly, which were selected and highlighted by the experts, were departmentalized into 6 considered compositions of movement program. 7 required composition of movement program, 1 Appropriate frequency of 3 times in a week and 1 30 minutes for each exercise, 1 operation method, 5 appropriate exercise of rhythm expression, 4 appropriate aerobic exercise, 4 appropriate muscle exercises, 5 appropriate stretches, 3 appropriate partner exercises 4 Appropriate massages, 5 appropriate tools

Survey of Point-of-Care Testing Devices for Pre-hospital EMS Equipment of Glucometer on Local Area (지역 EMS의 현장검사 혈당측정기 사용에 대한 실태조사)

  • Byeong-Hyun, Kim;Dai-Hai, Choi;Gyoung-Yim, Ha
    • Journal of agricultural medicine and community health
    • /
    • v.47 no.4
    • /
    • pp.220-228
    • /
    • 2022
  • Objective: glucometer is one of POCT(point-of-care testing) devices used by EMS. Accurate measurement value is important for patient decision making. Quality control is necessary for this, but most EMS are still using glucometer without quality control it. Therefore, management status and quality control status of glucometers used by 119 paramedics waswere investigated. Methods: 6 and 8 of glucometers and blood glucose test strips were submitted from 4 safety centers in 2010 and 8 safety centers in 2012, respectively. Glucometers submitted by local safety centers were analyzed in 2010 and 2012. The control glucometer, which was well managed at A University Hospital, was assumed to be accurate for at blood glucose measurement. Glucose values of various quality control materials control solutions were measured and analyzed using linear regression and Pearson's correlation test. Error rates were obtained via error tolerance range required by the 2011 ISO(International Organization for Standardization) guideline. For statistics, Excel and MedCalC programs were used. Results: mong 14 safety centers in the region, 4 centers(28.5%) in 2010 and 8 centers(57.1%) in 2012 submitted 6 and 8 glucometers. In the first evaluation in 2010, 2 out of 6(33.3%) glucometers were untestable due to error, and 45 out of 6(66.683.3%) blood glucose test strips' validity were expired. In the second evaluation in 2012, 1 out of 8(13.5%) glucometers were untestable due to lack of battery, and 2 out of 8(25%) blood glucose test strips' validity were expired. All correlation coefficients were above 0.989 in 2010 and above 0.997 in 2012. Error rates were generally high when using expired blood glucose test strips. Conclusion: Among 119 paramedics' guideline, quantity and operation status of POCT devices are well managed, but quality control is not. Therefore, it is necessary to add management status and quality control status of POCT devices to the EMS' field work guideline.

Elementary, Middle and High School Parents' Awareness of School Garden Education Service

  • Hong, In-Kyoung;Yun, Hyung-Kwon;Jung, Young-Bin;Lee, Sang-Mi;Lee, Choon-soo
    • Journal of People, Plants, and Environment
    • /
    • v.24 no.2
    • /
    • pp.169-178
    • /
    • 2021
  • Background and objective: Education based on agricultural experience in school gardens is coming to the fore as a solution to reduce the negative effect of rapid urbanization and the development of information technology (IT) on students. Accordingly, this study aimed to investigate how parents of elementary, middle, and high school students in Korea perceive the value of education service using school gardens, as well as their willingness to participate in and pay for such service, and to utilize the results in a quantitative assessment of the socioeconomic value of the education service. Methods: A contactless online survey on the perceived value of education service using school gardens was conducted on 1,010 parents of elementary, middle, and high school students in Korea's five major districts from October 22 to 26 (5 days) of 2020 by M, a Korean specialized survey agency. The data collected was analyzed using SPSS for Windows 25.0 and Excel to obtain the frequency and ratio of each measured item. Results: The respondents had an average of 1.83, of which 52.8% were male. 55.3% of the respondents were aware of the education service using school gardens, and 27.9% experienced the service. When asked if they saw the educational service using school gardens as necessary, 79% answered in the affirmative. In terms of the difference in perception of the need for the service according to experience, 91.8% of the parents who experienced the service responded that it was necessary, indicating that it is important to provide opportunities to experience this service to expand the scope of service. 54.9% of all respondents responded they were willing to pay the costs required for school gardens. When income tax was used as a payment method, the average amount parents were willing to pay was 13,193 KRW, and the tax rate was 2.02%. Based on experience, those who experienced this service had a higher need and willingness to pay for the service than those who had not experience, but the actual amount or tax rate was low as they knew how it was operated. Conclusion: As basic research on the assessment of the value of agricultural experience education using school gardens, this study determined how parents perceive this form of education service as well as their willingness to participate and pay for the service. These findings can be used to systemize the assessment indicators and promote the value of the education service using school gardens, allowing students to maintain a healthy and happy school life through agricultural experience.

Classification of submitted nuclear medicine dissertation and directional consideration (핵의학 투고 논문 분류 및 방향성 고찰)

  • Ho-Yeon, Cho;Yeong-Ran, Woo;Kang-Rok, Seo;Gun-Chul, Hong
    • The Korean Journal of Nuclear Medicine Technology
    • /
    • v.26 no.2
    • /
    • pp.37-42
    • /
    • 2022
  • Purpose Since 1985, the Korean society of nuclear medicine technology (KSNMT) has been engaged in academic activities related to nuclear medicine imaging. From 2017 to 2021, the papers published in the journal were classified by the specific fields to examine the trends in the research and the direction of nuclear medicine in comparison with the papers submitted to the Korean Society of Nuclear Medicine (KSNM) during the same period. Materials and Methods From 2017 to 2021, papers submitted to KSNMT and KSNM were classified and databaseization using the Excel program by submission type, examination equipment, and examination field. Through this data, the number of papers published in journals by year, the number of papers submitted by detailed fields, and key words by era were analyzed and compared. Results The papers included by journal was 57 KSNMT and 280 KSNM. The major large classification of equipment, PET, Planar and SPECT was 26.3%, 21.1%, 19.3% in the KSNMT, KSNM was 49.6%, 6.4%, and 9.3%, with 66.7% and 65.3%, respectively. the major medium classification of equipment, industrial safety, urogenital system, nervous system, and quality control accounted for 54.4% of the total papers of the total ratio in the KSNMT, while the medium classification of oncology, endocrine system, urogenital system, therapy, and nervous system accounted for 61.1% of KSNM. In the major small classification of image acquisition, improvement effect, and exposure management accounted for 70.2% in KSNMT, while the items of image acquisition, report, and improvement effect accounted for 60.7% in KSNM. The major keywords except for equipment-related keywords such as PET/CT, PET/MR, and SPECT were SUV, Planar Image, and Respiration Gating Method in KSNMT and Ga68, Thyroid, and Lymphoma in the KSNM. Conclusion When checking the last 5 years of submissions, we can see that KSNMT is mainly concerned with image acquisition using existing radiotracers, while KSNM has focused on new radiotracers such as 68Ga, 177Lu, etc., and new medical technologies of theranostic. It has been confirmed that more PET-related papers than other examination equipment will account for a greater number of papers, and it is believed that future submissions will also account for a higher proportion of PET-related papers than other equipment.

The Analysis of Professional Education Needs for the Competencies of Occupational Therapists in Cognitive Rehabilitation: Focusing on the Professors in Occupational Therapy Departments of Universities/Colleges in Korea (작업치료사의 인지재활 직무역량에 대한 교육요구도 분석: 국내 대학 작업치료(학)과 교수자를 중심으로)

  • Hong, Seung-Pyo;Lee, Hee-Ryoung;Han, Dae-Sung;Ju, Yu-Mi;Kim, Young-Geun
    • Therapeutic Science for Rehabilitation
    • /
    • v.12 no.3
    • /
    • pp.45-59
    • /
    • 2023
  • Objective : This study aims to identify the status of education in cognitive rehabilitation (CR) in occupational therapy departments of Korean universities/colleges and to analyze the educational needs for professional competencies. Methods : This study was conducted by distributing a questionnaire to professors. The questionnaire extracted items related to professional competencies from the results of a previous Delphi study. A total of 39 respondents from 32 (51.6%) of 62 universities/colleges were analyzed. The questionnaire analysis was conducted using Excel 2010 and SPSS 18.0 to analyze the Borich requirements and the priority of education through the Locus for focus model. Results : The priority of competency in CR was followed by "clinical reasoning ability to explain cognitive problems from the occupational performance perspective", "ability to manage insurance billing for CR", "ability to establish a CR plan based on outcome evaluation", "ability to perform occupation-oriented CR", and "ability to solve problems that occur during CR evaluation and intervention". In the Locus for focus model, items such as occupation-based cognitive assessment, intervention, and skills for documentation were high priorities for education. Conclusion : This study is expected to reflect educational competencies for CR and establish a plan for CR specialists through continuing education.

Priority Area Prediction Service for Local Road Packaging Maintenance Using Spatial Big Data (공간 빅데이터를 활용한 지방도 포장보수 우선지역 예측 서비스)

  • Minyoung Lee;Jiwoo Choi;Inyoung Kim;Sujin Son;Inho Choi
    • Journal of Intelligence and Information Systems
    • /
    • v.29 no.3
    • /
    • pp.79-101
    • /
    • 2023
  • The current status of local road pavement management in Jeollabuk-do only relies on the accomplishments of the site construction company's pavement repair and is only managed through Microsoft Excel and word documents. Furthermore, the budget is irregular each year. Accordingly, a systematic maintenance plan for local roads is necessary. In this paper, data related to road damage and road environment were collected and processed to derive possible areas which could suffer from road damage. The effectiveness of the methodology was reviewed through the on-site inspection of the area. According to the Ministry of Land, Infrastructure and Transport, in 2018, the number of damages on general national roads were about 47,000. In 2019, it reached around 38,000. Furthermore, the number of lawsuits regarding the road damages were about 93 in 2018 and it increased to 119 in 2019. In the case of national roads, the number of damages decreased compared to 2018 due to pavement repairs. To measure the priorities in maintenance of local roads at Jeollabuk-do, data on maintenance history, local port hole occurrence site, overlapping business section, and emergency maintenance section were transformed into data. Eventually, it led to improvements in maintenance of local roads. Furthermore, spatial data were constructed using various current status data related to roads, and finally the data was processed into a new form that could be utilized in machine learning and predictions. Using the spatial data, areas requiring maintenance on pavement were predicted and the results were used to establish new budgets and policies on road management.

Acquisition and Analysis of Environmental Data for Smart Farm (스마트팜 생육환경 데이터 획득 및 분석)

  • Seok-Ho Han;Hoon-Seok Jang
    • The Journal of Korea Institute of Information, Electronics, and Communication Technology
    • /
    • v.16 no.3
    • /
    • pp.130-137
    • /
    • 2023
  • Smart farms, which have been receiving attention as a solution to recent rural problems, refer to technologies that optimize the growing environment of crops and increase the productivity and quality of crops through efficient management. If the relationships between environmental data in smart farms are analyzed, additional productivity enhancement and crop management will be possible. In this paper, we propose a method for acquiring and analyzing nine environmental data, including temperature, humidity, CO2, soil temperature, soil moisture, insolation, soil EC, EC, and pH. Data acquisition is done through RS-485 communication between the main board and the sensor board and stored in the database after acquisition. The stored data is downloaded in Excel sheet format and analyzed through histograms, data charts, and correlation heatmaps. First, we analyze the distribution of total, day, and night data through histogram analysis, and identifiy the average, median, minimum, and maximum values by month through data chart analysis separating day and night to see how the data changes by month. Finally, we analyze the correlation of the data through a correlation heatmap analysis separating day and night. The results show a very strong positive correlation between temperature and soil temperature and soil EC and EC during the day, and a very strong positive correlation between temperature and soil temperature and soil EC and EC at night, and a strong negative correlation between temperature and soil EC.

A Study on the Effects of Franchise's Factors and Performance : Analysis Disclosure Agreement (프랜차이즈 가맹본부의 특성과 가맹점 사업 성과간의 영향에 관한 연구 : 정보공개서를 중심으로)

  • Lee, Eun-Ji;Cho, Chul-Ho
    • The Korean Journal of Franchise Management
    • /
    • v.3 no.2
    • /
    • pp.20-38
    • /
    • 2012
  • After being introduced into franchises industry, franchise has made a phenomenal growth in a short time and a substantial contribution to job creation and economic revitalization. Nevertheless, franchise business operators failed a business or low profit because of a lack of information and indiscriminate foundation. Therefore the first object of this study is characteristics of franchise's factors on disclosure agreement in franchise associate website. second is examinations about casual relationship between factor and franchise performance with using Excel and SPSS 18.0 versions. The findings of present study were as follows. First, franchises manage small business mostly(financial data, scale so on) and franchise's type focused the food service industry. Specially, a business district select unprotected contract. Second, in franchise's factors, we could find statistically significant effect on annual average sales and annual average net profit. However growth rate of franchise don't have statistically significant effect. Third, we could find statistically significant difference on analysis both franchises' factors and financial data. In conclusion, we must consider of franchise industry environment and success effect on performance in starting one's business. Furthermore franchises plan ways for their sustained growth and protection of rights and interests. Finally business operator draw up their information and upgrade continuously for franchises industry growth. Discussion and theoretical and managerial implications of the results were described along with future franchise research suggestions.

Optimized Hardware Design using Sobel and Median Filters for Lane Detection

  • Lee, Chang-Yong;Kim, Young-Hyung;Lee, Yong-Hwan
    • Journal of Advanced Information Technology and Convergence
    • /
    • v.9 no.1
    • /
    • pp.115-125
    • /
    • 2019
  • In this paper, the image is received from the camera and the lane is sensed. There are various ways to detect lanes. Generally, the method of detecting edges uses a lot of the Sobel edge detection and the Canny edge detection. The minimum use of multiplication and division is used when designing for the hardware configuration. The images are tested using a black box image mounted on the vehicle. Because the top of the image of the used the black box is mostly background, the calculation process is excluded. Also, to speed up, YCbCr is calculated from the image and only the data for the desired color, white and yellow lane, is obtained to detect the lane. The median filter is used to remove noise from images. Intermediate filters excel at noise rejection, but they generally take a long time to compare all values. In this paper, by using addition, the time can be shortened by obtaining and using the result value of the median filter. In case of the Sobel edge detection, the speed is faster and noise sensitive compared to the Canny edge detection. These shortcomings are constructed using complementary algorithms. It also organizes and processes data into parallel processing pipelines. To reduce the size of memory, the system does not use memory to store all data at each step, but stores it using four line buffers. Three line buffers perform mask operations, and one line buffer stores new data at the same time as the operation. Through this work, memory can use six times faster the processing speed and about 33% greater quantity than other methods presented in this paper. The target operating frequency is designed so that the system operates at 50MHz. It is possible to use 2157fps for the images of 640by360 size based on the target operating frequency, 540fps for the HD images and 240fps for the Full HD images, which can be used for most images with 30fps as well as 60fps for the images with 60fps. The maximum operating frequency can be used for larger amounts of the frame processing.

Methods for Quantitative Disassembly and Code Establishment of CBS in BIM for Program and Payment Management (BIM의 공정과 기성 관리 적용을 위한 CBS 수량 분개 및 코드 정립 방안)

  • Hando Kim;Jeongyong Nam;Yongju Kim;Inhye Ryu
    • Journal of the Computational Structural Engineering Institute of Korea
    • /
    • v.36 no.6
    • /
    • pp.381-389
    • /
    • 2023
  • One of the crucial components in building information modeling (BIM) is data. To systematically manage these data, various research studies have focused on the creation of object breakdown structures and property sets. Specifically, crucial data for managing programs and payments involves work breakdown structures (WBSs) and cost breakdown structures (CBSs), which are indispensable for mapping BIM objects. Achieving this requires disassembling CBS quantities based on 3D objects and WBS. However, this task is highly tedious owing to the large volume of CBS and divergent coding practices employed by different organizations. Manual processes, such as those based on Excel, become nearly impossible for such extensive tasks. In response to the challenge of computing quantities that are difficult to derive from BIM objects, this study presents methods for disassembling length-based quantities, incorporating significant portions of the bill of quantities (BOQs). The proposed approach recommends suitable CBS by leveraging the accumulated history of WBS-CBS mapping databases. Additionally, it establishes a unified CBS code, facilitating the effective operation of CBS databases.