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
HTHVampire

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
Golden
Microsoft MVP

Windows 7 Ult. x64
 
 

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
My System SpecsSystem Spec
30 Jun 2012   #3
HTHVampire

windows 7 ultimate x86
 
 

Hi,here's the link of my draft sheet:
https://skydrive.live.com/redir?resi...O3s0gj5jibUxP4
sorry, ignore the 1st one,i try to upload 2nd sheet:
https://skydrive.live.com/redir?resi...DC3jZHCn4x7vjk
this is it!

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

Reply

 How to Create gradereport with Microsoft Excel




Thread Tools




Similar help and support threads
Thread Forum
Microsoft Excel - The Date Bug
Hey all, Let me just start of by saying, this may be old news but it is still highly relevant in today's market. But there is a large bug in Office's suite all of them in fact (2000 - 2014), concerning the way it handles time / dates. History A brief bit of history for you all, MS decided...
Microsoft Office
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 Access/Excel
Can Microsoft Access/Excel update with a barcoding scanner? If yes, which 1 i easier to use?
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
Software


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 19:27.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App