• Title/Summary/Keyword: Microsoft Excel

Search Result 177, Processing Time 0.02 seconds

Calculation of Optimum Number of Nurses Based on Nursing Intensity of Intensive Care Units (중환자 간호단위의 간호강도에 근거한 적정 간호사 수 산출)

  • Ko, Yukyung;Park, Bohyun
    • Korea Journal of Hospital Management
    • /
    • v.25 no.3
    • /
    • pp.14-28
    • /
    • 2020
  • Purpose: The purpose of this study was to calculate the total daily nursing workload and the optimum number of nurses per intensive care unit (ICU) based on the nursing intensity and the direct nursing time per inpatient using the patient classification. Methods: Two ICUs at one general hospital were investigated. To calculate the nursing intensity, patient classification according to the nursing needs was conducted for 10 days in each unit during September 2018. We performed patient classifications for a total of 167 patient-days in the Medical Intensive Care Unit (MICU) and 86 patient-days in the Surgical Intensive Care Unit (SICU). The total number of person-days for nurses who responded to the Nursing Time survey was 151 for MICU and 85 for SICU. In each unit, direct and non-direct nursing hours, nursing intensity score, and direct nursing hours were analyzed using descriptive statistics such as frequency, percentage, and average calculated using Microsoft Excel. The amount of nursing workload and the optimum number of nurses were calculated according to the formula developed by the authors. Findings: For the MICU, the average direct nursing time per patient was 5.59 hours for Group 1, 6.98 hours for Group 2, and 9.28 hours for Group 3. For the SICU, the average direct nursing time per patient was 5.43 hours for Group 1, 7.21 hours for Group 2, 9.75 hours for Group 3, and 12.82 hours for Group 4. Practical Implications: This study confirmed that the appropriate number of nurses was not secured in the nursing unit of this study, and that leisure time such as meal time during nursing work hours was not properly guaranteed. The findings suggest that to create working environments where nurses can serve for extended periods of time without compromising their professional standards, hospitals should secure an appropriate number of nurses.

Chemical Risk Assessment Screening Tool of a Global Chemical Company

  • Tjoe-Nij, Evelyn;Rochin, Christophe;Berne, Nathalie;Sassi, Alessandro;Leplay, Antoine
    • Safety and Health at Work
    • /
    • v.9 no.1
    • /
    • pp.84-94
    • /
    • 2018
  • Background: This paper describes a simple-to-use and reliable screening tool called Critical Task Exposure Screening (CTES), developed by a chemical company. The tool assesses if the exposure to a chemical for a task is likely to be within acceptable levels. Methods: CTES is a Microsoft Excel tool, where the inhalation risk score is calculated by relating the exposure estimate to the corresponding occupational exposure limit (OEL) or occupational exposure band (OEB). The inhalation exposure is estimated for tasks by preassigned ART1.5 activity classes and modifying factors. Results: CTES requires few inputs. The toxicological data, including OELs, OEBs, and vapor pressure are read from a database. Once the substance is selected, the user specifies its concentration and then chooses the task description and its duration. CTES has three outputs that may trigger follow-up: (1) inhalation risk score; (2) identification of the skin hazard with the skin warnings for local and systemic adverse effects; and (3) status for carcinogenic, mutagenic, or reprotoxic effects. Conclusion: The tool provides an effective way to rapidly screen low-concern tasks, and quickly identifies certain tasks involving substances that will need further review with, nevertheless, the appropriate conservatism. This tool shows that the higher-tier ART1.5 inhalation exposure assessment model can be included effectively in a screening tool. After 2 years of worldwide extensive use within the company, CTES is well perceived by the users, including the shop floor management, and it fulfills its target of screening tool.

