• Title/Summary/Keyword: spreadsheets

Search Result 41, Processing Time 0.024 seconds

Prediction of post fire load deflection response of RC flexural members using simplistic numerical approach

  • Lakhani, Hitesh;Singh, Tarvinder;Sharma, Akanshu;Reddy, G.R.;Singh, R.K.
    • Structural Engineering and Mechanics
    • /
    • v.50 no.6
    • /
    • pp.755-772
    • /
    • 2014
  • A simplistic approach towards evaluation of complete load deflection response of Reinforced Concrete (RC) flexural members under post fire (residual) scenario is presented in this paper. The cross-section of the RC flexural member is divided into a number of sectors. Thermal analysis is performed to determine the temperature distribution across the section, for given fire duration. Temperature-dependent stress-strain curves for concrete and steel are then utilized to perform a moment-curvature analysis. The moment-curvature relationships are obtained for beams exposed to different fire durations. These are then utilized to obtain the load-deflection plots following pushover analysis. Moreover one of the important issues of modeling the initial stiffness giving due consideration to stiffness degradation due to material degradation and thermal cracking has also been addressed in a rational manner. The approach is straightforward and can be easily programmed in spreadsheets. The presented approach has been validated against the experiments, available in literature, on RC beam subjected to different fire durations viz. 1hr, 1.5hrs and 2hrs. Complete load-deflection curves have been obtained and compared with experimentally reported counterparts. The results also show a good match with the results obtained using more complicated approaches such as those involving Finite element (FE) modeling and conducting a transient thermal stress analysis. Further evaluation of the beams during fire (at elevated temperatures) was performed and a comparison of the mechanical behavior of RC beams under post fire and during fire scenarios is made. Detailed formulations, assumptions and step by step approach are reported in the paper. Due to the simplicity and ease of implementation, this approach can be used for evaluation of global performance of fire affected structures.

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

Mathematical Discovery and Justification through Modeling Activity in Spreadsheet Environment (스프레드시트 환경에서 모델링 활동을 통한 수학적 발견과 정당화)

  • Son, Hong-Chan;Lew, Hee-Chan
    • School Mathematics
    • /
    • v.7 no.4
    • /
    • pp.427-444
    • /
    • 2005
  • The Purpose of this study is to explore he mathematical discovery and justification of six 10th grade students through mathematical modeling activities in spreadsheet environments. The students investigated problem situations with a spreadsheet, which seem to be difficult to solve in paper and pencil environment. In spreadsheet environments, it is easy for students to form a data table and graph by inputting and copying spreadsheet formulas, and to make change specific variable by making a scroll bar. In this study those functions of spreadsheet play an important role in discovery and justification of mathematical rules which underlie in the problem situations. In modeling activities, the students could solve the problem situations and find the mathematical rules by using those functions of spreadsheets. They used two types of trial and error strategies to find the rules. The first type was to insert rows between two adjacent rows and the second was to make scroll bars connecting specific variable and change the variable by moving he scroll bars. The spreadsheet environments also help students to justify their findings deductively and convince them that their findings are true by checking various cases of the Problem situations.

  • PDF

An Establishment of Greenhouse Gas Information System using Excel Spreadsheets (엑셀 스프레드시트를 활용한 온실가스 정보시스템 구축)

  • Lee, Hae-Jung;Chung, Young-Bae
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.40 no.4
    • /
    • pp.129-136
    • /
    • 2017
  • Climate change is the biggest environmental issue of our times. A variety of activities to reduce greenhouse gas emissions have been in progress to observe the Kyoto Protocol. Especially, the Energy Target Scheme is created to reduce greenhouse emission with the supervision of Korean government. This includes Green-house Gas Information Systems to promote activities in the private sector to reduce green-house gas emissions, to cut a cost of energy use, and to reduce GHG emissions. Also, the system has calculated the amount of greenhouse gases. Without any additional investment, 2.75% savings are increased over the previous year. In service sector, a cooperation of customers and employees is necessary. A reduction of GHG emissions requires a proper service organization, considering an amount of investment and payback period. Without any additional investment or replacement, employees can save energy easily turning off ventilation systems an hour before employees' departure, installing timers to turn off water purifiers and vending machines after some period of no use. The Green-house Gas Information System is similar to that of Environmental Management System. However, the Excel is the best program to calculate an amount of green-house gas emissions, and to assess for a reduced amount of GHG emissions. A goal of this research is to propose a practical method in the private sector to calculate an amount of green-house gases. The Green-house gas Information System based on Excel spreadsheet gives standards for good evaluation. The greenhouse gas information system establishes and executes the policies and objectives related to greenhouse gas emissions Similar to ISO 14001 environment management system structures, the advantages of using simplified Excel Sheet for calculating GHG emissions and reducing GHG emissions are easy to access.

