VTU Result Analysis / Student Result Automation

A Python-based desktop automation tool to fetch student results from the VTU results portal and export them into an Excel sheet for department-level analysis.

This project was originally built and used across multiple departments in my college to automate result retrieval and reduce manual effort by 90%.

---

Tech Stack

• Python
• Tkinter – Desktop GUI
• Selenium – Browser automation
• Excel automation
  • openpyxl for reading .xlsx
  • xlwt for writing .xls

---

What This Tool Does

• Reads student USNs from an Excel file
• Opens the VTU results website in Google Chrome
• Submits USNs and fetches:
  • Student name
  • Subject-wise IA (Internal assessment), SEE (Semester End Exam), TOTAL marks
  • Pass/Fail status
• Exports the collected data into an Excel .xls file

---

Important Notes

• The VTU portal uses a captcha, so the process cannot be fully automated.
• The tool relies on VTU(Visevesvaraya Technological university, Karnataka, India) website structure (XPath selectors).
  If the website layout changes, the selectors may need to be updated.
• Real student data should never be committed to the repository.

---

Setup Instructions

Install Dependencies

From the repository root:

pip install -r requirements.txt

ChromeDriver Setup

This tool requires ChromeDriver.

• Download ChromeDriver matching your installed Chrome version from ChromeDriver Downloads
• Provide the ChromeDriver path through the GUI

---

How to Run

From the repository root:

python src/main.py

---

How to Use the Application

GUI Inputs

• CHROMEDRIVER PATH
  Select the path to chromedriver.exe (Windows) or the ChromeDriver binary.

• USN FILE PATH
  Select an Excel .xlsx file containing USNs in Column A.

• WEBSITE ADDRESS
  Paste the VTU results portal URL.

• SAVE PATH
  Choose the output file path and name (Excel .xls).

• USN START (Row) and USN END (Row)
  Specify the row range in the input Excel file to process.

Click SUBMIT to start automation.

Captcha Handling

• When prompted in the terminal, manually enter the captcha displayed in the browser.
• The same captcha is reused for processing the selected range.

---

Output

Generates an Excel .xls file containing:

• USN
• Student Name
• Subject-wise IA, SEE, TOTAL marks
• Result status (P/F)

---

Authors

Samarth Kashyap

Original project developed during undergraduate studies (Department of CSE)

---

License

This project is shared for educational purposes.