How to calculate students grades in Excel

In this lesson, I will be teaching you how to calculate student grades using Microsoft Excel. #Excel #Microsoft #AdjoTech @TeachersTech @freecodecamp @LeilaGharani @SeleTraining
Feel free to buy me a coffee: www.buymeacoffee.com/adjotech
- PRODUCTS -
Grow Your Channel with Vidiq : vidiq.com/adjotech
Get cheap domain name and hosting : namecheap.pxf.io/Z0Goz
Get Voice Over: elevenlabs.io/?from=partnerrobinson9021
Make money using FourthWall: link.fourthwall.com/ref/adjotech
GET IN TOUCH!
📸Instagram ➜ / adjotechgh
👍Facebook ➜ / adjotechgh
🌐Website ➜ www.adjotechgh.com/
✒️Twitter ➜ / adjotechgh​​​
🧐Linkedin ➜ / ​​
CLICK HERE TO SUBSCRIBE- ruclips.net/channel/UCiIX...
Check out my previous videos:
Top 10 excel functions you need to know: www.youtube.com/watch?v=qwHPZ...
how to create a simple logo with photoshop
www.youtube.com/watch?v=DNj3N...
About me:
I'm a tech enthusiast trying to solve your everyday tech problems.
I make videos on coding, graphic design, WordPress, etc
How to calculate students grade
calculate grade in excel
calculate grades using vlookup
calculation
excel formulas
excel formulas and functions
excel grading
excel tutorial
grade formula in excelgrading in excel
grading students with excelhow to grade students in Excel
if function

[@adjotech]

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

[@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.

[@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

[@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

[@emmanuelamgeni5024]

❤

[@adjotech]

👍

[@lizamedia1015]

Great tips

[@adjotech]

Thanks

[@silaskalonzoke3038]

Watch from Kenya 🥰
You are great

[@adjotech]

Thanks so much

[@ustazisma]

Great work out there

[@adjotech]

Thank you

[@adjotech]

Don't forget to subscribe

[@ricodem419]

TIDs Repping!

[@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...

[@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. ruclips.net/video/pES8_cNJIBU/видео.html remember to subscribe, like and share

[@nambagovicent8747]

Thanks so mch sir

[@adjotech]

You're welcome

[@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.

[@harryakakpo7258]

Great work

[@adjotech]

Thanks Harry

[@adjotech]

I hope you subscribed?

[@rubysvlogz]

Nice work bro

[@adjotech]

Thanks

[@deannangsventures1417]

Awesome

[@adjotech]

👍

[@mohsinnor8698]

Amazing

[@adjotech]

Thanks

[@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

[@Workoutmarshall]

Nice video

[@adjotech]

Thanks bro

[@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

[@OKEKEONDU]

Grest

[@adjotech]

Thanks

[@BRIDGETBLESS-z]

Interesting

[@adjotech]

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

[@BRIDGETBLESS-z]

@@adjotech yes sir

[@cyrilafiaboh4701]

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

[@yakubumohammeddanka5021]

Charlie Excel is interesting

[@adjotech]

Very powerful

[@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.

[@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🙏🙏

[@diclotofficialmusic4339]

Hots teacher

[@adjotech]

😊😊

[@user-rq7pe8im5l]

bro pls can i get the template

[@adjotech]

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

[@suzieoquinn173]

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

[@adjotech]

Okay

[@realbrotherstune6551]

The video is not clear enough for us to see

[@adjotech]

Click on setting and switch to 720