Skip to main content

Map Assignments and Export Grades

Prachi Patel
  • Updated

To export grades from the Student Success App, you will first need to map assignments to an assessment item. After mapping the assignments, you will be able to export grades from the Student Success App.

Map New Assignments to an Assessment Item 

Before you can export grades to your student record system (Universe, Banner, etc.) you need to associate or map the relevant assignment/s to each correct assessment item. 

Ideally, you have already done this towards the start of the semester so that students get visibility of which assignments are formative vs. summative and how those summative grades are calculated. 

However, if you haven’t already done this, you can do it now:

 

Create a Manual Assignment in the Student Success App and Upload the Grades 

  1. Navigate to the Student Success App (Journey / Assignments / Student Success App).
  2. Click on the green ＋ to create a manual assignment.
  3. Enter a relevant title, which will be visible to students.
  4. Choose a grade type*. 
  5. Once the assignment is created, click on it.
  6. Click Upload Grades, select your csv file, and click Next.
  7. Check that the relevant column headers are selected for student email and grades and click Apply grades.
  8. Release grades to students if required.

The assignment will now behave in exactly the same way as Turnitin or Handin assignments. You can now map this assignment to an assessment item following the instructions in section 1. 

Note

  • When exporting grades to Universe via the Student Success App, only the student’s email and grade is exported so using this workaround does not have a negative impact on data integrity.
  • *If you intend to map more than one assignment to an assessment item with weighting, you must choose Percentage as grade type.

 

Map Several Assignments for Sub Groups of Students into 1 Assignment Using the Manual Assignment Feature

If you have created separate assignments for different sub-groups of students and, therefore, you have grades spread across several assignments, there is a workaround using the manual assignment feature in the Student Success App. 

This workaround allows you to assemble grades for all students into a single assignment, map this to an assessment item, and export those grades to Universe in the required manner.

Download the student grades into a csv file

  1. Head to Journey>Assignments and locate the main assignment in the assignments list.
  2. Click on the three dots and select Export grades.
  3. Upload csv file from the main submission link to the manual assignment
  4. To combine all data together, once the extensions submissions are marked, download the csv file for this assignment. 
  5. Edit this file so it only contains students with a grade. 
  6. Upload this extensions csv file to the manual assignment. This will merge these students with the first upload. 

Export Grades to Student Records 

Once all grades are completed and released to students, you can export grades to the Student Records system your institution uses (Universe, Banner, etc). Clicking on Export on the relevant assessment item will reveal the grade export panel, where you can review the grades for each student before exporting. 

Export Grades to a CSV file 

Students’ grades can be also be exported separately via CSV and then sent to the student records system. The csv download button can be found next to the main Export button in the grade export panel. Just remember to remove the ‘Do not export’ override first. 

Screenshot_2020-12-18_at_15.47.21.png

Labels 

These provide additional information about the status of each assignment and help you make the correct decision about what should be exported for each student.

  • Not submitted: There is no submission available. 
  • Late submission: The student submitted their assignment after the due to date.
  • Not graded: A submission is present but it has not yet been graded.

Use the grade override options in the drop-down menu on the right to adjust the values to be exported as required. 

Grade override options 

  • Do not export: Choosing this option will exclude this student entirely from the export.
  • Not submitted: This is equivalent to AB or Absent in the previous Moodle-Universe plugin. Use this for non-submission or non-attendance at exam.

Resit & Deferral Assignments 

Once students have made their submissions on the resit link, head to the Student Success App. 

  1. Locate the mapping of the previous assignment to the assessment item in Student Records (Banner, Universe, etc) and remove it. This action will not remove marks previously sent to Student Records for other students.
  2. Once complete, map the new assignment to the same assessment item.
  3. Finally, export grades to Student Records
    1. For deferred/resit students, choose newgrades to be exported.
    2. For students who already have a grade and didn’t participate in resit (didn’t submit any work), this will be automatically set to Do not export.

Note

  • We recommend that you set up the mapping at the beginning of term because this makes it clear to students which assignments count towards their final grade for the course, and which are formative only. 
  • Some of the features mentioned in this article might not be available on your institution’s Aula account. To find out more, please contact your university directly.
  • Students who are the subject of a pending academic misconduct case should be excluded from any exports until the case has been considered.

Related articles