"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 with the analysis of your water filter experiments.

You must hand in the cover sheet for the assignment and a printout of 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 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 one shown below. Check the results of your spreadsheet with the data list below and with your hand calculations using filter data you have collected in lab. Click here for template.

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

Part 3: Complete the Project #2 Survey

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

Cover sheet 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.