Information Technology Grade 11 P1 2014 QP

Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE GRADE 11 NOVEMBER 2014 INFORMATION TECHNOLOGY P1 MARKS: 150 TIME: 3 hours *IINFTDM1* This question paper consists of 11 pages.

Downloaded from hlayiso.com 2 INFORMATION TECHNOLOGY P1 (NOVEMBER 2014) INSTRUCTIONS AND INFORMATION 1. This is a three-hour examination. Because of the nature of this examination, it is important to note that you will not be permitted to leave the examination room before the end of the examination session. 2. You require the files listed below in order to answer the questions. They are either on a CD issued to you, or the invigilator/educator will tell you where to find them on the hard drive of the workstation you are using or in a network folder. P1 Data folder P1Q1 Folder P1Q2 Folder P1Q3 Folder P1Q4 Folder Q1_p.dpr Q2_p.dpr Q3_p.dpr Q4_p.dpr Q1_p.dfm Q2_u.pas Q3_u.pas DMQ4.dfm Q1_p.pas Q2_p.dfm Q3_p.dfm DMQ4.pas furniture.txt Q4_u.pas Q4_p.dfm electric.mdb 3. If a CD containing the above files was issued to you, write your name and surname on the label of the CD. 4. Save your work at regular intervals as a precaution against power failures. 5. Rename the P1 Data folder as your Name and Surname. 6. Type in your name and surname as a comment in the first line of each program. 7. Read ALL the questions carefully. Do only what is required. 8. At the end of this examination session you will be required to hand in the CD with all the files with the work you have done or you must make sure that ALL the files with your work have been saved on the network as explained to you by the invigilator/educator. 9. Ensure that ALL files can be read. 10. During the examination you may use the HELP functions of the software. You may NOT make use of any other resource material.

Downloaded from hlayiso.com (NOVEMBER 2014) INFORMATION TECHNOLOGY P1 3 SCENARIO: You have just been appointed manager of Grandpa Furniture Shop in East London. QUESTION 1: DELPHI PROGRAMMING Customers always want to open accounts with you. In order to verify their credit worthiness you have to call head office in Johannesburg. To speed up the process you decide to design a small program to determine whether a customer is eligible, or not eligible, for credit. Open the program and answer the following questions: 1.1 Display the title, name and surname of the customer in one line when the Check Eligibility button is clicked. (3) 1.2 Calculate tax: 1.2.1 Design a function called NetSalary which receives the gross salary as a parameter and then returns the net salary after income tax has been deducted. Make use of the table below to calculate the amount of tax to be paid. TAKE NOTE: The first R 67 134 per year is non-taxable. Taxable Income/Year Tax Rate R0 – R 165 600 18% R165 601 – R258 750 25% R258 751 – R358 110 30% R358 110 – R500 940 35% R500 941 – R638 600 38% R638 601 and above 40% Example of calculation: Salary per month is R15 500.00 Annual Salary = R15 500*12 = R186 000.00 Taxable Amount = (R186 000.00 – R67 134.00) = 118 866.00 Annual Tax = 118 866*0.18 = R21 395.88 Monthly Tax = R21 395.88/12 = R1 782.99 Net Salary = R15 500.00 – R1 782.99 = R13 717.01 (15)

Downloaded from hlayiso.com 4 INFORMATION TECHNOLOGY P1 (NOVEMBER 2014) 1.2.2 Call the function and display the Net Salary. (2) 1.3 Calculate the Net Family Salary by adding the spouse’s net salary to the customer’s net salary. Make use of an appropriate method (Netsalary function). (3) 1.4 After subtracting all the expenses from the net salary, it should display the income available. (3) 1.5 After repaying the loan a customer should be left with a minimum of R3 000 if they are to be approved; otherwise the customer does not qualify for the loan. Calculate the monthly repayment and whether the customer qualifies for the loan. Display your answers. (8)  Enter your name and surname as a comment line in the first line of the file named Q1_u.pas.  Save the program.  Make a printout of the code of the Q1_u.pas file. [34]

