"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. 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. 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 |
Part 2. Use the graphing capabilities of Excel to
develop a contour map from the data listed in Table 1. Include a North arrow
and contour line labels on your plot. Hand in a printout of your spreadsheet
containing the graph and submit your spreadsheet via 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.
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 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.
|