"If you can't explain something simply, you don't know enough about it." - Albert Einstein

Objective

The purpose of this assignment is twofold. First, continue to develop your skills in applying spreadsheets to civil engineering applications. Second, you can use the spreadsheet to help you analyze your water filter experiments.

You must hand in the coversheet for the assignment, a printout of the spreadsheet for Part 1, and your calculations for Part 2.  Also, submit your Excel file for Part 1 to the Dropbox in Canvas.

Part 1: Develop a spreadsheet to compute the efficiency of the water filters constructed in the lab. The information in yellow is the input data. The results of your spreadsheet are the values printed in green. Your spreadsheet should look similar to the one below. Check the results of your spreadsheet with the data listed below and with hand calculations using the filter data you collected in the lab. Click here for the template.

Part 2: Compute your current grade in the class using the information in the syllabus.

Part 3: Complete and submit the Project #2 Survey.

Part 4: Read Chapter 10 in the Strategies for Creative Problem Solving by Fogler and LeBlanc.

Coversheet for homework

This website was originally developed by Charles Camp for CIVL 1101.
This site is Maintained by the Department of Civil Engineering at the University of Memphis.
Your comments and questions are welcomed.