Details of Assessment Term and Year Time allowed N/A Assessment No 1 Assessment Weighting 50% Assessment Type Written Due Date Week 6 Room Details of Subject Qualification ICT50115 Diploma of Information Technology Subject Name Object Oriented Programming II Details of Unit(s) of competency Unit Code ICTPRG527 Apply intermediate object-oriented language skills Details of Student Student Name College Student ID Student Declaration: I declare that the work submitted is my own, and has not been copied or plagiarised from any person or source. Signature: ___________________________ Date: _______/________/_______________ Details of Assessor Assessor's Name Assessment Outcome Results 0 Competent 0 Not Yet Competent Marks /50 FEEDBACK TO STUDENT Progressive feedback to students, identifying gaps in competency and comments on positive improvements: ________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ Student Declaration: I declare that I have been assessed in this unit, and I have been advised of my result. I also am aware of my appeal rights and reassessment procedure. Signature: ____________________________ Date: ____/_____/_____ Assessor Declaration: I declare that I have conducted a fair, valid, reliable and flexible assessment with this student, and I have provided appropriate feedback Student ID not attend the feedback session. Feedback provided on assessment. Signature: ____________________________ Date: ____/_____/_____ Purpose of the Assessment The purpose of this assessment is to assess the student in the following learning outcomes: Competent (C) Not yet Competent (NYC) Performance for Competency Code 1.1 Review the program requirements 1.3 Use at least two of the utilities of the target language, allowing for the internal storage of collections of data 1.4 Use the utilities of the target language, providing internal data-sorting and searching facilities 1.8 Use the operator and function or method overloading facilities available in the language, at an introductory level 1.9 Use exception-handling techniques to ensure program stability 1.10 Use of a class that is based on multiple inheritances 2.1 Design and implement programs that connect to a database 2.2 Design and implement programs that use the language facilities to extract, update, and delete data stored in a database 2.4 Write programs that deliver transactional integrity 3.1 Employ the graphical user interface (GUI) framework, or text windowing interface, appropriate to the chosen language 4.1 Use stand-alone debugging tools, or tools provided by the integrated development environment, to examine variables, and trace the running code 4.2 Use the debugger to detect logical and coding errors 4.3 Use the tracing of code and examination of variable contents during execution, to detect and correct errors 5.1 Design and document limited tests of code 5.2 Undertake limited testing of the produced code to ensure that it complies with the program specification 5.3 Capture and document the test results 6.1 Read and interpret the supplied design document, to create the code 6.2 Create and maintain program documentation Assessment/evidence gathering conditions Each assessment component is recorded as either Competent (C) or Not Yet Competent (NYC). A student can only achieve competence when all assessment components listed under "Purpose of the assessment" section are recorded as competent. Your trainer will give you feedback after the completion of each assessment. A student who is assessed as NYC (Not Yet Competent) is eligible for re-assessment. Resources required for this assessment • Computer with relevant software applications and access to internet • Weekly eLearning notes relevant to the tasks/questions Instructions for Students Please read the following instructions carefully • This assessment has to be completed 1 In class 1 At home • The assessment is to be completed according to the instructions given by your assessor. • Feedback on each task will be provided to enable you to determine how your work could be improved. You will be provided with feedback on your work within two weeks of the assessment due date. All other feedback will be provided by the end of the term. • Should you not answer the questions correctly, you will be given feedback on the results and your gaps in knowledge. You will be given another opportunity to demonstrate your knowledge and skills to be deemed competent for this unit of competency. • If you are not sure about any aspect of this assessment, please ask for clarification from your assessor. • Please refer to the College re-assessment for more information (Student handbook).   Assessment – Written/Practical Solution Written/Practical Tasks (50 Marks) Tasks instructions: Please give the solutions to the following tasks. None of the following are conceptual/knowledge "question and answer" type of written tasks. They all have practical part that requires the solution coding samples. The solution coding can be from your project, your class exercises, or from an example solutions in your reference books or other tutorial resources related based on which you have practiced in preparation of doing your project. Please describe and provide either PHP/MySQL coding evidence or the screenshot evidence of PHP/MySQL coding for all the following. Note: Important, please do not mistake the following tasks as "question and answer". None of them are questions; they all have practical part, which requires the evidences (either screenshots or code example.) 1. Please describe and provide either PHP/MySQL coding evidence or the screenshot evidence of PHP/MySQL coding for the following: (4 Marks) The implementation of MySQL database insert and update inside PHP coding. 2. Please describe and provide either PHP/MySQL coding evidence or the screenshot evidence of PHP/MySQL coding for the following: (4 Marks) The implementation of MySQL database select (with "ordered by" sorting feature) and MySQL delete. 3. Please describe and provide either PHP/MySQL coding evidence or the screenshot evidence of PHP/MySQL coding for the following: (3 Marks) Simple PHP overloading. 4. Please describe and provide either PHP/MySQL coding evidence or the screenshot evidence of PHP/MySQL coding for the following: (3 Marks) Why do we need PHP exception handling in PHP coding? Please list 5 exception handling methods. Give one example of basic use of exception. 5. In object-oriented programming I, we have explained how to set up a PHP class to represent and store the components of the structure of a webpage to meet the requirement of the project. Suppose the values of these components are to be stored in a MySQL tale, please propose the structure of such a table. (4 Marks) The description of this task must be demonstrated in the context of the understanding of the difference between small sized and medium-sized application programming, or sequential and object oriented programming, ie, the concept of object-oriented programming and language (PHP) that support it. 6. Please describe and provide either PHP/MySQL coding evidence or the screenshot evidence of PHP/MySQL coding for the following: (4 Marks) A PHP class being intertied multiple inherited. (Hint: new objects created for index.php and about_us.php for instance). 7. Please describe and provide either PHP/MySQL coding evidence or the screenshot evidence of PHP/MySQL coding for the following: (4 Marks) Database connection routine in PHP coding. 8. Please explain the advantage of using MySQL transaction and its integrity? Please give an example. (4 Marks) 9. Use the following example, explain the process and techniques related to the use of a graphical user interface (GUI), to accommodate the interaction between an operator inside the client's company and the database where the information of the webpage is represented. (4 Marks) Please giving one example of interface building using PFBC (PHP Form Builder Class)? (You can refer to the examples from: https://code.google.com/p/php-form-builder-class/) 10. Please provide and name and web address of two stand-alone PHP debugger (or Debugging Tools)? Giving one example of the logic and coding error identification; one example of detection and correction of error. (4 Marks) 11. Please give an example of testing withSimpleTest? (Please refer to the examples from: www.simpletest.org) (4 Marks) 12. During testing of your PHP project, you might be using either of the flowing: (4 Marks) • Smoke Testing • Functionality Testing • System Testing • Retesting • Regression Testing • Performance Testing • Please give an example of Smoke testing or Regression testing procedure 13. Use the following example, outline and explain the techniques to document applications/programming. (4 Marks) Please give an example of the use of API and phpDocumentor in PHP project? Note: The following assessment task should not be considered as question and answer tasks. You are required to provide evidence that you not only understand the relevant knowledge, but also evidence that you can process the relevant required procedures. Submission Guide: • The tasks of this assessment should be directly answered inside this document. • Student must submit by sending the assessment in a zip file (not rar file) compressed format by the due date, by sending it to the submission email. (Email address is provided inside eLearning of each subject. Note: important! Assessment submission email address is not trainers' staff email address) Assessment Guidelines and Marking Sheet Marking List Marks Written/Practical (50 Marks) Task 1 /4 Task 2 /4 Task 3 /3 Task 4 /3 Task 5 /4 Task 6 /4 Task 7 /4 Task 8 /4 Task 9 /4 Task 10 /4 Task 11 /4 Task 12 /4 TOTAL /50