91原创

GRADE ROSTER IMPORT

91原创SIS has a grade roster import tool that allows an instructor to upload grades from a .csv file to their 91原创SIS grade roster.听 File format specifications and import instructions are below.听 Faculty can request access to the grade roster import tool through the听.

听

听

CREATING YOUR SPREADSHEET

If you already have a spreadsheet with your students and grades for a class section, review the 鈥淔ile format鈥� section below.

If you do not have a spreadsheet with your students and grades:

1.听 Open听.听 Navigate to the听Faculty and Advisors Homepage听and select the听Faculty Center听tile.

2.听 Confirm that you have the correct semester selected and click the听Grade Roster icon听to the left of a class section.

3.听 Confirm that you have the correct Grade Roster Type selected (Mid-Term or Final).

4.听 Click the听Download icon听at the top the roster to download the list.

a.听 If prompted with a message about the file format and extension not matching, this is expected. Click听Yes听to open the file.

5.听 Remove all columns except for the ID and Roster Grade.听 Enter grades in the Roster Grade column and follow the File Format specifications below to save the file.

6.听 The filename format must be the 91原创SIS term code_91原创SIS class number.csv.

a.听 91原创SIS term code information can also be found听here.

b.听 The class number can be found in parentheses next to the subject/catalog/section number at the top of the roster page.

听

听

FILE FORMAT

1.听 The csv file should contain two fields 鈥� the Student ID (column A) and the Roster Grade (column B):

2.听 Column headers are optional and shouldn鈥檛 interfere with the process

3.听 The file can include multiple sections of the same course (so one spreadsheet can include students from multiples sections of the same course and be renamed, as needed).

a.听 The file听cannot听include students from more than one course or the same student twice.

4.听 The filename format must be the 91原创SIS term code_91原创SIS class number.csv (鈥�2213_12345.csv鈥�, for example).听 Your filename can be found in the blue bar on the top of the upload page (step 1 below).听 91原创SIS term code information can also be found听here.

a.听 For Windows users, the file format should be CSV (Comma Delimited)

i.听 You will be asked if you want to keep using that format.听 Select听Yes.

ii.听 When you close the file, you鈥檒l be asked if you want to save it again.听 Select听Save.

b.听 For Mac users, the file format should be Windows Comma Separated (.csv)

听

听

IMPORT INSTRUCTIONS

Once you have a spreadsheet that matches the format above, open听, go to the听Faculty and Advisors Homepage听and select the听Faculty Center听tile.听 听Use the听Grade Roster Import听link on the left hand bar and follow the steps below.

1.听听Confirm听that your .csv filename matches the Filename column for the class section on the 鈥楿pload Grade to the Roster鈥� page.

2.听 Click听Upload Grades听for the section you are grading.

3.听 Click the听Upload File听button then听Browse.听 Select the csv file on your computer and click听Upload.听 You should see a message stating that the upload was successful.听 Click OK.

a.听 If you receive an error, review the File Format instructions above to confirm that your csv file is correct.

4.听 Select the roster type for which you are entering grades 鈥� either听Mid Term Grades听or听Final Grades.

5.听 Click听Submit Grades听to load the grades from your spreadsheet to the roster page.听 You should see a message stating that the submission was successful if there are no errors with the file.

a.听 If there are students missing grades or invalid grades, you will be alerted to that fact but the rest of the students鈥� grades will be loaded.

b.听 If you receive an error of any kind, read it carefully and retry the submission.

6.听 Click听Back to Grade Roster听to see the grades from your spreadsheet listed on the roster page.

7.听 Once you have reviewed the grades to confirm that they are ready for posting, change the Approval Status to听Approved听and click the green听Save听button.听 Grades are posted to students鈥� records nightly.