Different colleges have different charts. What’s required for a merit scholarship at Duke is significantly different from what is required at UAH.
There was a poster a few years ago whose child was not a stellar CC student (meaning probably good average). They honed their search and found a number of merit aid options. Anyone remember the title of that thread?