Grading has become one of the best practices every user and professional should know when it comes to Information Technology and Computer Science. Have you thought of how to grade using any of the office applications, especially MS Excel?
Grading in Microsoft Excel or using the spreadsheet application helps a lot in accomplishing many difficult tasks. Meanwhile, this can be done either by using the following commands or syntaxes, or what we called in Excel, Functions.
A few examples are:
- IF
- NESTED IF
- AND
- OR
- IFS
- VLOOKUP
The aforementioned can be used to evaluate students or candidates performance per user requests.
Using the PASS and FAIL
Using the Pass and Fail command, let’s consider the below functions. To see if a student passes or fails, adding to his or her grading system, we can use the below command:
=IF(B2>550,”A”, IF(B2>500, “B+”, IF(B2>300,”C”,”FAIL”))))’
The above command or syntax noted that if a student scores greater than 550, then that candidate should be awarded the grade of A, then proceeded to C for failure.
About Author
Discover more from SURFCLOUD TECHNOLOGY
Subscribe to get the latest posts sent to your email.
