What's new

#### foxgalano

Elite
sino po ba may alam na formula sa college grading system using excel?

thanks

#### ChuckY DolL

Elite
ang dali lang nyan ts

Comment

#### Demon_Cyborg

Established
You mean to say na automatic paps? Yung pag-ininput mo ang isang particular no. (in that case ay ang grade) ay lalabas ang corresponding value (passed or failed) niya?

Ang grading system ay dedepende din sa allotted percentage per area based din sa bigay ng university/college niyo paps.

Comment

Established

Comment

#### foxgalano

Elite
yung mismo pong formula hinihingi ko po sir

Comment

#### Syntax_Error4

Elite
Nasa student handbook po yan ts. Hanapin mulang.
Nandook lahat

crimelove
yes, i have a good excel program that i been using for 6 years as a college instructor and professor..the excel is edited base in your preferences.. you can edit the percentage and all formula..

#### homer_simpson

##### Eternal Poster
Base sa Legend mo, ang Remarks can contain only 1 of the 2 values, ie PASSED o FAILED. Wala na yung Merit, Outstanding etc.

So ang numerical comparison mo ay simple: >= 75. Anything else is failed.

Eto:

Sa C2:
=B2*0.40

Sa E2:
= D2*0.60

Sa F2:
= C2+E2

Sa H2:
= IF(H2>=75, "PASSED", "FAILED")

So unless babaguhin mo yung Remarks, GPA of 1 and 3 are equivalent.

Jer
" Base sa Legend mo, ang Remarks can contain only 1 of the 2 values, ie PASSED o FAILED. " Tutol ako dto. Hahaha isa lang ba ang way para dyan????????

#### homer_simpson

##### Eternal Poster
Yung GPA? Well, base sa classification it's useless.

Comment

#### ChuckY DolL

Elite
, Last edited:
Yung GPA? Well, base sa classification it's useless.
makalusot...haha

hindi mo lang alam mga grading na GPA base
at baka di mo lang alam gawan ng formula

gusto ko lang MAKATULONG kay TS
NAPASAMA pa ako...

at si TS, HINDI ALAM magOpen ng file para MAKITA ang FORMULA

according to shown Photo
yun ang GINAWA ko

tapos USELESS hahahaha

WT!!!!

Comment

#### homer_simpson

##### Eternal Poster
, Last edited:
makalusot...haha

hindi mo lang alam mga grading na GPA base
at baka di mo lang alam gawan ng formula

gusto ko lang MAKATULONG kay TS
NAPASAMA pa ako...

at si TS, HINDI ALAM magOpen ng file para MAKITA ang FORMULA

according to shown Photo
yun ang GINAWA ko

tapos USELESS hahahaha

WT!!!!
Kiddo, tingnan mo yung mga posts ko sa Linux at dito sa Coding forums para may idea ka. Search mo na din yung mga scripts na posted ko + yung mga posters na natulungan ko.

Napaka-simpleng formula ito. Eto auto-colorizer pa yan, kapag failed RED yung cell. Kapag pass, GREEN. Conditional formatting tawag dyan para may madag-dag sa kaalaman mo.

#### Attachments

• 13.2 KB Views: 0
Comment

Comment

#### pnash08

Established
Teacher ka ata, well meron sa yt. You can create your own formula as long as alam mo ung functions, kahit intermediate level lang makaka create kana.
Like nesting, calling.....meron nga this coming webinar part 2 for intermediate level for excell.

Comment

#### pnash08

Established
Teacher ka ata, well meron sa yt. You can create your own formula as long as alam mo ung functions, kahit intermediate level lang makaka create kana.
Like nesting, calling.....meron nga this coming webinar part 2 for intermediate level for excell.
How to use SUM, AVER, IF, reference, nesting at marami pa

Comment

#### ChuckY DolL

Elite
, Last edited:
Kiddo, tingnan mo yung mga posts ko sa Linux at dito sa Coding forums para may idea ka. Search mo na din yung mga scripts na posted ko + yung mga posters na natulungan ko.

Napaka-simpleng formula ito. Eto auto-colorizer pa yan, kapag failed RED yung cell. Kapag pass, GREEN. Conditional formatting tawag dyan para may madag-dag sa kaalaman mo.
asan yun GPA na 1,1.25,1.5......5

even make no sense...asan yun GPA?
it seems di mo nga alam

GPA ba yun 94 at 34?

hindi ako nagmamagaling sa XCEL at di ko yan Pinag-aralan but i can make sheet to sheet computations.....Common sense lang

Comment

#### homer_simpson

##### Eternal Poster
asan yun GPA na 1,1.25,1.5......5

even make no sense...asan yun GPA?
it seems di mo nga alam

GPA ba yun 94 at 34?

hindi ako nagmamagaling sa XCEL at di ko yan Pinag-aralan but i can make sheet to sheet computations.....Common sense lang
Displaying GPA is not needed as it is just unnecessary. Pero kung insistent ka, that is too simple to do. So kung mai-display na yung GPA happy ka na?

Nassan na uli yung formula mo, bat nawala?

Comment

#### ChuckY DolL

Elite
Displaying GPA is not needed as it is just unnecessary. Pero kung insistent ka, that is too simple to do. So kung mai-display na yung GPA happy ka na?

Nassan na uli yung formula mo, bat nawala?
nawala kasi hindi nakatulong kay TS

ang hanao daw nya Formula

ColorfulRain
Hahahahh awts gege

#### homer_simpson

##### Eternal Poster
" Base sa Legend mo, ang Remarks can contain only 1 of the 2 values, ie PASSED o FAILED. " Tutol ako dto. Hahaha isa lang ba ang way para dyan????????
Then create your own thread and state that Remarks must be derived from GPA. Not unless the TS changes his criteria, my answer stands.

Can you show your formula on how would you go about it? Mahirap yung panay tayo salita without any solution offered.

Comment

#### PRIME_05

Elite
good eve ts
sana makatulong sa gpa
ginawa ko na more specific ung range
#respect po

#### Attachments

• 263.5 KB Views: 0
• 164.5 KB Views: 0
Comment

Members online
797
Guests online
658
Total visitors
1,455