Solusi Numerik Metode Beda Hingga Aplikasi Excel Untuk Solusi Lendutan Balok Beton Sederhana

Abstract

The use of worksheets in Excel is one of the tools for learning in solving the mathematical problems. At generaly the solution of mathematical problem ussually is solved by the soft ware aplication, that sure used high level programming languages like FORTRAN, BASIC, C++, MATLAB, etc. However the use of worksheet in Excel rather more familiar than using the software aplication for the students. It is caused the students must be able to know how to write the code program that obtained product the listing program. One of the most problematic on civil engineering is about concrete beam structure deflection. The mathematical analysis simple beam structure deflection is presented by the ordinary differential equation second order non linier and the other name it’s called poisson equation. The aim of this article for : (1) To give the learning assistance to the student when they aren’t use the soft ware program and beside to rise creation the application spreadsheet as tool for numerical solution by finite difference method on simple beam deflection. (2) To evaluate the error result comparation of numeric solution and analytic solution.(3)To give the understanding about numerical method that accordance with simple beam deflection problem on civil engineering education and mathematical education.
 Keywords: Fungsi Internal EXCEL, Metode Beda Hingga. Persamaan Garis Elastika.

Solving numerical method problems with mathematical software: Identifying computational thinking

“…Based on this information, it can be inferred that software can effectively assess students' CT skills in solving mathematical problems. This aligns with research conducted by Rodríguez-Martínez et al (2020), which emphasizes the use of mathematical software for developing CT. Additionally, Yoh (2017) suggests that Microsoft Excel is sufficient for solving various problems without the need for programming. Furthermore, Bernard and Senjayawati (2019) state that VBA-based mathematical games for Microsoft Excel can enhance conceptual understanding in learning.…”

Template Metode Numerik Pada Excel Untuk Menemukan Solusi Dari Persamaan Nonlinier

“…Selanjutnya penelitian terdahulu terkait pemanfaatan excel dalam analisis numerik telah dilakukan El-Gebeily & Yushau (2007) dan Chutia et al (2013) untuk topik integral numerik dan interpolasi polinom, Ketkar & Reddy (2003) untuk topik solusi numerik dari persamaan diferensial parsial linier homogen 1 dimensi, Yoh (2017) untuk topik metode beda hingga untuk menemukan solusi dari persamaan diferensial, dan Qomariyatuzzamzami & Kurniasih (2014) dalam menerapkan metode numerik pada rangkaian RLC. Sedangkan pada penelitian ini, berdasarkan kendala dan permasalahan yang dikemukakan di atas, maka dikembangkan template pada excel untuk menjalankan algoritma empat metode numerik untuk menemukan solusi dari masalah persamaan nonlinier, yaitu metode bisection, metode regula falsi, metode Newton dan metode secant.…”