#1-MS Excel: How to make Grade Sheet / create Marksheet in Excel (2019)


How to make Grade Sheet / create Marksheet in Excel (2019)


This video tutorial is made to teach how to make a grade sheet for class.

1. On the first row write down the Heading. Like Roll Numbers (which I have not used) &
Names of students, then one by one write down the name of Subject, Total,Percent, Result & Grade.

2. So, on the top row I have given Name, Eng, Ben, His, Geo, Science, Total, Average( you can write Percent),  Result, Grade.

3. Then fill the roll no, name & numbers of subject that student has got. Here I have only filled one name only and his numbers for demo.

4. Below the Total heading i.e on the G2 write down the formula =sum(B2:F2) and then hit the Enter button. You will see the total that student has got. Then copy the formula and paste under all students Total.

5. Under Average or Percent i.e H2 write down the formula =AVERAGE(B2:F2) and then hit the Enter button. You will see the percentage that student has got.

6. In Result, we assume that if a student gets 35 or more on the basis of average then he will get Pass result otherwise he will get Fail result. so in I2 cell we will put formula in this way =IF(H2>=35,"Pass","Fail") after that hit the
enter button, you can see that the student got Pass or Fail.


7. In Grade, we assume that if a student gets

Average >= 90 then A
Average >= 70 then B
Average >= 50 then C
Average >= 35 then D
Average <   35 then Fail

So now in J2 cell we will put formula in this way
=IF(H2>=90,"A",IF(H2>=70,"B",IF(H2>=50,"C",IF(H2>=35,"D","Fail")
after that hit the enter button, you can see that the student got any of the grades.

8.
 After that you can format the table in various way.

Thats All

We will post more interesting videos on Excel. If you have any queries please do contact me I will be pleased to help you.

********************************* ~:Support Our Work Financially:~ *********************************
Project File Type: Free
If you think this tutorial helps you to solve your problem and add value to your work, Buy me a Coffee..
buy me a coffee

************************************************************************************************

Post a Comment

0 Comments