TESDA Programming NCIV
Submitted by arjay_nacion on Sunday, December 13, 2009 - 17:03.
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.
VB6 is an OOP language although not SOLID
VB6 is oOP.
You use controls with Properties and Methods.
And you can create your own classes by making class modules.
Although VB6 is not solid OOP, still most of the time you'll be using the OOP feature of vb6.
For Christ Sake!!
VB6 is not an OOP!!! it is just an Object Based Programming Language but not an OOP!!!!! Please try to do some thorough research!!!
For Christ Sake!!
VB6.0 is not an OOP!!! it is an Object Based Programming Language but not an OOP!!! please try to do some thorough research. It doesn't mean that if you can create classes, add some properties and methods eh pwede mo nang tawaging OOP ang isang language. a Programming language can be considered as an OOP if and only if it is capable of doing the four fundamental concepts of OOP which is abstraction, encapsulation, INHERITANCE and POLYMORPHISM. can you do the last two concepts using VB6.0?!!! definitely not. even MICROSOFT admits that it is not an OOP that is why they redesigned it and introduce VB.Net. yes, that is the VB version that can be considered as an OOP language but not VB6.0.
For Christ Sake, never feed your brains with wrong ideas. nakakabobo yan!
OOP
excuse me... first of all di OOP or Object-based ang VB6 programming language, it's an "event-driven programming language", if you noticed, the whole IDE of this language is puro event ang controls, so all you have to do is to set the event of a certain control kung kailan sya dapat magtake place of mag-occur.. more research bout this much better..
hi kuya arjay?
ask ko lang po, im creating on my project, the voice command but di ko po lam if san ako mag-uumpisa, ginagamit ko po ay vb.net, nagawa ko na po sya, he speaked what ever i type in the textbox but ung pronunciation niya ay parang ngungu, sir panu po gumamit ng sepra? saka po pede po makahenge ng sample kung panu gawin na icocompare mo ung voice mo dun talagang nakaregister mong voice. tnx a lot po.
Taking the Exam
Hi,
Any tips on the 2nd part of the exam, i know the 1st part is VB and i'll be using ADO and i know SQL queries, on second part our choices is C++ or Java, and TESDA scheduled our exam this coming friday and saturday, we haven't review a lot so self study na lang or group study kami... if only the 2nd part of exam is PHP language I'm sure I'll pass
Taking the Exam
Hi,
Any tips on the 2nd part of the exam, i know the 1st part is VB and i'll be using ADO and i know SQL queries, on second part our choices is C++ or Java, and TESDA scheduled our exam this coming friday and saturday, we haven't review a lot so self study na lang or group study kami... if only the 2nd part of exam is PHP language I'm sure I'll pass
Designing the Flow
Hi! Im going to take the NC4 exam 2mrow, Im almost ready 4 the program but Im just curious f all the assesor are strict in the designing the flow of the system?? In your experience did the assesor strictly check your diagram??and can you show us the example..f you dont mind??
VB.Net programmer opening
Hi,
our company has an opening for vb.net programmers, if your interested do email your resume to [email protected]
hint
Hey! I've taken the exam recently and failed. i would like to retake the exam this May. Hingi sana ako ng ibang constraints ng program kasi di nakaya ng powers kung imemorize sya.... about don sa borrowing form, anong data dapat andun??? at sino pwedeng magborrow lang manually? thanks po sa mga sasagot.
:))
hey Im aerohn... yung sa borrowing transaction facility(manual mode). that panel e para lang sa administrator's facilities, tapos ung reserve facility e para lang sa member's facility. kailangan ung listed book(s) e mapapadagdag directly dun sa borrow facility, hindi dun sa reservation record.
tapos kelangan ding maggenerate syempre ng feedbacks... *yung member's ID Number(confirmation) *ung printable report ng transaction *and allowable na dami ng books na pwdeng mahiram.
hello po....
hindi po b mahirap ang exam s computer programming...
kc po gusto korin po mag araln2ng pasukan....
How to connect to MS Access. PHP and ODBC
To those who want to use PHP in OOP:
http://www.configure-all.com/php_accessb.php#a
hi kuya i need help poh regarding the procedural programming tnx
hi kuya in need help poh regarding the procedural programming i would appreciate it if you could see my code on the write to txt file part because when ti try write the file in to the next line it overwrites the whole file..here's the my code is this correct?
FileOutputStream fo = new FileOutputStream("dtr.txt,")
it writes the data i inputed but over writes the old data that was saved for example:
the txt file should be like this :
A02-0001,8:00,17:00
A03-0001,8:00,17:00
but it does this:
old txt file :
A02-0001,8:00,17:00
overwritten file:
A03-0001,8:30,17:30
tnx kuya if you ever find the tine to answer this please email me @ [email protected] ^^,
file streaming
FileOutputStream fo = new FileOutputStream("dtr.txt",ios::app) try to replace your code with this one. ok
NEXT NCIV SCHEDULE??
Hi mga sir, ask ko sana if kelan ang next schedule for NCIV. Please reply in this thread if meron ng updates. Plan to take kc. Thanks YOu!
Olol nga Progamming NC IV
Pataka lng ang TESDA ka require ug NC IV sa mga 2 year IT courses. nganu man? dili mana cla kapasa kung wala gyud extendsive training. Diritso take murag nag labay lang na sila ug kwarta tapos ang effect in the long run cge ang mga estudyante ka take cge man bayad nila P500 tapos five year lang ma expire ngeee..masyadong political ang TESDA. Mga wala plano nga mga agency sa government.
Can I use MySQL server as my database?
I'm a fresh grad and planning to take the NC IV exam.I'm a java programmer using MySQL as my database since ito po yung nakasanayan namin during sa college. Now, I already learn VB using the latest visual studio 2008/2010 and i'ts much easier than of java.In the exam i'm planning to use VB2010 and MySQL for the OOP and java for procedural. Would it be possible kung ito yung gagamitin ko?
taga ncpit poh aku from mindanao..
gusto ku sana magpatulong exam din nmin sa nciv..mhirap poh buh?anu poh ang mga gagawin pag exam na?
Gustong gusto ko poh...
sana poh tulongan mo ako.. dahil kinakabahan na kaci ako eh,ngayong may ng exam namin.. kahit mga sample code lng,, email mu nman dito [email protected].. tnx poh. from ATC poh.
Add new comment
- Add new comment
- 683 views