Analysis of Educational Needs for Developing a Consumer-oriented Regular Safety and Health Education Curriculum - Focusing on Management Supervisors (수요자 중심의 산업안전보건교육 과정 개발을 위한 요구분석 -관리감독자 정기안전보건교육을 중심으로-)

  • Choi, Ah Rum;Hwang, Jung ho;Kim, Jina
    • Journal of Korean Society of Occupational and Environmental Hygiene
    • /
    • v.30 no.4
    • /
    • pp.364-375
    • /
    • 2020
  • Objectives: The purpose of this study is to suggest a direction for consumer-oriented curriculum development by analyzing the priorities of subjects and their preference for educational methods. Methods: The participants included 773 management supervisors and education practitioners in the workplace, and a survey was conducted from April 17 to August 30, 2019. Frequency analysis, t-test, Borich's Needs Analysis, and Locus for Focus Model analysis were performed using Microsoft Excel 2019 and IBM SPSS 21.0. Results: The highest perceived priorities for education subjects were as follows: ① 'CPR and First Aid Practice' and 'Occupational Disaster Prevention and First Aid Basics' in the manufacturing industry; and ② 'Emotional Labor and Job Stress Prevention', 'Occupational Disaster Prevention and First Aid basics, and 'Musculoskeletal Disorder Prevention' in the service industry. 'Collective education' was the most preferred method of education. 'School-type' was preferred for the seating arrangement, and the proper number of trainees was considered to be about 30. Respondents said the contents of the education was a top priority when they applied for education, and curriculum and appropriate textbooks should be considered in calculating the cost of education. Conclusions: Practical subjects and subjects related to major hazards by industry were required for management supervisor education. It was proposed in this study that the contents and operating methods of education be changed so that workers can easily comprehend essential subjects such as the Occupational Safety and Health Act. In conclusion, it is necessary to design the curriculum and apply educational methods suitable for each subject's characteristics in consideration of the priorities for subjects reflected in the needs of trainees.

Analysis of Plant Species in Elementary School Textbooks in South Korea

  • Kwon, Min Hyeong
    • Journal of People, Plants, and Environment
    • /
    • v.24 no.5
    • /
    • pp.485-498
    • /
    • 2021
  • Background and objective: This study was conducted to find out the status of plant utilization in the current textbooks by analyzing the plants by grade and subject in the national textbooks for all elementary school grades in the 2015 revised curriculum in Korea. Methods: The data collected was analyzed using Microsoft Office Excel to obtain the frequency and ratio of collected plant data and SPSS for Windows 26.0 to determine learning content areas by grade and the R program was used to visualize the learning content areas. Results: A total of 232 species of plants were presented 1,047 times in the national textbooks. Based on an analysis of the plants presented by grade, the species that continued to increase in the lower grades tended to decrease in the fifth and sixth grades, the upper grades of elementary school. As for the number and frequency of plant species by subject, Korean Language had the highest number and frequency of plant species. The types of presentation of plants in textbooks were mainly text, followed by illustrations and photos of plants, which were largely used in first grade textbooks. In addition, as for the area of learning contents in which plants are used, in the lower grades, plants were used in the linguistic domain, and in the upper grades, in the botanical and environmental domains of the natural sciences. Herbaceous plants were presented more than woody plants, and according to an analysis of the plants based on the classification of crops, horticultural crops were presented the most, followed by food crops. Out of horticultural crops, flowering plants were found the most diversity with 63 species, but the plants that appeared most frequently were fruit trees that are commonly encountered in real life. Conclusion: As a result of this study, various plant species were included in elementary school textbooks, but most of them were horticultural crops encountered in real life depending on their use. Nevertheless, plant species with high frequency have continued a similar trend of frequency from the previous curriculums. Therefore, in the next curriculum, plant learning materials should be reflected according to social changes and students' preference for plants.

A Study on the Competitive Strategies for the Logistics Warehouses of Busan New Port (부산 신항 물류창고의 경쟁력 강화 전략에 관한 연구)

  • Kim, La-Yun;Jung, Jun-Sik
    • Journal of Korea Port Economic Association
    • /
    • v.38 no.2
    • /
    • pp.165-183
    • /
    • 2022
  • The main purpose of this paper is to present a competitive strategies for the Logistics Warehouses of Busan New Port. Based on the survey conducted by the Logistics Warehouses of Busan New Port experts, the categorized factors were compared using the analytic hierarchy process (AHP) to assess the importance of each factor and sub-factor in the case of the Logistics Warehouses of Busan New Port. This is a quantitative study that conducted a face-to-face survey on employees and related public officers at the Logistics Warehouses of Busan New Port. The final sample size consisted of 49 people, including workers at the Busan New Port logistics warehouses and related local customs officers. The data were coded in Microsoft Excel and the imprtance of SWOT factors was derived using "the I make it" program developed by Decision Sience, and it was analyzed using the AHP method. This study quantifies the importance of the strengths, weaknesses, opportunities, and threats factor of the Logistics Warehouses of Busan New Port and presents strategic guidelines for the key factors for the development of the Logistics Warehouses of Busan New Port. This research provides strategic guidelines to Korea for the development of the Logistics Industries, and development of the Logistics Warehouses of Busan New Port.

