Automating Student LPA Classification using UiPath Studio & Microsoft Excel
Author: Sankari Ganesh
Department: Information Technology
Institution: St. Joseph's Institute of Technology (Autonomous), OMR, Chennai – 119
Program: Placement Empowered Program (PEP) — Robotics Process Automation (RPA)
Manual calculation of placement eligibility is:
- Time-consuming — coordinators check each student record individually
- Error-prone — multiple parameters and eligibility rules increase mistake risk
- Unscalable — large student batches cause significant delays
This project automates the entire pipeline: reading student data → calculating scores → classifying LPA categories → writing results back to Excel.
| # | Goal |
|---|---|
| 1 | Automatically read student data from Excel |
| 2 | Calculate total marks from 8 standard checkpoints |
| 3 | Apply GATE exam flexibility (skip 3 lowest checkpoints) |
| 4 | Assign LPA categories based on score thresholds |
| 5 | Generate an updated Excel report with results |
| 6 | Handle large datasets accurately and consistently |
RPA_PlacementEligibility/
│
├── Main.xaml # UiPath main workflow (XAML)
├── project.json # UiPath project configuration
│
├── Data/
│ └── Students.xlsx # Input file (student records)
│
├── Output/
│ └── Students_Result.xlsx # Auto-generated output (after run)
│
├── generate_sample_data.py # Script to create sample Students.xlsx
├── verify_logic.py # Standalone Python script to test logic
│
└── README.md
| Column | Description |
|---|---|
| Roll No | Student roll number |
| Register No | University register number |
| Student Name | Full name |
| Department | Dept code (IT, CSE, ECE, …) |
| Class | Degree (B.E, B.Tech, …) |
| Year | Current year of study |
| Coding Problems Solved | Checkpoint score |
| Open Source Contribution | Checkpoint score |
| Competition Achievement | Checkpoint score |
| Certificate Requirement | Checkpoint score |
| CP Rating (CodeChef / CodeForces / AtCoder) | Checkpoint score |
| Project / Product Development Checkpoint | Checkpoint score |
| Aptitude Checkpoint | Checkpoint score |
| Weekly SkillRank Assessment Checkpoint | Checkpoint score |
| GATE Exam Marks | Optional — leave 0 if not applicable |
Total = Coding + Open Source + Competition + Certificate
+ CP Rating + Project + Aptitude + SkillRank
1. List all 8 checkpoint scores
2. Sort ascending, identify 3 lowest
3. Exclude those 3 from calculation
4. Total = Sum(remaining 5 checkpoints) + GATE Marks
Example:
Scores: 5, 10, 10, 12, 15, 18, 20, 30
Sorted: 5, 10, 10, 12, 15, 18, 20, 30
Skip: 5, 10, 10 → Remaining: 12+15+18+20+30 = 95
GATE: 40
Total: 95 + 40 = 135
| Total Marks | LPA Category |
|---|---|
| ≥ 260 | Above 10 LPA |
| 130 – 259 | Above 5 to Below 10 LPA |
| 70 – 129 | Up to 5 LPA |
| < 70 | Not Eligible |
The output file contains all original columns plus two new ones appended:
| Column Added | Description |
|---|---|
| Total Marks | Computed score (GATE logic applied if applicable) |
| LPA Category | Classified placement tier |
| Tool | Purpose |
|---|---|
| UiPath Studio | RPA workflow automation |
| Microsoft Excel | Input data storage & output report |
| UiPath Excel Activities | Read/Write Excel files |
Prerequisites:
- UiPath Studio ≥ 2023.10
- Microsoft Excel installed
- UiPath.Excel.Activities package installed in Studio
Steps:
- Clone this repository:
git clone https://github.com/YOUR_USERNAME/RPA_PlacementEligibility.git
- Open UiPath Studio → Open Project → select
project.json - Generate sample data (first time only):
pip install openpyxl python generate_sample_data.py
- Ensure
Data/Students.xlsxexists with student records - Press Run (F5) in UiPath Studio
- Check
Output/Students_Result.xlsxfor results
Useful to verify logic or test on any machine:
pip install openpyxl
python generate_sample_data.py # creates sample input
python verify_logic.py # runs logic and saves outputExpected terminal output:
======================================================================
Placement Readiness Calculator — Logic Verification
Input : Data/Students.xlsx
======================================================================
Name GATE Total Category
---------------------- ----- ------ --------------------------
Aarav Kumar — 250.0 Above 5 to Below 10 LPA
Gayathri Menon 60 178.0 Above 5 to Below 10 LPA
...
======================================================================
[OK] Results saved to: Output/Students_Result.xlsx
┌─────────────────────────────────────────────────┐
│ START AUTOMATION │
└──────────────────────┬──────────────────────────┘
▼
┌────────────────────────┐
│ Read Students.xlsx │
│ (Load into DataTable) │
└───────────┬────────────┘
▼
┌────────────────────────┐
│ For Each Student Row │◄──────────────┐
└───────────┬────────────┘ │
▼ │
┌────────────────────────┐ │
│ Read 8 Checkpoints │ │
│ + GATE Marks │ │
└───────────┬────────────┘ │
▼ │
GATE > 0? │
/ \ │
YES NO │
│ │ │
▼ ▼ │
Sort checkpoints Sum all 8 │
Skip 3 lowest checkpoints │
Sum 5 + GATE │
│ │ │
└──────┬───────┘ │
▼ │
┌───────────────────────┐ │
│ Classify LPA Category│ │
│ (≥260 / 130-259 / │ │
│ 70-129 / <70) │ │
└───────────┬───────────┘ │
▼ │
┌───────────────────────┐ │
│ Write Total + LPA │ │
│ back to DataTable │ │
└───────────┬───────────┘ │
│ More rows? ─┘
▼
┌───────────────────────┐
│ Write Full DataTable │
│ to Students_Result │
└───────────┬───────────┘
▼
[ END ]
| Student Name | GATE | Total Marks | LPA Category |
|---|---|---|---|
| Aarav Kumar | — | 250 | Above 5 to Below 10 LPA |
| Chitra Rajan | — | 63 | Not Eligible |
| Esha Nair | 45 | 174 | Above 5 to Below 10 LPA |
| Gayathri Menon | 60 | 280 | Above 10 LPA |
| Harish Reddy | — | 39 | Not Eligible |
This project is developed for academic purposes as part of the Placement Empowered Program (PEP) at St. Joseph's Institute of Technology.
- UiPath Community — for the free Studio IDE and activity packages
- St. Joseph's Institute of Technology — for the PEP-RPA program
- Placement Coordinators for defining the eligibility rules
"Automating Student Placement Eligibility — Making decisions faster, fairer, and more consistent."