How to Create gradereport with Microsoft Excel

Hi,I'm trying to create a student's grade report for my teacher using MS Excel .Here's the draft of the report:



1. how can I set the Grade automatically once I insert the score?i.e, once I insert 90marks, the grade there will automatically appear grade A.

2. How can I set the GPA score automatically after the insertion of the Grade according to the grade table below?

3.Since there are about 20 students and the sheet need to print out, how can I save all the 20 students grade and print them out? creating a new sheet for a new student?

there's my problem I faced since I seldom use MS Excel. The format should be like this . Can someone helps me to clear my problems?I really appreciate your help!thanks!

Hi,

You need to use some conditional statements and formulas. Since you aren't that familar with Excel, its easier if you upload a copy of the spreadsheet here, and I'll be glad to add it in for you.

Regards,
Golden

Hi,here's the link of my draft sheet:
https://skydrive.live.com/redir?resid=A92BE608257FC338!716&authkey=!AO3s0gj5jibUxP4
sorry, ignore the 1st one,i try to upload 2nd sheet:
https://skydrive.live.com/redir?resid=A92BE608257FC338!722&authkey=!ADC3jZHCn4x7vjk
this is it!

you can manipulate the scores for testing =) the scores i stated are just for trying.