Merge Learning: Matrices to Numerical Methods using Excel

Solve linear algebraic equations with Numerical methods using Excel

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.

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.

Course Content

  • Brief introduction of determinants, Cramer’s Rule –> 9 lectures • 53min.
  • Introduction –> 6 lectures • 1hr 8min.
  • Inverse of Matrices –> 8 lectures • 1hr 35min.
  • Introduction to Numerical methods extended from Matrices –> 9 lectures • 1hr 19min.
  • Conclusion –> 1 lecture • 3min.

Auto Draft

Requirements

  • Basic knowledge of matrices and excel.

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:

  1. Introduction to Matrices (includes properties like addition, subtraction, multiplication, adjoint, etc.)
  2. Basic knowledge of determinant, Cramer’s rule (2×2,3×3)
  3. Two ways to find the inverse, and in Excel
  4. normal form and echelon form
  5. normal form and echelon form using Excel.
  6. Introduction to Numerical methods extended from Matrices
  7. Numerical methods of Gauss methods
  8. Gauss-elimination with Excel
  9. Gauss-Jordan with Excel
  10. Gauss-Jacobi and with Excel
  11. Gauss-Seidel collaborating with Excel.