An admissions officer at Caltech once told me they did look at applicants with poor grades and would overlook them if there was a good reason why the grades were poor and there was very strong evidence that the applicant was impressive anyway.
Anything less is beyond poor compared to Caltech's admissions standards.