Downloaded from hlayiso.com (NOVEMBER 2014) INFORMATION TECHNOLOGY P1 5 QUESTION 2: DELPHI PROGRAMMING You are asked to examine the contents of a text file named furniture.txt saved in the folder named P1Q2. This file contains the data referring to the description of items in stock and a code number for each type of item. Each field is delimited with a comma. The content of the text file is shown below. Emma 3-piece Black,BSEBP70 Grace 4-piece Sleigh - Cherry,BSSSS9 Rimini 2-door Budget Robe,BURBR19 The first entry example represents: A furniture item with a description and a special code of BSEBP70 The BS means that it’s a Bedroom Suite The BU means that it’s a Bedroom Unit 2.1 Declare TWO arrays with class scope, named arrDesc and arrCodes, which can store a maximum of 35 elements. The code numbers will be stored in arrCodes and the descriptions will be stored in arrDesc. (2) 2.2 Write a Boolean function called Valid which will receive a string (sCode) containing the furniture code and a character (cDesc) containing the first letter of the description. In order for the code to be valid, the following rules apply:  The code must be 7 characters long.  The first five characters must be uppercase alphabetical characters.  The next two characters must be numerical digits.  The third character of the code must be the same as the first character of the description. (14) 2.3 Reading, checking and displaying: 2.3.1 Write a procedure loadfile which must read information from the text file furniture.txt. This procedure must open the text file and initialise a loop to read the data. Each line represents a record of a type of furniture in the shop. Add code to this procedure to test if the text file furniture.txt exists. If the file does not exist, a suitable error message must be displayed and the program must terminate. Add further code to the procedure to initialise the file and to read each line of text from the text file. The descriptions need to be stored in arrDesc and the codes need to be stored in arrCodes.

Downloaded from hlayiso.com 6 INFORMATION TECHNOLOGY P1 (NOVEMBER 2014) 2.3.2 Read and Check Button: The loadfile method must be called and all codes need to be validated. The description code for each furniture item must be displayed in the richedit component. If the code is valid then 'Valid Code’ must be added; if the code is invalid then 'Invalid Code' must be added. The total number of valid and invalid codes must also be displayed. Example of output below: (31) 2.4 Categories Button: The first two characters of all the Code indicate the category of the furniture, BU stands for Bedroom Unit and BS stands for Bedroom Suite. Write code to display a list of the furniture types and the number of items in each category and the total items in the list. (11)  Enter your name and surname as a comment line in the first line of the file named Q2_u.pas.  Save the program.  Make a printout of the code of the Q2_u.pas file. [58]

Downloaded from hlayiso.com (NOVEMBER 2014) INFORMATION TECHNOLOGY P1 7 QUESTION 3: DELPHI PROGRAMMING When you are creating an account for the client on your accounting system, a password has to be automatically generated from the Name, Surname and Day of Birth of the client (eg. 13 November 1997, so the input will be 13). The password is in the format vvnnnn where the first v is the first vowel found in the client's name and the second v is the first vowel in the client's Surname. The nnnn is a number generated from the client's date of birth (the day the client was born on). Add 2000 to the date of birth, then add a randomly generated number between 1 and 999 to get the number nnnn.  Enter your name and surname as a comment line in the first line of the file named Q3_u.pas.  Save the program.  Make a printout of the code of the Q3_u.pas file. [20]

Downloaded from hlayiso.com 8 INFORMATION TECHNOLOGY P1 (NOVEMBER 2014) QUESTION 4: DELPHI PROGRAMMING AND DATABASE The database, electric.mdb, in the P1Q4 folder supplied to you, contains details of electrical gadgets in stock at the furniture shop. The database contains a single table named Televisions. Data about the different types of televisions is stored in this table. Each record refers to a type of television, the price of one television and the number of televisions of this type in stock. The fields in this table are defined as follows: Field Type Description Example ID Autonumber AutoID 2 Price Number The price of one television in Rands 4560.99 Brand Text The brand of television Sony Size Number The screen size 32 TypeT Text The type of television screen LCD Stock Number Number of Televisions in stock 3 The following is an example of the data contained in the table: The folder P1Q4 also contains an incomplete Delphi project – Q4_p.dpr – which contains two units, namely a data module named DMQ4.pas and Q4_u.pas (the main unit). The data module, DataForm, contains the following components: ADOConnection, ADOTable and a DataSource.

