How to Export your Class List A0 Numbers and Format Them

Exporting class list can bring all of your students in your course in one Excel sheet with their A#, Last name, First name, individual grades for each activity and their Final Calculated Grades.

1. Open your course in the Learning Hub.
2. Click on ‘Grades’ in your course Navbar
3. Click on the button ‘Export’
4. From the Export Grades page, select the settings
5. Key Field = Org Defined ID
6. Grade Values = Grade Scheme
7. User Details = Select Last Name and First name
8. Choose Grades to Export = Final Calculated Grade (you select individual quizzes assignments also as needed)
9. Click the button “Export to CSV”
10. Download and open the CSV file in Excel
11. Remove all the “#” signs
12. To delete the # from the ID in column A:
13. Select Column A
14. Find & Select/Replace
15. Find what = “#’
16. Replace with: = (leave this blank)
17. Replace All

Now you have the Excel sheet with all of the A numbers in Column A.