Previous Topic Next Topic

HOW TO CALCULATE AGGREGATE OF STUDENT'S MARKS

Closed
peterappiahkubi Posts 1 Registration date Saturday June 12, 2021 Status Member Last seen June 12, 2021 - Jun 12, 2021 at 09:02 AM
 Wofanat - Mar 23, 2022 at 05:03 AM
In creating an excel app to calculate the aggregate for students in their exams as used by WAEC to determine the student aggregate in BECE . The Excel has to select Six Subjects from Nine Subjects, with Four being compulsory and Two other best. I want an excel formular that will add the grade value of four compulsory subjects : English, Maths, Science, Social. And then automatically select 2 other subjects from the rest with best grade value.



For Instance, If a student has the following result:

1. English - 2

2. Maths - 1

3. Science - 1

4. Social - 2

5. ICT - 3

6. BDT - 3

7. RME - 1

8. French - 2

9. Twi - 2



I want a formular for this calculation :

English(2)+Maths(1)+Science(1)+Social(2) and randomly select best other two subjects from the rest : RME(1)+French(2) = 10



Kindly help me.
Related:

1 response

Answer 1 / 1
basante Posts 1 Registration date Sunday June 13, 2021 Status Member Last seen June 13, 2021 2
Jun 13, 2021 at 01:38 PM
Hi Peter,

I have created a similar excel sheet for school exams reporting which I would be glad to share with you but you can have a look at your solution with the image. Hope it helps

below
Wofanat
Mar 23, 2022 at 05:03 AM
How do we calculate 3 core subject and 3 electives

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

Hello,
hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the 1st 2nd 3rd...so on position of student leads from highest to lower one...

regards
hardy

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

Hello,

Hello,
hi sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the 1st 2nd 3rd...so on position of student leads from highest to lower one...

regards
hardy

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

Hello
Hello, sir/madam...i am doing some work with the students result in excel...but I faced a problem..it is simple but I havn't got dat in my mind...i have students total marks.now I wanna get the position of the students i.e first , second, third etc. I will be glad and praiseworthy if u can help me out
...

Configuration: Windows 7 / Safari 536.11

12 responses
Keyboard troubles
jimbobjoe -
car -

Hello, my keyboard is pretty messed up for my on msn or any other sites I visit besides this site my "?" buttin shows me and "e" when I press it im unsure how to fix this so I ask you on all my other sites I go on when I need to put a question mark I have to use "shift" "6" and that brings up my "?"


Any Help?

ThankzSystem Configuration: Windows XP
Internet Explorer 6.0

38 responses
calculating fuel surcharge
Nancy -
xpcman -

Hello,

I have the amount which includes freight charge+fuel surcharge that is $14.36. It is said that fuel surcharge is 22%. what formula should we enter in excel to get the break down of the charges .. freight and fuel separate or the actual freight charges excluding the fuel surcharge...please let me know, it is urgent

Thanks!!

Configuration: Windows 7 / Chrome 43.0.2357.124

1 response