Result Excel Instruction
This guide helps in accurate data entry, result analysis, and student performance tracking. Follow step-by-step for optimal use of the Excel Result Sheet.
- Enable Macros: When opening the Excel sheet for the first time or if you see “Macro has been Disabled”, click “ENABLE CONTENT” and save the file. Example: Without enabling macros, calculations won’t run until you switch sheets or save again.
- School Data Sheet: Fill in all required school details. Pre-filled data can be edited. Example: Update school name, principal name, etc.
- Student Data Sheet:
- Enter GR No., seat number (1, 2, 3…), and name.
- Mark ‘Y’ in the exam column (1st, 2nd, or 3rd) if the student appeared; otherwise, you can’t enter marks.
- If a student has left, choose “LEFT”; if not present, select “N”.
- Example: A student present only in 1st exam gets ‘Y’ for 1st and ‘N’ for the rest.
- Village, Caste, Taluka, District: Typing once will store it in the dropdown. Example: If “Dabhi” is written once, select it from dropdown next time.
- Dropdown Fields: Use dropdown options only for standard, caste, etc. Do not enter anything manually. Example: Standard 8 must be selected from the dropdown.
- Optional Fields: Not all fields are mandatory, like Aadhaar number or English name. Fill only if needed.
- Student Info Required: GR No., admission standard/date, caste, gender must be filled to generate date-wise report. Example: Missing gender may cause the report not to work.
- Date-wise Entry Sheet:
- Choose how many months of data you need.
- Shows admission and dropout count per month.
- Example: Add columns for June, July to track admissions.
- Mark Entry Sheet (FE SLIP):
- Enter marks for only 7 main subjects.
- Additional subjects (Computer, Drawing, etc.) go in a different sheet.
- Example: Math, English go in FE SLIP; Drawing goes in minor subject sheet.
- Absent Students:
- Use ‘AB’ for absent students or leave cell blank (system auto-fills ‘AB’).
- Students marked ‘N’ or ‘LEFT’ won’t allow mark entry.
- Unit Test Entry:
- Enter unit test marks taken before 1st exam.
- Select subjects only from dropdown.
- Periodic Test Entry:
- Use “Periodic-1 MANUAL” for first term periodic tests.
- “Periodic-2 MANUAL” for second term.
- Automatic Marks from Periodic:
- If no unit test marks, periodic marks will be considered.
- Use AUTO sheet and select ‘MAX’ or ‘AVERAGE’ in yellow cell.
- These marks get added to internal marks automatically.
- Internal Marks:
- Only enter classwork, homework, and subject proficiency scores.
- Pass/Grace Marks:
- Automatically calculated as per rules.
- Grace marks added to help student pass in failing subjects.
- Result Summary Sheet:
- Displays 4 students’ results at a time by seat number.
- Includes subject-wise marks, grace, internal, total, percentage.
- Select seat number in yellow cell to view.
- Annual Report Card:
- Print on A4 paper – two students per page.
- Example: Enter seat number 3 (top), 4 (bottom) for page 1.
- Filtered PDF Result (Only Pass Students):
- Use yellow cells with “RESULT” heading.
- Choose “Grace Pass” and click “SAVE ALL RESULT AS PDF” to save PDFs in D: drive.
- You can also choose all types: Pass, Grace Pass, Fail.
- Filtered Result Sheet:
- Get list of passed, failed, and failed subjects.
- Subject-wise Fail List:
- Example: To find students failed in Math, select “RESULT-MATH” and ‘Fail’ below.
- Re-Test Sheet:
- For students who failed, retest is mandatory as per promotion rules.
- Retest Data Entry:
- Enter GR number only. Seat number and subject auto-fill.
- Marks entry fields become available for failed subjects.
- Retest Entry Format:
- First part shows subjects for retest.
- Second part shows already passed subjects (for info only).
Let me know if you need this turned into a PDF or printed report format!