Principles Of Computer Programming NCV Level 3 — Exam Paper
February 2020 — NCV Level 3 — Principles Of Computer Programming
NCV Level 3
2020
NCV IT
Preparing document
📋 Document Analysis
See full analysis
Questions — A Preview of What to Expect in the Document
92
This section provides a quick preview of questions from the document. It may not display every question or the complete wording of each one. For the full content, including diagrams, tables and other information, view the original PDF above.
Q1— Section header —
Q2— Section header —
Q1— Section header —
1.1Add the following IDE settings and form class declarations
1.1.1 Ensure that option strict is enforced (1\
1.1Dec lare and appropriately initialis e a v ariable named intClientCount to count the number of clients
1.1.3 Declare and appropriately initiali e a variable named intStatus to indicate the status (availability\ i.e. 0 or 1 or 2 of the vehicle.
1.1Dec lare and appropriately initialis e a variable named decRentalfee to store the applicable rental cost. (1\
1.2sing a restricted access modifier, create a user defined sub procedure called PopVehicleNames without parameters which will perform the following: (2\
1.2.1Remove all items from the Vehicle list box. (1\
1.2.2(a\ Use a nested If ElseIf statement to determine which category of vehicle has been selected. (b\
1.2.3Select the first item in the Vehicle list box. (1\
1.3sing a restricted access modifier create a user defined sub procedure called DisplayVehicleInfo which will display vehicle information using the following
1.3.1The sub procedure must accept as a copy the following THREE parameters as a copy Description Rental f ee
1.3.2Concatenate the current vehicle name from the list box together with the value of the Description arameter and assign the value to the Vehicle Description label control.
1.3.3Assign the value from the Availability parameter into the flag variable named intStatus (1\
1.3Disable the Create Booking button (1\ (10041023\
1.3(a\ Use an If ElseIf statement to determine if the vehicle is not available or if it is sold out
Q1— Section header —
Q1— Section header —
1.4Add program code to the hecked changed event of every radio button. Determine if the radio button is c hecked, and then invoke the sub procedure
Q1— Section header —
1.5sing a restricted access modifier, create a user defined function procedure
1.5.1The function procedure must accept as a copy ONE parameter named Amount and must return a flag value. (3\
1.5.2Determine if the entered credit card balance is more than twice the value of the parameter named Amount or not and return an appropriate flag value in each case. (3\
1.6A user defined sub procedure named SaveRentalData with TWO value parameters (amount and days\ has been partially completed. Complete the rest of the program code to perform the following:
1.6.1Change the access modifier of the sub procedure to restrict access. (1\
1.6.2Increment the client counter variable by 1. (1\
1.6.3Create a pop up dialog box to display the rental confirmation note as shown in STEP 6 above. (2\
1.7Add the following program code to the Click Event of the Create Booking button:
1.7.1Create an input dialog box to request the user to enter number of days and assign the value into a local variable ( numberOfdays (2\
1.7.2Calculate the amount due
1.7.3Determine whether the client credit card balance is sufficient enough or not by adding the program code to perform the following: (10041023\
1.8Insert your EXAMINATION NUMBER in the source code and print
1.9Change the text property of the form to your EXAMINATION NUMBER Run the application and enter the following test data: Select vehicle t ype : Hatch Vehicle make :
Q2— Section header —
2.1Declare the following at form level:
2.1.1A 2 dimensional array calle decArrCarWashPrices . The first second and third rows contain
2.1.2A 2 dimensional array call ed decArrExtrasPrices . The first , second and third rows contain zeroes, sedan prices and 4x4 prices
2.1.3THREE variables to store the car wash cost extras cost and total cost respectively. (1\
2.2Using an open access modifier create a sub procedure called DisplayCustomerInfo without parameters. The procedure must perform the following: (2\
2.2.1Concatenate the customer name and contact number and assign it to the lblCustomerDetails display label. (2\
2.2.2Assign the appropriate value to the lblRegNumber lblMakeModel and
2.3Add program code to the click event of the Choose Car Wash Option button on the registration tab to display the customer information.
2.3.1Determine if the entered contact number is valid or not by invoking the function procedure named ValContactNumber . If not , then alert the user with
2.3.2Determine if the entered registration number is valid or not by invoking the function procedure named ValTextField to If not , alert the user with
Q2— Section header —
2.3.3Check if a vehicle type had been selected. If not, then alert the user with an appropriate message
Q2— Section header —
2.4Add the following progr am code to the user defined sub procedure named CalcTotalCost
2.4.1Assign the car wash price from t he two dimensional ar ray created
Q2— Section header —
2.4.2If the drying checkbox is ticked, then assign the extra cost price from the two dimensional ar
Q2— Section header —
2.4.3If the vacuum checkbox is ticked, add the extra cost price
Q2— Section header —
Q2— Section header —
2.4.4Calculate the total cost by adding the car wash price and extra cost price (1\
2.5A user defined function procedure n amed CalcCostExcludingVAT has been partially completed. NOTE: This function procedure receives the total amount including VAT and
2.5.1Change the function procedure s definition to accept, as a copy, a decimal type parameter named amount
2.5.2Change the return type of the function to decimal
2.5.3
2.6Test and debug the source code.
2.7Insert your EXAMINATON NUMBER into the sourc e code and make a PRINTOUT [30]30
Q3— Section header —
3.1Use the information above to set up the database in MS Access. Open a new blank database and save it as Jobs with your EXAMINATION NUMBER Jobs
3.1.1Create a Clients table (refer to TABLE 4\ and save it as CLIENT. (3\
3.1.2Create a Jobs table (refer to TABLE and save it as JOB. (3\
3.1.3Create a 1: M relationship between CLIENTS and J obs tables. Use the ClientID field as key. Enforce referential integrity. (2\
3.1.4Open the J obs table. Select the Salary field. Make a screen print and print the table design view. (1\
3.1.5Use the database documenter to set the print table definition options as shown in FIGURE below. FIGURE
3.2Create a database form based on J obs table Use the form wizard to create a simple form based on the J ob table. Format
3.3Follow the instructions below to capture all input data into database tables:
3.3.1Open the database table called Clients in a datasheet view mode and insert the following records: CLIENT ID CLIENT NAME CONTACT NUMBER 1001 ABB South Africa 011 567 8000
Q3— Section header —
3.3.3Re enter the annual salary for Job ID 000002 using the correct amount R88 000. Make a
3.4Create a database que ry based on the JOB table using the instructions given below:
3.4.1The query must retrieve data from the following fields: JOB table (JobID, JobTitle, and Area\ (1\
3.4.2Add new field called Monthly Salary and calculate the monthly salary. (3\
3.4.3Add a condition to retrieve all jobs from the Centurion area. (1\
3.4Open the query in design view. Ensure that all columns are clearly legible . Make a screen print of the query design and print it. (10041023\
3.4Run the query, select all records and print the selected records. (1\
Q3— Section header —
3.5.1The r eport must display all the fields from the query. (1\
3.5.2Sort by Job t itle. (1\
3.5.3Report layout: Tabular and Portrait.
3.5.4Report title: Selected Vacancies with your EXAMINATION NUMBER (1\
3.5.5Add a formula to determine the lowest monthly salary. (2\
3.5.6Add Lowest as a descriptive label to the formula created in
Q3— Section header —
3.5.7Add the currency symbol and TWO decimal places to the lowest monthly salary. (1\
3.5.8Print the report. [25] TOTAL: 10025
Topics Identified
1
Forms of Ownership
Mark Allocation
Total100 marks
Sections45 + 30 + 25 = 100 marks
Key Information
Contact Number0229490808 · 011 567 8000
Paper information
TitleExam Paper
SubjectPrinciples Of Computer Programming
LevelNCV Level 3
Document typeQuestion paper
Year2020
MonthFebruary
Pages17
Downloads3
Examination context
Decade2020s
Years ago6y
SeasonSummer (SH)
Start daySaturday
Exam periodFebruary 2020
Days since exam2,443
About Principles Of Computer Programming examination preparation
This TVET examination resource can be used as part of a structured revision programme. Past papers are most useful when learners attempt questions independently, work within a realistic time limit, and review their answers afterwards.
How to use this resource for revision
A TVET past examination paper is most useful when it is treated as an active revision exercise. Try the questions yourself before checking the corresponding memorandum. Where you make an error, identify the reason — was it a knowledge gap, a calculation mistake, an interpretation issue, or an examination technique problem?
For stronger examination practice, complete the paper without unnecessary interruptions and keep track of the questions that take the most time. Afterwards, review the memorandum and separate knowledge gaps from mistakes caused by interpretation, calculation, structure, or examination technique.
understanding question requirements
applying subject knowledge
working under time constraints
checking answers
identifying revision priorities
A practical revision approach
Start by completing the resource without looking at the memorandum. Review incorrect and incomplete answers afterwards and make a short revision list based on the areas that caused difficulty.
File details
File size485.3 KB
Pages17
Archived on8 September 2026
File age45d
ContributorFreeMode
FingerprintAC9BEB3ADC03
Questions and learner discussion
Log in to ask a question or leave a review.
No questions or discussions have been posted yet.