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 on 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 1.23     100.00
    TP1 4.52   6.64  
    TP2 6.78   7.54  
    TP3 3.71   3.25  
    BM2     9.98  

  1. Complete and check the level notes show below by hand calculations.

    Station BS HI FS Elevation
    BM1 4.72     864.38
    TP1 7.12   3.56  
    TP2 9.45   3.78  
    TP3 3.95   4.98  
    TP4 3.15   6.84  
    BM2     1.54  

  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.