Friday, November 22, 2019

How to create a sample student report card in MS-Excel

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.


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 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 for more lessons and learning contents.

No comments:

Post a Comment