|
Using
Excel for Soil Testing
| |
|
Attention
New York Engineers:
This
course cannot be taken to fulfill your continuing education requirements
in the state of New York since the course does not fall under the category
of "Areas of Practice" or "Law/Ethics". For more
information, check the New
York State Board Requirements.
|
Robert
Duane Nickols, P.E.
Overview
This course covers many soils tests that can be done in Excel.
• Liquid Limit
• Plastic Limit
• Sieve Analysis
• Specific Gravity
• 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.
The student must take
a quiz consisting of ten (10) questions in order to receive PDH credit.
Specific Knowledge or Skill Attained
This
course teaches the following specific knowledge and skills:
-
The basics of several soil tests
-
Liquid Limit
-
Plastic Limit
-
Sieve Analysis
-
Specific Gravity
-
Proctor
-
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
Course
Click on the following
PDF attachment and review the document prior to taking a quiz for PDH credit.
Using
Excel for Soil Testing (409 KB)
Excel
worksheets used in the course can be downloaded and installed on your hard drive
in the following manner:
1 -
RIGHT click the link below and select "Save Target As" (Internet
Explorer) or "Save Link As" (Firefox)
2 -
Save the file to your desktop
3 -
When completed, double click on the icon to install the files on your computer.
Worksheet
installation file for Using Excel for Soil Testing
Having Trouble Downloading the PDF File?
Right click on the link. Select "Save Target As..."
Then save on your desktop. To view the file, double click the icon on your
desktop and return to this page to take the quiz.
You may need Acrobat Reader to view this document.
Click on the link below to download a free copy of Acrobat Reader.
To obtain PDH credits for this course, you will need to take a quiz for
credit. Click on the link below.
(To take the quiz,
your web browser must be set to accept cookies. See how to
check your cookie settings.)
 
|
