Unibandh · Help centre
Recording planSign in
Unibandh · School management for Indian schools · Home
    Help centre/Exams, marks entry and report cards/Paste marks from Excel and lock a subject/Script

    Recording script: Paste marks from Excel and lock a subject

    5 shots · about 44 s of finished video · lesson 7 of Exams, marks entry and report cards

    Record as

    Owner (demo_owner)

    Sign in at /demo on a demo-mode build

    Screens

    /exams/marks

    Length

    44 s

    narration at ~150 words/min + screen time

    Status

    Not yet recorded

    Before recording

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

    Intro voice-over

    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.

    #ScreenAction (on screen)Must be visibleVoice-over~s
    1/exams/marksIn your spreadsheet, sort the students in roll-number order and copy the marks column (one value per row). Type AB for absentees.The clipboard holds one line per student.Teachers who kept marks in Excel do not retype them: one paste fills the column.10
    2/exams/marksClick the Marks box of the first student and paste.

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

    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."Click the first marks box and paste; the column fills downward.8
    3/exams/marksCheck the summary bar's Entered, Highest and Average, then wait for Autosaved.The counts match the spreadsheet.Check the summary bar before you move on.7
    4/exams/marksAs an admin, click Lock in the summary bar.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".Lock a subject once the teacher confirms it is final. Publishing the exam locks every subject at once.11
    5/exams/marksTo correct a mark later, click Unlock, change the cell, then Lock again.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."Unlock, correct, and lock again when a change is approved.8

    Outro voice-over

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

    After the video is published

    Add its YouTube id under exams-marks-paste-lock in src/lib/help/videos.ts, with a chapters map of step number → seconds. The lesson page then shows the video and a “Watch this step” link on every step. See the video production guide.