Automated CGPA Computation & Academic Standing

1. Overview & Business Value#

This comprehensive operational guide details the architecture, business workflows, configuration parameters, and execution steps for Automated CGPA Computation & Academic Standing within SmartERP.

Master the mathematics of Semester GPA, Cumulative CGPA, academic standing statuses, Dean's List honors, and academic dismissals.

{screenshot:cgpa-computation-and-academic-standing-overview-dashboard}

2. Prerequisites & Security Access Groups#

• Required Modules: smarterp_higher_education, smarterp_student_records
• Security Groups:
  • Admissions Officer (Technical ID: smarterp_higher_ed.group_admissions_user)
  • Registrar / Academic Dean (Technical ID: smarterp_higher_ed.group_registrar_manager)
  • Faculty Member / Instructor (Technical ID: smarterp_higher_ed.group_faculty_user)
• Master Data Dependencies: Faculties, departments, ECTS modular curricula, academic semesters (Ethiopian/Gregorian calendar), tuition fee schedules, and student master files.

3. Step-by-Step Configuration & Execution#

Step 1: Navigating to the Module Interface#

1. Log into your SmartERP instance at https://smarterp.et/odoo.
2. Open the main App Switcher (grid icon in the top-left corner).
3. Select the Higher Education app icon.
4. From the top navigation bar, open Higher Education → Academic Registry → Students / Admissions / Courses / Grading.

{screenshot:cgpa-computation-and-academic-standing-app-switcher-navigation}

Step 2: Creating and Parameterizing Records#

1. Click the New button in the top-left control panel.
2. Complete the mandatory fields in the record form:
   • Student ID Number (Mandatory): Unique institutional student registration identifier
   • Full Name & National ID (Mandatory): Legal name matching Ministry of Education (MoE) enrollment records
   • Academic Program & Faculty (Mandatory): Approved undergraduate or postgraduate modular program
   • Semester Term (Mandatory): Active academic term adhering to ETA curriculum guidelines
3. Configure optional operational parameters and localized tags as required:
   • Course Prerequisite Override (Optional): Authorized waiver for advanced module enrollment
   • Tuition Sponsorship (Optional): Cost-sharing agreement or private employer corporate sponsorship
   • Dormitory & Campus Facility (Optional): Assigned residential block and meal plan access
4. Click the Save icon in the control bar to commit the record.

{screenshot:cgpa-computation-and-academic-standing-record-creation-form}

Step 3: Validating and Processing Transactions#

• State Transitions: Execute operational state progression (Applied → Admitted → Registered / Enrolled → Active Study → Grades Finalized → Graduated).
• Ledger & System Impact: Semester registration automatically generates student tuition invoices in Accounts Receivable; fee settlement via Telebirr/CBE Birr marks student financially cleared.
• Audit Verification: Automated recording of author ID, timestamp, and immutable revision history.

{screenshot:cgpa-computation-and-academic-standing-transaction-processing-state}

Grade Point Average Mathematical Architecture#

SmartERP automates all academic performance evaluations using standard credit-weighted quality point formulas:

1. Semester Grade Point Average (SGPA)#

$$\text{SGPA} = \frac{\sum_{i=1}^{k} \left( \text{Credit Hours}i \times \text{Grade Point}_i \right)}{\sum{i=1}^{k} \text{Credit Hours}_i}$$

2. Cumulative Grade Point Average (CGPA)#

$$\text{CGPA} = \frac{\sum_{j=1}^{N} \left( \text{Credit Hours}j \times \text{Grade Point}_j \right)}{\sum{j=1}^{N} \text{Credit Hours}_j}$$

Where $N$ represents all credit-bearing courses completed across the student's entire institutional history.

Course Repeat & Grade Replacement Policy#

When a student fails a course (F or D) and subsequently repeats it:

• The new grade replaces the previous failing grade in the CGPA computation.
• The original failing grade remains visible on the historical transcript with an [R] (Repeated) notation, preserving full historical transparency.

Statutory Academic Standing Rules#

At the end of each academic semester, the system evaluates student CGPA against statutory MoE thresholds:

flowchart TD
    A["Compute Semester SGPA & Cumulative CGPA"] --> B{"Undergraduate CGPA Assessment"}
    B -- "CGPA >= 3.50 (SGPA >= 3.50)" --> C["Status: Dean's Honor List"]
    B -- "2.00 <= CGPA < 3.50" --> D["Status: Good Academic Standing"]
    B -- "1.75 <= CGPA < 2.00" --> E["Status: Academic Warning (Probation)"]
    B -- "1.50 <= CGPA < 1.75" --> F{"First Time in Range?"}
    F -- Yes --> G["Status: Final Academic Probation"]
    F -- No (Consecutive) --> H["Status: Academic Dismissal"]
    B -- "CGPA < 1.50" --> H

Academic Action Classifications:#

1. Good Standing: Student maintains $\text{CGPA} \ge 2.00$; eligible for regular term progression.
2. Academic Warning (Probation): $\text{CGPA} < 2.00$; maximum registration capped at 12 credit hours.
3. Academic Dismissal: Consecutive semesters on probation or failure to maintain minimum progression; student is formally discontinued from the program.

4. Advanced Configuration Points#

• Automated Actions & Scheduled Tasks (Crons):
  • Education: Compute semester GPA and cumulative CGPA (smarterp_higher_ed.ir_cron_cgpa_calc): Runs at the end of each examination period to compute student academic standing
  • Finance: Generate semester tuition fee invoices (smarterp_higher_ed.ir_cron_tuition_invoices): Runs prior to semester registration deadline
• Custom Print Templates & Reports:
  • Official Student Academic Transcript (MoE & ETA Standards)
  • Semester Course Registration & Clearance Slip
  • Student ID Card with Cryptographic QR Verification
  • Examination Results & Faculty Grade Distribution Ledger
• Multi-Company Rules: Record-level security isolation under Company 1 (Ashewa Technology Solutions S.C.), preventing cross-company ledger leakage across parent and subsidiary legal entities.

5. Comprehensive Troubleshooting Matrix#