How can I bulk upload marks or grades?

Teachers can bulk upload marks or grades in three simple steps using the google chrome web browser.

Step 1: Download the Excel Template

1. Navigate to Student > Examination > Marks Entry.
2. Click the icon at the top-right of the screen to proceed for download the predefined excel format.
3. Select the Class, Section, Term, Assessment, and Subject.
4. Click Download (top-right corner).
5. A predefined Excel file will be downloaded to your device

Step 2: Fill the marks/grades in excel

1. Understand the Excel Template
   The downloaded Excel template is designed to make marks entry easy and accurate.
   • It contains Admission Number, Roll Number, and Student Name for easy identification.
   • It includes multiple subject-wise sheets based on the configured exam hierarchy.
   • You can enter marks or grades for subjects, activities, and rubrics.
     Note:
     • Marks/grades must be within the configured maximum marks limits.
     • You may enter AB (Absent), DC (Don’t Consider), or ML (Medical Leave) where applicable.
2. Enter Marks / Grades in the Excel File
   • Open the downloaded Excel file.
   • Select the required subject sheet.
   • Navigate to the Term and Assessment columns (these may span or be merged across multiple columns).
   • Identify the activity or rubric for which marks need to be recorded.
   • Enter the marks or grade in the MARKS / GRADE column for that activity.
     • The NOTE column beside MARKS can be used for descriptive indicators (if applicable).
   • Marks can be entered with or without decimal values.
     • The system will automatically round off values based on configuration.
   • Once all entries are completed, save the Excel file and proceed to upload it.

Step 3: Upload the filled excel file

1. Navigate again to Student > Examination > Marks Entry.
2. Select the same Class, Section, Term, Assessment, and Subject used during download.
3. Go to the Upload section and browse or drag & drop the completed Excel file.
4. The system validates all entries:
   • If valid – upload is allowed
   • If invalid – errors are highlighted in red with cell references
5. Download the error file, correct the entries, and re-upload.
6. Once uploaded successfully, marks will appear against each student in the Marks Entry page.