Anchor | ||||
---|---|---|---|---|
|
Info |
---|
Before importing grades, ensure the spreadsheet has been properly formatted. |
In this article:
Table of Contents | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Import grades
Click Grades on your course navigation bar to access the Enter Grades page.
Click Import at the top of the page.
Click Browse… to locate and select your prepared .csv (or .txt) file.
Select the checkbox beside Create new grade item when an unrecognized item is referenced.
Click Continue.
If the grade item names from your spreadsheet do not already exist in your grade book, you will be taken through the steps to Create New Grade Items.
Make sure all checkboxes are selected in the Create New Grade Item column for the items you want to create.
Click Continue.
Under New Grade Item Properties, select or enter the Max. Points value and Weight for your new items.
Click Continue.
On the Errors and Warnings page, you may see information about unrecognized users (e.g. students who dropped the course) or incompatible grade values on your spreadsheet (e.g. you entered grades out of 100, but the grade item’s Max Points value is 25). See Frequently Asked Questions for more information.
Click Continue to ignore any errors and continue.
On the final Preview Import page, review the grades that will be imported.
If you have more than 20 students, select 200 from the per page drop-down list at the top- or bottom-right to view all students.
If you have more than 200 students, click the arrow to go to the next page.
Info Grade changes to existing items are indicated by an arrow ( ->) in the grade column.
New grade columns are marked with a yellow icon beside their name.
Click Import at the bottom left corner of the page.
Frequently asked questions
Anchor | ||||
---|---|---|---|---|
|
Click on the question to display the answer.
Expand | ||
---|---|---|
| ||
Detailed instructions can be found in Import Grades from a Spreadsheet into myCourses. |
Expand | ||
---|---|---|
| ||
No. These number signs will not interfere with the import either way. |
Expand | ||
---|---|---|
| ||
No. Grades can be imported in any order. |
Expand | ||
---|---|---|
| ||
myCourses requires a spreadsheet to have specific formatting to ensure that the correct grades are imported. A spreadsheet will not import if it contains any of the following:
|
Expand | ||
---|---|---|
| ||
Yes, unless you are using OpenOffice or a French operating system. Just download the sample file, paste your grades into the existing fields, save, and upload. You can rename or delete any extra columns later on the Manage Grades page in myCourses. |
Expand | ||
---|---|---|
| ||
A spreadsheet will import but you will receive a warning if it contains the following:
|
Expand | ||
---|---|---|
| ||
If you do not receive an error or warning message and your spreadsheet imports, but your students are receiving the wrong grades, it is possible that you did any of the following:
|
Expand | ||
---|---|---|
| ||
On the Enter Grades page, click the arrow beside the name of the column with the incorrect grades and select Grade All.
|
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|
Insert excerpt | ||||||||
---|---|---|---|---|---|---|---|---|
|