Merge Learning – Matrices to Numerical Methods using Excel

Free Download Merge Learning – Matrices to Numerical Methods using Excel
Duration: 4h58m | Video: .MP4, 1280×720 30 fps | Audio: AAC, 44.1 kHz, 2ch | Size: 1.67 GB
Genre: eLearning | Language: English
Solve linear algebraic equations with Numerical methods using Excel
What you’ll learn

Redefine Numerical Methods using Matrices in an interdisciplinary mode
Solve problems related to Numerical Methods using knowledge of Matrices
Analyze the concept of Numerical methods through Matrices
Apply acquired knowledge to problems using Excel
Requirements
Basic knowledge of matrices and excel
Description
The course aims to explore areas, which are otherwise excluded in traditional classroom learning. Matrices are a modern tool in science and technology. Determinant helps to find the consistency of the given matrix. Numerical methods approximate true solutions and are repeatedly applied to better approximate until an accurate solution is obtained. The bridge between Matrices and Numerical methods is narrowed for the students to grasp multi-facet knowledge. The blending of these subjects taught in online mode would bring the learner ease to connect with applications in real-life. The learner is no more restricted to the narrow platform of knowledge. Interdisciplinary approaches are inculcated naturally through this course. The course imbibes the learner to apply in various fields of the study and allows them to think in a broader aspect to bridge the gap between two subjects. The course is designed in two parts. One part of the topic would be about mathematical notations and formulations and second part is designed for solving using excel.
The course consists of:
Introduction to Matrices (includes properties like addition, subtraction, multiplication, adjoint, etc.)
Basic knowledge of determinant, Cramer’s rule (2×2,3×3)
Two ways to find the inverse, and in Excel
normal form and echelon form
normal form and echelon form using Excel.
Introduction to Numerical methods extended from Matrices
Numerical methods of Gauss methods
Gauss-elimination with Excel
Gauss-Jordan with Excel
Gauss-Jacobi and with Excel
Gauss-Seidel collaborating with Excel.
Who this course is for
Undergraduate students can extend classroom learning to practice connecting two different subjects of mathematics using Excel
Homepage

https://www.udemy.com/course/merge-learning-matrices-to-numerical-methods-using-excel/