Merge Learning: Matrices to Numerical Methods using Excel

Merge Learning: Matrices to 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.

The course consists of:

1. Introduction to Matrices (includes properties like addition, subtraction, multiplication, adjoint, etc.)

2. Basic knowledge of determinant, Cramer's rule (2x2,3x3)

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.

Solve linear algebraic equations with Numerical methods using Excel

Url: View Details

What you will 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

Rating: 5

Level: Intermediate Level

Duration: 5 hours

Instructor: Dr. V. R. Lakshmi Gorty