Information Technology Grade 11 September Test 2018 QP

Downloaded from hlayiso.com 1 KZN DEPARTMENT OF EDUCATION PINETOWN DISTRICTS GREENBURY SECONDARY SCHOOL he in a SEPTEMBER CONTROL TEST 2018 INFORMATION TECHNOLOGY GRADE 1] EXAMINER : M PADAYACHEE MODERATOR: S NAIDOO DURATION : | 4 HOURS MARK: 60

Downloaded from hlayiso.com 2 (Please ensure that this paper consists of 7 pages and 2 question) INSTRUCTIONS AND INFORMATION 1. 9. This question paper contains one question based on general programming techniques. The duration of this examination is 1% hours. Make sure that you answer the question according to the specifications that are given in the question. Marks will only be awarded according to the set requirements. Answer only what is asked in the question. For example, if the question does not ask for data validation, then no marks will be awarded for data validation. Your programs must be coded in such a way that they will work with any data and not just the sample data supplied or any data extracts that appear in the question paper. Routines such as search, sort and selection must be developed from first principles. You may not use the built-in features of a programming language for any of these routines. All data structures must be defined by you, the programmer. You may not use components provided within the interface to store and later retrieve data. . You must save your work regularly on the folder you have created, or the disk space allocated to you for this examination. Make sure that your name appears as a comment in every program that you code. 10. You are responsible submission of all code you have written, therefore it is detrimental that you save your work correctly on the space allocated. Missing pieces of code will receive a zero mark.

