Blog Archives

Canvas: Moving Your Final Grade Column to the Front of your Grade Book

Tired of scrolling all the way to end of your gradebook to see the total column?


Open your gradebook and scroll to the Total Column. Hover over the Total Column header under you see the circle for the drop-down menu, select the circle (1) and then (2) select “Move to front.”

total-move.png

Remember…the force will be with you, always.

Read more →

Canvas: Import/Export an Excel File to/from Grade Book


Note: We recommend to all faculty to communicate with your TAs when you are reporting final grades. Otherwise, they may make adjustments to the Canvas gradebook that will not be reflected in the final grade reported to the Registrar’s office.


Step 1: Access Course Settings

Open Settings Tab in your course (1) and (2) click on the “Course Details” tab.

export01.png

Step 2: Enable Course Grading Scheme

Next to Grading Scheme on the Course Details Tab, mark the checkbox (1) on the menu item “Enable Course Grading Scheme” and then (2) click the “Update Course Details” button.

 

Note: The Registrar’s Grade Submission System requires a letter grade. If you do not perform this step, you will receive an error message when you try to upload your gradebook .csv file because there won’t be any letter grades in this file!

 

 export02.png


Open Grades in your course navigation and look at your Gradebook. You should now see a faint letter grades next to each student’s final grade percentage.

Confirm Grade Scheme change


If you would like to edit your grade scheme, check out Instructure’s tutorials:

HOW TO EDIT GRADE SCHEMES

HOW TO FORMAT DIFFERENT GRADE SCHEMES


Step 3: Download Scores .CSV

In your Gradebook, select the Export button in the upper right corner of the interface. You may have a choice between current or previous exported gradebooks, select accordingly.

export03.png

In your downloads folder, or whatever default location your downloads are directed to, you should see your downloaded .csv file.

Confirm .csv download

Step 4: Access Registrar’s Submission Website

Log in to the Registrar’s Grade Submission Website.

export11.png

Step 5: Select Course Unique

You should be automatically taken to the grade submission page when you log in. If not, (1) click on the link in the left navigation bar. Then (2) select the unique number for the course for which you wish to upload your grade .csv file.

 

Note: If you have cross-listed several of your course uniques/sections, just select the primary course’s unique number and submit your .csv file to for that unique. This will also submit student grades for all secondary/cross-listed course sections.

Open grade submission panel

Step 6: Select .CSV File

Click the “choose file” button (1) and select .csv file from downloads folder. Then (2) click the upload button to upload the .csv file to the Registrar’s site.

Upload .csv file

You will see a browser message asking you if you’re saved your file as a comma-delimited text-file, click the OK button as your .csv file is already comma-delimited. 

 Reminder message

After clicking the upload button, you will be able to monitor the progress of the upload (1) and when you see the “upload successful” message, (2) click on the course unique to confirm that grades have been properly uploaded.

You may see a status that reads “upload in progress, click to update,” which you can click to update uploading progress.

Monitor upload progress

Step 8: Review Grade Submission Results

Confirm that grades have been properly uploaded by spot checking several students throughout the course roster.

(Student names & EIDs have been blurred here for protection of student data.)

If there are any discrepancies, you can manually change or enter grades in this interface.

Note: If you are importing a .csv file that contains a course with multiple sections, your students’ grade information will include the unique number of the section for which they originally registered.  

 Confirm grades import

Step 8: Submit Grade

Don’t forget to communicate with your TAs that you have submitted final grades!

Click Submit.  TASK COMPLETE!

Read more →

Canvas: Preparing Your Grade Book for Final Grade Submission

 
 

The 4 things you should do:

 

1 Converting All Ungraded Assignments to a 0 (or some other score)

When submitting your grades from Canvas, all ungraded items will automatically be counted as zeros, this could change the exported totals from what you see in your Canvas Gradebook considerably. 

 

It’s recommended that you enter zeros for students who do not turn in their work throughout the semester. That way, the running total for their final grade is accurate throughout the semester and they don’t develop any unrealistic expectations about their final grade. 

 

Treat Ungraded as 0: Is a view feature only. It does not actually convert ungraded assignments (dashes) to zeros.

To actually change ungraded assignments (dashes) to 0s, you will need to do this following.

 Click on the drop-down menu (1) and select (2) Set Default Grade.

set-as-0.1.png

 

Enter 0 in the set default grade (1) and click (2) Set Default Grade.

set-as-0.2.png


2 Unmute All Muted Assignments

Please make sure you unmute ALL muted grades (1) and changed all ungraded (2) assignments to a numeric score.

unmute01.png

Click on the drop-down menu (1) for the grade column you want to unmute and select (2) Unmute assignment from that menu.

unmute02.png


3 Removing Assignments You Are Not Using

You can either unpublish or delete any assignment you are not going to use and do not want to contribute toward final grade calculation. To unpublish, open the Assignments page in your course and click on the green cloud. The cloud will turn gray and at the point it is unpublished and removed from gradebook calculation.

If there is any student work that’s been uploaded to that assignment, you will have to delete the assignment by clicking on the gear icon next to the cloud and selecting “Delete.”

 

 

4 Activate Final Letter Grade in Total Column

As you know, the Registrar’s online grade reporting system only accepts letter grades. To activate letter grades, you will go to your course settings page (1) and (2) the course details tab (if it doesn’t automatically open to this tab.)

finalgrade01-1.png

 

Then you will select the check box next to Grading Scheme “Enable course grading scheme” and then click the blue “Update Course Details” button at the bottom right of the page.

finalgrade02.png

finalgrade03.png

If you check your gradebook, you will see the final letter grades next to the percentages in the Total column.

finalgrade04-1.png

 


If you would like to enable and/or edit the grade scheme for your course, please check out this tutorial.


For more on the Gradebook, click here.

To view the tutorial on how to submit final grades using the Registrar’s Tool, click here.

To view the tutorial on how to submit final grades by importing an Excel spreadsheet,

Read more →