Generate Marksheets
Generate Marksheets
Create official marksheets that consolidate student results across all exams in a session. Marksheets display subject-wise marks, grades, and overall performance.
Time required: 5-10 minutes per batch
Prerequisites
- Exam Manager or Academic Admin role
- All exam results entered for session
- Grade configuration complete
- Results validated
Overview
Marksheets provide:
- Subject-wise marks breakdown
- Grade assignments per subject
- Overall percentage and grade
- Pass/fail status
- Class rank (optional)
Steps
Step 1: Navigate to Marksheet Register
- Go to OpenEduCat > Exam > Marksheet Register
- Click Create for new marksheet batch
Step 2: Configure Marksheet Details
| Field | Required | Description | Example |
|---|---|---|---|
| Name | Yes | Marksheet batch name | ”Fall 2024 Results” |
| Exam Session | Yes | Source session | ”Fall 2024 Finals” |
| Course | Auto | From session | ”B.Tech CS” |
| Batch | Auto | From session | ”2024-2025” |
| Generate Date | Yes | Date on marksheet | 2024-12-20 |
Step 3: Select Students
Choose which students to include:
| Option | Description |
|---|---|
| All Students | Entire batch |
| Passed Only | Students who passed all subjects |
| Failed Only | Students with failures |
| Select Specific | Manual selection |
Step 4: Configure Display Options
| Option | Description | Default |
|---|---|---|
| Show Grade | Display grade column | Yes |
| Show Percentage | Display percentage | Yes |
| Show Rank | Calculate class rank | No |
| Show Remarks | Include comments | No |
| Include Absent | Show absent subjects | Yes |
Step 5: Generate Marksheets
- Click Generate Marksheets button
- System processes each student
- Progress indicator shows status
- Marksheet lines created
Step 6: Review Generated Marksheets
- Go to Lines tab
- For each student, verify:
- Subject marks are correct
- Total and percentage accurate
- Final result status
- Click on any line for details
Step 7: Validate Marksheets
- Review all marksheet lines
- Click Validate to finalize
- Status changes to “Validated”
- Ready for printing/publishing
Marksheet Contents
Header Section
- Institution name and logo
- “Statement of Marks” title
- Exam session name and dates
Student Information
| Field | Source |
|---|---|
| Student Name | op.student.name |
| Roll Number | op.student.roll_number |
| Father’s Name | op.student.father_name |
| Course | op.course.name |
| Batch | op.batch.name |
Results Table
| Column | Description |
|---|---|
| Subject Code | Subject identifier |
| Subject Name | Full subject name |
| Max Marks | Total possible marks |
| Marks Obtained | Student’s score |
| Grade | Letter grade (A, B, C…) |
| Status | Pass/Fail/Absent |
Summary Section
| Field | Calculation |
|---|---|
| Total Obtained | Sum of all subjects |
| Total Maximum | Sum of max marks |
| Percentage | (Obtained/Max) x 100 |
| Overall Grade | Based on percentage |
| Final Result | Pass/Fail |
| Rank | Class position |
Printing Marksheets
Individual Print
- Go to Exam > All Marksheets
- Open student’s marksheet
- Click Print
- Download PDF
Bulk Print
- Open Marksheet Register
- Select your batch
- Click Print All Marksheets
- Downloads combined PDF
Print Options
| Option | Description |
|---|---|
| One per Page | Each student on new page |
| Include Signature | Add signature block |
| Include Seal | Add institution seal |
| Paper Size | A4/Letter |
Publishing Results
Portal Access (Enterprise)
- After validation, click Publish to Portal
- Students can view online
- Parents can also access
Email Distribution
- Select students in lines
- Click Action > Email Marksheet
- Compose message
- Send with PDF attached
Field Reference
Marksheet Register
| Technical Field | UI Label | Type | Notes |
|---|---|---|---|
name | Name | Char | Required |
session_id | Exam Session | Many2one | Source session |
course_id | Course | Many2one | Auto-populated |
batch_id | Batch | Many2one | Auto-populated |
generated_date | Date | Date | Print date |
state | State | Selection | draft/validated |
line_ids | Lines | One2many | Student marksheets |
Marksheet Line
| Technical Field | UI Label | Type | Notes |
|---|---|---|---|
student_id | Student | Many2one | Student record |
total_marks | Total Marks | Float | Marks obtained |
percentage | Percentage | Float | Calculated % |
grade_id | Grade | Many2one | Overall grade |
result | Result | Selection | pass/fail |
rank | Rank | Integer | Class position |
Troubleshooting
”No results found for session”
All exams need results:
- Check all exams have results entered
- Verify status is “Result Updated”
- At least one student with marks
Percentage calculating wrong
Check:
- All subjects have correct max marks
- No zero max marks values
- Marks don’t exceed maximum
Missing subjects in marksheet
Subject may be missing:
- No exam created in session
- Results not entered
- Student not marked as attendee
Cannot validate
Some results incomplete:
- Check lines with errors
- Enter missing marks
- Try validation again
Related: Generate Results | Enter Results | Create Exam Session