CIVL 1101 - Assignment #2

 Name: ________________________
"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.

Problems

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

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

  1. Develop a spreadsheet to compute the elevations from back sight (BS) and fore sight (FS) data. 

  2. Use your spreadsheet to compute the elevations from back sight (BS) and fore sight (FS) data.