Gradebook Overview
Gradebook Overview
Use the gradebook to enter, manage, and calculate student grades across all assessments.
Time required: Varies by class size
Prerequisites
- Faculty or Grading role
- Grade scale configured
- Assessments created
Access Gradebook
Step 1: Navigate to Gradebook
- Go to OpenEduCat -> Grading -> Gradebook
- Select course and batch
- View gradebook grid
Step 2: Understand the Layout
| Column | Content |
|---|---|
| Student Name | List of enrolled students |
| Assessments | Each assignment/exam column |
| Total | Calculated total score |
| Grade | Letter grade from scale |
| GPA | Calculated GPA |
Enter Grades
Individual Entry
- Click on cell to edit
- Enter score
- Press Tab or Enter to save
- Move to next cell
Bulk Entry
- Click Import Grades
- Download template
- Fill in spreadsheet
- Upload file
- Confirm import
Grade Calculations
Weighted Grading
Assessments weighted by category:
| Category | Weight |
|---|---|
| Assignments | 20% |
| Quizzes | 15% |
| Midterm | 25% |
| Final Exam | 40% |
Simple Average
All assessments equal weight:
- Total points earned
- Divided by total possible
- Convert to percentage
Points-Based
Raw point accumulation:
- Sum all earned points
- Compare to possible points
- Calculate percentage
Gradebook Features
Filter and Search
| Filter | Function |
|---|---|
| Student | Find specific student |
| Assessment | View single assessment |
| Status | Graded/Ungraded |
| Grade Range | A’s, B’s, etc. |
Sort Options
| Sort By | Description |
|---|---|
| Name | Alphabetical |
| Total | By total score |
| Grade | By letter grade |
| Last Updated | Recent changes |
Grade Status
| Status | Color | Meaning |
|---|---|---|
| Entered | Green | Grade recorded |
| Pending | Yellow | Awaiting entry |
| Excused | Blue | Exempt from assessment |
| Missing | Red | No submission |
Special Actions
Excuse Student
Student exempt from assessment:
- Right-click cell
- Select Excuse
- Not counted in total
Drop Lowest
Configure to drop lowest scores:
- Go to category settings
- Set Drop Lowest count
- System excludes lowest
Curve Grades
Apply curve to assessment:
- Select assessment column
- Click Apply Curve
- Enter curve method
- Preview and confirm
Gradebook Reports
| Report | Description |
|---|---|
| Class Summary | All students, all grades |
| Student Report | Individual progress |
| Assessment Analysis | Score distribution |
| Grade Distribution | Grade breakdown |
Field Reference
Gradebook Entry
| Technical Field | UI Label | Type | Notes |
|---|---|---|---|
student_id | Student | Many2one | Required |
assessment_id | Assessment | Many2one | Required |
score | Score | Float | Points earned |
max_score | Max Score | Float | Points possible |
percentage | Percentage | Float | Calculated |
grade | Grade | Char | From scale |
status | Status | Selection | Entry status |
Publishing Grades
Make grades visible to students:
- Review all entries
- Click Publish
- Confirm publication
- Students can view grades
Troubleshooting
GPA not calculating
Check:
- Grade scale assigned
- Include GPA flag set
- Credit hours configured
Total showing incorrectly
Verify:
- Category weights sum to 100%
- All scores entered
- Excused entries handled correctly
Cannot edit grade
Confirm:
- You have edit permissions
- Gradebook not locked
- Assessment not finalized
Related: Configure Grade Scale | Grade Reports