Impact of Transportation on Air Quality and Carbon Emissions in Developing Countries: A Case of Myanmar (개발도상국의 교통수단이 대기 질 및 탄소배출에 미치는 영향: 미얀마를 중심으로)

  • Wut Yee Lwin;Byoung-Jo Yoon
    • Journal of the Society of Disaster Information
    • /
    • v.19 no.1
    • /
    • pp.231-240
    • /
    • 2023
  • Purpose: The purpose of this study is to analyze air quality and carbon emissions in developing countries, particularly Myanmar, and explore the impact of transportation on CO2 emissions during peak hours relative to free-flow conditions. Method: This study conducted a traffic survey in two major cities in Myanmar to quantify carbon dioxide emissions from the transportation sector, using IPCC's tier 1 and tier 2 approaches, with statistical analysis performed using Python 3 and Microsoft Excel for comparative analysis of critical factors in CO2 emissions. Result: The result of this study is an estimate of the vehicle kilometers traveled (VKT) and fuel consumption in Yangon city for the year 2019, based on data from various sources including the Myanmar Statistical data base, YUTRA project survey, and Ministry of Electric and Energy. The study also analyzes the average travel time index (TTI) for the four roads in Yangon, which indicates the impact of congestion on vehicle travel time and CO2 emissions. Overall, the study provides important insights into the transport sector in Yangon city and can be used to inform policies aimed at reducing greenhouse gas emissions and improving traffic conditions. Conclusion: The study concludes that congestion plays a significant role in increasing fuel use and emission levels in the road transport sector in Myanmar. The analysis provides valuable insights into the impact of the sector on the environment and emphasizes the importance of addressing congestion to reduce fuel use and emissions. However, the study's scope is limited to Yangon city and Mandalay city, and some mean values may not accurately represent the entire country and other developing countries.

A Web-based Survey Research on Clinical Practice Patterns of Korean Medicine Treatment for Degenerative arthritis of hip and finger joints

  • Chang-woo Seon;Ye-jin Hong;Kyung-bok Park;Jeong-rock Kim;Dong-woo Nam;Ye-eun Kim;Min-jeong Kim
    • The Journal of Korean Medicine
    • /
    • v.43 no.4
    • /
    • pp.33-51
    • /
    • 2022
  • Objectives: This study aimed to understand the current status of clinical practice patterns of Korean medicine in the treatment of degenerative arthritis of the hip and finger joints using web-based survey. Methods: An e-mail questionnaire survey was conducted with the Korean Medicine Doctor(K.M.D) registered in the Korean Medicine Association. The survey data were analyzed using Microsoft Excel. Results: Although the response rate of the survey was low, the characteristics of the respondents generally reflected the characteristics of the study population. A total of 35.2% of the respondents had heard of the guidelines; however, they did not use them for medical treatment. The reason as answered by 32.8% of the respondents was "not enough treatment time to check the manual and apply it." More than half (78.80%) answered that they were treating patients with both degenerative hip and finger arthritis; however, the average monthly number of first-time patients was ≤5. A total of 379 (60.9%) respondents answered that "acupuncture is very important," which was the only one that exceeded the majority compared to other treatments. As a result of the safety investigation, "Acupuncture, herbal medicine, cupping" were considered high in safety, while "Pharmacopuncture and Bee venom acupuncture" were considered low in safety. Conclusions: This survey helped to determine the current clinical practice patterns of Korean medicine treatments, further providing basic data for CPGs for degenerative arthritis of the hip and finger joints.

A Survey on the Public's Experience of Medical Use for Developing Korean Medicine Clinical Practice Guideline of Female Infertility (여성 난임 한의표준임상진료지침 개작을 위한 일반인 대상 의료 이용 경험 조사)

  • Sung-Joo Lee;Soo-Hyun Sung;Doing-Il Kim;Young-Jin Yoon;Jang-Kyung Park
    • The Journal of Korean Obstetrics and Gynecology
    • /
    • v.37 no.2
    • /
    • pp.109-119
    • /
    • 2024
  • Objectives: This study is aimed to survey public's experience of medical use for developing Korean medicine clinical practice guideline of female infertility. Methods: The study engaged women who had experienced infertility despite regular conjugal relations, selected from an online survey company's national panel. Participants were surveyed from November 3 to 8, 2021. The questionnaire, developed from prior studies on Korean medicine, was emailed to 29,465 adults; 550 responses were analyzed after exclusions. The study received an IRB exemption from Pusan National University Korean Medicine Hospital and utilized Microsoft Excel for statistical analysis. Results: Among 550 respondents, 32.2% had experienced infertility, predominantly due to unexplained causes (52%). About half had received medical treatment (49.3%), primarily at hospitals and general hospitals (54.2%) and obstetrics and gynecology clinics (49.4%), with Korean medicine facilities also utilized (24.7% for clinics, 14.4% for hospitals). The most common treatments included herbal medicine in Korean medicine and ovulation induction in Western medicine, with most treatments lasting less than six months (71.4%) and costing between 1 to 5 million won (50.5%). Efforts to conceive included lifestyle adjustments such as maintaining a warm lower abdomen, supplement intake, and avoiding alcohol and tobacco. Conclusions: It is necessary that the guidelines be revised to address female infertility and to integrate recommendations for combining Korean medical treatments and Western medical treatments, which will enhance patient care in managing female infertility.

