"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 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 skills in writing and formatting equations.

You must hand in a copy of the cover sheet for the assignment and printouts of your Excel spreadsheet for Part 1 and your Word document for Part 2. Also, you must submit your Excel spreadsheet for Part 1 and your Word document for Part 2 to 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 like the one shown below. Use the data below to check for your spreadsheet calculations. All final component weights should be rounded to 0.1 lb. (precision of lab scale). Hint: your Excel formulas for this analysis should only be in the green boxes. Click here for 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 documents via the Assignment link in 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.