Identifying Unassigned Students using the Assignment Review CSV Export

Overview:

This article provides the steps for identifying which students are not currently assigned to a rater using the Assignment Review CSV export. It will cover both students who haven't been assigned and those who were skipped and haven't been reassigned.

NOTE: The Assignment Review is only available for those with Site Leader or Program Admin accounts in the Aperture System.

How to Download a CSV File of the Assignment Review List:

1. Select the Admin gear icon in the top-right corner.
2. Select Admin from the drop-down menu.
3. Select Assignment Review.
4. Select the ellipsis icon […].
5. Select Export CSV.
6. Download and open the file using a spreadsheet program, like Microsoft Excel.

Using the Assignment Review CSV Export to Identify Unassigned Students:

Identifying Students Who Haven't Been Assigned a Rater:

1. Open the Assignment Review CSV Export in Microsoft Excel.
2. Select column B in its entirety by clicking on the “B” above the column header “Rater Name”.
3. On the home tab, find the “Editing” section and select “Sort & Filter”.
4. From the dropdown, select “Filter”.
5. Click on the arrow that appeared next to the column header “Rater Name”.
6. In the dropdown, uncheck the “Select All” box.
7. Scroll down and check the box that says “(Blanks)” at the bottom.
8. Click “OK”.

The students who appear with this filter are not assigned to any rater and didn't have their rating assignment manually changed.

Identifying Students Who Were Skipped and Need to Be Reassigned

1. Open the Assignment Review CSV Export in Microsoft Excel.
2. Select all the data by clicking the triangle between Column A and Row 1 in the top left corner.
3. On the home tab, find the “Editing” section and select “Sort & Filter”.
4. From the dropdown, select “Custom Sort”.
5. In the box that pops up, make sure the checkbox in the upper right corner saying “My data has headers” is checked.
6. In the “Sort By” dropdown, select “Manual Changes” and hit “OK”. This will bring all the students with manual changes to their rating assignments to the top of the spreadsheet.
7. Select column E in its entirety by clicking on the “E” above the column header “Student ID”.
8. On the home tab, find the “Styles” section and select “Conditional Formatting”.
9. From the dropdown, select “Highlight Cell Rules” and then select “Duplicate Values…”.
10. Click “OK” on the popup box. This will highlight all students who appear in the file more than once in red in the Student ID field.
11. Select all the data by clicking the triangle between Column A and Row 1 in the top left corner.
12. On the home tab, find the “Editing” section and select “Sort & Filter”.
13. From the dropdown, select “Filter”.
14. Click on the arrow that appeared next to the column header “Manual Changes”.
15. In the dropdown, uncheck the “Select All” box.
16. Scroll down and check the box that reads “Skipped”.
17. Click “OK”. This will show you all the skipped students.
18. Select all the data by clicking the triangle between Column A and Row 1 in the top left corner.
19. On the home tab, find the “Editing” section and select “Sort & Filter”.
20. From the dropdown, select “Custom Sort”.
21. In the box that pops up, make sure the checkbox in the upper right corner stating “My data has headers” is checked.
22. In the “Sort By” dropdown, select “Student ID”.
23. In the “Sort On” dropdown, select “Cell Color”.
24. In the “Order” dropdowns, select “No Cell Color” and “On Top”.
25. Hit “OK”. This will bring all the students who were skipped and don't appear in the file again to the top of the spreadsheet.

Any student who was skipped and not reassigned will appear at the top of the spreadsheet with their student ID NOT highlighted in red.