Adding Student PID to the Gradebook in Canvas

Description

Instructors may find it useful to house student PID in the Canvas Gradebook to aid in submitting grades at the end of the year in the Faculty and Advising Center . Instructors can add PID to their Gradebook in Canvas using the following instructions. 

Environment

Canvas in your web browser

Solution 

Adding Student PID to the Canvas Gradebook

1. Log in to Canvas at canvas.ohio.edu

2. In the left global navigation menu, select the course you want to edit the Gradebook in

3. Select the Gradestab in the left course navigation menu

4. In the Gradebook, select the Gear Iconat the top right of the page, which will open the Gradebook Settings side panel 

   

5. In the Gradebook Settings, select the View Options(1.) tab and select the Notes(2.) check box then select Apply Settings(3.)

   

6. The Gradebook will now include a Notes column to the right of the Total column

   

7. Select the Exportbutton and then select the Export Entire Gradebook option from the drop-down

   

8. Once the Gradebook export downloads, open the export in Excel and see the Notes column

   

9. Instructors can either manually add the PID number or create an export from the Faculty and Advising Center and use an excel function called VLOOKUP  to add PID to the Gradebook export

   •  VLOOKUP is an Excel function that searches for a value in a table and returns a corresponding value in the same row from a specified column

10. Once PID is added, remove any columns after the Notes column and save the document as the file type CSV (Comma delimited)

11. In the Canvas Gradebook, select the Importbutton

    

12. On the Upload Gradebook page, select the Choose Filebutton (1) and find the saved CSV file on your machine, then select Upload Data(2)

    

13. On the next page, Canvas shows the information that will be changing in red. Review these changes and select  Save Changes

    

14. As the changes are processing, instructors can navigate away from the Gradebook page after selecting the OKbutton on the Canvas generated pop-up that reads: "You will be redirected to Gradebook while your file is being uploaded. If you have a large CSV file, your changes may take a few minutes to update. To prevent overwriting any data, please confirm the upload has completed and Gradebook is correct before making additional changes"

    

Outcome: Moving forward the Notes column will display the PID number in the Gradebook and every Gradebook export will include the PID number in the Notes column

Get help from Canvas

• Live chat with Canvas support (Faculty)

• Get 24-hours/7-days a week Canvas support   

• Dial the Canvas Support Hotline number located under "Get Help" in the Canvas Global Navigation Menu  

• Contact OIT at 740-593-1222 for questions related to logging in, test courses/manually created courses, or third-party tools (Panopto, VoiceThread, Inclusive Access, etc.)  

Get help from OIT

• Use the Canvas Learning Management System (LMS) ticket form to submit a help ticket  

• Visit the  Technology Resources and Training  page for available training  

Additional resources

• Canvas Basics Guide

• Canvas Instructor Guide

• Canvas Video Guide

• Mobile Guides

• Canvas Course Accessibility Checklist

• Canvas LMS Implementation updates

• Canvas Experts Corner Blog