# Exporting Assignment Grades, Evaluations, and Submissions

Updated

When you click the Download Grades button on the Review Grades page, you'll first be given the option to download the information as a CSV or Excel spreadsheet. When you open the file, you may want to resize your columns or rows or use the Wrap Text feature in the spreadsheet toolbar to be able to view the content more easily on your screen.

In this file, you'll find the following for each student in your course: their first and last name; their student ID (if IDs were added to the course roster); their email; their total score and the max possible points on this assignment; their assignment status (i.e., Graded, Ungraded, or Missing); their submission ID generated by Gradescope; the date and time their work was submitted; their view count (how many times they viewed their graded, published submission); and the number of points they received on each question. For student-uploaded assignments, you’ll also see a Lateness column in H:M:S format. For students who submit before the due date, lateness will be recorded as 00:00:00 in the spreadsheet.

#### Exporting assignment evaluations

When you click the Export Evaluations button on the Review Grades page, a zipped folder of spreadsheets, one for each question and subquestion in the assignment, will automatically download to your computer.

More about point values and rubric numbers: Click to enlarge the image above which shows the evaluation spreadsheet for Question 1.1 of an assignment. In the header row, you can see that there were three rubric items in Question 1.1: "Correct," "Partial Credit," and "Incorrect." In the Rubric Numbers row at the bottom of the spreadsheet, 1.1.1 refers to the first rubric item listed in Question 1.1, which, in this case, is the "Correct" rubric item. That means 1.1.2 refers to the second rubric item, "Partial Credit," and 1.1.3 refers to the third rubric item, "Incorrect." In the Point Values row, we see that rubric item 1.1.1 ("Correct") was worth 3 points, 1.1.2 ("Partial Credit") was worth 1.5 points, and 1.1.3 ("Incorrect") was worth 0 points.

#### Exporting assignment submissions

Not available for Online Assignments: If your students completed an Online Assignment, you will not have the option to export their submissions.
##### Exam, Homework, and Bubble Sheet Assignments

When you click the Export Submissions button on the Review Grades page of an Exam, Homework, or Bubble Sheet assignment, Gradescope will allow you to download a folder containing PDFs of each student's latest submission. Gradescope will also email you a link to a zipped folder containing these PDFs. If the assignment was variable-length and you notice that some students' submissions were not included in the export folder, open the missing submissions in Gradescope and make sure the students selected pages (indicated which pages their answers are on in the file they submitted).

When you open one of the submission PDFs, on the first pages you'll find the student's overall score, the full rubric (unless you've changed the default Rubric Item Visibility settings), and the rubric items you applied, comments you entered, and text box annotations you added to the student's work. Notice that each text box annotation has a circled number next to it. On the latter pages, you'll find the student's submission, any pencil annotations you gave the student (e.g., corrections you hand drew on their work using Gradescope's pencil tool), and circled numbers indicating where you gave the student a text box annotation. Note that any LaTeX you used in your text box annotations will appear as LaTeX syntax rather than text or equations on the first pages of the PDF (see image below).

##### Programming Assignments

Programming Assignments will also allow you to export submissions from the Review Grades page. However, when you click the Export Submissions button, Gradescope will export every student’s submission into a single metadata.yml file containing info from the autograder output.

#### Posting assignment grades to an LMS

Check out our LMS Workflow section for instructions on how to post Gradescope assignment grades in BlackboardBrightspace (D2L)CanvasMoodle, and Sakai to Gradescope. The LMS Workflow section of the Help Center also contains step-by-step instructions, images, and gifs about how to use Gradescope with an LMS as an instructor and a student.

Alternatively, check out the LMS Integration video on our Get Started page to see how to connect your LMS to Gradescope and post grades from the Gradescope website. Please note that the video only shows one method for using Gradescope with an LMS, but updated videos for each LMS are in the works.