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

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