PDHengineer continuing education for engineers consumers and corporate

PDHengineer PDH CEU CPC CPD - top white line

 

PDHengineer for engineers continuing education

OnlineChatSoftware

PDH CEU CPC CPD spacer

Courses | Webinars | Write a Course | FAQ | Contact Us | My Account

 PDH online courses and webinars
PDHengineer
Explore all PDH CEU CPC CPD and Webinars for Engineers

 

This course accepted in:

 

• Alabama (P.E.)

• Alaska (P.E.)

• Arkansas (P.E.)

• Florida (P.E.) (AOP)

• Georgia (P.E.)

• Idaho (P.E.)

• Illinois (P.E.)

• Iowa (P.E.)

• Kansas (P.E.)

• Kentucky (P.E.)

• Louisiana (P.E.)

• Maine (P.E.)

• Maryland (P.E. Category B)

• Minnesota (P.E.)

• Mississippi (P.E.)

• Missouri (P.E.)

• Montana (P.E.)

• Nebraska (P.E.)

• Nevada (P.E.)

• New Hampshire (P.E.)

• New Mexico (P.E.)

• North Carolina (P.E.)

• North Dakota (P.E.)

• 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.)

• Virginia (P.E.)

• West Virginia (P.E.)

• Wyoming (P.E.)

 

 

 

Abbreviations:

AOP-Areas of Practice

LAR-Laws & Rules

P.E.-Professional Engineers

 

Explore all PDH CEU CPC CPD and Webinars for Engineers

Using Excel for Soil Testing

Course No. C-2025

Credit: 2 PDH

Course Fee: $57.90 Purchase course

Subject Matter Expert: Robert Duane Nickols, P.E., R.L.S.

Attention New York Engineers:

This course cannot be taken to fulfill your continuing education requirements for the state of New York since the course does not fall under the category of "Areas of Practice" or "Laws / Rules." For more information, check the New York State Board Requirements.

Attention Ohio Engineers:

This course cannot be taken to fulfill your continuing education requirements for the state of Ohio since the subject matter does not fall within the state guidelines. For more information, check the Ohio State Board Requirements.

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 Obtained

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 link to the PDF document to review the course material before taking the quiz for credit.

Using Excel for Soil Testing

 

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?

If clicking the link does not bring you to the PDF file, then right-click the link. Click "Save Target As" and 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 want to bookmark this page for your convenience. If you have questions, Live Support Chat can help.

Get Adobe ReaderYou may need Adobe Reader to view this document. Click on the link to download a free copy of the latest version of Adobe Reader.

 

To receive PDH credit for this course, you must pass a multiple-choice quiz. Click the button below to Purchase Course and Take Quiz. To take the quiz, your computer must be set to accept cookies. See how to check your cookie settings.

 

Download course material Purchase PDHengineer course