Live support chatUsing Excel for Soil Testing
In Using Excel for Soil Testing, you'll learn ...
- How to calculate the moisture content of soil
- How to approximate the liquid limit of soil
- Know the order of precedence of arithmetic operators
- How to calculate the plasticity limit How to use several built-in functions in Excel- AVERAGE, STDEV, SQRT, LOG10
Overview
Preview a portion of this course before purchasing it.
Credit: 2 PDH
Length: 19 pages
This course covers many soils tests that can be done in Excel Liquid Limit; Plastic Limit; Sieve Analysis; Specific Gravit; Proctor.
Each test includes a description of the equipment used, the procedure used along with how the calculations and graphs look in Excel. Many engineers used to use a slide rule to calculate and graph paper to plot up the results. Excel can be used to do the calculations and plot the results. A little prior knowledge of how to use Excel is needed. This course should be of interest to Civil Engineers who might be involved with different kinds of soil testing, even if you work in the field, lab or design.
Specific Knowledge or Skill Obtained
This course teaches the following specific knowledge and skills:
- How to calculate the moisture content of soil
- How to approximate the liquid limit of soil
- Know the order of precedence of arithmetic operators
- How to calculate the plasticity limit How to use several built-in functions in Excel- AVERAGE, STDEV, SQRT, LOG10
- How to calculate the uniformity coefficient
- How to calculate the coefficient of curvature
- How to make an absolute cell address in Excel
- How to calculate the specific gravity of soil
- How to calculate the moist unit weight and the dry unit weight of soil
Certificate of Completion
You will be able to immediately print a certificate of completion after passing a multiple-choice quiz consisting of 10 questions. PDH credits are not awarded until the course is completed and quiz is passed.
| This course is applicable to professional engineers in: | ||
| Alabama (P.E.) | Alaska (P.E.) | Arkansas (P.E.) |
| Delaware (P.E.) | District of Columbia (P.E.) | Florida (P.E. Area of Practice) |
| Georgia (P.E.) | Idaho (P.E.) | Illinois (P.E.) |
| Illinois (S.E.) | Indiana (P.E.) | Iowa (P.E.) |
| Kansas (P.E.) | Kentucky (P.E.) | Louisiana (P.E.) |
| Maine (P.E.) | Maryland (P.E.) | Michigan (P.E.) |
| Minnesota (P.E.) | Mississippi (P.E.) | Missouri (P.E.) |
| Montana (P.E.) | Nebraska (P.E.) | Nevada (P.E.) |
| New Hampshire (P.E.) | New Jersey (P.E.) | New Mexico (P.E.) |
| New York (P.E.) | North Carolina (P.E.) | North Dakota (P.E.) |
| Ohio (P.E. Self-Paced) | Oklahoma (P.E.) | Oregon (P.E.) |
| Pennsylvania (P.E.) | South Carolina (P.E.) | South Dakota (P.E.) |
| Tennessee (P.E.) | Texas (P.E.) | Utah (P.E.) |
| Vermont (P.E.) | Virginia (P.E.) | West Virginia (P.E.) |
| Wisconsin (P.E.) | Wyoming (P.E.) | |
Preview a portion of this course before purchasing it.
Credit: 2 PDH
Length: 19 pages
