1. (50 pts) Create a spreadsheet or computer program that is capable of automatically generating a soil classification based on the American Association of State Highway Transportation Officials (AASHTO) Soil

Classification System. This spreadsheet/program should be able to generate a classification of a soil when provided with the weight of material retained on each of the sieves and the Atterberg Limits. Use the data provided in Questions2 and 3 to develop your computer protocol and check that it is working.