You are the Geotechnical engineering which was appointed to work on a roads project near Bloemfontein. One of you responsibilities is the site laboratory where all the test are conducted.
You are required to write your own excel sheet which must calculate all the Sieve analysis, Atterberg limits, bulk density and CBR results. These results must be used to determine the Colto classification of the soil.
You will be evaluated on how well your excel sheet performs and how professional it looks. The less input data you have to give to calculate the results and determine the COLTO classification the better. You are required to hand in your excel sheet on a CD with your assignment. Please ensure that it is properly attached and will not get lost.
Your assignment should have the following headings:
1. Title page with rubric and student numbers (Note: the rubric must be on your title page and the group member's student Names & numbers or -10%)
2. Introduction and objective
3. Methodology on how to use the COLTO classification
4. COLTO classification excel sheet (Ensure CD is properly attached)
5. Calculation results
6. Conclusion
7. References
8. Minutes and meetings (Note: Minutes and meetings must be in your assignment or -10%)
9. Declaration (Note: the declaration must be in your assignment or -10%)
(NB: the report must be typed in Arial font size 12 with spacing of 1.5)
(Note: -10% if your report is not arial font size 12 with spacing 1.5)
Data obtained in the lab:
1. Material description:
Natural gravel with small boulders.
2. Sieve analysis results:
|
Sieve size (mm)
|
Mass of empty sieve (g)
|
Mass of sieve + soil retained (g)
|
Soil Mass (g)
|
% Retained
|
Cumulative % passing
|
|
53
|
120
|
120
|
|
|
|
|
37.5
|
115
|
115
|
|
|
|
|
26.5
|
117
|
280
|
|
|
|
|
19
|
135
|
295
|
|
|
|
|
13.2
|
131
|
328
|
|
|
|
|
4.75
|
129
|
668
|
|
|
|
|
2
|
121
|
555
|
|
|
|
|
0.425
|
124
|
401
|
|
|
|
|
<0.425
|
120
|
355
|
|
|
|
|
|
|
|
|
|
|
|
Hydrometer Results (Given)
|
|
0.075
|
7.02%
|
|
0.002
|
4.70%
|
3. Atterberg Limits results: (3 - One point tests)
Atterberg Limits on sample (0.425 mm):
|
Atterberg Limits
|
|
|
Date
|
|
2016/07/03
|
|
|
L.L
|
L.L
|
L.L
|
|
P.L
|
P.L
|
|
Tin
|
1
|
2
|
3
|
4
|
5
|
|
Tin (g)
|
14.1
|
14.3
|
14.2
|
14.5
|
14.36
|
|
Tin + Wet Soil (g)
|
20.7
|
20.98
|
21.29
|
18.95
|
19.31
|
|
Tin + Dry Soil (g)
|
19.4
|
19.7
|
19.89
|
18.23
|
18.55
|
|
No. of Blows
|
22
|
28
|
25
|
|
|
|
% Water (MC)
|
|
|
|
|
|
|
Correcting Factor (n/25)0.12
|
|
|
|
|
|
|
Result
|
|
|
|
|
|
4. Bulk Density:
|
Compacted soil sample number
|
|
|
|
|
|
|
MC sample number
|
1A
|
2A
|
3A
|
4A
|
5A
|
|
Moisture can lid number
|
1
|
2
|
3
|
4
|
5
|
|
Mass of can + lid (g)
|
7.7
|
7.5
|
7.88
|
8.2
|
7.81
|
|
Mass of can + lid + moist soil (g)
|
11.8
|
10.05
|
11.12
|
11.34
|
10.3
|
|
Mass of can + lid + dry soil (g)
|
11.6
|
9.87
|
10.85
|
11.05
|
10.01
|
|
Mass of soil solids (g)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Mass of water (g)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Moisture content %
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Mould dimensions:
|
|
Diameter (mm)
|
152
|
151
|
150
|
149
|
150
|
|
Height (mm)
|
151
|
152
|
153
|
153
|
150
|
|
Mould in (cm³)
|
|
|
|
|
|
|
|
|
|
|
|
|
Compacted soil sample number
|
1
|
2
|
3
|
4
|
5
|
|
|
|
|
|
|
|
|
Mass of compacted soil and mould (g)
|
6458
|
6689
|
6899
|
6759
|
6701
|
|
Mass of mould (g)
|
1933
|
1933
|
1976
|
1849.5
|
1782.2
|
|
Mass of compacted soil (g)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Density (g/cm3)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dry density (g/cm3)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Optimum Moisture Content (%)
|
|
|
Maximum Dry density (g/cm³)
|
|
5. CBR:
|
California Bearing Ratio
|
|
Mould
|
6A
|
7A
|
8A
|
|
Mould dimensions:
|
|
Diameter (mm)
|
151
|
152
|
153
|
|
Height (mm)
|
151
|
152
|
153
|
|
Mould in (cm³)
|
|
|
|
|
Mass of mould and wet soil (g)
|
6891
|
6756
|
6709
|
|
Mass of mould (g)
|
2600
|
2330
|
2140
|
|
Loads required at 2.54 mm penetration per mould to determine CBR
|
5.67
|
4.67
|
3.87
|
|
California Bearing Ratio
|
|
|
|
|
|
|
|
|
Mould
|
|
|
M6
|
M7
|
M8
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Density (kg/m3)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dry Density (kg/m3) (OMC=%)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
% Compaction (MDD= kg/m3)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CBR (2.54 mm) (Given)
|
|
|
|
|
|
|
|
|
|
99.0
|
98.7
|
98.5
|
|
% Compaction
|
|
CBR (from graph)
|
|
|
|
|
|
NOTE: All information not given may be reasonably assumed.
Attachment:- Built-Environment.rar