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 Questions 2 and 3 lo develop your computer protocol and check that it is working.