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- kzread.info/dron/iIX.html...
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

Пікірлер: 78

  • @kwadwodennis1647
    @kwadwodennis16473 жыл бұрын

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

  • @adjotech

    @adjotech

    3 жыл бұрын

    We're glad to hear that.

  • @Mudi-zk2cy
    @Mudi-zk2cy2 күн бұрын

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

  • @adjotech

    @adjotech

    2 күн бұрын

    🤭🤭🤭

  • @adjotech
    @adjotech Жыл бұрын

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

  • @elijahacheampongoduro5779
    @elijahacheampongoduro57792 жыл бұрын

    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

    @adjotech

    2 жыл бұрын

    You're welcome

  • @hon.samuelnkekebia3414
    @hon.samuelnkekebia34143 жыл бұрын

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

  • @adjotech

    @adjotech

    3 жыл бұрын

    Thank you

  • @yawbaffour1441
    @yawbaffour14412 жыл бұрын

    Great work done✌️

  • @adjotech

    @adjotech

    2 жыл бұрын

    Thank you

  • @lizamedia1015
    @lizamedia10153 жыл бұрын

    Great tips

  • @adjotech

    @adjotech

    3 жыл бұрын

    Thanks

  • @professordavid2008
    @professordavid200815 сағат бұрын

    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

    @adjotech

    15 сағат бұрын

    You're welcome

  • @Faith.20008
    @Faith.200083 ай бұрын

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

  • @adjotech

    @adjotech

    3 ай бұрын

    You're welcome

  • @baimbakarkunabieu1524
    @baimbakarkunabieu15248 күн бұрын

    Great, it so wonderful

  • @adjotech

    @adjotech

    8 күн бұрын

    Thank you

  • @ustazisma
    @ustazisma2 жыл бұрын

    Great work out there

  • @adjotech

    @adjotech

    2 жыл бұрын

    Thank you

  • @adjotech

    @adjotech

    2 жыл бұрын

    Don't forget to subscribe

  • @silaskalonzoke3038
    @silaskalonzoke30383 жыл бұрын

    Watch from Kenya 🥰 You are great

  • @adjotech

    @adjotech

    3 жыл бұрын

    Thanks so much

  • @nambagovicent8747
    @nambagovicent8747 Жыл бұрын

    Thanks so mch sir

  • @adjotech

    @adjotech

    Жыл бұрын

    You're welcome

  • @harryakakpo7258
    @harryakakpo72583 жыл бұрын

    Great work

  • @adjotech

    @adjotech

    3 жыл бұрын

    Thanks Harry

  • @adjotech

    @adjotech

    3 жыл бұрын

    I hope you subscribed?

  • @rubysvlogz
    @rubysvlogz3 жыл бұрын

    Nice work bro

  • @adjotech

    @adjotech

    3 жыл бұрын

    Thanks

  • @deannangsventures1417
    @deannangsventures1417 Жыл бұрын

    Awesome

  • @adjotech

    @adjotech

    Жыл бұрын

    👍

  • @mohsinnor8698
    @mohsinnor86983 жыл бұрын

    Amazing

  • @adjotech

    @adjotech

    3 жыл бұрын

    Thanks

  • @edohmichaeladah5481
    @edohmichaeladah54812 жыл бұрын

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

  • @adjotech

    @adjotech

    2 жыл бұрын

    Yes, this video has detail explanation to that. kzread.info/dash/bejne/onmHmsGcfq2vcrg.html remember to subscribe, like and share

  • @ibrahimaminudanyaya7103
    @ibrahimaminudanyaya71032 жыл бұрын

    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

    @adjotech

    2 жыл бұрын

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

  • @edohmichaeladah5481

    @edohmichaeladah5481

    2 жыл бұрын

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

  • @GboloAbdul-gafaru
    @GboloAbdul-gafaru2 күн бұрын

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

  • @adjotech

    @adjotech

    2 күн бұрын

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

  • @nyaabaakabotiemmanuel7372
    @nyaabaakabotiemmanuel73723 жыл бұрын

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

  • @adjotech

    @adjotech

    3 жыл бұрын

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

  • @Workoutmarshall
    @Workoutmarshall3 жыл бұрын

    Nice video

  • @adjotech

    @adjotech

    3 жыл бұрын

    Thanks bro

  • @weldonrotich5802
    @weldonrotich58022 жыл бұрын

    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

    @adjotech

    2 жыл бұрын

    Will do that

  • @BRIDGETBLESS-z
    @BRIDGETBLESS-z3 жыл бұрын

    Interesting

  • @adjotech

    @adjotech

    3 жыл бұрын

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

  • @BRIDGETBLESS-z

    @BRIDGETBLESS-z

    3 жыл бұрын

    @@adjotech yes sir

  • @josephakande1044
    @josephakande10443 жыл бұрын

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

  • @adjotech

    @adjotech

    3 жыл бұрын

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

  • @adjotech

    @adjotech

    3 жыл бұрын

    share with friends as well

  • @ricodem419
    @ricodem4192 жыл бұрын

    TIDs Repping!

  • @yakubumohammeddanka5021
    @yakubumohammeddanka5021 Жыл бұрын

    Charlie Excel is interesting

  • @adjotech

    @adjotech

    Жыл бұрын

    Very powerful

  • @cyrilafiaboh4701
    @cyrilafiaboh47013 ай бұрын

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

  • @adjotech

    @adjotech

    3 ай бұрын

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

  • @emmanuelamgeni5024
    @emmanuelamgeni5024Ай бұрын

  • @adjotech

    @adjotech

    Ай бұрын

    👍

  • @yuoridomatthew8541
    @yuoridomatthew85412 жыл бұрын

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

  • @adjotech

    @adjotech

    2 жыл бұрын

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

  • @patrick_the_technician

    @patrick_the_technician

    2 жыл бұрын

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

  • @yuoridomatthew8541

    @yuoridomatthew8541

    2 жыл бұрын

    @@patrick_the_technician God bless you🙏🙏

  • @anyichiechristopher502
    @anyichiechristopher502 Жыл бұрын

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

  • @adjotech

    @adjotech

    Жыл бұрын

    Yes

  • @anyichiechristopher502

    @anyichiechristopher502

    Жыл бұрын

    @@adjotech can you give a hint on that.

  • @suzieoquinn173
    @suzieoquinn1732 ай бұрын

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

  • @adjotech

    @adjotech

    2 ай бұрын

    Okay

  • @user-rq7pe8im5l
    @user-rq7pe8im5l8 ай бұрын

    bro pls can i get the template

  • @adjotech

    @adjotech

    8 ай бұрын

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

  • @OKEKEONDU
    @OKEKEONDU2 жыл бұрын

    Grest

  • @adjotech

    @adjotech

    2 жыл бұрын

    Thanks

  • @diclotofficialmusic4339
    @diclotofficialmusic43394 ай бұрын

    Hots teacher

  • @adjotech

    @adjotech

    4 ай бұрын

    😊😊

  • @realbrotherstune6551
    @realbrotherstune655121 күн бұрын

    The video is not clear enough for us to see

  • @adjotech

    @adjotech

    21 күн бұрын

    Click on setting and switch to 720

Келесі