It depends on what major you are in. Generally, by defining a school as 'great', it usually is prestigious, well-known for something, either athletic or academic wise. So to answer your question, you can be classified as a 'great' school by different standards, the best way is to do your necessary research about the school.