On my spreadsheet the grade levels are in order but GIS is resorting them to 11th, 8th, 9th. Is there a way to force the data to stay in order?
Change the categories to true numbers, 8, 9, 10, etc. Adding "th" at the end interprets it as text, where anything starting with 1 comes before other numbers.