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
You guys are amazing. You can imagine by how much you’ve lessened my burden when it comes to grading students. 👍🏽
@adjotech
3 жыл бұрын
We're glad to hear that.
Imagine you're better than all my lecturers thank you.
@adjotech
2 күн бұрын
🤭🤭🤭
Please subscribe, like and turn on post notification. Subscribe to my channel here: bit.ly/3h4BPBF
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
2 жыл бұрын
You're welcome
Wow that's great job done. Keep the good works up.
@adjotech
3 жыл бұрын
Thank you
Great work done✌️
@adjotech
2 жыл бұрын
Thank you
Great tips
@adjotech
3 жыл бұрын
Thanks
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
15 сағат бұрын
You're welcome
Thank you so much the video has been of help to me
@adjotech
3 ай бұрын
You're welcome
Great, it so wonderful
@adjotech
8 күн бұрын
Thank you
Great work out there
@adjotech
2 жыл бұрын
Thank you
@adjotech
2 жыл бұрын
Don't forget to subscribe
Watch from Kenya 🥰 You are great
@adjotech
3 жыл бұрын
Thanks so much
Thanks so mch sir
@adjotech
Жыл бұрын
You're welcome
Great work
@adjotech
3 жыл бұрын
Thanks Harry
@adjotech
3 жыл бұрын
I hope you subscribed?
Nice work bro
@adjotech
3 жыл бұрын
Thanks
Awesome
@adjotech
Жыл бұрын
👍
Amazing
@adjotech
3 жыл бұрын
Thanks
Thanks, so much for this. Please I will like to know about how to compute Position.
@adjotech
2 жыл бұрын
Yes, this video has detail explanation to that. kzread.info/dash/bejne/onmHmsGcfq2vcrg.html remember to subscribe, like and share
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
2 жыл бұрын
You can equally do that. Rank function can help you get the positions. I will consider doing a video on multiple subjects
@edohmichaeladah5481
2 жыл бұрын
@@adjotechthat we be very good. please, we are waiting...
Pls at the grading point can u explain again how u get the equal sign and the bracket
@adjotech
2 күн бұрын
The equal sign and the brackets are close to the Backspace button on your keyboard
That is great! How will you display the grades for each subject if the subjects are many?
@adjotech
3 жыл бұрын
It's the same procedure. You have to get individual scores.
Nice video
@adjotech
3 жыл бұрын
Thanks bro
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
2 жыл бұрын
Will do that
Interesting
@adjotech
3 жыл бұрын
Share with friends and also ask other to subscribe for amazing videos like this.
@BRIDGETBLESS-z
3 жыл бұрын
@@adjotech yes sir
This is great. How can this be transformed to report sheet for each student?
@adjotech
3 жыл бұрын
Nice suggestion, I will make a video on that. I hope you subscribed ?
@adjotech
3 жыл бұрын
share with friends as well
TIDs Repping!
Charlie Excel is interesting
@adjotech
Жыл бұрын
Very powerful
How do we print for each student using this excel table if all the subject is enter on the same table
@adjotech
3 ай бұрын
It can be done, but we may have to add some dropdowns and buttons in order to print for individual student
❤
@adjotech
Ай бұрын
👍
Please how do you grade using numbers eg. 100-80=1 , 70-79=2...... instead of letter form
@adjotech
2 жыл бұрын
Same process where I placed the letter use the numbers and it should be in qoutes as well.
@patrick_the_technician
2 жыл бұрын
if(cell reference>79,"1",if(cell reference=80,"1".....)) you will get the same results
@yuoridomatthew8541
2 жыл бұрын
@@patrick_the_technician God bless you🙏🙏
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.
Please zoom in I'm not seeing what you're doing
@adjotech
2 ай бұрын
Okay
bro pls can i get the template
@adjotech
8 ай бұрын
I will try and get the file and link it at the description
Grest
@adjotech
2 жыл бұрын
Thanks
Hots teacher
@adjotech
4 ай бұрын
😊😊
The video is not clear enough for us to see
@adjotech
21 күн бұрын
Click on setting and switch to 720