摘要
Excel软件作为一款被广泛应用的数据处理办公软件,兼有函数计算、程序设计、数据库编辑及调用等二次开发功能。公路勘测作业数据的处理专业性强、数学模型相对复杂,文章以公路勘测内外业为例,充分利用Excel计算功能和VBA编程功能,论述了Excel在公路勘测实践教学工作中的具体方法和注意事项。通过笔者所在单位教学环节的实践,该方法适用于解决公路勘测工作中数据计算量大、重复性强的实际问题,可以为相关课程课间实训、课程实习提供思路。
As a widely used data processing office software,Excel software has secondary development functions such as function calculation,programming,and database editing and calling.The processing of highway survey operation data is highly professional and the mathematical model is relatively complex.Taking the internal and external business of highway survey as an example,making full use of Excel calculation function and VBA programming function,this paper introduces the specific methods and precautions of Excel in practical teaching of highway survey.Through the practice of teaching links in the author's unit,this method is suitable for solving the practical problems of large amount of data calculation and strong repeatability in highway survey work,and can provide ideas for the inter-class training and course practice of relevant courses.
作者
谈秋英
应楠欣
阮晓光
TAN Qiuying;YING Nanxin;RUAN Xiaoguang(Zhejiang Highway Technician College,Hangzhou,Zhejiang Province,310023 China;Zhejiang University of Water Resources and Electric Power,Hangzhou,Zhejiang Province,310018 China)
出处
《科技资讯》
2023年第5期181-187,共7页
Science & Technology Information
基金
浙江省自然科学基金(项目编号:LZJWY22E090002)。
