Geometric Design Of Highway Vertical And Horizontal Curves Using Excel

Conference

2009 Annual Conference & Exposition

Location

Austin, Texas

Publication Date

June 14, 2009

Start Date

June 14, 2009

End Date

June 17, 2009

ISSN

2153-5965

Conference Session

Innovation in the Civil Engineering Classroom

Tagged Division

Civil Engineering

Page Count

11

Page Numbers

14.647.1 - 14.647.11

DOI

10.18260/1-2--5818

Permanent URL

https://peer.asee.org/5818

8112

Abstract NOTE: The first page of text has been automatically extracted and included below in lieu of an abstract

Geometric Design of Highway Vertical and Horizontal Curves Using Excel

Abstract

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. 10.18260/1-2--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