Downloading assignment grades to a spreadsheet

Note: To complete the procedures in this document, you must be assigned a role having the necessary permissions. To determine your role, follow the directions in Participant roles. For a basic understanding of roles and permissions, see Permissions and roles: Overview.

To download grades from the Assignments tool to a spreadsheet, follow these steps:

  1. In the menubar of the relevant course or project site, click Assignments.

  2. At the top of the page, click Grade Report.

  3. Click Download Spreadsheet.

  4. Depending on your web browser, you might be prompted to either open the file or save it. Follow your web browser's prompts; if you choose to save the file, you will have to locate it (e.g., on your computer's hard drive) to open the spreadsheet.

    Note: The downloaded file will be in Microsoft Excel (i.e., .xls) format.

The spreadsheet contains students' usernames and full names in the first two columns. Each subsequent column lists a different assignment, and student grades are located in the corresponding cells within each column. If no grade is present then "No Submission" is displayed. The spreadsheet does not tally assignment grades.