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 in 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.

You must hand in a copy of the cover sheet for the assignment, your solutions to Part 1 on engineering paper, and printouts of your spreadsheet for Part 2 and the Word document for Part 3. Also, you must submit your Excel spreadsheet for Part 2 and your Word document for Part 3 to Canvas.

Problems

Part 1.Table 1 lists the corner elevations (in feet) of each 50-ft square grid cell. Develop a contour map for the two left-most cells in the top row of the grid elevation data (indicated by green in Table 1). For these two cells, draw 2-ft interval contours using a scale of 1 inch = 25 feet. Remember to follow the homework format; however, you may use a different type and size of paper to present your contour map. Identify your solution methodology and discuss the strengths and weaknesses of your solution. If you have any questions, please get in touch with contact Dr. Camp.

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

A B C D E
1 69.1 65.6 61.9 58.3 53.1
2 67.6 63.2 57.6 55.0 52.3
3 64.7 60.3 55.7 53.8 50.9
4 61.3 59.7 56.8 52.4 49.8

Show all the details of your calculations for the two left-most cells in the top row of the grid above.

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. Upload a copy of your Excel spreadsheet to the HWK #3 dropbox in eCourseware.

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

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