Generate Marksheets

Generate Marksheets

Create official marksheets consolidating student results across all exams in a session. Marksheets include subject-wise marks, grades, overall percentage, and final result status.

Time required: 5-10 minutes

Prerequisites

• Exam Manager or Academic Admin role
• All exams in session have results entered
• Exams in “Result Updated” or “Done” state
• Grade configuration complete

Steps

Step 1: Navigate to Marksheet Register

1. Go to OpenEduCat → Exam → Marksheet Register
2. Click Create to start a new marksheet batch

Step 2: Configure Marksheet Settings

Fill in the marksheet details:

Field	Required	Description	Example
Name	Yes	Marksheet batch name	”Fall 2024 Final Results”
Exam Session	Yes	Source exam session	”Fall 2024 Finals”
Course	Auto	Populated from session	-
Batch	Auto	Populated from session	-
Generate Date	Yes	Date on marksheet	2024-12-20

Step 3: Select Students

Choose which students to include:

Option	Description
All Students	Generate for all students in batch
Passed Only	Only students who passed all subjects
Failed Only	Only students who failed one or more
Select Specific	Choose individual students

Step 4: Configure Display Options

Option	Description
Show Grade	Display grade column
Show Percentage	Display percentage column
Show Rank	Calculate and display class rank
Show Remarks	Include remarks column
Include Absent Subjects	Show subjects where student was absent

Step 5: Generate Marksheets

1. Click Generate Marksheets button
2. System processes results for each student
3. Progress indicator shows status
4. Marksheet lines are created

Step 6: Review and Finalize

1. Review generated marksheets in the Lines tab
2. For each student, verify:
   • Subject-wise marks are correct
   • Total and percentage calculated properly
   • Final result status (Pass/Fail)
3. Click Validate to finalize marksheets

Marksheet Contents

Each generated marksheet includes:

Header

• Institution name and logo
• “Statement of Marks” title
• Exam session details

Student Information

Field	Source
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

Subject-wise 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
Status	Pass/Fail/Absent

Summary Section

Field	Calculation
Total Marks Obtained	Sum of all subjects
Total Max Marks	Sum of max marks
Percentage	(Obtained/Max) × 100
Overall Grade	Based on percentage
Final Result	Pass if all subjects passed
Rank	Position in class (optional)

Viewing Marksheets

Individual View

1. Go to Exam → All Marksheets
2. Click on a student’s marksheet
3. View full details in form view
4. Click Print for PDF

Bulk Print

1. Go to Marksheet Register
2. Open your marksheet batch
3. Click Print All Marksheets
4. Download as PDF (one per page)

Result Templates (Enterprise)

Use templates for complex result calculations:

Create Result Template

1. Go to Exam → Configuration → Result Templates
2. Click Create
3. Configure:

Field	Description
Name	Template name
Weightage Type	Equal / Custom weights
Pass Criteria	All subjects / Percentage based
Include Internal Marks	Add internal assessment

Subject Weightage

If using custom weightage:

Subject	Credits	Weightage
Mathematics	4	20%
Physics	4	20%
Lab Practical	2	10%

Formula Configuration

Set up custom calculations:

Final Score = (External × 0.7) + (Internal × 0.3)
Grade Points = Sum(Subject Credits × Grade Points) / Total Credits

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	Marksheet date
state	State	Selection	draft/validated
line_ids	Marksheet Lines	One2many	Individual marksheets

Marksheet Line

Technical Field	UI Label	Type	Notes
student_id	Student	Many2one	Student record
roll_number	Roll Number	Char	From student
total_marks	Total Marks	Float	Sum of all subjects
total_max_marks	Max Marks	Float	Maximum possible
percentage	Percentage	Float	Calculated
grade_id	Grade	Many2one	Overall grade
result	Result	Selection	pass/fail
rank	Rank	Integer	Class position
result_line_ids	Results	One2many	Subject-wise results

Publishing Results

Make Available on Portal (Enterprise)

1. After validation, click Publish to Portal
2. Students can view marksheets in their portal
3. Parents can also access via portal

Email Marksheets

1. Select students in marksheet lines
2. Click Action → Email Marksheet
3. Compose email message
4. Send with PDF attached

Troubleshooting

”No results found for session”

Ensure all exams have:

• Results entered
• Status changed to “Result Updated”
• At least one student with marks

Percentage calculating incorrectly

Check that:

• All subjects have correct max marks
• No subjects have zero max marks
• Student marks don’t exceed max marks

Missing subjects in marksheet

The subject may not have:

• An exam created in the session
• Results entered
• Student marked as attendee

”Cannot validate - missing results”

Some students have incomplete results:

1. Check marksheet lines with errors
2. Enter missing marks for flagged subjects
3. Try validation again

Rank not appearing

Rank calculation requires:

• “Show Rank” option enabled
• More than one student
• All marksheets generated
• Results validated

---

Related: Enter Exam Results | Create an Exam Session