CIVL 1101 - Assignment #3

 Name: ________________________

 

"Not everything that counts can be counted, and not everything that can be counted counts"  - Albert Einstein

Objective

The purpose of this assignment is twofold. First, you will have an opportunity to practice your skills on developing a contour map from data recorded from a differential leveling survey; and second, you will get a chance to practice your skills in developing simple engineering spreadsheets for surveying applications.

Problems

Part 1. Table 1 lists the elevations (in feet) at the corners of each 50-ft square grid cells. Develop a contour map for the two left-most cells in the top row of the grid elevation data. for these two cells, draw 2-ft interval contours using a scale of 1 inch = 25 feet. Remember to following the homework format; however, you may use a different type and size of paper to present your contour map if you desire. Clearly identify your solution methodology and discuss the strengths and weaknesses of your solution. If you have any questions, please contact Dr. Camp.

Table 1. Elevation data for 50' x 50' grid.

A B C D E
1 64.8 67.1 69.3 71.2 67.4
2 66.8 69.1 70.9 71.5 69.2
3 67.2 70.7 71.1 72.8 69.7
4 63.3 66.5 68.1 68.2 66.6

Show all the details of your calculations for the two left-most cells in the top row of the grid above. For the remaining cells, you may just show your final linear interpolations for the contour lines. Make sure that you label each contour line with the appropriate value of the elevation.

Part 2. Use the graphing capabilities of Excel to develop a contour map from the data listed in Part 1.  Include a North arrow and contour line labels on your plot. Hand in a printout of spreadsheet containing the graph (no printout of formulas is required).

Part 3. Use WORD or some other word processing software to prepare a title page and a Table of Contents for the Project #1 Final Report. To develop a sample table of contents, use the heading structure as defined in the content evaluation criteria and assume page numbers for each section. See the report guidelines for details on the the report format.

Part 4. Read the Preface and Chapter 1 in the Strategies for Creative Problem Solving by Fogler and LeBlanc.