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:
Introduction to Matrices (includes properties like addition, subtraction, multiplication, adjoint, etc.)
Basic knowledge of determinant, Cramer's rule (2x2,3x3)
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.
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
Courses By: 0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
About US
The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.
View Sitemap