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 shown 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 shown 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 backsight (BS) and foresight (FS) data. 

     

  2. Use your spreadsheet to compute the elevations from backsight (BS) and foresight (FS) data.