School Based SF System v.1.1

[arman666]

yung mga Class Adviser na nagugugol ng days sa paggawa ng School Forms ay andito na po solution, automatic na po pati printing of SF137, SF138 and SF5, within an hour maka-generate na po tayo ng mas mabilis at less hassle na po preparation. Sa SHS Registrar naman po ay mas mabilis na din po ma-monitor at ma-evaluate student po natin. To God be the glory
View attachment 309228
View attachment 309230
View attachment 309231
View attachment 309232
View attachment 309233

 

[dejosejimpaul]

Program po ba 'to or yung Excel template ng DepEd?

 

[hardcorekid03]

penge naman po ng copy

 

[LaGAdero]

sir asan po ang copy? pwede pa attach? thanks

 

[arman666]

Program po ba 'to or yung Excel template ng DepEd?

program na po.

penge naman po ng copy

sir asan po ang copy? pwede pa attach? thanks

pa-approvan ko po muna sa DepEd Albay division, once approved na po ay for sure ishare po natin dito sa symbianize

 

[hardcorekid03]

program na po.



pa-approvan ko po muna sa DepEd Albay division, once approved na po ay for sure ishare po natin dito sa symbianize

sige po sir, salamat

 

[batangburgos]

waiting kami paps

 

[LaGAdero]

program na po.



pa-approvan ko po muna sa DepEd Albay division, once approved na po ay for sure ishare po natin dito sa symbianize

Sige sir antayin namin yan.. Laking tulong niyan. Thanks!

 

[arman666]

View attachment 309824

School Form 5(SF5) added, here is the worksheet relationship of the SHS School Based SF System v.1.1

MSExcel Features/Command used are the ff:
1. drop down box
2. if()
3. iferror()
4. round()
5. rank()
6. concatenate()
7. vlookup()
8. average()
9. or()
10. index()
11. match()
12. indirect()
13 countif()

 

[arman666]

added features, SF5, Student Rank and Deficiencies

View attachment 311694
View attachment 311693
View attachment 311692

 

[arman666]

added feature, summary sheet per grade level and per semester

View attachment 312291

 

[Kjhoe]

sir approve n po b pwede mkhingi ng program... Thanks...

 

[arman666]

sir approve n po b pwede mkhingi ng program... Thanks...

di pa po approve, so busy pa po kasi sa business. but tomorrow/independence day I will attach it. remind ko lang po that this is unofficial copy kasi nga po di pa approve ng deped.

 

[arman666]

wala pa pong sf2 yan at di pa po yan approve ng deped.

 

[CONFITEOR]

salamat dito sir. pwede ko ba gamitin to at i-adapt sa school namen?

 

[arman666]

salamat dito sir. pwede ko ba gamitin to at i-adapt sa school namen?

opo it would be good if magagamit nyo po, attached file temporary remove. updating po...

 

[arman666]

Updated version as of 6/23/2017 includes main Menu for easy navigation and autocompute of age as of first day of June. SF2/attendance is still in progress.

https://drive.google.com/open?id=0B0LBNPYWsjBxS0pJdmo2UzVFRk0

 

[marvinfloreza]

sir pahinge din ako ng copy


thanks

 

[arman666]

sure po, dl nyo na lang po

 

[kilo18]

Up for this thread, Salamat sa copy TS!