Automating Hackathon Scoring

The Problem

During my internship, we organized a company hackathon. The scoring process was entirely manual judges used paper forms, scores were tallied by hand, and results took hours to compile. This was inefficient and error prone.

The Solution

I built an automated scoring system using Google Sheets and Google Apps Script that streamlined the entire evaluation process from judge input to final results.

How It Works

1. Judge Input Forms

Each judge gets a dedicated sheet with:

• Custom Input Fields: Clean, dedicated rows or cells where judges can input scores for each team based on the specific hackathon criteria.
• Strict Evaluation Validation: Built-in rules that prevent duplicate evaluations, ensuring a judge cannot accidentally score the same team twice or submit incomplete scores.
• Protected Ranges: Locked cells to make sure judges only interact with their designated input fields without accidentally messing up the underlying formulas or layout.

2. Automated Score Compilation

The system automatically:

• Collects Real-Time Data: Triggers an Apps Script function the moment a judge enters a score, instantly fetching data from multiple individual judge sheets.
• Consolidates Results: Merges all active inputs into a single, centralized master sheet without requiring manual copy-pasting or page refreshes.
• Applies Weighted Calculations: Automatically processes the raw scores against preset criteria weights to maintain absolute data integrity.

3. Results Dashboard

A summary dashboard shows:

• Live Leaderboard: A dynamic view that ranks the competing teams instantly as new scores flow into the system.
• Instant Winner Determination: Background logic that automatically identifies and flags the top-performing team based on the final tallied results.
• Submission Status: A quick overview showing which judges have submitted their scores and which evaluations are still pending.

Impact

• Zero Post-Event Delay: Eliminated the hours spent manual-tallying scores after the presentations. The winning team was determined automatically the exact second the final judge hit submit.
• Flawless Data Integrity: Eradicated human errors like double-scoring, missed fields, and calculation mistakes through strict script-driven validation.
• Operational Efficiency: Transformed a chaotic, paper-heavy evaluation process into a seamless, hands-off digital workflow.

What I Learned

• Automation Over Complexity: You don't always need to build a heavy full-stack application to solve an operational bottleneck. Google Apps Script can deliver enterprise-grade automation when leveraged correctly.
• Input Validation is Everything: Preventing bad data at the point of entry (like blocking duplicate evaluations) saves you from writing complex, messy error-handling code later in the pipeline.
• Coding for Real Impact: The most satisfying solutions are those that solve immediate, real-world pain points and save people hours of stressful, tedious work.