Downloaded from hlayiso.com (NOVEMBER 2014) INFORMATION TECHNOLOGY P1 9 The program should be able to connect to the database named electric.mdb. When you do QUESTION 4.1 and you find that the connectivity is not in place, use the following steps to establish connection with the database:  Click on the ADOConnection component in the Data Module.  Click on the Ellipse button (three dots) to the right of the ‘ConnectionString’ property in the Object Inspector.  Click on the Build button which takes you to the Data Link Properties dialogue box.  Select Microsoft Jet 4.0 OLE DB Provider and click on Next.  The first option on the Connection tabsheet allows you to browse and find the electric.mdb file.  Remove the user name Admin.  Click on the Test Connection button. Click OK on each one of the open dialogue windows. NOTE: If you cannot establish connectivity with the database at all when you execute the program you must still do and submit the programming code for marking. 4.1 Btn A: Write code to display the data sorted in the following order: The Brand field in descending order and the Size field in ascending order. Example of output (first few records): (3)

Downloaded from hlayiso.com 10 INFORMATION TECHNOLOGY P1 (NOVEMBER 2014) 4.2 BtnB: Write code to count the number of LG televisions and display the answer using a ShowMessage component. (4) 4.3 BtnC: Write code to count the number of televisions in stock. (7) 4.4 BtnD: Write code to calculate the total Rand value of that particular television brand as entered by the user (use an inputbox component). If the brand entered is not found, display a suitable message. Example of output: Or (12)

Downloaded from hlayiso.com (NOVEMBER 2014) INFORMATION TECHNOLOGY P1 11 4.5 BtnE: Enter code to input a new record with the following values: Price = 1924.00 Brand = LG Size = 14 TypeT = Monitor Stock = 2 (7) 4.6 BtnF: Enter code to delete the record you have just entered in QUESTION 4.5. (5)  Enter your name and surname as a comment line in the first line of the file named Q4_u.pas.  Save the program.  Make a printout of the code of the Q4_u.pas file. [38] TOTAL: 150

(NOVEMBER 2014) INLIGTINGSTEGNOLOGIE V1 11 4.5 Knoppie E: Skryf kode wat ʼn nuwe rekord met die volgende waardes sal byvoeg: Prys = 1924.00 Vervaardiger = LG Grootte = 14 Tipe = Monitor Voorraad = 2 (7) 4.6 Knoppie F: Skryf kode wat die rekord wat jy so pas ingesit het in VRAAG 4.5 sal skrap. (5)  Plaas jou naam en van as kommentaar in die eerste reël van die lêer genoem V4_u.pas.  Stoor die program.  Druk die kode van die lêer V4_u.pas uit. [38] TOTAAL: 150 Downloaded from hlayiso.com

10 INLIGTINGSTEGNOLOGIE V1 (NOVEMBER 2014) 4.2 Knoppie B: Skryf kode om die aantal ‘LG Televisions’ te tel en vertoon die antwoord in ʼn ‘ShowMessage’ komponent. (4) 4.3 Knoppie C: Skryf kode om die aantal televisiestelle in voorraad te tel. (7) 4.4 Knoppie D: Skryf kode om die Randwaarde van ʼn sekere televisie maak wat deur die gebruiker ingetik word(gebruik ʼn ‘inputbox’ komponent) te bereken. Indien die spesifieke maak nie gevind word nie moet ʼn gepaste boodskap vertoon word. Voorbeeld afvoer: Of (12) Downloaded from hlayiso.com

