Orbit Edu BISE Tabulation Gazette, Examination Broadsheets & Multi-Campus Ranking Architecture

1. Assessment Mission & Board Alignment Architecture

Academic institutions operating under national and provincial educational frameworks—such as the Board of Intermediate and Secondary Education (BISE) and Federal Board (FBISE)—require strict compliance in examination scoring and tabulation. Assessment integrity dictates that raw exam scores must be accurately recorded across written theory and laboratory practical components, validated against passing criteria, and aggregated into official tabulation gazettes.

Manual calculation of examination gazettes on paper broadsheets introduces severe administrative risks: mathematical rounding errors, incorrect compartment evaluations, miscalculated grade point averages (GPA), and biased manual ranking tie-breakers. Furthermore, issuing marksheet certificates without cryptographic verification creates opportunities for student credential forgery.

Orbit Edu automates the entire examination assessment lifecycle. The system provides high-density marks entry matrices, validates passing marks per component, applies statutory board grading formulas, resolves merit rankings, and renders broadsheet gazettes ready for official board submission.

The architectural foundation resides in apps/edu/src/app/admin/exams/page.tsx (the examination control center), apps/api/src/modules/edu/services/grading.service.ts (the grading engine executing generateTabulationSheet and calculateGradeAndGpa), verified in grading.service.spec.ts, and the underlying BiseSubjectSummary, StudentSubjectScore, TabulationStudentRow, and TabulationSheetResult data contracts.

1.1 Operator Authority Matrix

Execution of examination operations and grading evaluation spans four institutional roles:

1. Subject Teacher (Tier 1 Examiner): Conducts term assessments, evaluates answer scripts, enters component scores (Theory and Practical), and provides student performance remarks.
2. Head of Department (Tier 2 Reviewer): Audits subject score distributions, verifies laboratory practical evaluations, and ensures marking consistency across sections.
3. Controller of Examinations (Tier 2 Academic Authority): Manages exam terms and datesheets, executes broadsheet tabulation runs, reviews compartment cases, and seals official tabulation gazettes.
4. Campus Principal (Tier 3 Executive): Grants final authorization to publish official examination gazettes, approves marksheet certificates, and issues academic scholarship awards.

2. Interactive Examination Tabulation Console

The examination broadsheet console displays high-density student results, subject-wise scores, position ranks, and class statistical distributions:

3. Statutory BISE Grading Matrices & Ranking Rules

The examination engine enforces statutory board criteria across marks aggregation, component splitting, letter grade assignment, and division calculation.

3.1 Grade Point & GPA Conversion Tables

The conversion function maps the overall percentage score (P) to statutory grade points and division rankings:

Mathematical Division Mapping Rules

Division(P) =
  First Division:      if P >= 60.0%
  Second Division:     if 45.0% <= P < 60.0%
  Third Division:      if 33.0% <= P < 45.0%
  No Division (Fail):  if P < 33.0%

3.2 Position Ranking Algorithm with Attendance Tie-Breaker

To prevent arbitrary ranking allocations when students achieve equal grand total marks, grading.service.ts sorts candidates deterministically:

evaluatedRows.sort((a, b) => {
  if (b.grandTotalObtained !== a.grandTotalObtained) {
    return b.grandTotalObtained - a.grandTotalObtained;
  }
  // Deterministic tie-breaker: prioritize student with higher attendance diligence
  return b.attendancePercentage - a.attendancePercentage;
});

evaluatedRows.forEach((row, idx) => {
  const rank = idx + 1;
  row.numericRank = rank;
  if (row.resultStatus !== 'PASSED') {
    row.positionRank = '—';
  } else if (rank === 1) {
    row.positionRank = '1st Position';
  } else if (rank === 2) {
    row.positionRank = '2nd Position';
  } else if (rank === 3) {
    row.positionRank = '3rd Position';
  } else {
    row.positionRank = `${rank}th Position`;
  }
});

4. Operational Runbook: Examination Lifecycle & Gazette Publication

The examination broadsheet routine is divided into three chronological phases: Examiner Marks Ingestion, Tabulation Verification, and Gazette Publication.

Phase 1: Examiner Marks Ingestion & Locking

1. Award List Initialization:

   • The examination controller generates blank award lists for each scheduled subject at apps/edu/src/app/admin/exams.
   • Teachers log in and access their assigned subject entry grid (navigating score inputs with Tab and confirming cell values with Enter).
   • For subjects with laboratory practicals (Physics, Chemistry, Biology, Computer Science), separate input columns are provided for Theory Marks and Practical Marks.

2. Validation Rules:

   • Theory marks cannot exceed maximum limits (such as 60 or 75 marks).
   • Practical marks cannot exceed laboratory limits (such as 15 or 25 marks).
   • Once all scores are verified, the subject head clicks Lock Award List, preventing subsequent modifications.

Phase 2: Tabulation Processing & Compartment Auditing

1. Execute Batch Tabulation:

   • The controller clicks Generate Tabulation Sheet.
   • The system aggregates all locked subject scores for enrolled students.
   • Calculates total obtained marks, overall percentages, letter grades, GPAs, and class divisions.

2. Compartment & Failure Review:

   • The algorithm audits students failing the 33% passing threshold:
     • 1 to 2 failed subjects: Flagged as COMPARTMENT. Eligible for supplementary examinations.
     • 3 or more failed subjects: Flagged as FAILED. Required to repeat the class term.
   • Top scorers and subject toppers are identified across all disciplines.

Phase 3: Gazette Sealing & Certificate Distribution

1. Official Gazette Number Allocation:

   • The system formats a unique gazette reference number:

     GazetteNumber = "BISE-GAZ-" + SessionKey + "-" + Section
     

     (e.g., BISE-GAZ-20252026-A).

2. Broadsheet PDF Generation:

   • Generates high-resolution multi-page A3/A4 landscape broadsheets suitable for permanent binding and BISE board submissions.
   • Broadsheets feature formal certification signatures from the Controller of Examinations and Campus Principal.

3. Individual Student Marksheet Release:

   • Student marksheet certificates are generated and made available on the Guardian Self-Service Portal.
   • Each marksheet contains a cryptographic verification hash to ensure authenticity.

5. Architectural Verification & Throughput Telemetry

The grading service is evaluated against high-density multi-campus examination loads:

6. Failure Modes & Recovery SOP

The following operational contingency protocols resolve edge-case exceptions during examination tabulation:

7. Cross-Vertical Internal Linkages

The BISE Tabulation Gazette system serves as the academic evaluation authority, coordinating directly with other modules in the academic network:

• Registrar 360 Student Dossier & Clearance Gates — Ingests final academic standing and position rankings into permanent student profiles.
• Campus Supervision Duty Rosters & Invigilation Neutrality — Manages faculty invigilation assignments and exam hall seating plans.
• Guardian Self-Service Portal & Turnstile Stream — Delivers term report cards and marksheet certificates directly to parent mobile interfaces.
• Diagnostic Report Lifecycle & Autoverify Rules — Shares high-throughput multi-component validation and cryptographic report verification architectures.
• Physical Stock Take Broadsheet & FEFO Reconciliation — Shares dense tabular DataGrid ergonomics and batch variance reconciliation patterns.