|
"The man who knows it all has lots to learn" - Unknown
Objective
The purpose of this assignment is twofold: first, you will have an
opportunity to practice your skills in computing elevations 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 the cover
sheet for
the assignment, your solutions to Parts 1 and 2,
and printouts of your spreadsheet for Parts 3
and 4. Also, submit your spreadsheet for Parts 3
and 4 to Canvas.
Problems
-
Complete and check the level notes show below by hand
calculations.
| Station |
BS |
HI |
FS |
Elevation |
| BM1 |
3.10 |
|
|
100.00 |
| TP1 |
6.44 |
|
9.82 |
|
| TP2 |
8.76 |
|
6.86 |
|
| TP3 |
7.12 |
|
3.27 |
|
| BM2 |
|
|
10.44 |
|
-
Complete and check the level notes show below by hand
calculations.
| Station |
BS |
HI |
FS |
Elevation |
| BM1 |
7.432 |
|
|
864.384 |
| TP1 |
7.121 |
|
1.862 |
|
| TP2 |
6.946 |
|
6.733 |
|
| TP3 |
5.397 |
|
6.491 |
|
| TP4 |
4.312 |
|
4.682 |
|
| BM2 |
|
|
5.111 |
|
-
Develop a spreadsheet to compute the elevations from
back sight (BS) and fore sight (FS) data.
Your spreadsheet should look similar to one shown
below.
-
Use your spreadsheet to compute the elevations from
back sight (BS) and fore sight (FS) data.
Requirements
Your name and assignment number should appear in the top left corner
of the spreadsheet. The date should appear in the top right corner of the spreadsheet.
Lastly, 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.
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.
|
