|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/merge-learning-matrices-to-numerical-methods-using-excel/
课程评论：没有评论
课程名称：融合学习：使用Excel的矩阵与数值方法 课程概述： 本课程旨在探索传统课堂学习中通常被忽视的领域。矩阵是科学和技术中的现代工具，行列式帮助确定给定矩阵的一致性。数值方法则通过不断逼近真实解来求解问题，直到获得准确解。课程将矩阵与数值方法的桥梁缩小，帮助学生掌握多方面的知识。在线授课的方式使学习者更容易与现实生活中的应用相结合，打破狭窄的知识平台。课程自然而然地融入跨学科的方法，让学生在各个研究领域中应用所学，并以更宽广的视角思考，弥合两个学科之间的差距。课程分为两个部分：第一部分涵盖数学符号和公式，第二部分则以Excel进行解决。 课程内容包括： 1. 矩阵入门（包括加法、减法、乘法、伴随矩阵等性质） 2. 行列式的基本知识，克拉默法则（2x2，3x3） 3. 计算逆矩阵的两种方法及Excel使用 4. 正常形式和阶梯形式的介绍及在Excel中的应用 5. 基于矩阵的数值方法导论 6. 高斯方法 7. 使用Excel的高斯消元法 8. 使用Excel的高斯-乔丹法 9. 使用Excel的高斯-雅可比法 10. 使用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 Excelnormal form and echelon formnormal form and echelon form using Excel. Introduction to Numerical methods extended from MatricesNumerical methods of Gauss methodsGauss-elimination with ExcelGauss-Jordan with ExcelGauss-Jacobi and with ExcelGauss-Seidel collaborating with Excel.
