Academic Technology Center
Teaching with Technology Collaboratory

Downloading and Uploading Grades with Microsoft Excel

To Download Grades to Microsoft Excel from myWPI

  1. Go to Control Panel > Assessment > Grade Center. The Grade Center Full Grade Center View page appears.
  1. Click Manage in the Action Bar of the Grade Center.
  1. Select Download From the Action Link menu.
  1. Select the data to download.
  2. Select the file delimiter, Comma or Tab.
  3. select whether to Include Hidden Information in the downloaded data. Hidden information includes columns and students that have been hidden from the view in the downloaded file.
  4. Select the location for the download. Files downloaded to the Content System need to
    be saved in a folder in the Content System. Click Browse to select the folder.
  5. Click Submit to finish the download.
  6. Click Download.
  7. Save the file in a location on your computer.
  8. Use Microsoft Excel to open the file.

To Upload Grades from Microsoft Excel to myWPI

Caution!

Uploading grades from Microsoft Excel to myWPI only works when you use the Grade Center format provided by myWPI. To upload grades, you must first download the Grade Center to Excel, and then you can add columns in Excel and import grades from this format. Note that grades can only be uploaded one column at a time, and your student names must match those in myWPI.

  1. Go to Control Panel > Assessment > Grade Center. The Grade Center full view page appears.
  2. Click Manage in the Action Bar of the Grade Center.
  3. Select Upload from the Action Link menu.
  1. Click Browse to locate the Excel file on your computer.
  2. Select either Comma, Tab, or Auto for the Delimiter type. If you select Auto, myWPI will attempt to automatically detect the type of delimiter used in the file.
  3. Click Submit when you have successfully located the file and are ready to upload. The Upload Grade Confirmation page appears.
  4. Select the column or columns you wish to upload from the file using the check boxes to select the desired columns.
  5. Click Submit to upload the column(s)and save your changes.
Maintained by itweb@wpi.edu
Last modified: Mar 27, 2009, 07:19 EDT
[WPI] [ATC] [Home] [Back]