What Is It?
How to import and export on Canvas.
Table of Contents
- 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