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)
  • First cell (row 1, column 1) should contain the team name
  • First column should contain participant names
  • Starting from column 4, list the events each participant is competing in
  • Upload one roster file per team
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

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 🎨 Bootstrap 5