|
2011 Competition Guide
|
|
Scoring Spreadsheet All ASCE student conferences are now required to use the scoring spreadsheet provided below by the national rules committee. The completed spreadsheet must be emailed to the Rules Committee at AFTBQ@uaa.alaska.edu before any teams can be invited to the National competition. As much as we'd like the spreadsheet to be perfect on first release, that goal is still elusive. This means that you need to contact the above email address ASAP when you discover a problem. During the ASCE student conference competitions, your ASCE National CSA Representative will have a phone number to contact for quick replies. It is strongly suggested that you run some sample data sets to check the computations and to verify the sorts and printing SEVERAL WEEKS before your ASCE student conference. Don't wait to the last minute to learn how to use this complex spreadsheet. Also, you should do a last minute check of this website to see that you have the latest version. Hosts can ask to be added to an email distribution list for spreadsheet updates by sending their request to the above email address. Click on the following link to download the latest version:
2011NSSBCScoreSheet_v00.xls This year's spreadsheet continues to use VBA macros to lead you through the set up and usage phases. We have gone this route as significant number of ASCE student conferences did not appear to understand how the spreadsheet worked before instituting the programming and tried to force their way around the controls that were in place. It is hoped that this new version will help to guide users in the proper usage of the spreadsheet. If you have to force the programming at all, please contact AFTBQ@uaa.alaska.edu as soon as possible. -----------------<0>----------------- Four videos will help you with the spreadsheet. The first shows how to set up the spreadsheet for the competition. The next illustrates how to print out judging forms. The third is a quick tutorial on entering data and printing a summary page for each team. Finally, the fourth video shows the proper procedure for running the ranking macro and printing the results for dissemination to the participating teams. -----------------<0>----------------- Setting Up the Spreadsheet
-----------------<0>----------------- Printing the Judging Forms
-----------------<0>----------------- Entering Data and Printing Results
-----------------<0>----------------- Determining the Final Rankings
-----------------<0>-----------------
INSTRUCTIONS FOR USING THE SPREADSHEET Note: You must allow Macros to run this spreadsheet. It has been checked out in both 2003 and 2007 MS Excel.
|