"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 its strengths and weaknesses. If you have any questions, please get in touch with 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 Canvas.

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.

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

Cover sheet 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.