This is an Excel based scoring system for use at Science Olympiad tournaments. Versions have been in use since 2002 at tournaments all over the country. It is free for non-commercial use and modification. Please submit any bug reports or feature requests by emailing the author at the address listed on the Startup page in the workbook.

Click on the green button above to download the current Div C version, or on the files link to get the Div B version (be sure to save to disk first, then open the files). There is also a version with test data pre-populated and numerous settings / errors to demonstrate the functionality of the program.

NOTE: Excel 2008 for Mac does NOT support macros at all, thus many parts of this system won't work. Virtually any other version of Office will work.

Be sure to signup for the mailing list to be informed of updates

Note a 'SO Scoring Best Practices' PDF is available to give tips and tricks used at the National Tournament.

Features

  • Self contained in 1 Excel workbook
  • Individual scoring sheets for each event
  • A master scoring report
  • Automatic error checking, including tie detection and highlighting
  • Ability to import data from spreadsheet provided by event supervisors
  • Ability to generate reports ordered either by team number or rank for individual events and overall results
  • Ability to output medal results for the awards ceremony as both a script for the presenter and a PPT presentation to display
  • Customizable for tournament specific information such as team names, trial / pilot events
  • Ability to dynamically 'remove' individual teams and events from scoring calculations
  • Printable version of blank score sheets available for supervisors who want to use a paper copy
  • Works with all recent versions of MS Excel except for Excel 2008 for Mac

Project Samples

Project Activity

See All Activity >

Categories

Education

Follow Science Olympiad Scoring System

Science Olympiad Scoring System Web Site

Other Useful Business Software

Take Advantage of O365 + Online Backup Bundles Take Advantage of O365 + Online Backup Bundles Icon
Take Advantage of O365 + Online Backup Bundles Icon

The Perfect Small Business Offer That Packages Productivity, Disaster Recovery & Security Under One Price Tag. Join SherWeb to Start Reselling.

Add more value to your Office 365 offers with Online Backup. The program will back up servers, desktops, virtual machines and smart devices, plus popular applications and Office 365 data. Online Backup comes with the Active Protection feature embedded, making it possible to stop any ransomware attack and restore encrypted files in a blink. It also provides a web-based intuitive console that eases backup and disaster recovery management.
Are you an IT professional looking to profit from reselling Office 365?
Sign up NOW, it’s FREE

Rate This Project

Login To Rate This Project

User Ratings

★★★★★
★★★★
★★★
★★
0
0
0
0
0
ease 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
features 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
design 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5
support 1 of 5 2 of 5 3 of 5 4 of 5 5 of 5 0 / 5

User Reviews

There are no 4 star reviews.

Additional Project Details

Intended Audience

Education

Programming Language

Visual Basic for Applications (VBA)

Registered

2012-01-01