L1R5 Calculations using Excel

[evirob3]

Dear all,

I am a teacher.

I have a series of data of students results of different combinations.

I need to calculate the L1R5. (Table 3 in https://www.moe.gov.sg/admissions/direct-admissions/dsa-jc/eligibility)

However, due to my lack in excel knowledge and almost zero programming language, I am unable to create an excel formula to do it.

Anybody can help here?

 

[davidktw]

Dear all,

I am a teacher.

I have a series of data of students results of different combinations.

I need to calculate the L1R5. (Table 3 in https://www.moe.gov.sg/admissions/direct-admissions/dsa-jc/eligibility)

However, due to my lack in excel knowledge and almost zero programming language, I am unable to create an excel formula to do it.

Anybody can help here?

As a teacher, perhaps it's a good start to demonstrate to students in this forum, how is it that learning is a lifelong process ?

http://bookboon.com/en/excel-ebooks

If you meet with problem while at it, then post your enquires here for help. There is very little programming involved, mostly just setting up your cell values and probably just ONE (or MORE, if you break it up) formula(s).

 

[peterchan75]

If you can tell your excel spreadsheet format, maybe I can formulate it in the spreadsheet or code Excel VBA for it