Project 2

Handout 2:00 pm WED 14 OCT 2009
Deadline 6:00 pm TUE 20 OCT 2009

Approximate time needed to complete project 30-60 minutes.

MATERIAL FOR SUBMISSION

Project must be filed on the following folder
shared(Y:)/computers/project 2/your own name.
The file must be named after your last name and first name.
For example
Frank Lloyd Wright is making a submission of on document the file will be called wrightfrank.xls (or.xlsx)

ASSESSMENT

The project is 15% of Semester 1 mark.
Late submissions will not be marked.
Marks will be awarded as follows:
Design 30%,
Technical accomplishment 60%
Proper filing 10%

TASK DESCRIPTION

The aim of this exercise is to allow you to use Microsoft Excel spreadsheet program for establishing preliminary sizes of structural elements.

Refer to the structural elements charts and produce a spreadsheet so that each type of element appears on a different sheet of your excel document, let the user of the spreadsheet input the length of his element in meters and present him with an estimated element size - height and width in milimeters.

Your formula can look like this:
=IF(B2<=8,ROUND((B2/24)*1000,0),"beam length too long")

The layout should be clear so that any error can be spotted

Design the layout so that it appears like a professional tool.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License