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.

1 reply

basante
Posts
1
Registration date
Sunday June 13, 2021
Status
Member
Last seen
June 13, 2021
1
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
1
How do we calculate 3 core subject and 3 electives
0