TESDA Programming NCIV

At last I have successfully passed the TESDA Programming NCIV exam last December 5 and 6. The exam sure is tough and I think college students would have a hard time passing the exam especially those taking up 2-year programming course and the nominal PGS scholars. The exam has 2 parts. The object-oriented programming where in you have to develop a library system using any OOP language of your choice with MS Access integration and the second part, a payroll system using any procedural language using file manipulation functions. I used Visual Basic 2008 for the OOP and C for the procedural. For the first part, a candidate for NCIV must have knowledge in SQL in these areas: * LIKE * AND / OR * JOINS * Query grouping The candidate must also know how to cast database datetime column values to language DateTime object for date and time comparison. This is essential in the part where in you have to check for the validity of the user account. There are four tables in the database where in you have to query those tables all in one single query using joins. * tblUser - contains the userid and personal information of the user * tblUserAccount - contains the username and password * tblRoles - contains the role for each user account (e.g. Administrator or Member) * tblMembership - contains the validity of each user account For the second part, you must be familiar with the following C functions (if you prefer to use C for the procedural exam): * fopen * fgets * strtok * atoi * fflush * fprintf You must also be familiar with looping and conditional statements. The best way to pass this exam is to have a thorough review of the areas I mentioned above. College instructors must also be proficient in these areas in order for them to properly prepare the students for the NCIV exam.

since updated nmn to i just wnt you to know my experience,i'm a fresh grad and dhil nglakas lakasan ako ng loob n mg aply as a programer sa isang institution,ng apply ako snce ang requirements lng is graduate of 4 yr corz related to the said position and merong prof.eligibility which i am already..so dis is d best part,after d interview sabi i need to take practical exam and guess wat, they gave me an nc iv programming exam..i think nd nmn ako ngkakamali kc ang nsa cover is tesda nciv programming, madami syang pages 2 parts ryt?...ung 1 is gud 4 1 hr and another is gud for 5 hrs,sa pinak likod is d proposed database..ryt?..so if i am ryt un nga un...ang nkktwa is dat they gave me 1 hr to do d programing, library system un, the database is already done by them at d ko nga ginawa ang program, unbelievable, 1 hr to do the whole program...nd n nga sa kanila ang exam bnago pa ang rules...they are not tesda employees so i dont know how they got a copy of nc iv programming and they even used it for a practical exam of their applicants..

Helo, poh ask ku lng po kng Library system (OOP) at Payroll system (procedural) po tlga ung ggwin sa exam? o pwd ibng system? me written exam pa po b d2 sa NCIV? If God permit sna po mkapasa kme dis coming feb..... Reply nan poh...pls..pls.......Thanks!

......Ask kng lng po kng Library sytem at payroll system po b ggwin sa exam? Im from Region II Isabela.....tnks po!

hmmm ask q lng puh qng cnu my lam program n bar examination result system/ tnxxxxxxxxxxx

kamusta! mgkano po ba ang NC4 exam? im planning to take NC$ exam na,after passing NC2.. sana pumasa, hehe..kaso halo-halo na nasa isip ko..haha

hahahahah wawa man nging assessor q nun d nalito s connection na ginamit q palibhasa adodc ska adodb lng alam ai....gniamit q man my SQL s lbrary syatem,tpos turbo MYSQL din gnamit q pasado man aq Computer programmer NC IV holder n q Computer Hardware Servicing NC II holder din then nagfile para mgin assessor din kea now pwede n kau magtanong skin if u need an clarified answer heheheheheheheh.....STI COLLEGE FAIRVIEW poh aq

In reply to by Anonymous (not verified)

PAturo Nmn Ako kac mag tittke din ako ng ng nc4 eh!!!!!!!!!!!!!!!!!!!!!!

In reply to by Anonymous (not verified)

ahm sa nc4 exam p b pwed b gmamit ng mysql as a database backend ko... ze mas nkasanayan q ang mysql eh... pwed po b paPM sa yam ko... e2 po: [email protected]

In reply to by Anonymous (not verified)

