About SciOly Analyzer

What is SciOly Analyzer?

SciOly Analyzer is a web application designed to help Science Olympiad coaches and team members track and analyze performance across multiple competitions throughout the season.

By combining roster data with competition results, SciOly Analyzer provides detailed insights into:

  • Individual participant performance and trends
  • Team-level performance across competitions
  • Event-by-event breakdowns by category
  • Consistency metrics and top performers
  • Team depth analysis

Features

  • Multi-Team Support: Track up to 3 teams per competition (Varsity, JV, C team)
  • Multi-Competition Analysis: Upload and compare data from multiple competitions
  • Detailed Metrics: Average placement, best/worst performance, consistency (standard deviation)
  • Visual Analytics: Interactive charts showing performance trends over time
  • Event Categories: Results organized by Science Olympiad event categories
  • Secure & Private: Each user has their own private data

File Format Requirements

Roster Files (CSV)
  • Add a header row with a "Name" column โ€” events can be in any other column, in any order
  • Name the file after your team, e.g. "Gold Team.csv"
  • Older files (team name in cell A1, events from column D onward) still work automatically
Results File (CSV)
  • Should contain columns for "School" and "Team"
  • Each event should be a separate column
  • Cell values should be numeric placements (1, 2, 3, etc.)
  • Compatible with Duosmium export format โ€” or search Duosmium by name right from the upload page

Tips for Best Results

  • Make sure team names in your roster match exactly with how they appear in results (case doesn't matter)
  • Use descriptive competition names to easily identify them later
  • Upload competitions in chronological order to see trends over time
  • Check the team mapping carefully to ensure data links correctly
๐Ÿ”ฌ
Developed by Rahula Abeysekera

Freshman at Langley High School

Feel free to report bugs or ask any questions at Rahulaabeysekera@gmail.com

๐Ÿ Flask ๐Ÿ—„๏ธ SQLAlchemy ๐ŸŽจ Tailwind CSS