(NOVEMBER 2014) INLIGTINGSTEGNOLOGIE V1 9 Die program is veronderstel om tot die databasis naamlik electric.mdb te konnekteer. Indien jy besig is met VRAAG 4.1 en die konneksie tot die databasis het nie plaasgevind nie, gebruik die volgende stappe om ʼn konneksie op te stel:  Klik op die ADOConnection komponent in die ‘Data module’.  Klik op die ‘Ellipse’ knoppie (drie kolletjies) aan die regterkant van die ‘ConnectionString property’ in die ‘Object Inspector’.  Klik op die ‘Build’ knoppie wat jou sal neem na die ‘Data Link Properties dialogue box’.  Kies ‘Microsoft Jet 4.0 OLE DB Provider’ en klik op ‘Next’.  Die eerste opsie op die ‘Connection tabsheet’ sal jou toelaat om na die electric.mdb lêer te navigeer.  Verwyder die gebruikersnaam Admin.  Klik op ‘Test Connection’ button. Klik OK op elkeen van die ‘open dialogue windows’. LET WEL: Indien jy nie tot die databasis kan konnekteer wanneer jou program hardloop nie moet jy nog steeds die vrae beantwoord en dit inhandig om gemerk te word. 4.1 Knoppie A: Skryf kode wat die data sal vertoon en sorteer in die volgende orde: Die Vervaardiger veld in dalende volgorde en die Grootte veld in stygende volgorde. Voorbeeld van afvoer (Eerste paar rekords): (3) Downloaded from hlayiso.com

8 INLIGTINGSTEGNOLOGIE V1 (NOVEMBER 2014) VRAAG 4: DELPHI-PROGRAMMERING EN DATABASIS Die databasis, electric.mdb, in die P1Q4 lêer word aan jou verskaf en bevat data oor elektriese ‘gadgets’ wat in die winkel in voorraad is. Die databasis bevat een tabel genoem ‘Televisions’. Data oor die verskillende televisies word in hierdie tabel gestoor. Elke rekord verwys na ʼn sekere tipe televisie en die hoeveelheid daarvan in voorraad. Die velde in die tabel word soos volg voorgestel: Veld Tipe Beskrywing Voorbeeld ID Autonumber AutoID 2 Prys Number Die prys van een televisie in 4560.99 Rand Vervaardiger Text Die vervaardiger van die televisie Sony Grootte Number Die skermgrootte 32 Tipe Text Die tipe televisie LCD Voorraad Number Die aantal TV’s in voorraad 3 Die volgende is ʼn voorbeeld van die data wat huidig in die databasis is: Die lêer P1Q4 bevat ʼn onvoltooide Delphi projek – V4_p.dpr – wat twee eenhede bevat, naamlik ʼn ‘data module’, DMQ4.pas en V4_u.pas (die ‘main unit’). Die ‘data module’, DataForm, bevat die volgende komponente: ‘ADOConnection’, ‘ADOTable’ en ʼn ‘DataSource’. Downloaded from hlayiso.com

(NOVEMBER 2014) INLIGTINGSTEGNOLOGIE V1 7 VRAAG 3: DELPHI-PROGRAMMERING Wanneer jy ʼn rekening vir ʼn kliënt op jul rekening sisteem skep, moet daar outomaties ʼn wagwoord geskep word deur gebruik te maak van die kliënt se Naam, Van en Dag waarop die kliënt gebore is (bv. as die kliënt gebore is op 13 November 1987, dan moet 13 ingesleutel word). Die wagwoord is in die formaat vvnnnn: die eerste v is die eerste klinker wat gevind word in die kliënt se naam en die tweede v is die eerste klinker wat gevind word in die kliënt se van. Die nnnn is ʼn nommer wat gegenereer word deur van die kliënt se geboortedatum (die dag waarop die kliënt gebore is) gebruik te maak. Voeg 2000 by die getal en voeg ʼn ewekansige nommer tussen 1 en 999 by en dan bestaan die nommer nnnn daaruit.  Plaas jou naam en van as kommentaar in die eerste reël van die lêer genoem V3_u.pas.  Stoor die program.  Druk die kode van die leêr V3_u.pas uit. [20] Downloaded from hlayiso.com

6 INLIGTINGSTEGNOLOGIE V1 (NOVEMBER 2014) 2.3.2 Lees en Toets knoppie: Die loadfile metode moet geroep en alle itemkodes moet getoets word. Die beskrywing van elke meubelstuk moet in die richedit komponent vertoon word. Indien die kode geldig is dan moet 'Geldige Kode’ bygevoeg word; indien dit nie is nie, moet 'Ongeldige Kode' bygevoeg word. Die totale hoeveelheid geldige en ongeldige kodes moet ook vertoon word. Voorbeeld van afvoer: (31) 2.4 Kategorieë Knoppie: Die eerste twee karakters in al die kode verwys na die kategorie waarin die meubels behoort, ‘BU’ staan vir ‘Bedroom Unit’ en ‘BS’ staan vir ‘Bedroom Suite’. Skryf kode om ʼn lys van meubelkategorieë en die totale hoeveelheid items in daardie kategorie te vertoon en die totale items in die lys. (11)  Voeg jou naam en van as kommentaar in die eerste reël van die lêer genoem V2_u.pas.  Stoor die program.  Druk die kode van die lêer V2_u.pas. [58] Downloaded from hlayiso.com