from STI COLLEGE Tuguegarao sir, my sample code pba kau??

In reply to by Anonymous (not verified)

kaya pla, hindi cguro mrunong gumam8 nang SQL.. Assessor cia?.. hehe! Sa amin dito design nga lng kulang eh, hindi pa mkapasa.. Depende rin kac sa Assessor.. Meron nMn iba my mali sa codes pero maliit lng, pinapasa.. unfair nMn sa iba na design lng na wla namang Function.. Dapat ung mga Assessors maraming alam na Programming Languages.. From Region XII.

I Seconded.. Dapat mag upgrade din sila.. di lang sila mag stick sa alam nila.. kasi marami ang program languages.. bawat programmer ay may technique sa pag-gawa.. REGION XII..

hahai, sak8 sa ulo pg gumagawa ka ng program,, at ang mas masakit, kpag hindi ito ng RUN.. hehehe

Hehe, Excited na ako... grabe, problem ko lang talaga is yong work, ojt and other subjects ko.. working student po kasi ako.. napapanaginipan ko lagi ang NC4 exam.. subrang siksik ng schedule ko at laging puyat, hay naku.. wish ko makapasa.. ngayon palang ang dami nang magpapagawa ng program sakin, eh hindi pa naman ako expert no. nakakapagod pero kelangang magsikap.. mahirap lang kasi ako. gusto kong mag share ng knowledge about programming after ng graduation namin.

In reply to by Anonymous (not verified)

.,pwdng po bng humingi ng tip para mkpsa xa NCIV?

In reply to by Anonymous (not verified)

turuan mu din nman ako,,,, gusto ko din pumasa ng nc IV e..

ayon poh sa amin nung last batch daw di daw naka pasa sa nc4 tapos ngayun gina hintay pa poh ang result kung sinu ang naka pasa ngayung batch...first year 2nd sem poh ako IT,sabi daw ng sir.namin sana sa aming batch may maka pasa na daw kasi wla pa pong resulta ngayung batch eh ayaw daw matulad mangyari na walang naka pasa ,,,,.MAE po pla name ko

Sir ask q lng po ung ma contanation para s java, kc ngawa po kmi ng payroll Sysytem...tnx po ....

ako pala si ryan jay ng general santos ngayong march programming NCIV na namin.. gusto ko lahat kami makapasar sa NCIV.in RMMC.. NGAYONG ARAW january2011 bali nag titraining pa kami sa programming............................,

loe poh ako ay isang studyante anu ang aking gawin para pumasa sa nc4 at anu ang mga tips during sa assesment at 2 years lng ang akind course medyo lisud sa aming part ang nc 4 eh... pls reply tnx......

low pwde bang magdala ng flsh drive during assessment sa nc4 ga naay codes?

haii...mi po ngayon mag ttake ng nciv.. D nmin alam kung ano ang gagawin... hahaii nko... short pa sa tym..

hi pwede bang parehas java ang gamitin ko sa procedural at oop.. kasi yong java pwede na yang oop kasi yong netbeans meron JFORM,, na drag and drap na gui builder parang visual basic.. pwede kaya yon?

