Salt Lake Valley Science and Engineering Fair

2010 ISEF Shoptalk Presentation Materials

Thanks for taking the time to listen to our Shoptalk presentations at ISEF 2010. Here you will find the files and links we discussed. If you have any questions about our processes or judging methods, please email judge@slvsef.org. We’ll be glad to answer your questions.

Registration

• Online Registration (user: milky / pass: way)
• Online Administration (user: milky / pass: way)
• 2010 Students Edited.xls
• 2010 Judges Edited.xls

Name Tags & Labels

• Merge Info.xls
• Score Sheet Labels.dot (10 per)
• Score Sheet Labels.dot (15 per)
• Student Name Tags.dot
• Judge Name Tags.dot
• Special Award Judge Name Tags.dot

Judge Assignments

• Judge Assignments.xls
• Email Body.doc
• Judge Assignment Merge.dot
• SLVSEF Venue Map.pdf

D&S Checkoff

• D&S Key.xls
• D&S Check Off Sheet.dot

Scoring Program

• Project Number Format.pdf
• Master Judging Sheet.xls
• Master Scoring Matrix.xls
• Blank Awards Show.ppt
• SLVSEF Checks.dot
• Judge Score Sheet.pdf
• Judging Rubric.pdf

Presentation Slides

• Microsoft Office Tips & Tricks That Simplify Running A Science Fair
  A bunch of helpful hints and things we do to make running our science fair nice and easy. Presentation by Cris LaPierre.
• Excel-Based Judging Software
  The software and processes we use at SLVSEF to run our entire science fair. Developed by Cris LaPierre.
• Average Z-Score
  Learn why using a z-score is important when calculating scores for student projects. Presentation by Cris LaPierre.

Helpful Links & Notes

• All Shoptalk Downloads.zip (All Above Files, 11 MB Archive)
• Sample Registration Data.xls
• Avery Label Templates
• Microsoft Office Tutorials
• How To Merge Two Or More Excel Workbooks
• How To Mail Merge To Send Email
  
• How To Mail Merge to E-mail With Attachments
  
• How To Run VBA Macro Code
  
• How To Perform A Mail Merge.pdf
• Spreadsheet passwords are all: slvsef
• Macros must be enabled for some features to work.
  Security must be set to medium or low. This can be set in office 2003 by going to Tools > Macro > Security