I have a database of records that are a bit different from grade items.
My last test contained 97 multiple choice items labeled Item001, …, Item100 (I eliminated 3 items.)
Each item is categories by the course learning outcomes CLO01, CLO02, …,
There are 22 students who took the test, labeled SS001, SS002, …, SS022.
For my department report, I need to find scores by CLO for each student.
I cannot figure out how to create agents to do this. I have created a folder for SS001, but I would have to do this 172 times for the whole class. Is there an easier way to do this?