You don't have to be a great student to get scholarships.
There are scholarships that are specifically designed for average to below average students. These scholarships are often available through your school.