You are the geotechnical engineering which was appointed to

Question

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