Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: How to Create gradereport with Microsoft Excel

30 Jun 2012   #1

windows 7 ultimate x86
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!

My System SpecsSystem Spec
30 Jun 2012   #2
Microsoft MVP

Windows 7 Ult. x64


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.

My System SpecsSystem Spec
30 Jun 2012   #3

windows 7 ultimate x86

Hi,here's the link of my draft sheet:
sorry, ignore the 1st one,i try to upload 2nd sheet:
this is it!

you can manipulate the scores for testing =) the scores i stated are just for trying.
My System SpecsSystem Spec


 How to Create gradereport with Microsoft Excel

Thread Tools

Similar help and support threads
Thread Forum
Can I create a pie chart with data in an existing excel file?
Where I work an excel sheet with any and all "failed activities" (we're not getting paid) is sent out every wednesday. How can I highlight specific cells (for a specific person) and have that chart show how much of the failed activities belong to them. They obviously know that, but this will...
Microsoft Office
About microsoft excel
Hi I need a help about excel I'm working on excel before but i forgotten now how to crop the columns and row after i finish assesment
Microsoft Office
How to create two adjacent Y-axes in Excel 2010
Hello, I am creating histogramm for statistics course. How can I please add two adjacent Y-axes to histogramm? Typical example image of histogram is attached. Thanks.
Microsoft Office
Microsoft Excel Help
I'm trying to make a drop down list or combo box display 2 values in 2 different cells but I'm having a tough time doing that. Can anybody help me over teamviewer please? Thanks
microsoft excel 2010
i have office 2010. tried opening a excel document and wouldn't open. no error message. it showed for a split second and disappeared but never showed on the tool bar. i opened another excel document and opened the first document and it showed...anybody know why this may be happening?
Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 21:16.
Twitter Facebook Google+