APCR Govt College - Level of Attainment Report Generator

Project Description

The Level of Attainment Report Generator is a Python-based desktop application developed for a government college to automate the generation of detailed academic performance reports. It processes Excel data to calculate semester-wise attainment levels and generates comprehensive reports with a user-friendly Tkinter GUI.

Features

  • User-Friendly Interface:
    • Built with Tkinter for an intuitive and easy-to-use GUI.
    • Allows users to select input and output files, choose semesters, and set cutoff percentages.
  • Automated Report Generation:
    • Processes Excel files to calculate attainment levels for end-semester theory, internal, and practical exams.
    • Generates detailed reports with metrics like student percentages, attainment levels, and course-wise summaries.
  • Dynamic Data Handling:
    • Uses pandas and openpyxl for efficient data processing and Excel file manipulation.
    • Supports multiple courses and semesters, with customizable cutoff percentages.
  • Final PO Sheet:
    • Creates a "Final PO" sheet summarizing Program Outcome (PO) levels for each department.

Technical Details

  • Languages and Libraries:
    • Python for core logic and scripting.
    • Tkinter for the graphical user interface.
    • pandas for data manipulation and analysis.
    • openpyxl for Excel file handling and formatting.
  • Input Data:
    • Excel files containing student marks and course details.
    • Columns include papcode, subject, r_mrkint, r_mrkprc, r_mrkext, and more.
  • Output Data:
    • Excel files with detailed attainment reports and a "Final PO" sheet.

How It Works

  1. User Input:
    • Users select an input Excel file, output file location, and semester.
    • Set cutoff percentages for end-semester theory, internal, and practical exams.
  2. Data Processing:
    • The application processes the input data to calculate attainment levels for each course.
    • Generates metrics like student percentages, attainment levels, and total course attainment.
  3. Report Generation:
    • Creates detailed Excel sheets for each course with formatted data.
    • Adds a "Final PO" sheet summarizing Program Outcome (PO) levels for all departments.

Usage

  • Ideal for academic institutions to automate the generation of performance reports.
  • Helps educators analyze student performance and program outcomes efficiently.