Project #2

Due Wedensday, 8 April, 2009 

Team Project

Using the crane models you created in Project #1 create a crane selection program. The interaction with the program will be through ONE dialog box that will appear automatically when the file is opened.

The dialog Box should contain at least:

 Input Output Navigation controls to
Height of building (2p.) List of cranes that can make the lift (10p.) Display geometry of lifting (One, common to all cranes) (2p.)
Height of payload (2p.) Special message if no crane can make the lift. (2p.) View of each crane (2p.)
Depth of lift (2p.)   Table of allowable payloads for each crane (2p.)
Safety clearance (2p.)   Main Dialog Box (on each user accessible sheet, not on the dialog box) (2p.)
Payload (2p.)    
Rigging (2p.)

 

Project Grading: 0-100

 

  • Requirements for dialog box:
  • 30 p. (points as marked)
  • Lock access of user to workbook:
  • 5 p.
  • Drawings & tables
  • 5 p.
  • Correctness of model
  • 20 p. (-5p./mistake)
  • Correctness of macros
  • 20 p. (5p./macro)
  • Completeness of solution
  • 20 p.

Individual Grading: Each team member will distribute 300 points among the other team members (no points to yourself). All 300 points have to be distributed. The point distribution will be confidential. Only the professor and TA will see them.

Submission: Each team member will email individually the point distribution to con251@asu.edu. The point distribution will contain:
 
  1. Name of the team
  2. Names of each of the members in order of their role and the grade assigned. Remember to include yourself and assign 0 as a grade.
  CEO only: One project per team, to the drop-box of the CEO. In the comment area the CEO will also post the name of the team and its members.

 

Deadline: 1 minute prior to lecture time on Monday, 6 April, 2009.

Bonus: 10 points for displaying only buttons of the cranes that can make the lift.