采用电子表格实现通信原理仿真的研究  

Research on Communication Principle Simulation with Spreadsheet

作　　者：张建明[1] 王毅[1] 欧浩源[1] ZHANG Jianming;WANG Yi;OU Haoyuan(Guangdong Polytechnic,Foshan 528041,China)

机构地区：[1]广东职业技术学院,广东佛山528041

出　　处：《现代信息科技》2021年第6期66-69,共4页Modern Information Technology

基　　金：广东省高职教育精品在线开放课程建设项目(300358);广东省高职教育教学改革研究与实践项目高职扩展专项(JGGZKZ2020097);广东职业技术学院校级教育教学改革项目(XJJG201941);广东职业技术学院继续教育网络课程项目(K202109)。

摘　　要：通信原理的概念抽象难懂且数学计算复杂,教学过程中普遍采用商业工具进行原理仿真。为了实现低成本、便于操作的通信原理仿真,提出了采用普通的电子表格直接建模仿真通信原理的方法。先分层实现通信系统中各个模块的功能,再组合一起模拟通信仿真。仿真过程中可直接在电子表格的单元格中查看所有数据(也可以通过图表展示),提高了学习者分析问题、解决问题的能力。and difficult to understand,and the mathematical calculation is complex.In the teaching process,commercial tools are widely used for principle simulation.In order to realize the simulation of communication principle with low cost and easy operation,a method of modeling and simulating communication principle with common spreadsheet is proposed.Firstly,the function of each module in the communication system is realized hierarchically,and then they are combined to simulate communication simulation.In the process of simulation,all data can be viewed directly in the cells of the spreadsheet(or can be displayed through charts),which improves learners’ability on analyzing problems and solving problems.

关 键 词：通信原理 电子表格 仿真教学 单元格 

分 类 号：TN911[电子电信—通信与信息系统]