How do I get myself more committed to school guys?

I'm on my freshman year in a community college and I'm doing OK. No As but I guess about C or D average. My midterms just came up and I'm sure I failed my geography test. I'm worried that I won't make it in life in the long term with this shitty attitude of mine. But I also feel discouraged and intimidated to try. I had a 72.9% in my statistics class but I didn't go to take the test. Now I have a 22.9% average. I can work on it now and turn it but i feel like I won't pull a good grade. And I have a 4 page paper due Tuesday and a presentation thursday.

How do I pull myself forward?

Any stories or experiences from you guys that did shit in college but ended up OK?

I really need some motivation because I'm having hard time finding the desire to even get up in the morning.