"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 - you can use the spreadsheet to help you with your concrete mix design in the project. Secondly, you will get the opportunity to write a mix proportioning description for the Project #2 report and practice your skill in writing and formatting equations. 

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

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 the 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 to download a template for the spreadsheet.

Submit your spreadsheet via Canvas. 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 your document via the dropbox on Canvas.

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