Grade Spreadsheet
A grade spreadsheet can be accessed from the bottom right corner of a Gradebook Assessments page. Course coordinators can quickly enter grades into the spreadsheet instead of entering grades for one assessment at a time. The grade spreadsheet also provides a way to indicate an adjusted grade or include a narrative comment about a learner.
Adjusted Grades
The ability to enter adjusted grades on a gradebook spreadsheet is controlled by a database setting (gradebook_adjusted_grades_enabled). To enable the setting, please speak to a developer.
The Adjusted Total Grade feature will allow course administrators to enter an Adjusted Total Grade to the Grading Spreadsheet for a Course Gradebook.
This will allow you to reflect a grade other than that calculated in the Weighted Total column of the Gradebook. An example use case could be: A learner has a weighted total of 75%/Pass (P) in the course, but, because they failed the NBME, their adjusted total should reflect a grade of Incomplete (INC) standing. An administrator or the Course Director can now reflect that adjusted overall grade of INC due to the NBME failure.
With the gradebook_adjusted_grades_enabled setting enabled, navigate to a Course Gradebook and open the Grade Spreadsheet.
On the far left of the spreadsheet, you'll see a column for Adjusted Total.
Click on a cell to enter an adjusted total percentage.
![](https://docs.elentra.org/~gitbook/image?url=https%3A%2F%2F3158514913-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FPqjYT9PvGYNZqulOdQ15%252Fuploads%252FaojsR6gt75I0pfFaGxWs%252FScreen%2520Shot%25202021-05-04%2520at%25202.32.00%2520PM.png%3Falt%3Dmedia&width=768&dpr=4&quality=100&sign=6606dfc9&sv=1)
Currently the adjusted total will display to learners in their My Gradebooks view.
Adjusted Totals will not display in the System Report Learner Report Card.
Future work will include the Adjusted Total in the gradebook export and introduce the adjusted total in the Learner Explorer view.
Comments Column
New in ME 1.25
The Comments column in a grade spreadsheet gives course administrators a space to add comments for each learner as needed (e.g., the rationale for a change in weighting to one or more assessments, the rationale behind the application of an Adjusted Total Grade). These comments are not visible to learners.
If a comment has been entered, a filled-in speech bubble will display in the Comments column.
![](https://docs.elentra.org/~gitbook/image?url=https%3A%2F%2F3158514913-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FPqjYT9PvGYNZqulOdQ15%252Fuploads%252FRXmPVqIMmu6sUofsa8wL%252FScreenshot%25202023-03-17%2520at%25203.03.50%2520PM.png%3Falt%3Dmedia%26token%3Dda429ce9-2cdd-490a-a503-1046d3a48bbe&width=768&dpr=4&quality=100&sign=1c122404&sv=1)
When comments are entered, Elentra will display the author's name and a date and time stamp.
![](https://docs.elentra.org/~gitbook/image?url=https%3A%2F%2F3158514913-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FPqjYT9PvGYNZqulOdQ15%252Fuploads%252F3YmUButdHFkVh5s13ubQ%252FScreenshot%25202023-03-17%2520at%25203.03.14%2520PM.png%3Falt%3Dmedia%26token%3D73cd8d43-59c4-415f-97da-cd0380fe5f1e&width=768&dpr=4&quality=100&sign=119b4173&sv=1)
Users may edit or delete their own comments.
Comments are included in an export of the grade spreadsheet. Mulitple comments on one learner will be separated by a semi-colon.
Last updated