Enhancing Communication on Medication Side Effects: Insights from a Survey Study (의약품 부작용 정보 전달의 중요성: 설문조사 기반 고찰)

  • Ji Hye Choi;Hye Seong Han;Mi Kyong Shim;Hyun Soon Sohn
    • Korean Journal of Clinical Pharmacy
    • /
    • v.34 no.2
    • /
    • pp.126-133
    • /
    • 2024
  • Background: Medication's benefits and harms require careful management. Laws mandate pharmacists to provide essential medication details since inadequate counseling may pose risks. This study explores public expectations for pharmacist-provided side effect information to enhance safety. Methods: A self-developed questionnaire was created for participant to self-report, refined through pilot surveys with experts and laypersons. Nineteen items were categorized into four sections, using closed-ended questions. Adults over 20, having obtained prescription medications within the past year, were surveyed via convenience sampling. Data analysis employed descriptive statistics and T-tests using IBM SPSS Statistics 21 and Microsoft Excel. Results: The study involved 189 participants, with a slightly higher proportion of females (59.3%) than males (40.7%), predominantly in their 20s (45.0%) and college graduates (57.1%). Health professionals represented 76.2% of respondents. Over half visited pharmacies at least 5 times yearly for prescriptions. Indirect experience with side effects was more common (30.2%) than direct experience (17.5%). Most (82.0%) showed interest in media-reported side effect events. Satisfaction with pharmacist-provided side effect explanations was low (59.7%), but importance was high (98.9%). Preferences favored combined verbal and written explanations (65.1%), with a majority desiring explanations for common but less serious side effects (82.5%). Healthcare professionals found explanations significantly more sufficient than non-professionals did. Older individuals, those living with elderly, and frequent pharmacy visitors attributed greater importance to pharmacist-provided explanations. Conclusion: Koreans view pharmacist-provided medication side effect explanations as vital but find current services lacking. Enhancements in content and delivery methods are needed in pharmacy counseling to meet public expectations.

Evaluation of the effectiveness of tell-show-do and ask-tell-ask in the management of dental fear and anxiety: a double-blinded randomized control trial

  • Niharika Reddy Elicherla;Kanamarlapudi Venkata Saikiran;Karthik Anchala;Sainath Reddy Elicherla;Sivakumar Nuvvula
    • Journal of Dental Anesthesia and Pain Medicine
    • /
    • v.24 no.1
    • /
    • pp.57-65
    • /
    • 2024
  • Background: The objective of behavioral guidance is to establish effective communication that aligns with a child's requirements to manage disruptive behavior. This study aimed to evaluate the effectiveness of the Tell-Show-Do and Ask-Tell-Ask techniques in managing dental anxiety in children during their initial appointment. Methods: The study included 50 children (28 boys and 22 girls) without any prior experience between the ages of 7 and 11 at their first dental visit. The children were randomly categorized into two groups: Group 1, Tell Shows Do, and Group 2, Ask-Tell-Ask. Subsequently, all children underwent noninvasive treatment procedures such as restorations, sealants, and oral prophylaxis. Furthermore, behavioral management techniques were employed based on the allocated group. Finally, anxiety levels for all children were assessed using the Raghavendra, Madhuri, and Sujata Pictorial Scale (RMS-PS) and heart rate at three different intervals (before, during, and after). The obtained data were entered into Microsoft Excel, and statistical analysis was performed using SPSS software. A paired t-test and Mann-Whitney U-test were used to compare the mean and median values of the two groups and determine their effectiveness. Results: Children in the TSD group exhibited statistically significant heart rates and RMS-PS scores in intra-group comparisons. However, children in the ask-tell-ask group showed a significant reduction only in the RMS-PS scores (P < 0.001) but not in the measures used to assess heart rate (P < 0.001). Conclusion: Tell-Show-Do was more effective than ask-tell-ask in alleviating dental anxiety in children. The simultaneous application of these two strategies can synergistically alleviate dental anxiety during a child's initial dentist appointment.