"Anyone who has never made a mistake has never tried anything new" - Albert Einstein

Objective

The purpose of this assignment is twofold. First, you will get yet another chance to practice your skills in developing simple engineering spreadsheets for civil engineering applications. Secondly, you will get the opportunity to write a mix proportioning description and practice your skill in writing and formatting equations.

Part 1: Develop a spreadsheet to compute the mix proportions for a given mix ratio and w/c to produce a number of cylinder and beam specimens. The information in the yellow boxes are the design variables, the data in the gray boxes are the design parameters, and the results are displayed in the green boxes. Your spreadsheet should look similar to one shown below. Use the data given below as a check for your spreadsheet calculations. Hint: your Excel formulas for this analysis should only be in the green boxes. Click here are a template for the spreadsheet.

Submit your spreadsheet via the eCourseware. Your name and assignment number should appear in the top left corner of the spreadsheet. The date should appear in the top right corner of the spreadsheet.

Part 2: Use WORD and the equation editor object to transcribe a document. Click on the following link to download a copy of the document. Submit a your document via the drop box on eCourseware.

Part 3: Read Chapters 5-6 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.