Well, today we are
going to learn how someone can create a sample student report card in MS-Excel.
We will use some screenshot of our own generated demo report card and its looks
very simple yet easy to make one.

So, without wasting
valuable time of everyone’s, let’s proceed to the point right now.

__Prerequisite__
To create a student
report card, you should have a clear understanding of different types of
mathematical expressions (conditions……if-else) and should know how to perform
some basic level mathematical operations, like- Addition,

**Average**and so on. That’s set, isn’t it looks simple! Well, actually it is. So, let’s start,
At first, we are giving
a screenshot of our completed Student Report Card & here it is,

So, we hope, you get
the idea how your student report card will look like. (Take a closer look at the
above screenshot please)

Create the basic layout
of the report card like the title of your desired school name, the number of
field required for the card, input values including

**Student_ID, Student_Name, Subjects & Marks**etc.
For the demo, create
this below layout first,

Here, you can see we have
already input some demo values for our first six columns (from left to right)
and now we have to calculate Total marks of those subjects entitled as English,
Science, Math an ICT. So, how we are going to do that? Well, it’s just a simple
addition operation.

In the

**Total**column, we will take our mouse cursor and click the**G6**cell first. Then, start typing “ = ” in that cell and start clicking from left side cell of subject values, for our case**English**is most left sided subject and has a value of**87**which is in the cell**C6**then use the addition symbol (**+**) and select the next cell of the subject i.e. for our case Science and has a value of**77**which is in cell number**D6**and similarly just select other cells of the subject values and just press the**Enter**button of your keyboard.
You will get the Total marks of those subjects based
on your input values. Or, you could just type
the below formula in the

**G6**cell.
Now, just put your
mouse cursor below in the

**G6**cell and you will notice a black**+**symbol there, just drag your mouse from the next cell**G7**to the last cell of that table**G11**and you will get Total marks of all other students in the table.
Now, it time to
calculate the

**Average**of marks of those individual students. We definitely know how to calculate average from some values, right!
Well, in mathematics, the formula of average,

**Average =Addition of all values/ number of inputs**

For our case, we can
see, there are four (4) subjects and we already calculated the Total marks by
performing addition of subject-wise values and we put the value in a new column
titled as

**Total**. So, it will save our time and effort to calculate the Average marks of students.
So, from above
screenshot, it is easy to calculate Average marks of Students. For example, Average
Marks of Student

**A**= Total/4 (Here is only four subject enlisted) and same formula will work on other Students Average Marks Calculation.
From our report card,
we will use this simple formula ( =G6/4 ) for calculating the Average marks of
Student Name,

**A**and for other Students we will just drag the ‘**+**’ symbol from the below of the**H6**cell to the following cells.
Now, give your full
attention, because in this part, we will learn how to calculate the

**Grades**of those Students and for that we will use a little bit difficult formula.
For calculating Grades
of the Students, at first simply we will use this formula,

**=IF(H6>=80,"A+",IF(H6>=70,"A",IF(H6>=60,"B",IF(H6>=50,"C",IF(H6>=40,"D",IF(H6<40,"F"))))))**to find out the Grade of Student**A**.
Then, for other
Students

**Grades**we will just drag the ‘**+**’ symbol from the below of the**I6**cell to the following cells.
And, for the last field
of our report card, we will

The final look of our created Student Report Card,

**Comment**out the Grades (it could be Outstanding, Good, Satisfactory based on performance) and we will do it in a manual way. That’s all for our demo Student Report Card for Beginners and hopefully, everyone will clearly understand the full process of generating a simple Student Report Card in MS-Excel in any version.The final look of our created Student Report Card,

Thanks for your
support. Have a good day & stay with

**tutorialabc.com**for more lessons and learning contents.
## No comments:

## Post a Comment