soscoring-updates Mailing List for Science Olympiad Scoring System
Excel based scoring system for Science Olympiad tournaments
Brought to you by:
achalker
Menu
▾
▴
soscoring-updates — Announcements of updates to the program
You can subscribe to this list here.
| 2012 |
Jan
|
Feb
(2) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2013 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
|
From: Alan C. <al...@os...> - 2013-12-01 18:47:49
|
Happy Holidays! I've just uploaded to the project website (https://sourceforge.net/projects/soscoring/files/) this year's version (V8) of the Science Olympiad Scoring system. In addition to updating the event names to match this year's slate, I've incorporated several new features / changes based upon feedback received from various people last year. These include the following: * Created new printable medal sheet print dialog checkbox options for landscape vs. portrait printing and one event per page printing * Added the import data from another workbook button on the standalone scoresheets that are created * Added red highlighting of any ns or dq scores on master sheet As always, if you have additional feedback / suggestions please let me know. ---- Alan Chalker, Ph.D. al...@os...<mailto:al...@os...> 614-247-8672 |
|
From: Alan C. <al...@os...> - 2012-12-31 03:16:34
|
Happy New Year! I've just uploaded to the project website (https://sourceforge.net/projects/soscoring/files/) this year's version (V5) of the Science Olympiad Scoring system. In addition to updating the event names to match this year's slate, I've incorporated several new features / changes based upon feedback received from various people last year. These include the following: * Combined team names / states into 1 cell on event and master score sheets and reduced the overall column width * Updated the row shading on all sheets to be in more readable groups of three instead of alternating lines * Rotated event names 180 degrees on master sheet to improve readability * Added code to print sheet macro to automatically switch between landscape / portrait orientations depending on the size of the Master sheet (Thanks to Connor Duffy for suggesting all of the above) * Added correlation check between overall team rankings and individual event rankings. A warning will now display on event pages if the score sort order is likely incorrect (e.g. low score wins selected instead of high score wins) * Added ability to turn off warning messages on master sheet during printing via a pop up message box when using the print sheet button * Minor formatting changes on the printable medals page As always, if you have additional feedback / suggestions please let me know. ---- Alan Chalker, Ph.D. al...@os...<mailto:al...@os...> 614-247-8672 |
|
From: Alan C. <al...@os...> - 2012-02-08 05:11:18
|
I've just uploaded to the project website (https://sourceforge.net/projects/soscoring/files/) version "2" of the Science Olympiad Scoring system. I've incorporated several new features / changes based upon feedback received from various tournaments over the past month. These include the following: -Added copying of sort order selection to import data macro auto function -Added a note about sort order selection to import data macro manual function -Added ability to set arbitrary Team #s on setup sheet, including no team #s at all if desired -Changed Printable Medals List so that blanks are displayed instead of error messages when data is missing -Added option to change Printable Medals List order to either 1st rank shown on top row or last rank shown on top row -Added option to change PPT Presentation List order to either 1st rank shown on top row or last rank shown on top row -Added option to select an image file to set as the PPT Presentation background -Added option to select which events to create PPT slides for -Added option to select which events to print out from Printable Medals List -Added code to automatically check SourceForge project website for updated scoring system each time spreadsheet is opened up -Added additional automatic tie breaking for teams on Master sheet which should break ties in almost all cases now -Set default score order to low score wins for Mousetrap Vehicle and Gravity Vehicle As always, if you have additional feedback / suggestions please let me know. ---- Alan Chalker, Ph.D. al...@os...<mailto:al...@os...> 614-247-8672 |
|
From: Alan C. <al...@os...> - 2012-02-08 04:55:15
|
I've just uploaded to the project website (https://sourceforge.net/projects/soscoring/files/) version "2" of the Science Olympiad Scoring system. I've incorporated several new features / changes based upon feedback received from various tournaments over the past month. These include the following: -Added copying of sort order selection to import data macro auto function -Added a note about sort order selection to import data macro manual function -Added ability to set arbitrary Team #s on setup sheet, including no team #s at all if desired -Changed Printable Medals List so that blanks are displayed instead of error messages when data is missing -Added option to change Printable Medals List order to either 1st rank shown on top row or last rank shown on top row -Added option to change PPT Presentation List order to either 1st rank shown on top row or last rank shown on top row -Added option to select an image file to set as the PPT Presentation background -Added option to select which events to create PPT slides for -Added option to select which events to print out from Printable Medals List -Added code to automatically check SourceForge project website for updated scoring system each time spreadsheet is opened up -Added additional automatic tie breaking for teams on Master sheet which should break ties in almost all cases now -Set default score order to low score wins for Mousetrap Vehicle and Gravity Vehicle As always, if you have additional feedback / suggestions please let me know. ---- Alan Chalker, Ph.D. al...@os...<mailto:al...@os...> 614-247-8672 |
