June 14, 2009
June 14, 2009
June 17, 2009
14.647.1 - 14.647.11
Geometric Design of Highway Vertical and Horizontal Curves Using Excel
This paper presents the work that was developed as a project in the first offering of the transportation engineering class at the new civil engineering program at Indiana University- Purdue University Fort Wayne. The project statement required the use of Excel in developing a program for highway geometric design; from simple curves to compound curves; both vertical and horizontal. In addition, the goal of this project was linked to ABET outcomes that address the ability of students to design a system, component, or process to meet desired needs within realistic constraints and, measure student’s ability to use the techniques, skills, and modern engineering tools necessary for engineering practice.
The paper presents the process of developing the spreadsheet step-by-step, the command used, challenges, and skills and lessons learned by the author and other student in the class. As a result, a simple and efficient spreadsheet to design vertical curves and simple and compound horizontal curves including default values was developed.
The results of the survey suggested a major improvement of students’ skills in Excel in general and in developing engineering design in particular. Major improvements were found in using functions and nested If statements. The least skills acquired were in using the Absolute and Sum commands and graphing in Excel. Most of the students either knew these commands before the class or they were familiar with them. Finally, this project enabled students to advance their knowledge of spreadsheets while learning important transportation engineering topics.
McNair, B., & Ashur, S. (2009, June), Geometric Design Of Highway Vertical And Horizontal Curves Using Excel Paper presented at 2009 Annual Conference & Exposition, Austin, Texas. https://peer.asee.org/5818
ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2009 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015