Microsoft Office Forums Auto calculation of Percentage, Position and Grade of students
 Register FAQ Search Today's Posts Mark Forums Read

#1
11-23-2023, 01:52 PM
 Oluagbe1 Windows 10 Office 2019 Novice Join Date: Feb 2019 Posts: 8
Auto calculation of Percentage, Position and Grade of students

Hello everyone.
My students offered 10 while some offered 11 out of the 12 subjects.
Now, I need to calculate the underlisted.

Percentage: to calculate this, those students that offered 10 subjects, their total should be divided by 10 and those that offered 11 subjects, their total be divided by 11

Position: In finding the position, the student with the highest percentage comes 1st, followed by the next in line. Also note that if we have 3 students with the same percentage, it means that position will be repeated 3 times e.g if we have 69.05 appearing 3 times for 3 different students, the position will appear as 3rd, 3rd and 3rd, it means the next position will be 6th as there will not be 4th and 5th because of the reoccurrence of 3rd.

Grade: In grading, the percentage column will be used. From there we can deduce 0  29 as F, 30  39 as E, 40  49 as D, 50  59 as C, 60  69 as B and 70 and above as A

Remark: in getting the remark, 3 criteria will be used. Each student must score 50% and above in English Language, Mathematics and must have 50 and above percentage. Is the student meets this criteria, the Remark column returns a PASS else Failed and if a student did not partake in any of the exam i.e 0 in percentage the remark returns absent

Thank you in anticipation
Attached Files
 sample SCORE TEMPLATE 1.xlsx (21.9 KB, 1 views)

Last edited by Oluagbe1; 11-24-2023 at 09:11 AM. Reason: To change the prefix to solved.
#2
11-23-2023, 05:44 PM
 p45cal Windows 10 Office 2021 Expert Join Date: Apr 2014 Posts: 855

See attached
Attached Files
 msofficeforums51689sample SCORE TEMPLATE 1.xlsx (22.3 KB, 1 views)
#3
11-24-2023, 09:09 AM
 Oluagbe1 Windows 10 Office 2019 Novice Join Date: Feb 2019 Posts: 8
Great job

Quote:
 Originally Posted by p45cal See attached
Thank you very much.
This work very well for me. I appreciate your efforts much.

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post yoyo4 Excel 10 11-15-2017 11:44 AM ballst Excel Programming 8 05-21-2015 03:54 PM raminraiszadeh Project 2 04-06-2015 06:38 AM VivekG1 Project 1 02-06-2015 05:33 AM johnnykhan Excel 2 04-03-2012 02:28 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:35 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top