中文摘要：

混凝土结构设计原理是高等院校土木工程专业最重要的课程之一。根据工程应用型本科院校的教学特点和实际情况，以混凝土结构设计原理课程中大、小偏压构件为例，将Excel软件强大的建模计算功能融入土木工程专业混凝土结构设计原理课程教学，并对课程教学改革进行了探索。该应用加深了学生对偏压构件的认识，激发了学生学习混凝土结构设计原理课程的兴趣，收到了良好的课堂教学效果，也为将来j学业设计以及工作中方便、熟练应用Excel软件奠定了基础。

英文摘要：

Concrete structure design principle is one of main courses of civil engineering major in colleges and universities. According to characteristics of engineering-application-oriented colleges and the actual situation of colleges and universities, and taking the design of large eccentricity compressive members and small eccentricity compressive members as examples, the way of teaching reform of civil engineering major was explored by applying the modeling calculation function into the concrete structure design principle teaching. Students＇ study interest was stimulated and the teaching effect was improved. Applying Excel software in the course teaching can also make students skilled in using Excel in graduation design and work in the future.