Student placement automation using UiPath and Excel for validating records, calculating scores, detecting errors, and predicting salary packages based on student performance data.
This is an academic project that helps placement coordinators automatically determine which salary category students qualify for. The tool reads student achievement data from Excel spreadsheets, calculates scores based on 8 different checkpoints (like coding problems solved, certifications, projects, and competitions), applies special rules for students who took the GATE exam, and classifies everyone into salary tiers ranging from 'Not Eligible' to 'Above 10 LPA'. The results are written back to a new spreadsheet that coordinators can use for placement decisions.
How It Works
As a placement coordinator, you have hundreds of student records with their coding scores, certifications, projects, and other achievements.
All student information is already organized in a spreadsheet with columns for each achievement area.
Instead of checking each record manually, the tool automatically reads all the data from your spreadsheet in seconds.
All 8 checkpoint scores are added together to get the total.
The 3 lowest scores are automatically ignored, and the GATE exam score is added to the remaining 5.
Based on their total score, students are classified as 'Above 10 LPA', 'Above 5 to Below 10 LPA', 'Up to 5 LPA', or 'Not Eligible'.
A new spreadsheet is created with all original data plus each student's total score and placement category, ready to share with placement teams.
Star Growth
Repurpose is a Pro feature
Generate ready-to-use prompts for X threads, LinkedIn posts, blog posts, YouTube scripts, and more -- with full repo context baked in.
Unlock RepurposeSimilar repos coming soon.