Interview Score Aggregator
Consolidate grading entries from multiple interviewer panels across weighted criteria — automatically compute composite scores and rank high-potential applicants.
Used by admissions panels, academic selectors, and scholarship committees
How Panel Interview Score Aggregation Works
Panel interviews introduce inter-rater variability — different panellists naturally score the same applicant differently based on their focus area and assessment style. Aggregating scores across panels and weighting them against standardised criteria neutralises individual bias and produces a more defensible, objective ranking.
This tool computes a weighted composite score per applicant by: (1) averaging each panellist's score per criterion, (2) multiplying by the criterion's normalised weight, and (3) summing across all criteria to produce a final 0–10 composite.
Aggregation Method
- Panel average per criterion — All panels' scores for a given applicant-criterion pair are averaged to produce a single panel-consensus score.
- Weight normalisation — Criterion weights are summed and each is divided by the total, so they always add up to 100% regardless of input values.
- Weighted composite — Panel-average scores are multiplied by their normalised weights and summed to produce the final composite (0–10 scale).
- Final ranking — Applicants are sorted in descending order of composite score with medal awards for the top 3.
Frequently Asked Questions
Averaging normalises for panels that may grade more or less strictly than others. A panel that consistently scores 9–10 across all criteria would inflate composite totals if summed. Averaging ensures the composite reflects genuine assessment rather than scoring-style differences between panellists.
Leave the score field blank for applicant-criterion combinations that a panel did not assess. The tool treats blank entries as absent and computes the average only from panels that provided a score, so partial panel attendance doesn't skew the result.
High variance on a given criterion for a particular applicant signals disagreement between panels — this applicant warrants discussion before a final decision. Low variance indicates broad consensus. The results table highlights where panels diverged most significantly.
UniCloud360 Admissions CRM manages the full interview workflow — scheduling, panel assignment, score collection, and offer generation — in one platform.
Book a DemoHow to Aggregate Interview Scores in 3 Steps
Follow these steps to get results in under a minute
Real Results from Real Users
Trusted by lecturers and students across Sri Lankan universities
"We interview 200+ scholarship applicants across three panels every year. This tool replaced our custom spreadsheet that kept breaking. Instant ranking with no formula errors."
"The variance column in the results is the hidden gem — it immediately flags the borderline candidates where panels disagreed, which is exactly where we need the discussion."
"PDF export is professionally formatted and goes straight into the selection pack. Our academic board was impressed."
"Very intuitive. I set up our entire 5-criterion framework in under two minutes. Minor suggestion: add a notes field per applicant for the PDF."
"We used to collate panel sheets manually and average in Excel. One click now does what took 45 minutes. Game changer at offer round."
How Interview Score Aggregator Compares
vs spreadsheets, manual processes, and paid platforms
| Feature | UniCloud360 Interview Score Aggregator | Manual Excel | Shared Google Sheet | Paid ATS |
|---|---|---|---|---|
| Multi-panel score averaging | Automatic | Complex formulas | Manual setup | Yes |
| Weighted composite ranking | Instant | Formula error-prone | Limited | Yes |
| Panel variance indicator | Visible | Not built in | No | Yes |
| PDF ranking report | One click | Excel print | Screenshot only | Paid |
| Free to use | Free | Requires Excel | Free | Paid |