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!
No comments:
Post a Comment