CIVL 1101 - Assignment #9 |
Name: ________________________ | ||||||||||||||||||||||||||||||||||||
"One is always a long way from solving a problem until one actually has the answer." - Stephen Hawking Objective The purpose of this assignment is twofold: first, you will get yet another chance to practice your skills in developing simple engineering spreadsheets for civil engineering applications; and second, you can use the spreadsheet to help you with the mechanical analysis of soils used in the filter experiments. Part 1: Develop a spreadsheet to develop the particle-size distribution plot for a given set of data. Use your spreadsheet to develop a particle-size distribution plot for the following data:
Estimate D10, D30,
and D60 from the particle-size distribution
curve and compute the effective size, the uniformity coefficient, Cu,
and the coefficient of gradation, Cc. Part 2: Use your spreadsheet to develop a particle-size distribution plot for the following data:
Estimate D10, D30, and D60 from the particle-size distribution curve. Compute the effective size, the uniformity coefficient, Cu, and the coefficient of gradation, Cc. Extra Credit: Estimate D10, D30, and D60 from the particle-size distribution curve using linear interpolation between appropriate sieves using spreadsheet functions so that the entire sieve analysis computation is automated. Part 3: Read Chapter 9 in the Strategies for Creative Problem Solving by Fogler and LeBlanc. |