ICT and the Changing Nature of Work: Work Fragmentation (ICT와 업무의 변화 - 일의 파편화 관점에서 -)

  • Lee, Seyoon;Park, Jun-Gi;Lee, Jungwoo
    • Informatization Policy
    • /
    • v.21 no.1
    • /
    • pp.35-56
    • /
    • 2014
  • Information and communication technologies(ICT) allow and force people to work anywhere, anytime using remote databases and application systems available in real-time twenty four hours a day and seven days a week. With the real time nature of ICT, individual work is becoming more and more fragmented. Instead of working on a similar task repeatedly, individuals are required to respond to e-mails and inquiries through social networks, work on planning documents, work on presentation documents, work on spreadsheets, input necessary data on company databases, generate necessary reports from the database, run teleconference, etc., all maybe in a day's work. Work fragmentation may impact negatively on productivity as the flow is interrupted, but it may increase the productivity by allowing people to handle multiple tasks in a shorter time period. This study explores the types of work fragmentation and their characteristics. An online survey was administered to collect data about work fragmentation and work characteristics including autonomy, complexity, flexibility, usage of ICT, etc. 300 cases were used in the analysis. Analysis of k-mean cluster indicated four different types of work fragmentation: concentrated, temporally distributed, spatially distributed, and fully fragmented.

Trend of ICT Education in Korea and Analysis of Overseas Cases (국내 ICT 교육 동향 및 해외 사례 분석)

  • Woo, Seokjun;Koo, Dukhoi
    • 한국정보교육학회:학술대회논문집
    • /
    • 2021.08a
    • /
    • pp.261-267
    • /
    • 2021
  • This study examines the purpose and goals of ICT education, compares them with current software and artificial intelligence-oriented information curriculum, analyzes foreign SW curriculum, extracts learning topics and elements, and analyzes whether the current information curriculum is presented effectively. As a result of the analysis, the number of information-related courses in Korea is currently lower than in other countries, which has reduced the number of basic computer applications and underlying software applications such as presentations and spreadsheets covered in ICT training in the past. In addition, compared to Korea's curriculum where information education begins in the fifth grade of elementary school, other countries are introducing information education from the first grade to the third grade of elementary school. Therefore, active discussions on the expansion of the number of information education, the timing of introduction of information education, and the utilization of basic computers are needed.

  • PDF

Utility of three-dimensional printing in the surgical management of intra-articular distal humerus fractures: a systematic review and meta-analysis of randomized controlled trials

  • Vishnu Baburaj;Sandeep Patel;Vishal Kumar;Siddhartha Sharma;Mandeep Singh Dhillon
    • Clinics in Shoulder and Elbow
    • /
    • v.27 no.1
    • /
    • pp.72-78
    • /
    • 2024
  • Background: Clinical outcomes after fixation of distal humerus intraarticular fractures are directly related to the quality of reduction. The use of three-dimensional (3D)-printed fracture models can benefit preoperative planning to ensure good reduction. This review aims to determine if surgery performed with 3D printing assistance are faster and result in fewer complications and improved clinical outcomes than conventional methods. We also outline the benefits and drawbacks of this novel technique in surgical management of distal humerus fractures. Methods: A systematic literature search was carried out in various electronic databases. Search results were screened based on title and abstract. Data from eligible studies were extracted into spreadsheets. Meta-analysis was performed using appropriate computer software. Results: Three randomized controlled trials with 144 cases were included in the final analysis. The 3D-printed group had significantly shorter mean operating time (mean difference, 16.25 minutes; 95% confidence interval [CI], 12.74-19.76 minutes; P<0.001) and mean intraoperative blood loss (30.40 mL; 95% CI, 10.45-60.36 mL; P=0.005) compared with the conventional group. The 3D-printed group also tended to have fewer complications and a better likelihood of good or excellent outcomes as per the Mayo elbow performance score, but this did not reach statistical significance. Conclusions: Three-dimensional-printing-assisted surgery in distal humerus fractures has several benefits in reduced operating time and lower blood loss, indirectly decreasing other complications such as infection and anemia-related issues. Future good-quality studies are required to conclusively demonstrate the benefits of 3D printing in improving clinical outcomes.

