How to calculate students grades in Excel

[@kwadwodennis1647]

You guys are amazing. You can imagine by how much you’ve lessened my burden when it comes to grading students. 👍🏽

[@adjotech]

We're glad to hear that.

[@adjotech]

Please subscribe, like and turn on post notification. Subscribe to my channel here: bit.ly/3h4BPBF

[@hon.samuelnkekebia3414]

Wow that's great job done.
Keep the good works up.

[@adjotech]

Thank you

[@Faith.20008]

Thank you so much the video has been of help to me

[@adjotech]

You're welcome

[@yawbaffour1441]

Great work done✌️

[@adjotech]

Thank you

[@lizamedia1015]

Great tips

[@adjotech]

Thanks

[@nyaabaakabotiemmanuel7372]

That is great! How will you display the grades for each subject if the subjects are many?

[@adjotech]

It's the same procedure. You have to get individual scores.

[@ibrahimaminudanyaya7103]

You have done a wonderful job, thanks for that. This is just for one subject, what if you want to grade other subjects as well and get the positions?

[@adjotech]

You can equally do that. Rank function can help you get the positions. I will consider doing a video on multiple subjects

[@edohmichaeladah5481]

@@adjotechthat we be very good. please, we are waiting...

[@ustazisma]

Great work out there

[@adjotech]

Thank you

[@adjotech]

Don't forget to subscribe

[@edohmichaeladah5481]

Thanks, so much for this. Please I will like to know about how to compute Position.

[@adjotech]

Yes, this video has detail explanation to that. ua-cam.com/video/pES8_cNJIBU/v-deo.html remember to subscribe, like and share

[@baimbakarkunabieu1524]

Great, it so wonderful

[@adjotech]

Thank you

[@harryakakpo7258]

Great work

[@adjotech]

Thanks Harry

[@adjotech]

I hope you subscribed?

[@nambagovicent8747]

Thanks so mch sir

[@adjotech]

You're welcome

[@weldonrotich5802]

Good work.Please share how I can grade the best seven subjects based out of say 9 subjects where of the some subjects are compulsory while the rest are optional

[@adjotech]

Will do that

[@GboloAbdul-gafaru]

Pls at the grading point can u explain again how u get the equal sign and the bracket

[@adjotech]

The equal sign and the brackets are close to the Backspace button on your keyboard

[@josephakande1044]

This is great.
How can this be transformed to report sheet for each student?

[@adjotech]

Nice suggestion, I will make a video on that. I hope you subscribed
?

[@adjotech]

share with friends as well

[@silaskalonzoke3038]

Watch from Kenya 🥰
You are great

[@adjotech]

Thanks so much

[@deannangsventures1417]

Awesome

[@adjotech]

👍

[@Mudi-zk2cy]

Imagine you're better than all my lecturers thank you.

[@adjotech]

🤭🤭🤭

[@elijahacheampongoduro5779]

Hmmmm. 3 years at college I didn't get this concept. Just less than half an hour there is a miracle. Thank you Sir

[@adjotech]

You're welcome

[@cyrilact]

How do we print for each student using this excel table if all the subject is enter on the same table

[@adjotech]

It can be done, but we may have to add some dropdowns and buttons in order to print for individual student

[@mohsinnor8698]

Amazing

[@adjotech]

Thanks

[@rubysvlogz]

Nice work bro

[@adjotech]

Thanks

[@Workoutmarshall]

Nice video

[@adjotech]

Thanks bro

[@BRIDGETBLESS-z]

Interesting

[@adjotech]

Share with friends and also ask other to subscribe for amazing videos like this.

[@BRIDGETBLESS-z]

@@adjotech yes sir

[@anyichiechristopher502]

Is there a way to set it to pick the grade and remark for each student, rather than dragging it down

[@adjotech]

Yes

[@anyichiechristopher502]

@@adjotech can you give a hint on that.

[@professordavid2008]

This is good except the remarks part. A 90 should be excellent or very good. Not satisfactory. But I appreciate the time taken to show the formulas.

[@adjotech]

You're welcome

[@yuoridomatthew8541]

Please how do you grade using numbers eg. 100-80=1 , 70-79=2...... instead of letter form

[@adjotech]

Same process where I placed the letter use the numbers and it should be in qoutes as well.

[@patrick_the_technician]

if(cell reference>79,"1",if(cell reference=80,"1".....)) you will get the same results

[@yuoridomatthew8541]

@@patrick_the_technician God bless you🙏🙏

[@suzieoquinn173]

Please zoom in I'm not seeing what you're doing

[@adjotech]

Okay

[@Hertha_herly15]

Why is mine not working my grades

[@adjotech]

I think you should check your formula again

[@Hertha_herly15]

Thank you I did that it worked .❤

[@ricodem419]

TIDs Repping!

[@yakubumohammeddanka5021]

Charlie Excel is interesting

[@adjotech]

Very powerful

[@user-rq7pe8im5l]

bro pls can i get the template

[@adjotech]

I will try and get the file and link it at the description

[@emmanuelamgeni5024]

❤

[@adjotech]

👍

[@OKEKEONDU]

Grest

[@adjotech]

Thanks

[@realbrotherstune6551]

The video is not clear enough for us to see

[@adjotech]

Click on setting and switch to 720

[@diclotofficialmusic4339]

Hots teacher

[@adjotech]

😊😊