CM 3503 Module 1 Assignment Using the given information in the table below, students are required to complete the grain size distribution table including percent retained, total percent retained, and total percent passing and plot the grain size distribution table in Excel. Additionally, students are required to determine D10, D30, and D60, calculate Cc and Cz. The percent gravel, sand, and silt and clay must also be determined. The plasticity index must be calculated. Finally determine the USCS group symbol and group name. SIEVE SIZE SIEVE SIZE (MM) SOIL WEIGHT PERCENT RETAINED TOTAL PERCENT RETAINED TOTAL PERCENT PASSING 1.5 30.1 0 1 25.4 0 0.75 22.6 5.4 0.5 12.7 5.2 0.375 9.525 12.2 No. 4 4.75 85 No. 8 2.38 105.2 No. 16 1.19 216.4 No. 30 0.595 94.6 No. 50 0.297 100.6 No. 100 0.15 315.4 No. 200 0.075 610 Pan n/a 160 n/a n/a n/a Liquid Limit = 40 Plastic Limit = 15