Excerpt from the book USING VISUAL BASIC 6 Special Edition by Bryan Siler & Jeff Spotts Object-Oriented Programming You probably have heard the term object-oriented programming (OOP) or read about it in programming books and magazines. A key element of OOP is its use of reusable objects to build programs. OOP begins in the design stage, when you determine the objects in an application. For example, suppose you have to write a system to manage paychecks for employees. A traditional design plan would be to determine each program function, such as “Adding an employee to the database” or “Printing an employee paycheck.” An object-oriented design would instead try to separate programming tasks along the lines of the objects in the program (employees, database, paycheck, and so on). In order for a design to be considered object-oriented, several facts must be true about the objects. These fundamental concepts of OOP are summarized in the following list: Encapsulation. Encapsulation, or information hiding, refers to the fact that objects hide the details of how they work. For example, when you set the Text property of a text box, you do not know (or care) how the text box internally repaints the characters. Information hiding allows the programmer of an object to change how an object works without affecting the users of the object. Inheritance. A new object can be defined based on an existing object, and it can contain all the same properties and methods. For example, you can create a new object that contains all the standard properties and methods of an existing object plus a few of your own. You can just add your own extra properties and “inherit” the existing ones. Visual Basic, strictly speaking, does not support inheritance. Polymorphism. Although many objects can have methods bearing the same name, the method can perform differently for each of the objects. Through polymorphism, the program runs the method appropriate for the current object. For example, the + operator can be used with both strings and integers. Even though the same symbol is used for both data types, Visual Basic knows to perform different operations. An important consequence of an OOP approach is reusable code. Part of what makes an object reusable is its interface, or the methods and properties the object uses to communicate with the outside world. If you build objects with well-defined interfaces, it is easy to change the object internally or even add new interfaces without affecting programs that use the object. Classes in Visual Basic You create your own classes in Visual Basic with a class module. Class modules can contain several types of elements: Properties. These elements are used to assign and retrieve values from the class. Methods. These are public functions or subroutines that are defined in the class. Events. Just as a control can raise events in the form that contains it, an object created from your class can also raise events in its containing object. Class modules also contain two special events of their own, Initialize and Terminate. The Initialize event is triggered when a new instance of the class is created, and the Terminate event occurs when the object is destroyed. Object definitions are created in a class module. A class module is like a standard code module in that it contains only variable declarations and procedure code. There is no user interface component of a class module. However, a class can take action using a form that is in the program, just like a normal code module. Class modules can be used in several ways, such as the following: In a Visual Basic project, a class module provides a way to create multiple instances of objects anywhere in your program, without using global variables. You can create ActiveX objects and compile them into a DLL or EXE that other programmers can use in their code. For example, you can put all of your business financial rules in a class and compile it as an ActiveX DLL. Other programmers can reference the DLL and use the financial rules in their applications. You can build an Add-In to Visual Basic, to enhance the functions of the Visual Basic IDE. Kaya VB6 is an Object-Oriented Programming. Siguro nasabi ng iba jan na hindi ito OOP dahil hindi sila marunong gumawa ng mga reusable objects, instances, and level of inheritance. Problema lang kasi sa ibang assessor di din nila alam paano gumawa ng OOP sa VB6. Sa COC1 which is OOP(TESDA LIBRARY SYSTEM), kahit isang test case lang matapos mo at na perform mo lahat na nasa competency standard at tama ang required inputs, outputs, and you will be able to answer questions, pass ka na sa COC1. Sa COC2 which is PROCEDURAL (Employee's DTR) ganun din sa COC1.

In reply to by Anonymous (not verified)

I Disagree to you mate. VB6.0 is an Object BASED Programming language and not an Object Oriented Programming Language. A programming language can only be considered as an OOP if and only if it supports the four fundamental concepts of OOP such as Abstraction, Encapsulation, INHERITANCE and POLYMORPHISM. Definitely you can't do the last two concepts using VB6.0 that is why Microsoft redesigned it and Introduce VB.Net which is obviously an OOP language.

In reply to by Anonymous (not verified)

Napakahirap ng EXAM lalo na sa procedural.... NAKU! lagas lahat ng buhok mo... heheh, yung taga tesda na nag assess naming sobrang LATE, imagine, 8 AM pa kami antay, halos mag 12 NN na xa dumating at bigay agad ng FLOWCHARTING churva. 6 hours yong programming part. Meron xa taga ibang skul na pina observe kasi obviously, hindi niya kaya i-assess kasi TALAGANG kasing edad na xa ng TATAY ko, kaya yong mga kakapasa lang ng exam ang nagbantay, SUPER STRICT "kono", di naman diniscuss yong test package kaya sa 15 naming nag take kahapon, 4 agad nag withdraw, then sa 11 natira 2 lang pumasa sa procedural on the first day...... meaning, 2 lang ang nag exam ng OOP today, ewan ko kung sino sa kanila ang pumasa. DAMI lapses ng conduct ng exam. Sobrang OA ng mga PASSERS kono ng NC-IV, di naman nila alam mas may karapatan pa tong nagsulat kasi, di naman sa pagyayabang, ipinasa ko na rin yong PHILNITS FE and SW... FREE daw pero pinabayad naman kami tig 100... Kaya if you want to know more about the exam, please feel free to email me [email protected]

mahirap po ba ang programming NCIV, ngayong march 2011 kasi mag te take na kami dito sa gensan ng NCIV, sa exam po ba namin kasali po ba yong OOP? object oriented Programming and Procedual Programming, Ako Pala si Ryan Jay Ng Gensan im 2nd year 2nd year student Computer Programming in RMMCgensan...

i think this is another way of how tesda made the education as their business..?? what you think???

haizt sa sat na NC IV namin kinakabhan n aq,,,,,, goodluck to me

Hi Mdale pu ba ang nc?? POWER

Good Day sa lahat! Ask ko lng po anu po bah ung INPUT para sa payroll at ung OUTPUT? example: input: name of employee, time in, time out per day, position, output: salary per month. may mga tax pa po ba? kailangan po bah na e save as text file yong output? Sa library system poh! anu poh b ang INPUT at OUTPUT? sa admin, ADD, Delete, sort, search? e print po h ba ung result?? pls.. email me [email protected] wla poh kc ako nag undergo ng kahit anung training..

ndi nman ito ang mgbabago ng fortune ng mgttake ehh.. pasa o ndi..

Hello poh sa lahat!!! Ask ko lng poh kung mayroon papoh ba free training sa Computer Programming NCIV tulad po ng PGS. kung meron poh sana meron d2 socksargen..

kung pwede po sana makuha ung code, kasi mag eexam kami ng COC1, pero 2yrs na aq nka graduate..and di ko na maalala ung ibang dapat gawin sa programming, i will really appreciate kung tutulungan mo po ako...just email me [email protected] thank you and regards.

In reply to by Anonymous (not verified)

bilhen mo sakin!!! i swear running to!!!

In reply to by Anonymous (not verified)

hanggang ngayon ba library(OOP) at payroll(PROCEDURAL) pa din ang exam sa nc iv?? panu nga pala mag exam ng pprogramming nc iv?? pede ba gamitin ang iisang programming language? i mean kunwari java gmit ko sa OOP pde q b ulit gmitin ung java sa procedural??

In reply to by Anonymous (not verified)

Your taking an assessment exam and you are asking for code at the same time? Do you think you are qualified to be a programmer anyway?

can you tell mo po kung ano actual na object nandun?listview po ba?datagrid or msflexgrid?thx po...nalilito po kc ako eh...

ang tanong ko po, saan magagamit ang computer programming. May job opportunities po ba sa abroad nito.

Maraming nangangailangan ng mga programmers ngayon. Pero mas may edge ka kung naipasa mo ang isang exam gamit ang sarili mong kaalaman kaysa umasa sa mga ginawa na ng iba na mememoryahin mo na lang.

In reply to by Anonymous (not verified)

Yung Mga nanghihingi ng source code medyo mahiya naman kayo! niloloko nyo lang sarili nyo wag na kayo mag take ng assessment!

Pwede b gamitin PHP and MySQL for OOP

from sti college here. the best way to pass the exam is to actually read test cases . marami kasing mga nageexam na ndi talaga nagbabasa ng test cases so they end up failing instead.

Para sa mga kukuha ng exam review lang po kayo ng maigi at saka tama yung ibang post na may mga mali sa mga test case kaya dapat lagi niyong i-clarify sa Accessor niyo kung meron kayong di maintindihan. Kahapon yung last day ng exam ko. Best regards, Tobee

anu mas magandang gamitin sa procedural programming po?? Java or C?

pwede help po kung pano i-query yung 4 na tables?please

In reply to by Anonymous (not verified)

ambot lang

i have a copy of instructions to candidates...want some?

Add new comment