Merge Learning: Matrices to Numerical Methods using Excel

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