Entering Grades

There are several ways to enter grades into the gradebook including importing grades with a CSV, manually entering grades, and using an assessment form which when completed automatically populates the grade.

How to import grades using a CSV

• Navigate to Admin>Manage Gradebook.

• Search for and click on the required course name.

• Ensure that you're working in the correct curriculum period and change it as needed.

• Search for and click on the title of the assessment you would like to grade. This will take you to the assessment page.

• Click the Import/Export button on the right and select Import grades from the dropdown menu.

• The data needs to be in CSV format to be uploaded. If you use Excel or Numbers use “Save As” to create a version of your file as a .csv.

• The marking scheme dictates what information and formatting should be included in your .csv file to upload. For all files include the learner id number.

• For numeric marking schemes include the numerator of the grade

• For percentage marking schemes include the percentage

• For pass/fail marking schemes format your CSV so that a pass is 100 and a fail is 0

• For complete/incomplete marking scheme change the assessment marking scheme to pass/fail, import the marks as listed above, then revisit the Edit Assessment page and change the assessment marking scheme back to complete/incomplete. The marks should update to C’s and I’s as required.

• Drag and drop or browse you computer to find the file you need to upload. Click Import CSV.

How to manually enter grades

• Navigate to Admin>Manage Gradebook.

• Search for and click on the required course name.

• Ensure that you're working in the correct curriculum period and change it as needed.

• Search for and click on the title of the assessment you would like to grade. This will take you to the assessment page.

• Click in the grade column beside a learner name/number. Enter the appropriate grade.

• Your work saves automatically.

• Another option is to open the grade spreadsheet for a course and input grades directly in the spreadsheet.

Empty grades

If you do not provide a grade for an assessment it will display with a dash in the grade column when reviewing the assessment and will also display as a dash when viewing the grade spreadsheet. If you export the grades there will be a blank cell in the spreadsheet where the missing grade is and all missing grades will count as zeroes in the learner's final grade. Learners' views of their gradebooks will behave slightly differently from than this so that administrative staff can create all assessments in a gradebook at the beginning of a course and fill in grades over time without learners thinking they have multiple zeroes in their grades.

How to link quizzes and exams to gradebook to automatically supply a grade

A quiz created through the quiz module questions can be automatically graded. A reminder that the quiz module only allows for multiple choice questions. If a quiz is attached to a learning event and a gradebook assessment it will automatically be graded and the gradebook will be updated accordingly once the quiz is completed. For instructions on linking a quiz to a gradebook entry, please see the Gradebook>Attach Quiz help section.

Exams created with the Elentra Exam module can also be attached to a gradebook entry so that when the exam is graded the grade automatically forwards to the gradebook. Attaching an exam to a gradebook assessment can be completed from an exam post or from a gradebook assessment (assuming a post already exists). For additional details on completing this process please see the Gradebook>Attach Exam help section.

How to allow Grade Calculation Exceptions

This feature allows you to modify the weight of an assessment for an individual student.

• Navigate to Admin>Manage Gradebook.

• Search for the appropriate course as needed and click on the course title.

• Search for and click on the assessment title.

• Scroll down to Grade Calculation Exceptions.

• Click on Select a Student and select the required learner from the dropdown menu.

• When the learner name appears below adjust the weighting by typing in the new assessment weight.

• Remove individual grade calculation exceptions by clicking the red minus button beside a learner name.

If you use this feature you do need to ensure that you rebalance the gradebook weighting of other assessments for the learner. For example, if you reduce a midterm from 10% to 0% because of an excused absence, you will need to manually increase the weight(s) of the same student's other assessments so that the total weight is still 100%.

Releasing grades to leaners

When you add an assessment to the gradebook you can specify whether or not to show the assessment in the learner gradebook and you can set start and end date and time to control the visibility of the grade. Grades are released to all members of the course enrolment at the same time. You can’t currently release grades to only selected learners through gradebook.