ANSWER:

Grade Book: Work with Exported Grades in Excel

This article assumes you have a working knowledge of the Microsoft Excel program, and only describes the process of preparing a downloaded gradebook file for import back into your online Grade Book.

After you have exported the course Grade Book as a text file (.csv or .txt), follow these instructions to open and edit the file in Microsoft Excel:

Step 1: Do one of the following:

• If you saved the Grade Book as a Comma-delimited (.csv) file, double-click your file, which opens it in Excel.
   
• If you save the Grade Book as a Tab-delimited (.txt) file, first open the Excel program, then click File > Open. Select your .txt file and the Text Import Wizard dialog displays.

  Click the Finish button to display the file's contents.

Step 2: Clean up the Excel file by:

• Deleting “unnecessary” columns, such as Last Name, First Name, and Role. You do not want to change this information here, especially if members were enrolled through your campus Student Information System (SIS). Further, when you import the file, the Import screen matching columns will look "cleaner".
   
• Remove all rows for non-Student or non-Auditor members, such as Section Instructors, Designers, and Teaching Assistants. You cannot enter grade values for users in those roles.

Step 3: Make changes to existing grade data and/or add new grade columns and values.

NOTE: If you create formulas (e.g., to average a set of exam grades), keep in mind that only raw data produced by formulas is imported into your online Grade Book.  Your formulas and any special formatting you apply will not get imported. 

Step 4: In Excel, save the changes.

This message appears because the grade file is actually downloaded as a .csv or .txt file, and even though you are using Excel, if you created formulas or applied any special formatting to this spreadsheet, those will get stripped/lost if you click Yes. Therefore:

Click No if you created formulas or applied any special formatting to the spreadsheet. First save a copy of the file in Excel format (.xls) first to preserve these features.  Then save the file as type CSV (Comma delimited) (.csv) or Text (Tab delimited) (*.txt) so it is in the proper format for import into your online course Grade Book.

Click Yes if you just entered or changed values and did NOT create formulas or apply any special formatting to the spreadsheet

Your data file is ready to be imported into your online course Grade Book.

If you have any further questions, please contact us for support. Thank you.

- WebCampus Support