2012 National Tournament: University of Central Florida

chalker
Member
Member
Posts: 2066
Joined: January 9th, 2009, 7:30 pm
Division: Grad
State: OH
Contact:

Re: 2012 National Tournament: University of Central Florida

Postby chalker » May 23rd, 2012, 6:48 pm

kentuckyfan1001 wrote:Mr. Chalker, out of curiosity, do you have a spreadsheet of the results in excel format? I would like to sort the spreadsheet that was released by ranking.


I do, although I'm curious as to why you want to do that? What are you trying to get out of it? I might be able to just give you the final answer you are looking for.

Student Alumni
National Event Supervisor
National Physical Sciences Rules Committee Chair

User avatar
kentuckyfan1001
Exalted Member
Exalted Member
Posts: 116
Joined: February 23rd, 2008, 7:39 pm
Division: Grad
State: OH
Contact:

Re: 2012 National Tournament: University of Central Florida

Postby kentuckyfan1001 » May 23rd, 2012, 6:50 pm

chalker wrote:
kentuckyfan1001 wrote:Mr. Chalker, out of curiosity, do you have a spreadsheet of the results in excel format? I would like to sort the spreadsheet that was released by ranking.


I do, although I'm curious as to why you want to do that? What are you trying to get out of it? I might be able to just give you the final answer you are looking for.


Oh, I just want to see (visually) which events are the weakest for the top 10 teams. Also, I want to calculate the correlation coefficient of each event.
-JZ Solon '12, Penn '16
2013 Helicopters PA State Supervisor

chalker
Member
Member
Posts: 2066
Joined: January 9th, 2009, 7:30 pm
Division: Grad
State: OH
Contact:

Re: 2012 National Tournament: University of Central Florida

Postby chalker » May 23rd, 2012, 9:01 pm

kentuckyfan1001 wrote:Oh, I just want to see (visually) which events are the weakest for the top 10 teams. Also, I want to calculate the correlation coefficient of each event.


Unfortunately I don't think I'll be able to get approval to release the Excel versions of the spreadsheet. However with minimal effort you can cut and paste the data from the PDF's that were posted into Excel and generate your own. I did just do a quick analysis though that might be of interest:

In Div B, the top 10 teams collectively did the worst in Compute This, Exp. Design, Forestry, and Storm the Castle.
In Div C it was Chem Lab, Helicopters, Optics, and Tech Problem Solving.

I've also done a lot of statistical analysis already, including correlation coefficients, but the results are really only for internal consumption by the core SO Committee Members (and we are already having lots of discussions about them). I think there is a big danger in people misinterpreting things if I start posting a lot of data. For example, let's hypothetically say one particular event has a relatively low correlation to the others. Some people might think that indicates a problem with the event rules or event supervisors. However others might think it's just indicative of the fact the skills required for that event are markedly different from all the other events. Regardless, is it a good or bad thing that in that event more teams had a chance to medal / place well?

Student Alumni
National Event Supervisor
National Physical Sciences Rules Committee Chair

User avatar
smartkid222
Exalted Member
Exalted Member
Posts: 774
Joined: June 22nd, 2008, 8:12 am
Division: C
State: NY
Location: Western Long Island
Contact:

Re: 2012 National Tournament: University of Central Florida

Postby smartkid222 » May 24th, 2012, 1:52 pm

Is there a pdf score sheet that lists teams by rank instead of number?
Image 2008 NY BLG Champ
2010 NY Helicopter Champ

chalker
Member
Member
Posts: 2066
Joined: January 9th, 2009, 7:30 pm
Division: Grad
State: OH
Contact:

Re: 2012 National Tournament: University of Central Florida

Postby chalker » May 24th, 2012, 2:12 pm

smartkid222 wrote:Is there a pdf score sheet that lists teams by rank instead of number?


No. There's a general feeling amongst the organizers that by number is how more teams want to see it.

Student Alumni
National Event Supervisor
National Physical Sciences Rules Committee Chair

Luo
Staff Emeritus
Staff Emeritus
Posts: 506
Joined: March 21st, 2011, 1:31 pm
Division: Grad
State: MN
Contact:

Re: 2012 National Tournament: University of Central Florida

Postby Luo » May 24th, 2012, 6:14 pm