The Analysis on Utilization Trend of the Technology in Secondary Mathematics Textbooks Based on the $6^{th}$, $7^{th}$ and 2007 Revised Curriculum in Korea (교육과정에 따른 중등 수학과 교과서에서 공학 도구 활용의 변화 분석)

  • Kim, Mi Hwa;Son, Hong Chan
    • School Mathematics
    • /
    • v.15 no.4
    • /
    • pp.975-994
    • /
    • 2013
  • In this paper, we analyzed the utilization trend of technology in the secondary mathematics textbooks based on the 6th, 7th and 2007 revised mathematics curriculums in Korea. We analyzed 30, 60 and 90 mathematics books based on the 6th, 7th and 2007 revised mathematics curriculums respectively. The analysis focused on three aspects of using technology, i.e., contents areas in which technology used, technological tools and programs used, and methods of using technology in teaching and learning mathematics. The results shows that the frequency of using technology in mathematics books has been increased as mathematics curriculum has been revised. In the mathematics books based on th 6th curriculum, only 25 scenes were found, but in 7th and 2007 revised curriculum 248 and 355 scenes were found. In the 6th curriculum, calculators and graphing calculators were used mainly, but in the 7th and 2007 revised curriculum many kinds of technological tools and softwares were used including CAS, dynamic geometry software, spreadsheets, programming language, and the Internet. Especially the internet was used frequently in the 7th curriculum. And the methods of using technology has been diversified as time passed. In the 6th curriculum, the technology mainly used for introducing technology and simple calculation, but in the 7th and 2007 revised curriculum the technologies and software were also used for understanding mathematical laws, principles and concepts and students-centered exploring the mathematical properties.

  • PDF

Comparison of the accuracy of digital impressions and traditional impressions: Systematic review (디지털 인상법과 전통적 인상법의 정확도 비교: 체계적 고찰)

  • Kim, Kyoung-Rok;Seo, Kweonsoo;Kim, Sunjai
    • The Journal of Korean Academy of Prosthodontics
    • /
    • v.56 no.3
    • /
    • pp.258-268
    • /
    • 2018
  • Purpose: This study systematically examines literatures on the suitability of prostheses and accuracy of obtained impressions to see if digital impressions using intraoral scanners can replace traditional impressions. Materials and methods: A MEDLINE/PubMed search and manual search was performed for studies written in English about accuracy of digital impression published in dental journals from August 1, 1997, to July 31, 2017. Depending on criteria, the data for the selected articles were independently organized into standardized spreadsheets by 2 reviewers. Results: Among the total 35 studies met the inclusion criteria, there were 26 studies comparing the suitability of prostheses, and 9 studies comparing the accuracy of impressions through scan data without prostheses. Most studies used prostheses to compare the accuracy of impression techniques. Conclusion: This review suggests that making single crown or mesio-distally short prostheses with digital impressions is clinically reliable in natural teeth. However, there is still a limit to making mesio-distally long prostheses with digital impressions from the lack of related studies. Digital impression cannot fully replace traditional impressions in implant prostheses yet.

COBie Document Prototype for supporting BIM based Smart Maintenance of Buildings (BIM 기반 건축물 스마트 유지관리 지원 COBie 문서 프로토타입)

  • Koo, Kyo-Jin;Park, Sang-Hun;Cho, Dong-Hyun
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.20 no.12
    • /
    • pp.60-68
    • /
    • 2019
  • For effective building maintenance, the collection and management of various maintenance date such as work history information and material information is required. Despite the introduction of information management technologies and systems to reduce the amount of maintenance work of buildings, which have become larger and more complex, the maintenance information is not being utilized properly. As an alternative, research on the introduction and utilization of BIM is being conducted continuously. However, the BIM models generated at the design phase are not utilized in practice due to a lack of architectural maintenance information. This study proposed a COBie document prototype to support BIM-based smart maintenance tasks performed by building managers. In order to formalize various types of maintenance work procedures, a BIM-based maintenance process model is presented in two categories: inspection and maintenance. Among the BIM attribute data of the BIM model generated at the design phase, the parameters corresponding to the maintenance necessary information for each basic process are derived. Based on this, we proposed a COBie document prototype consisting of seven spreadsheets. The results of a case study confirmed that the KBIMS library-based BIM model created at the design phase without the maintenance information can be used at the maintenance phase.