Import Grades

BYU Learning Suite allows instructors to import assignment and exam scores into BYU Grades by a CSV file.

 

Step One:

Log into your Learning Suite course and create an assignment or exam for the scores you want to import. For more information, please visit Create an Assignment or Create an Exam.

 

Step Two:

Open a program, such as Excel, with which you can create a CSV file. For more information on creating a CSV file, click here.

 

Step Three:

Create an identifier column by entering the type of identifier in the top left cell. The identifier will ensure that the right score matches with the right student. It is best to use Net IDs, since it is unique to each student. (BYU IDs and email addresses can be used as well. The email address must be the one a student has on file in AIM).

Note: Scores will not enter properly if you don’t have a header for the Net ID and assignment score columns.

 

Step Four:

Add all students’ net IDs to the Net ID column.

 

Step Five:

Create an assignment identifier column by entering the title of the assignment or exam in the cell to the right of ‘Net ID’.

Note: More than one assignment or exam can be imported at a time. Simply include another column with the assignment identifier and scores.

 

Step Six:

Highlight all cells that will contain scores. Right click and select Format Cells….

 

 

Step Seven:

A dialog window appears.

NewFormatCells.png

 

[1] Select General, Number, Percent or Text from the list on the left. Any other format will not import correctly into Learning Suite

[2] Select Ok.

 

You may upload percentages into Learning Suite. Make sure the assignment column you want to be uploaded as percentages is formatted to percentage in Excel.

Below is an example of acceptable formatting styles. Any styling that does not match one of the styles below may not work when uploading.

 

Formatting.png

 

[1] Net ID/BYU ID

This column should contain the Net ID, BYU ID, or email address of the students. This allows for the scores in the rows to the right of the student to be tied to that identifier, ensuring scores will match up with the correct student upon import.

Note: It is important to ensure you have entered the correct identifier for the correct student, or it will cause the scores to not be recorded. Also, Net ID is preferred when uploading, as it causes fewer issues.

[2] Whole numbers

You may upload whole numbers without decimal points.

[3] Numbers with decimal points

You may upload numbers that have decimal points. *

[4] Percentage with whole numbers

To upload a percentage, select the Percentage option when formatting cells. When you upload a percentage, BYU Grades will automatically calculate the number of points that percentage is worth. *

[5] Percentage with decimal points.

To upload a percentage, select the Percentage option when formatting cells. When you upload a percentage, BYU Grades will automatically calculate the number of points that percentage is worth. *

*It is important to note that the decimal points will not show up unless the assignment category has been set to show decimal points. Click Here for more information about category creation. If decimal points have been disabled, the value will round to the nearest whole number.

 

Step Eight:

The following steps may vary based on what program you are using.

Save the CSV file by clicking the File option and then selecting Save As.

Save_as.png

 

Enter a File name.

 

Select the Save as type drop down menu.

SaveAsType.png

 

Select the CSV (Comma Delimited) option.

 

Save_as_CSV.png

 

Click Save.

Save2.png

 

Step Nine:

Log in to your Learning Suite course and select BYU Grades.

 

Step Ten:

Click Import/Export from the Grades navigation menu.

 

Step Eleven:

 

[1] Select Choose Files.

[2] A dialog window appears. Choose the CSV file you want to upload.

[3] Select Open.

 

Step Twelve:

Three new sections appear. Section two, Preview file, displays a preview of the file you selected. Make sure this is the correct file.

 

Step Thirteen:

Click the drop down menu in section three, Match Identifier, and select the column in your CSV file that corresponds to students’ Net IDs (or BYU ID or email addresses if used).

 

Step Fourteen:

The first column in the table listed under section four, Match imported points columns to gradebook assignments, lists the title of all columns in your CSV file. Click the drop down next to the identifier column (Net ID) and select Don’t Import. The Net ID column does not need to be imported into BYU Grades as it is only used to tie the correct score to the correct student.

 

Step Fifteen:

Click the drop down next to the remaining File Column titles and select the corresponding Learning Suite assignments, as shown below.

Columns.png

 

Step Sixteen:

Click Import.

 

Step Seventeen:

Import Summary appears. It displays the number of scores that were imported successfully or unsuccessfully.

 

Step Eighteen:

Click View Details to see which rows did and did not successfully import.

A score did not import successfully?

If you have a red x next to just one of the scores, go back to your original file and ensure the formatting is like all other cells.

If none of the scores uploaded properly, ensure correct cell formatting was used as shown in Step Eight.

 

Questions? Contact the OIT Service Desk (801.422.4000, it@byu.edu).