(NOVEMBER 2014) INLIGTINGSTEGNOLOGIE V1 5 VRAAG 2: DELPHI-PROGRAMMERING Jy word gevra om die inhoud van die tekslêer genoem meubels.txt te bestudeer. Dit is gestoor in die gids genoem P1Q2. Hierdie lêer stoor die beskrywing van items in voorraad asook ʼn itemkode vir elke item. Die inhoud van die tekslêer word soos volg getoon. Emma 3-piece Black,BSEBP70 Grace 4-piece Sleigh - Cherry,BSSSS9 Rimini 2-door Budget Robe,BURBR19 Die eerste reël van die voorbeelddata kan soos volg geïnterpreteer word: ʼn Meubelstuk met kode BSEBP70 Die BS beteken dit is ʼn ‘Bedroom Suite’ Die BU beteken dit is ʼn ‘Bedroom Unit’ 2.1 Verklaar twee skikkings met ‘class scope’, genoem arrDesc en arrCodes, wat ʼn maksimum van 35 elemente kan stoor. Die itemkode word in die arrCodes skikking gestoor en die beskrywing van die item in die arrDesc skikking. (2) 2.2 Skryf ʼn Boolse funksie genoem ‘Geldig’ wat ʼn string (sKode) sal ontvang wat die meubelstuk se kode bevat en ʼn karakter (cBeskr) wat die eerste letter van die beskrywing bevat. Vir die kode om korrek te wees moet die volgende reëls geld:  Die kode moet 7 karakters lank wees.  Die eerste vyf karakters moet hoofletters wees.  Die volgende twee karakters moet syfers wees.  Die derde karakter van die kode moet dieselfde wees as die eerste letter van die beskrywing. (14) 2.3 Lees, toets en vertoon: 2.3.1 Skryf ʼn prosedure loadfile wat die inligting vanaf die tekslêer meubels.txt lees. Hierdie prosedure moet die tekslêer oop maak en ʼn lus inisieer om die data in te lees. Elke reël van die tekslêer stel ʼn aparte item in die meubelwinkel voor. Voeg kode by om te toets of die tekslêer meubels.txt bestaan. Indien dit nie bestaan nie moet ʼn gepaste boodskap vertoon word en die program moet toe maak. Voeg nog kode by wat elke reël van die tekslêer inisieer en inlees. Die beskrywing moet in die skikking arrDesc en die kode in die skikking arrCodes gestoor word. Downloaded from hlayiso.com

4 INLIGTINGSTEGNOLOGIE V1 (NOVEMBER 2014) 1.2.2 Roep die funksie en vertoon die Netto Salaris. (2) 1.3 Bereken die Netto salaris van die gesin deur die netto salaris van die eggenoot by te tel. Maak gebruik van die geskikte metode (NettoSalaris funksie). (3) 1.4 Na al die uitgawes van die netto salaris afgetrek word, moet die beskikbare inkomste vertoon word. (3) 1.5 Nadat die lening afbetaal is moet ʼn kliënt nog ʼn minimum van R 3000 oor hê om goedgekeur te word. Indien dit nie die geval word die kliënt nie goedgekeur vir die lening nie. Bereken of die kliënt vir ʼn lening kwalifiseer en indien wel die maandelikse paaiement. Vertoon jou bevindings. (8)  Voeg jou naam en van as kommentaar in die eerste reël van die lêer genoem V1_u.pas.  Stoor die program.  Druk die kode van die lêer V1_u.pas. [34] Downloaded from hlayiso.com

