Course description
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
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.
Do you work at this company and want to update this page?
Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.
Upcoming start dates
Who should attend?
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.
Training content
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
Costs
Quick stats about PDHengineer?
Trusted by over 60,000 engineers to meet PDH requirements
Earn reward tokens with each course purchase
Triple guarantee that courses will be accepted by your state licensing board
Contact this provider
Professional Engineers have trusted PDHengineer to provide high-quality PDH courses since 2003. A large library of PDH courses and live, interactive webinars means that engineers can find PDH course material covering all of the major engineering disciplines. Plus, all PDHengineer...