Marks Entry

A fast, spreadsheet-style marks entry system that lets teachers record internal marks for all allocated subjects — component by component, with Excel bulk upload, special case handling, and a structured grievance resolution workflow.

1. How Marks Entry Works

Internal marks are organized by subject and mark components. The HOD configures which components (e.g., Internal Exam 1, Assignment, Viva, Practical) exist for each subject. The teacher then fills in each student's marks for each component they are responsible for.

sequenceDiagram
    participant TCH as Teacher
    participant SYS as System
    participant HOD as HOD Panel
    participant STU as Student Portal

    TCH->>SYS: Open Marks Entry for Subject
    SYS-->>TCH: Student list + component structure
    TCH->>SYS: Enter marks per student per component
    TCH->>SYS: Submit for HOD Review
    HOD->>SYS: Review and Approve marks
    SYS-->>STU: Marks published to student portal

2. The Marks Entry Interface

Designed to feel like an Excel spreadsheet — familiar, fast, and efficient for batch data entry.

2.1 Layout

Row = One Student: Each row represents one student in the class. Rows are ordered by roll number.
Column = One Component: Each column represents a mark component (e.g., "Sessional Test 1", "Assignment", "Practical Viva", "Lab Journal").
Maximum Marks Header: At the top of each column, the maximum marks for that component are shown (e.g., "25" for a sessional test).
Auto-calculated Total: The "Total" column auto-sums across all components and recalculates in real-time as the teacher types.
Auto-calculated Percentage: The system divides the total by the max marks and shows the percentage — teachers don't need to calculate manually.

2.2 Entering Marks

Click-to-Edit: Click any cell in the grid to edit it. Press Tab to move to the next cell (keyboard-friendly for fast data entry).
Input Validation: If a teacher enters a value greater than the maximum marks for that component, the cell turns red and the entry is rejected.
Auto-save Draft: Marks are auto-saved every 60 seconds as a draft — no data is lost if the browser closes unexpectedly.
Unsaved Indicator: The page shows a "Unsaved changes" indicator when marks have been edited but not yet saved/submitted.

2.3 Special Marks Cases

Case	What to Enter	How It Appears on Result
Student was Absent	Select "Absent (AB)" from the dropdown for that component	Shown as "AB" — treated as 0 for grade calculation
Marks Withheld	Select "Withheld (W)" — used when a disciplinary hold is placed	Shown as "W" — result remains in pending state
Grace Marks	Enter the total marks including grace. Add a note explaining the reason	A small "G" indicator shows marks include grace
Not Applicable	Select "N/A" — for components the student is exempted from	Component excluded from total calculation

3. Excel Bulk Upload

For teachers who prefer to work offline or already have marks in a spreadsheet, the Excel upload feature provides a seamless alternative.

Download Template: The teacher downloads a pre-formatted Excel file with the class roster and component columns already set up — no manual formatting required.
Fill Offline: Teacher fills in marks at their convenience, using their local Excel application.
Upload & Preview: Upload the filled Excel file. The system shows a preview of the imported data with color coding — green for valid entries, red for errors (e.g., marks exceeding maximum).
Error Correction: Invalid entries are highlighted. The teacher corrects them in the preview directly (no need to re-upload) and then confirms.
Merge with Existing: If some marks were already entered manually, the upload can merge — updating only empty cells without overwriting existing entries.

4. Saving, Submitting, and HOD Review

Save as Draft: Marks are saved but not submitted to the HOD — the teacher can continue editing.
Submit for HOD Review: Once all marks are complete, the teacher submits. The HOD is notified that marks for this subject are ready for review.
Locked After Submission: Once submitted, the marks are locked — the teacher cannot edit them. If a correction is needed, the teacher contacts the HOD to unlock.
HOD Approval: The HOD reviews the marks and either approves (publishes to students) or sends them back with comments for correction.
Correction Cycle: If returned, the teacher sees the HOD's comment, makes corrections, and resubmits. This cycle can repeat until the HOD approves.

5. Marks Grievance Handling

If a student disputes their marks after publication, they raise a formal grievance through their student portal. The teacher is the first reviewer in the resolution chain.

5.1 Teacher's Grievance Queue

Grievance Details: Student name, subject, component, marks awarded (current), marks expected by student, and the student's written reason.
Supporting Document: If the student uploaded evidence (e.g., a scanned answer sheet), the teacher can view it.

5.2 Teacher's Response Options

Accept: If the grievance is valid — the teacher confirms the correction. The marks are updated automatically and the student is notified.
Reject: If the grievance is not valid — the teacher enters a reason explaining why the original marks stand. The student can then escalate to the HOD if they disagree.
Response Deadline: Teachers must respond within the HOD-configured grievance window (typically 3–5 working days).

Overall Benefit: Marks entry that previously involved maintaining paper mark sheets, manually calculating totals and percentages, and physically submitting registers to the exam department is now a streamlined digital process. The Excel upload feature means teachers who prefer traditional methods are not forced to change their workflow — they simply upload their completed spreadsheet. The grievance system provides a fair, documented channel for mark disputes — protecting both students and teachers.

SLMT LMS