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

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 (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 if you desire. 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.

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. Read the Preface and Chapter 1 in the Strategies for Creative Problem Solving by Fogler and LeBlanc.

A web page describing the CIVL 1101 Excel homework policy is available. Read it before you turn in this assignment. You will be graded throughout the semester according to the policy outlined in it.

Coversheet for homework

This website was originally developed by Charles Camp for CIVL 1101.
This site is Maintained by the Department of Civil Engineering at the University of Memphis.
Your comments and questions are welcomed.