Unibandh · Help centre
Recording planSign in
Unibandh · School management for Indian schools · Home
    Help centre/Exams, marks entry and report cards/Lesson 7

    Paste marks from Excel and lock a subject

    Fill a whole column by pasting from a spreadsheet, then lock the subject's marks so nobody changes them, and unlock when a correction is approved.

    Open /exams/marksRecording script
    5 min5 stepsOwner, Admin, Principal, TeacherDemo: sign in as Owner

    Before you start

    Finish first: Enter marks subject by subject

    • A marks grid is open.
    • For locking: you are an owner, admin or principal.

    Steps

    0 of 5 done
    1. You should see: The clipboard holds one line per student.

    2. You should see: Values fill downward from that row; AB, A or absent tick Absent; invalid cells turn red; locked rows are skipped. The footnote under the grid explains: "Paste a column from Excel to fill down; "AB" marks absent."

      If the clipboard has several columns, only the first column is used. A single value pastes normally into one cell.

      Open /exams/marks
    3. You should see: The counts match the spreadsheet.

    4. You should see: The toast "Marks locked"; every row shows a small padlock next to the name and the inputs are disabled. Teachers' autosaves to this subject are skipped with "N locked row(s) were not changed".

    5. You should see: Toast "Marks unlocked". On a published exam the page warns "This exam is published. Unlock marks before editing; changes may need report cards to be regenerated."

    What you have now

    • A subject's marks entered in seconds and protected from accidental edits.

    If something goes wrong

    Pasted values land in the wrong rows
    The spreadsheet order must match the grid's roll-number order. Sort by roll number before copying.
    No Lock button
    Only owners, admins and the principal can lock or unlock.
    "Marks are published. Ask an admin to unlock them."
    Teachers cannot edit a published exam; an admin must unlock the subject.

    Related guides

    • Enter marks subject by subject
    • The exam status workflow
    Enter marks subject by subjectNext: Co-scholastic and HPC grades