Calculate all the sieve analysis

Reference no: EM131421607 , Length: 20

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/cm³)

Dry density (g/cm³)


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/m³)


Dry Density (kg/m³) (OMC=%)


% Compaction (MDD= kg/m³)


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

Reference no: EM131421607

Questions Cloud

Review the skill builder : Unit of Analysis and the Skill Builder: Levels of Measurement, which you can find by navigating back to your Blackboard Course Home Page. From there, locate the Skill Builder link in the left navigation pane.

Write basic information about syria : Write Basic information about Syria. This first briefing should be an introduction to your AOI(Area of Interest). After that, I want to know what is my AOI known for?

Function of the telecommunications component : Which of the following is NOT a function of the telecommunications component?

Recognize the major turning points in american history : After the Civil War, the United States became a much more industrialized society. Between 1865 and 1920, industrialization improved American life in many ways. However, industrialization also created problems for American society. Consider events ..

Calculate all the sieve analysis : 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.

The budget cuts of late have encouraged : The budget cuts of late have ”encouraged” Contracting Officers to more heavily favor “price” when evaluating proposals – and often stipulate “lowest technically acceptable” proposal evaluation criteria. What are some of the “unintended consequences” ..

What provision of first amendment applies to issue you have : What provision of the First Amendment applies to the issue you have defined? Analyze the case, applying the law to the facts of the case.

Positive-helpful behaviors would help morale within group : Explain how group cohesiveness influences productivity. How would you control or manage those who were harming the group's productivity and morale? Identify two additional animals you'd like to recruit to your group and why. What positive and helpful..

Describe how you would approach discussion of your topic : After choosing your topic, write one paragraph describing how you would approach discussion of your topic and provide your sources as well. The period of your paper is open from the time of Hominid to 1500 CE. Your topic should be very specific ..

Reviews

len1421607

3/10/2017 12:02:11 AM

Criteria Absent Inadequate/ Needs Improvement Adequate Good Outstanding Total Marks 1 Introduction & Objective 0 1 2 3 4 4/ 2 Methodology 0 1;2 3;4 5;6 7;8 8/ 3 COLTO excel sheet 0 1;2;3 4;5;6 7;8;9 10;11;12 12/ 4 Calculation results 0 1 2 3 4 4/ 5 Conclusion 0 1 2 3 4 4/ 6 Overall Report & Neatness 0 1 2 3 4 4/ 7 References 0 1 2 3 4 4/

3/10/2017 12:02:02 AM

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)

Write a Review

Required(*) Message

User Account

All Pages