(NOVEMBER 2014) INLIGTINGSTEGNOLOGIE V1 3 SCENARIO: Jy is aangestel as die bestuurder van Grandpa Furniture Shop in Oos-Londen. VRAAG 1: DELPHI-PROGRAMMERING Kliënte wil altyd rekeninge by die winkel oopmaak. Om hulle kredietwaardigheid te toets moet jy die heeltyd die hoofkantoor in Johannesburg skakel. Om die proses te bespoedig het jy besluit om ʼn klein programmetjie te skryf wat sal bepaal of ʼn kliënt kwalifiseer om op krediet te mag koop of nie. Maak die volgende program oop en beantwoord die vrae wat volg: 1.1 Vertoon die titel, naam en van, van die kliënt in een reël wanneer die Goedkeuring knoppie gedruk word. (3) 1.2 Bereken belasting: 1.2.1 Ontwerp ʼn funksie genoem NettoSalaris wat die bruto salaris as ʼn parameter sal ontvang en die netto salaris na belasting afgetrek is, terugstuur. Gebruik die tabel hieronder om te bereken hoeveel belasting betaal moet word. LET WEL: Die eerste R67 134 per jaar is belastingvry. Belasbare Inkomste/Jaar Belasting Persentasie R0 – R165 600 18% R165 601 – R258 750 25% R258 751 – R358 110 30% R358 110 – R500 940 35% R500 941 – R638 600 38% R638 601 en meer 40% Voorbeeld van bewerking: Salaris per maand is R15 500.00 Jaarlikse salaris = R15 500*12 = R186 000.00 Belasbare bedrag = (R186 000.00 – R67 134.00) = 118 866.00 Jaarlikse belasting =118 866*0.18 = R21 395.88 Maandelikse belasting = R21 395.88/12 = R1 782.99 Netto salaris = R15 500.00 – R1 782.99 = R13 717.01 (15) Downloaded from hlayiso.com

2 INLIGTINGSTEGNOLOGIE V1 (NOVEMBER 2014) INSTRUKSIES EN INLIGTING 1. Hierdie is ʼn drie-uur eksamen. Weens die aard van hierdie eksamen sal jy nie toegelaat word om die eksamenlokaal te verlaat voor die eksamen sessie voltooi is nie.. 2. Jy benodig die lêers hieronder gespesifiseer vir jou om die vrae te kan beantwoord. Dit sal of op ʼn CD aan jou verskaf word, of die toesighouer/onderwyser sal vir jou sê waar jy dit op die hardeskyf van die werkstasie waarop jy werk of in ʼn netwerkgids kan vind. P1 Datalêers P1Q1 Folder P1Q2 Folder P1Q3 Folder P1Q4 Folder V1_p.dpr V2_p.dpr V3_p.dpr V4_p.dpr V1_p.dfm V2_u.pas V3_u.pas DMV4.dfm V1_p.pas V2_p.dfm V3_p.dfm DMV4.pas meubels.txt V4_u.pas V4_p.dfm electric.mdb 3. Indien ʼn CD met die lêers aan jou verskaf is, skryf jou naam en van op die etiket van die CD. 4. Stoor jou werk gereeld as ʼn voorsorg indien daar ʼn kragonderbreking plaasvind. 5. Herbenoem die Q1 gidslêer na jou Naam en Van. 6. Tik jou naam en van as kommentaar in die eerste reël van elke program. 7. Lees AL die vrae noukeurig en doen net wat gevra word. 8. Teen die einde van die eksamensessie sal daar van jou verwag word om die CD met al jou gestoorde werk in te handig, of jy moet seker maak dat AL die lêers met jou antwoorde korrek gestoor is in die netwerkgids wat deur jou toesighouer/onderwyser aangewys is. 9. Maak seker ALLE lêers oopgemaak kan word. 10. Gedurende die eksamen mag jy gebruik maak van die hulp funksie van die programmatuur wat jy mee besig is. Jy mag NIE van addisionele notas of hulpbronne gebruik maak NIE. Downloaded from hlayiso.com

NASIONALE SENIOR SERTIFIKAAT GRAAD 11 NOVEMBER 2014 INLIGTINGSTEGNOLOGIE V1 PUNTE: 150 TYD: 3 uur *IINFTDM1* Hierdie vraestel bestaan uit 11 bladsye. Downloaded from hlayiso.com