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.