Level of Attainment Report Generator

Project Description

A Python-based desktop application developed for a government college to automate generation of detailed academic performance reports. It processes Excel data to calculate semester-wise attainment levels and produces comprehensive reports via a Tkinter GUI.

Features

• Intuitive Tkinter GUI for selecting input/output files and semesters
• Calculates attainment levels for end-semester theory, internal, and practical exams
• Generates detailed Excel sheets with metrics for each course
• Creates a "Final PO" sheet summarizing Program Outcome (PO) levels per department
• Supports multiple courses and semesters with customizable cutoff percentages

Technical Stack

• Language: Python
• GUI: Tkinter
• Data: Pandas, openpyxl

How It Works

1. User selects input Excel file, output location, semester, and cutoff percentages.
2. Application processes marks to calculate attainment levels per course.
3. Generates formatted Excel report with a Final PO summary sheet.