What's new

Help college grading system

[XX='homer_simpson, c: 289316, m: 1361956'][/XX] Sabagay, either manual yung GPA na gawing 4 o manual na ilagay na lang na INC yung Remarks, depende lang siguro kung may hidden conversion diyan depende sa Final Grade.

Baka need ni TS na makuha yung GPA base sa Final Grade, parang kailangan niyang gumamit ng Lookup pero parang hindi gagana yung data sa Legend.
 
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.
 
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
 
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
 
Last edited:
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?
 
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..
 
" 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????????
 
" 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.
 
good eve ts
sana makatulong sa gpa
ginawa ko na more specific ung range
#respect po
20200920_230455.jpg
20200920_230440.jpg
 

Attachments

Similar threads

Back
Top