Since many people (including several members of my team) have desired a rank-sorted results sheet, I took the liberty of creating one. Here are a couple minor formatting changes I made as well:

  • Shading of both columns and rows: In the official sheet, the rows are alternately shaded, which helps one's eyes stay on the proper line. However, the lack of alternate column shading makes it difficult to trace which event matches up with each placing in a given row.
  • Shading in blocks of three: I decided to shade the rows and columns in blocks of three, because it's still relatively easy to get lost with the singly alternate-shaded lines so close to each other.
  • Team name consistency: It was slightly bothersome to me that some teams had their full name listed with "high school" abbreviated (such as "Solon HS") while others had "high school" written completely out (such as "Troy High School") and still others did not have "high school" at all (such as "New Trier"). In my sheet, I made the high school names more accurate and consistent.
  • Event names flipped 180 degrees: The national results sheets for 2007-2011 (and those for most states I have seen) list the event names oriented so that the bottoms of the words are facing the right side of the page. The official sheet this year has them facing the opposite direction, so I followed the 2007-2011 precedent in my sheet.
  • Tighter formatting: I eliminated some of the blank space between the state abbreviations and school names. I also flipped the sheet to be in the portrait orientation, which fits the aspect ratio of the matrix better.
  • Addition of "average rank" column: I added a column listing "average rank" at the far right. Knowing total points is useful for inter-team comparisons, but knowing an average rank is far more useful for intra-team analysis, to know what is a "typical" placing for the team.
  • Completely enclosed cells: There isn't really a functional purpose for this, but I think it looks better for each cell to be completely enclosed by borderlines.

And of course, my sheet is rank-sorted, which I find much more conducive to at-a-glance information gathering as well as analysis of top teams. I do understand that there are benefits to a team number-sorted sheet, but I hope that soinc will allow sheets of both sorting methods to be published so that each individual may decide which version they find most beneficial.

Here is the Division C rank-sorted results sheet I created (direct download): http://goo.gl/ajVVo

*Note on typographical checking: After entering each individual event placing, I used an Excel function to add up each team's score (excluding trial events). I then cross-checked the total points column on my sheet with the total points column on the official sheet. Since all the point totals matched up, I believe it is reasonably safe to assume that the typography for all the individual placings is also correct. I then manually checked each team's overall ranking and trial event places. If an error is found, please contact me immediately.
Proud alumnus of Mounds View High School Science Olympiad, Arden Hills, MN
Co-founder of the MIT Science Olympiad Invitational Tournament: http://scioly.mit.edu/

User avatar
havenguy
Member
Member
Posts: 456
Joined: March 3rd, 2011, 2:06 pm
Division: Grad
State: PA
Contact:

Re: 2012 National Tournament: University of Central Florida

Postby havenguy » May 24th, 2012, 6:48 pm

Beautiful, any chance anyone could make one for B?
University of Pennsylvania Class of 2020
Strath Haven High School Class of 2016

2016 States Results:
Invasive Species: 1st
Dynamic Planet: 1st
Disease Detectives: 5th
Anatomy: 6th

Team Place: 4th

chalker
Member
Member
Posts: 2066
Joined: January 9th, 2009, 7:30 pm
Division: Grad
State: OH
Contact:

Re: 2012 National Tournament: University of Central Florida

Postby chalker » May 24th, 2012, 7:45 pm

Luo wrote:Since many people (including several members of my team) have desired a rank-sorted results sheet, I took the liberty of creating one. Here are a couple minor formatting changes I made as well: ......


Nicely done. I might steal some of your formatting ideas for next year;)

Student Alumni
National Event Supervisor
National Physical Sciences Rules Committee Chair

User avatar
Lily Essence
Member
Member
Posts: 67
Joined: March 29th, 2009, 1:36 pm
Division: C
State: TX
Contact:

Re: 2012 National Tournament: University of Central Florida

Postby Lily Essence » May 25th, 2012, 9:49 pm

chalker wrote:I tried several times to get them to pick up the overall pace, but was told that the students were enjoying the moment and it'd detract from that.


I do remember several events in which the top 6 were read considerably faster than the other events. At the time, I thought it was just the speakers switching out and one read faster than the other, but now I realize it was you trying to move the ceremony along. XD I personally feel that the ceremony stretched on just a tad too long and at a certain point even my high-school nerd attention span zoned out. I can't remember the exact times she commented on but my friend kept looking at her watch and wondering why, for such a well-timed event that started on time, the ceremony just seemed to crawl along for us.

Despite the length of the awards ceremony, I really really really must commend all of the people and staff in the background for starting the ceremony so promptly. (Like I think it was literally only 5 or 6 minutes past! Remarkable!) We joke in Texas that it's tradition for the State Awards to start an hour or two late so we can eat a decent dinner before going, but this was certainly not the case in this Nationals. Absolutely fantastic job! (coughI'm also glad that other people have the nick for timeliness; honestly, if the awards isn't going to start until 8, just tell us, don't tell us 6 and then have us wait for two hourscough)
Silent and Listen are spelled with the same letters
Seven Lakes SLHS Science Olympiad
Retiring my competition career! Off to scold the newbies as a manager!