Downloaded from hlayiso.com 3 QUESTION ONE: The advertising department of the local newspaper has a classified section where readers can place advertisements on a weekly basis. They decided to make use of a database to assist them in managing the placement of these advertisements. A program is being developed to make it easier for the staff at the newspaper to answer certain queries being made frequently. You are required to assist in developing this program. The information on the clients who placed advertisements as well as the advertisements being placed have been captured in a database called NewspaperDB.mdb. 1.1, Complete the code in the DisplayClients button by formulating an SQL statement to display all the fields in the ClientsTb table in alphabetical order according to the names of the clients. Example of output: ClientlD | ClientN ame ([TelNum [Subub BEOI3 Best Cars : (011) 678 9883“ Bedfordview C4012 .CarSelect (04 Yj 098 3445 Roodepoort DOOC? DOE (011) 285 9887 Bedfordview DBOO2 DagBox 082 123 3210 Midrand ECOO$ EconcTravel (011) 542 3438 © Johannesburg 1.2. Complete the code in the AllAdverts button by formulating an SQL statement to display all the fields in the AdvertsTb table except the ClientID field. Also display the ClientName field from the ClientsTb table. NOTE: You will need to link the tables with an appropriate where/join clause to be able to do this. Example of the output: AdvenID| DatePlaced [oveeksRuminalNumwords [Paid [Category [CientNName Ano 2008710719 2 72 Twe Animals The Pet Place aNoo2 2008/10/28 3 27 False Animals DagBox coon 2008/11/20 2 18 Tue Computers HiTech Goodies coos 2008/10/12 2 1D False Computers HiTech Goodies coco! 2008/11/23 2 12 True Computers HiTech Goodies coon3 2008/11/16 3 14 True Computers Hitech Goodies stoo2 2008/11/26 2 12 Fale Stationary Scappers Heaven STOO1 2008/12/17 1 35 False Stationary Scappers Heaven 1 30 True Photographic PhotoPte - PHOO! = 2008/12/10 1.3. Complete the code in the CatMonth button, by asking the user to enter the name of the category and the number of the month as inputs. Formulate an SQL statement to display the AdvertID, DatePlaced and (3)

Downloaded from hlayiso.com 4 WeeksRunning fields for the adverts in the category and month entered by the user. Example of the output where the user enters ‘Computers’ as the category and 11 as the number of the month (on the next page): AdverttD | DatePlaced [WeeksPunning coode 2008/11/20 2 COON 2008/11/23 2 COO03 2008/11/16 3 1.4. Complete the code in the ShortLongAdverts button by formulating an SQL statement to display the AdvertID, the number of words and the names of the clients who placed adverts with less than 15 and more than 30 words. Display suitable headings. NOTE: You will need to link the tables with an appropriate where/join clause to be able to do this. Example of the output: AdvertlO [Number of Werds| Client Name | ANOO1 12 The Pet Place coo04 10 Hitech Goodies Coon 12 HiTech Goodies coos 14 HiTech Goodies STon2 12 Scappers Heaven STO01 35 Scappers Heaven Joao 35. DOE : CAann3 j4 CarSelect A005 35 Pedigiee Cars (8) 1.5. Complete the code in the UpdateAdverts button by asking the user to enter the ID of the advert and the number of words to be added. (a) Formulate an SQL statement to update the number of words for the advert in the first SQL string. (b) Display the IDs and the number of words of all the advertisements after it has been updated in the second SQL string. (6) 'AdvertiD words ;e caco2 23 i canons 20 . cacot is » 30001 35 | 30002 3g } eacos 35 » cace2 16 anoo1 22 anon2 az 1. SAGOS “5. 1D ANOO1 was updated from 19 to 22 words. 1.6. Complete the code in the NotPaid button by asking the user to enter a letter of the alphabet. Formulate an SQL statement to display the IDs of

Downloaded from hlayiso.com 5 the adverts that have not been paid for in the categories starting with the letter entered by the user. Also display the names of the categories and the names of the clients as well as the Paid field. NOTE: You will need to link the tables with an appropriate where/join clause to be able to do this. Example of the output if the user enters the letter S as input: AdvertlD [Category [Name of Client [Has Paid (6) 51002 Stationery Scappers Heaven False SPOO1 Sports SportsPio False STO01 Stationery Scappers Heaven False 1.7. Complete the code in the CostAdverts button. Formulate an SQL statement to list the AdvertiD, DatePlaced, NumWords, WeeksRunning and Cost of all the advertisements placed after 16 November 2008. Cost is a calculated field. The cost of an advertisement must be calculated at 50c per word per week, Example of output: AdvertiD DatePlaced | [Numwords [WeeksRunning| Cost CA0NS = 2008/12/15 Ea 3°R 52.50 coo02 2008/11/20 18 2-R 16.00 Caos | 2008/12/01 25 2 A 26.00 $T002 | 2008/11/26 12 2A 1200 PROO1 2008/12/10 15) 2-15.00 SPO03 2008/12/10 18 2 A 18.00 cAo0! 200820 15 2-R 22.50 coom 2008/11/23 12 2A 12.00 PHOO 2008/12/10 0 1A 15.00 sto! 200Zt aw P1750 (6) 1.8. Complete the SQL code in the CountCellphones button that will determine and display the number of clients with cellphone numbers. A cellphone number starts with 0 as the first digit. Example of output: Number of clients with cellphone numbers | a (4) [40}

Downloaded from hlayiso.com 6 QUESTION TWO Write RAD code for the following buttons in the Q2 tabsheet: N.B. All RAD code must be written from first principles. No predefined methods will be accepted. 2.1. Code the button AmntOwing to receive the name of a category as an input and The price per word. Display the date of the advert, the client |D and the amount owed for the adverts that have not been paid. Display the total amount owed. Use the rich edit area for all your displays as shown below: (12) Sample Input: Enter Category Enter Price per word } [cars l 5.00 | | | | | | | | OK | Cancel | Or Cancel Deen ene [ee Ql Q2 ‘DATE OF ADVERT CLIENT ID AMOUNT OWED 2008/10/10 BEO13 R145,00 , 2008/10/24 CaAgi2 R100, 00 2008/11/12 CAG. R75.00 | 200s 12/15 PEQi4 Ri75,00 ‘The total owing for for Cars is R495.00 Amount Owing

Downloaded from hlayiso.com ri 2.2. Program the ClientsInSuburb button to display all Client names of the suburb selected from the combo box. (8) Sample run: Clients in Centurion are : : - - : 4 popes ney , The Pet Place |PhotoPro ‘SportsPra Pedigree Cars Amount Owing Clients In a Suburb [20] TOTAL = 60 GREENBURY SECONDARY SCHOOL OEFARTMENT OF MATHS 4 SCHENCES 4.0.0. MPL PHLLAY

Downloaded from hlayiso.com