HOW TO GRADE STUDENTS USING MICROSOFT EXCEL 2018
HTML-код
- Опубликовано: 11 фев 2018
- This video presents to you an easy way of grading students using the "IF" function of the Microsoft Excel. It helps you to build a comprehensive data base for your student. It also helps you to keep accurate data of your students. To do the grading follow the steps below:
1. Type in the equal sign =
2. Type "if" after the equal sign
3. Open a bracket
4. Click on the cell that has the marks you want to grade
5. Type in the greater than sign
6. Type in the equal sign and enter the mark that begins the grade you are allocating and enter the comma sign.
7. Open the quotation sign and type in the letter you want to use for that grade eg. A, A+, B etc, close the quotation and enter the comma sign.
The process continuous for each grade you are entering.
For God so loves the world that he gave his only begotten son that whoever believes in him shall not perish but have ever lasting life
Thanks a lot I was really struggling 😌😌 these are tears 😭 of joy
I am grateful
thank u for the subject i donot understand my teacher but i uderstand u
I am glad to hear that. Keep up
thanks! your video was helpful
Awesome info!
So good video my friend, it is so very easy to understand.
Thankyou, I needed this for an assignment
Really helpful vide...
Thanks you so much for this video. I was not understanding but now i think i understood
This is so fantastic because it helps me to learn how to use grade in excel .
Thank you very much.
thank you!!!
very helpful keep it up! i like ur branc
Thanks man, your explanation is on point 🔥🔥
Thanks
Thank you❤
Really Helpful 👍
Thanks for this 🙏🙏
i can see our brand there... herbalife...keep it up
.
If I press enter my laptop is not showing anything
Thanks very much very interesting
Thank you very much
Thanks for the video. How do we compile a list showing only students that failed? Separating it from those who passed
A small take away.
This formula can also grade any number above 80% like 101% which is irrelevant when it comes to actual school grades
Thank you brother
Nice work
This was very helpful thank you
You're welcome!
Thanks
thanks my brother. it is very helpfull for me. keep going
Thank u..
Thank for de video
Thank you
Nice video
Good ❤
I understood every thing thanks
Great
How to filter have grade
I love you forever 😘💖💓❤️
Much love 💕
Thank you.
Please a formula for the overall aggregate.
What will be the aggregate for each student?
Great
Very life...keep it up
Very helpful...
Thanks a lot bro
You welcome
Nice
A challenge for a better formula
5:08
Excel is very good program, am using too much
u are amazing
Thanks, I pray to do more
What of Microsoft excel 2019?
Thanks for your question. The same process can still be used for all Microsoft Excel version
Please display them clearly
Hello dear, thanks for your comment. Kindly specify the portion you refer to be displayed clearly
Why should we take A,B1,B2............E8
The alphabets are the grade letters used for grading students. Each of them has a remark commending the effort of the student. For example, A1 denotes excellent performance
B1 denotes very good performance etc
Thank you
Thank you
You're welcome