Principles Of Computer Programming NCV Level 3 — Exam Paper

November 2019 — NCV Level 3 — Principles Of Computer Programming

NCV Level 3 2019 NCV IT

↓ Download PDF 📄 424.5 KB

Preparing document

📋 Document Analysis

🎯 1 marks ⏱️ 4h 📄 8 pages 📝 88 items found 📚 1 topics

See full analysis

Questions — A Preview of What to Expect in the Document

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.

18.4Run/Debug the solution. Hold down the ALT key and press the print screen ( Pr nt Scrn \. Open a blank MS W or d document and paste the screen

18.5Make a PRINTOUT of the page. (10041023\ Copyright reserved Please turn over 19. The followi

Q1— Section header —

Q2— Section header —

Q1— Section header —

1.1Whe n the interface frmCalc loads:

1.1.1Invoke the user efined sub procedure PopIncomeCategories. (1\

1.1.2Declare TWO loop counters and initialise them to ZERO. (2\

1.1.3Use a pre test Do While loop to populate the Spouse combo box with th e values of the elements stored in an array called

1.1.4Use a For Next loop to populate the Parents combo box with the values stored in an array called strArrParents (2\

Q1— Section header —

1.1.5Select the first item in all THREE of the combo boxes. (1\ (10041023\ Copyright reserved Please turn over

1.1.6Make the Adult Price label visible. (1\

1.2Provide the Visual Basic code that will do the following: When the Adult Dependents checkbox is ticked, the Adult Dependents group box must be enabled, otherwise the Adult Dependents group box must be

1.3rite the Visual Basic c ode that will, w hen the Child Dependents checkbox is ticked, enable the

1.4When the Main M ember combo box is se lected, the application must use a Select Case statement to:

1.4.1Assign an appropriate message to the text property of the Adult Price label. NOTE For each case

1.4.2Assi gn appropriate amounts to the variables for the Main M ember contribution amount, the Adult Dependent price and the Child

1.5Create a user defined function called CalcNoOfAdults without parameters to calculate the number of Adult Dependents

1.5.1If the main member has selected Spouse , the function must assign the number of Adult Dependents to 1 otherwise the number should be zero. (2\

1.5.2If the main member has selected how many Parents/In laws he/she would like to cover, then the function must increment the original

Q1— Section header —

1.5.3Return the umber of Adult Dependents to the event procedure that invoked the function. NOTE he function procedure must use a procedure

1.6Create a user defined functi on called CalcMonthlyBasic to calculate the basic monthly cost of medical aid by doing the following:

1.6.1The function must accept the following parameters as a copy The cost of the main member 's contribution The number of adult dependents The cos t of the adult dependents

1.6.2Return the calculated basic monthly cost to the event procedure that invoked the function. (2\

1.7Create a user defined function called CalcDis count to calculate the discount amount for the medical aid.

1.7.1The function must accept the following parameters as a copy The number of child dependents The basic monthly cost (2

1.7.2Determine if the main member qualifies for a disco unt and then return the calculated discount amount to the event procedure that invoked the function. (2\

1.8When the Calculate button is clicked the application must:

1.8.1Use a arse method to det ermine if the number of child dependents ent ered is a whole number. If NOT the application must alert the user, highlight and focus the control

1.8.2Invoke the function procedure to calculate the number of adult dependents and assign the result to an appropriat e variable. (1\

1.8.3Assign the number of child dependents to an appropriate variable. (1\

1.8.4Invoke the functions to calculate the basic monthly cost and discount amount and assign the result to appropriate variables. (3\

1.8.5alculate the final monthly cost of the medical aid. (1\

1.9Insert your EXAMINATION NUMBE R in the source code and make a PRINTOUT. (10041023\ 10 Copyright reserved Please turn over

1.10Change the text in the title bar of the form to your EXAMINATION NUMBER. Run the application and enter t he following test data: Income: R6 301 R8 500

Q2— Section header —

2.1Add the progr am code to the user defined sub procedure Initialisation to

2.1.1Initialise the one dimensional array named sngArrTotalPerYear to zeroes using a Do While

2.1.2Initialise the strWettestMonth and sngHighestFigure to a null string and zero respectively. (2

2.2Create a user efined subprocedure called CheckForWettestMonth with TWO parameters called value

2.2.1Declare a one dimensional array to store the following names of months : Jan, Feb, March, April, May and June. (2

2.2.2Check if value is grea ter than sngHighestFigure, then: (a\ Assign value

2.3Create a user defined function called CalcYearlyTotalRainfall with ONE parameter rray called

2.3.1Use a For Next loop to determine the to tal monthly rainfall figures and invoke the procedure to che ck for the wettest month (4\

2.3.2Return the total rain fall. (1\

2.4Add program code to the user defined sub procedure called CalcRainfallTotals to calculate the rainfall totals for each year , by doing the following Invoke the

2.5Create a user defined function called DetermineDriestYear without parameters to return the driest year t o the calling procedure.

2.5.1Declare a one dimensional array to store: '2014', '2015', '2016', '2017' and '2018'. (1\

2.5.2Implement the sequential search technique to find the lowest rainfall total. (4\

2.5.3Return the driest year. (1\

2.6Create a user defined function called CalcMonthlyAvgRainfall without parameters to calculate the average monthly rainfall.

2.6.1Multiply the number of years by the number of months to determine the overall number of months the rainfall f igures were kept. (1\

2.6.2Determine the sum of all the rainfall totals from the array called sngTotalRainfallPerYear (3\

2.6.3Use a Try Catch block to calculate the monthly average rainfall. (2\

2.6.4Return the monthly average rain fall. NOTE he function procedure must use procedure level variables. (1\

2.7Insert your EXAMINATION NUMBER in the source code and print. [30] (10041023\ 15 Copyright reserved Please turn over30

Q3— Section header —

3.1Open the Sale table in design view and perform the following:

3.1.1Select the saleID field and click on the eneral tab. Make a screenshot of the table's design a nd print.

3.1.2Select the saleItem field and click on the ookup tab. Make a

3.2Set the following options for the tables using the database documenter: Print the table definitions for the TWO tables. (8\

3.3Follow the instructions below to capture all inpu t data into the database tables.

3.3.1Open the Product table in datasheet view and insert the following records: prodCode prodName prodPrice prodQtyInStock P0

3.3.2Use the form wizard to create a simple form with columnar layout as shown in FIGURE 5 based on the Sale table. FIGURE 5

3.3.3Make a screenshot of the form and print. (2\

3.3.4Use the simple form

Q3— Section header —

3.4Create a database query based on both tables using ALL the instructions given below.

3.4.1Select the following f ields: Product table: Product name Sales table: Sale quantity Product table: Product price

3.4.2Add a new field called TotalCost and calcul ate the total cost as follows: P roduct rice * S

3.4.3Change each field name to the new name given in brackets: prodName (Item Name\ saleQty (Quantity\ prodPrice (Unit P rice\

3.4.4Save the query as qrySale and your EXAMINATION NUMBER.

3.4.5Run the query and print the resulting records. Ensure that ALL columns are clearly visible (3\

3.4.6Open the query in design view and make a screenshot of the query design and print. Ensure that ALL columns are clearly visible. (3\ (10041023\ 18 Copyright reserved

Q3— Section header —

3.5.1The report must display ALL fields from the query. (1\

3.5.2Group by Item Name. (1\

3.5.3eport layout: S tepped and p ortrait. (1\

3.5.4Report title: Sales Data Report and your EXAMINATION NUMBER. (1\

3.5.5Open the report in design view and adjust the width of ALL columns to appropriate sizes.

3.5.6Add a formula to calculate the total cost for each sales record. (1\

3.5.7Add 'SUB TOTAL' as a descriptive label to the formula created in QUEST ION 3.5.6. (1\

3.5.8Add the currency symbol (R\ to the total costs. 1\

3.5.9Make a PRINTOUT of the report. [25] TOTAL: 10025

Topics Identified

Forms of Ownership

Mark Allocation

Total100 marks

Sections45 + 30 + 25 = 100 marks

Paper information

TitleExam Paper

SubjectPrinciples Of Computer Programming

LevelNCV Level 3

Document typeQuestion paper

Year2019

MonthNovember

Pages18

Downloads2

Examination context

Decade2010s

Years ago7y

SeasonSpring (SH)

Start dayFriday

Exam periodNovember 2019

Days since exam2,535

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 size424.5 KB

Pages18

Archived on8 September 2026

File age45d

ContributorFreeMode

FingerprintCE4292D73E9A

Questions and learner discussion

No questions or discussions have been posted yet.