User avatar
knittingfrenzy18
Exalted Member
Exalted Member
Posts: 142
Joined: April 3rd, 2012, 11:25 am
Division: B
State: MD
Location: Somewhere in the world.
Contact:

Re: 2012 National Tournament: University of Central Florida

Postby knittingfrenzy18 » May 31st, 2012, 6:41 pm

Has the streaming been posted on YouTube? My family wants videos.
Pilgrimage Homeschool Division B, Maryland
Visited 2012 and 2014 National Tournaments, 5th place Sounds of Music 2014
http://knittingfrenzy18.wordpress.com

awesome90220
Member
Member
Posts: 158
Joined: March 10th, 2012, 5:19 pm
Division: B
State: AL
Location: somewhere on this cruel, harsh planet
Contact:

Re: 2012 National Tournament: University of Central Florida

Postby awesome90220 » June 18th, 2012, 10:55 pm

Are the test scores up for the events? I want to know how close I was from the 8th place team at forestry
2016 Season: BISOT/Reg/State/Nats
Wind Power:9/1/1/11
Experimental Design:5/1/1/16
It's About Time:-/1/1/20

User avatar
rfscoach
Coach
Coach
Posts: 551
Joined: July 7th, 2008, 4:58 pm
Division: B
State: GA
Contact:

Re: 2012 National Tournament: University of Central Florida

Postby rfscoach » June 19th, 2012, 8:51 am

awesome90220 wrote:Are the test scores up for the events? I want to know how close I was from the 8th place team at forestry

Raw scores never get posted.
I am the Lorax. I speak for the trees. I speak for the trees, for the trees have no tongues.

User avatar
Infinity Flat
Member
Member
Posts: 274
Joined: March 12th, 2010, 4:00 pm
Division: Grad
State: WA
Location: Camas, WA
Contact:

Re: 2012 National Tournament: University of Central Florida

Postby Infinity Flat » June 19th, 2012, 12:17 pm

rfscoach wrote:
awesome90220 wrote:Are the test scores up for the events? I want to know how close I was from the 8th place team at forestry

Raw scores never get posted.

With the exception of Protein modeling, which MSOE posts on their website.
(State, Nationals)
2013: Astro (2, 6) / Chem (2, 5) / Circuits (8, 36) / Diseases (1,1) / Fermi (N/A, 24) / Materials (1, N/A)
2012 : Astro (1, 11) / Chem (N/A, 13) / Diseases (3, 1) / Optics (2, 3) / Sounds (2, 1)
2011: Astro(2,11) / Diseases (1,27) / Optics (1,13) / Proteins (2,15)

User avatar
tornado guy
Member
Member
Posts: 449
Joined: April 17th, 2011, 7:23 pm
Division: C
State: WA
Location: PAPERMAKERS!
Contact:

Re: 2012 National Tournament: University of Central Florida

Postby tornado guy » June 20th, 2012, 11:02 am

rfscoach wrote:
awesome90220 wrote:Are the test scores up for the events? I want to know how close I was from the 8th place team at forestry

Raw scores never get posted.


I understand why nationals doesn't give you back your corrected tests, but I don't see the issue with posting raw scores. And I would like to know how tightly gaped R&M was.
Proud ExCEL Homeschooler for five awesome years!
Nationals 2012: Meteorology 5th, R&M 19th, WQ 21st, DP 30th. Team 11th

Regionals 2013 C division: DP 3rd, WQ 5th.

Luo
Staff Emeritus
Staff Emeritus
Posts: 506
Joined: March 21st, 2011, 1:31 pm
Division: Grad
State: MN
Contact:

Re: 2012 National Tournament: University of Central Florida

Postby Luo » June 20th, 2012, 12:01 pm

tornado guy wrote:
rfscoach wrote:
awesome90220 wrote:Are the test scores up for the events? I want to know how close I was from the 8th place team at forestry

Raw scores never get posted.


I understand why nationals doesn't give you back your corrected tests, but I don't see the issue with posting raw scores. And I would like to know how tightly gaped R&M was.

I don't know how tight R&M was for Division B, but for Division C the top scores were 133, 127, 127, 127, 126, and 126 out of 150. The lowest score was 52.
Proud alumnus of Mounds View High School Science Olympiad, Arden Hills, MN
Co-founder of the MIT Science Olympiad Invitational Tournament: http://scioly.mit.edu/


Return to “2012 Nationals”

Who is online

Users browsing this forum: No registered users and 1 guest