CIVL 1101 - Assignment #10

 Name: ________________________

 

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

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 Parts 1 and your calculations for Part 2.  Also, submit your Excel file for Part 1 to the Dropbox in eCourseware.

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.

 

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.