Importing and Exporting on Canvas

Body

What Is It?

How to import and export on Canvas.

Signing into Canvas
Export Gradebook to Excel
Import Gradebook to Excel
Export Graded Column
Importing to Banner

Signing into Canvas

Step 1:

In your web browser, navigate to your Canvas using the following link:

https://mtech.instructure.com

Step 2:

Enter your username and password and then select "SIGN IN."

Note: Links to help with passwords are on the Web Sign-on page. Those who cannot log into Canvas should contact the IT Help Center.

Back to Table of Contents

Export Gradebook to Excel

Step 1:

On your web browser, navigate to your Canvas homepage using the following link:

https://mtech.instructure.com

Note: If you are having any issues accessing, please navigate to the Login section.

Step 2:

Navigate Grades from the Course tab.

Step 3:

(Click to view full) Select Export from the upper left corner of the page.

If you are using grading periods and want all grading periods included in your CSV file, click the Export Entire Gradebook link.

When export is completed, Canvas downloads the CSV file automatically to your computer.

Step 4:

View Previous Exports

Note:

Gradebook export files include the date and time of the download to differentiate between multiple exports. The export filename format is YYYY-MM-DDTHHMM, followed by the course name.
Gradebook export files automatically save to your user files in an Unfiled folder.

Step 5:

Edit Scores

Edit the scores in Microsoft Excel. Make sure to save the file as a CSV file type.

Once you have made changes, you can upload it to your course.

Step 6:

View Read-Only Columns

Current Points [1]: Reflects points for graded assignments.
Final Points [2]: Reflects points for all assignments.
Current Score [3]: Reflects scores for graded, posted assignments.
Unposted Current Score [4]: Reflects scores for graded assignments and includes hidden assignments.
Final Score [5]: Reflects overall score including unsubmitted assignments as zero but excluding hidden assignments.
Unposted Final Score [6]: Reflects total score, including unsubmitted assignments as zero and hidden assignments.
Current Grade [7]: Reflects course grade based on graded, posted assignments.
Unposted Current Grade [8]: Reflects course grade based on graded assignments, including hidden assignments but excluding unsubmitted assignments.
Final Grade [9]: Reflects overall course grade including unsubmitted assignments as zero but excluding hidden assignments.
Unposted Final Grade [10]: Reflects overall course grade, including unsubmitted assignments as zero and hidden assignments.

Back to Table of Contents

Import Gradebook from Excel

Step 1:

Create CSV File

For new files, save the file as Grades-Course_Name.csv.

Required columns and order

Student Name
Student ID
SIS User ID (only required if you use SIS)
SIS Login ID (only required if you use SIS)
Section
Assignment (this can be for an existing assignment or a new assignment; retain IDs for existing assignments)

Step 2:

Open Grade book

Step 3:

Upload Scores

Step 4:

Choose File

Step 5:

Open File

Locate CSV and then Click Open Button.

Step 6:

On your web browser, navigate to your Canvas homepage using the following link:

Click the Upload Data button.

Step 7:

Upload New Data

If you add a new column to the CSV file and then upload the file, Canvas will ask you what you want to do with the new column. In the drop-down menu, choose the A new assignment option. Then assign the number of points possible. Click the Continue button.

Notes:

When multiple grading periods is enabled, CSV file uploads cannot create new assignments.
New assignments created via a CSV file upload are automatically published and maintain the course posting policy.

Step 8:

Save Changes

Review the changes made to your Gradebook.

Any changes that will result in a lower grade than the previous version are highlighted in red.

If you upload assignments with no grade changes, they will be hidden from the upload.

Click the Save Changes button.

Step 9:

View updated Data

Back to Table of Contents

Export Graded Column

Step 1:

On your web browser, navigate to your Canvas homepage using the following link:

https://mtech.instructure.com

Back to Table of Contents

Step 2:

Open Grades from Course Navigation

Step 3:

Open Filters to view or manage gradebook filters

Step 4:

Open Filter Presets

Step 5:

Create New Filter

Step 6:

Add Filter Details

To save the filter for future use, enter a name in the Preset Name Field.

Step 7:

Select Filter Type

Step 8:

View Sections Filter

Step 9:

View Assignment Group Filter

Step 10:

View Modules Filter

Step 11:

View Student Groups Filter

Step 12:

View Grading Periods Filter

Step 13:

View Submissions Filter

Step 14:

View Start and End Date Filter

Step 15:

Save Filter Preset

Step 16:

View filter Preset

Step 17:

Manage Gradebook Filters

Step 18:

View Applied Filters

Back to Table of Contents

Importing to Banner

Now, you'll need to prepare the file for Banner (OrediggerWeb). Refer to the figure below if you need an example.

Change the "Institution" header to "TermCode".
Change the "Department" header to "CRN".
Fill in the first cell under TermCode and copy the value into all the following cells.
Fill in the first cell under CRN with the course's CRN and copy the value into all the following cells.
Add another column with the header "Last Attended Date".
Right click the "Email Address" header and then click "Insert". This will add a column to the left of "Email Address".
Type "Last Attended Date" as the header for this column.
If a student has an F in the course, you are required to fill in this field with the last date they attended. Use mm/dd/YYYY format (ex. Jan 3rd 2018 -> 01/03/2018). If you do not fill in this field, the F will not be imported.
Save the file as a new file on the desktop.
Keep all other fields the same.
Now, you are ready to import.

Now We're Ready to Import

Step 1:

From Banner, open the Faculty Grade Entry App. Click on either "Midterm Grades" or "Final Grades" and then select the course you'll be uploading grades to.

Step 2:

Next, you will want to sort your classes so the most recent term appears first. To sort the term from the newest to the oldest, you need to click on the "Term" column twice (the first click is to select the column, and the second click is to change the sort order).

Step 3:

Click the gear in the upper right corner of the screen and select "Import" from the list.

Step 4:

Click on the word "Browse" and select the Excel file with your grades, then click "Upload". Once the file is uploaded, click "Continue".

Step 5:

Banner (OrediggerWeb) will now let you preview the spreadsheet so you know you selected the correct file. Make sure "My Spreadsheet has headers" is checked. Once you are sure you picked the right file, click "Continue".

Step 6:

Now Banner (OrediggerWeb) will have you map the values of the spreadsheet to the values Banner is looking for. The four important matches are: ID number -> Student ID, CRN -> CRN, TermCode -> Term Code, Course total (Letter) -> Final Grade.

If any of them are mapped incorrectly, change it using the drop-down menu just above the column header. Once you are sure they are mapped correctly, click "Continue".

Step 7:

Banner will now preview what the values will look like in Banner. Click on "Download the validation report" to view any errors. This will open a text file with a list of the grades that will not be imported. You can attempt to fix any issues using this report and attempting to import again. Click "Continue" once everything looks correct.

Step 8:

Banner will now give you a completion verification and let you know how many records successfully imported. This is your last chance to download the verification report to see which records need to be fixed and fix the records. Once you are done, click "Finish".

Back to Table of Contents