摘要
在一维扩散方程加权隐式差分格式的基础上,用初始和边界条件推导确定加权隐式差分方程解的矩阵方程;用MS.Excel的矩阵运算、迭代计算和循环迭代计算功能,确定问题的数值解;巧用MS.Excel的绘制函数图像功能,实现"数""形"及"动"的连贯形式,演示数值解的动态模拟仿真;实现交互性,建立不同加权系数确定的数值解和模拟的平台。结果显示,MS.Excel的计算结果直观、快速、准确、灵活,入门容易、简单,MS.Excel可以作为偏微分方程数值解课程实验和实践教学的一种简单、直观、高效的辅助工具。
Based on the weighted implicit nite scheme of one-dimensional diffusion equation, use initial and boundary conditions determined matrix equations of weighted implicit flnite scheme. Combined use matrix function, iterative calculation and iteration function of MS.Excel to calculate the numerical solution of the problem. Through drawing image and animation visually demonstrated the dynamic solution of problem by using numeric,gure and move coherently. Interactive platform was established to study numerical solution and simulation with different weighted coefficients. The result shows that numerical results which obtained from MS.Excel are not only intuitive, fast and accurate, exible, but also to study easy and simple. So MS.Excel is a simple, intuitive and efficient tools for experimental and practice teaching of Numerical Solution to Partial Differential Equation.
出处
《中国教育技术装备》
2017年第20期40-42,共3页
China Educational Technology & Equipment
基金
新疆大学本科生创新项目的资助
关键词
偏微分方程
MS.Excel
实验和实践教学
partial differential equations
MS.Excel
experimental and practice teaching
