My school has a large spreadsheet of data. Student names make up the rows. The columns include Accuplacer scores, along with courses that students wish to register for next school year. What is the easiest way for us to “sort” the data. For example, we need to generate a list of student names who want to take a specific course and also have the required assessment scores.
Is it only using “if-then statements”? Pivot tables? Any suggestions would be greatly appreciated. We are just in the building stage and want to insure that our spreadsheet has longevity.
By: Rosie Matthies