What's new
  • Welcome to PHCorner Forums. Take a moment to Sign up and gain unlimited access and extra privileges that guests are not entitled to, such as: All that and more! Registration is quick, simple and absolutely free. Join our community today!

Help college grading system

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

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.
 
J
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????????
 
, 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

Comment

pixkit

Addict
Back in my college years the most common formula I know was buy your professor a gift and you get to graduate. The better the gift, the higher the grade.
 
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
, 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

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

Online statistics

Members online
797
Guests online
658
Total visitors
1,455

Forum statistics

Threads
811,835
Messages
16,059,513
Members
1,436,072
Top