IT NOV P1 QP ONLY hlayiso.com

Downloaded from hlayiso.com GREENBURY SECONDARY SCHOOL " INFORMATION TECHNOLOGY : PAPER 1 : NOVEMBER EXAMS -2018 MARKS: 150 TIME: 3 HOURS This question paper consists of 13 pages including this cover page. Page 1 of 14

Downloaded from hlayiso.com INSTRUCTIONS AND INFORMATION i) na Answer ALL the questions. The duration of this examination is three hours. 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. Make sure that you answer the questions according to the specifications that are given in each question. Marks will only be awarded based on the set requirements. Only answer what is asked in each 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 it will work with any data and not just the sample data supplied or any data extracts that appear in the question paper. Make sure that you develop routines, such as search, sort and selection, from first principles and not use the built-in features of a programming language for any of these routines, Save your work regularly on the disk (CD/flash disk/DVD, et cetera) that you have been given, or on the disk space allocated to you for this examination. Make sure that your name and surname appears as a comment in the first line of code. Also include the question number as part of the comment. At the end of this examination session, you must hand in the disk/CD with all your work saved on it OR you must make sure that all your work has been saved on the disk space allocated to you. Ensure that all files can be read. Page 2 of 14

Downloaded from hlayiso.com SCENARIO — |The primary focus in this paper is on healthcare. There are many aspects to Healthcare, which | _ include hospitals, clinics, doctor surgeries and medical aid schemes. Your help is required to design/complete applications for some of these sectors QUESTION 1: GENERAL PROGRAMMING SKILLS An excerpt of the GUI in project Question 1_U is given below: Question!_t Questionl_2 Number of years employed Permanently Employed Number of dependants Medical aid options | © Chal Servant 8 ss! FRuvygrazoy ~ | Sapphire@Rs600 “7 - | Topaz@R6300 4 Meslical Plan ‘quartz@4so0 - Ru | __} Question 1_3 Quartz Surname First Name Sapphire memOut Topaz Question 13 Membershipno = [bie b.No | Question! Question!_+ Question 1_5 Medical Aid Limit No of claims Question 1_5 | Questioni_+ | Complete the code for each section of QUESTION | as described in QUESTION 1,1 to QUESTION 1. LA An individual is eligible to become a member of this medical aid scheme if v they are permanently employed for more than 5 years OR v¥ any permanently employed civil servant (government employee ) can become a member irrespective of the number of years employed Write code to: retrieve the number of years employed from the text box . test whether the correct checkboxes are ticked and display a suitable message to indicate whether the person is eligible for membership to the medical aid scheme or not. SAMPLE OUTPUT 1 Page 3 of 14

Downloaded from hlayiso.com Questionl_1 | Number of years employed M Permanently Employed !3 | M)Ciil Servant TT 1 [ Question 1_1 | Eligible to be a member ! SAMPLE OUTPUT 2 Questioni_1 | Number of years employed = (J Permanently Employed | 3 | MCril Servant | : Question L_1 | ‘NOT Eligible to be a member ! - _____t SAMPLE OUTPUT 3 - Question]_1 | Number of vears employed © Permanently Employed | 16 : (Civil Servant | ible wo be a member ! | | —! (8) 1.2 A list box (IstMedPlan) is provided with the names of the different plans the medical scheme offers and their rates (tariff) per month for the main member. The format of the text in the list box is as follows: <Medical plan name >@R<Tariff> EXAMPLE - Sapphire@R5500 ‘Topaz@Ris00 i An amount of R900 is charged per dependant, which is added to the tariff amount, to obtain the members’ subscription fee for the month. Write code to do the following: Page 4 of 14

Downloaded from hlayiso.com Read the number of dependants from the spin-edit (spnDep), the tariff and the plan selected from the list box(/stMedicalScheme) then: e Based on the selected option from the list box , write code to select the corresponding option for the medical aid plan in the group box (rgpPlan) Eg. If Quartz@R4500 is selected in the list box(/stMedicalScheme), then the Quartz option must be selected in the radio group(rgpPlan) e Use the information obtained to calculate the subscription fees due. e In addition, if the member has more than 3 dependants, than they qualify for a 15% discount off their subscription fees. e Display a message whether the member qualifies for the discount or not, and the subscription fee due. SAMPLE OUTPUT 1 vumber of dependants Medical aid options is NO Discount Received! 1 | | Tariff -R4 £00.00 Subscription Fee SAMPLE OUTPUT 2 Taritf (RS 1.09 i Discount Received! Subscription Fee 7? $20.00 PSumber of dependanis Medical aid options i | 13 A person, approved for membership of the medical aid, needs to be assigned a membership number. The following strategy is used to generate a membership number for a member, after extracting the relevant information from the GUI components. Membership number consists of: co First three digits of Surname, in uppercase © Random three digit ODD number, where the first digit should be a non- zero digit o The symbol ‘~’ (tilde) . used as a separator o: Page 5 of 14

14 Downloaded from hlayiso.com o The letter C or X where C indicates that the member is a Civil Servant and X indicates they are not Display the generated membership number in the label (//MembNo). EXAMPLE OF MEMBERSHIP NO: (12) MAHS539~C Each medical aid plan has a medical aid limit. The following are the limits for each plan: | Plan Medical Limit. __ Ruby | R8000 Sapphire _ \ R9800 Topaz | 2.5 times subscription fee Quartz ib R800 e Use the medical aid option in 1.2 above to: determine the medical aid limit, based on the table above, and display the corresponding medical limit in the edit (ed/Limit). e Read in the claims made by the member in an input-box and display in tabular form the value of the claim made. and the total claims made. Use a conditional Joop to continue reading the claim amounts, till the medical aid limit is reached, OR a value of -999 is entered for the claim amount e Keep a track of the total number of claims made and display this value in the 10 edit (edtClaims). (10) @ Sample run: S | Question! _1 Question!_2 Number of years employed Permanently Employed Nuuniber of dtpendans Sietiealiaid'oplions 1 Civ Servant 2 2 | Question Li | ‘Topaz@Rssv0 ‘ Quartz@4500 First Name teniGut Tariff R$ 600.00 NO Discount Recerved! a Subscription Fee -R ? 4000.00 | Question 13 | Membershipno — /bLAfent No Question! _2 Question! _4 Question 1S | Medical Aid Limit 9g 90 No ofclaims 5 Question 1s | Rg 743 10 R10 748 80 Question!_4 | Page 6 of 14

Downloaded from hlayiso.com 1.5 A new text file, members. txi, containing member’s details needs to be developed. Details of the member must be extracted from the GUI components and then written to the text file in the following format with captions: Member No: <Membership no> Plan : <Medical Plan> No of Dependants : < No of Dependants> Display a suitable message in a dialog box that members details have been written to File. Members details written to File (10) TOTAL QUESTION 1: 50 QUESTION 2: ARRAYS & TEXT FILES The 4.P. Memorial Hospital keeps details of past patients who have outstanding debts with the hospital. The hospital would like to store the details of the debtors and the balances owing in two parallel arrays vizev arrDebtor: should contain the name of the debtor (patient owing money) arr Balance: should contain the amount being owed by the debtor A textfile called DataQ2.txt, provided, contains details of the debtors, stored in the following format : Account No #Name of Debtor#Amount Example: A6795#Moodliar AT#4S87.35 NOTE:: e All output involving currency, should be displayed in currency format, where applicable. e A global variable called, count, is declared to keep count of the number of entries in the array, The form Ques/2_u has the following interface: Page 7 of 14

N th Ne i) eS Downloaded from hlayiso.com Batton 23.1 Button 2.3.2 Button 2.3.3 Button 2.35.4 Button 2.3.5 Declare the above two arrays, to store the data from the text-file (2) Code the following: Procedure Display: Write a procedure that would display the details of the debtors, together with their current balances in tabular form, with suitable headings. (5) Function Total: Which will calculate and return the total amount being owed by the debtors (5) Create on-click events for the following buttons, as instructed: Button 2.3.1: Read the data from the text file and store the data into the respective arrays. Follow the following process : ® Check if the text-file can be located then proceed e [Ifthe text file cannot be found. display a suitable error message in a dialogue box and close the program e Use the global variable to keep track of each entry stored in the arrays e Proceed to read the text-file, a line at a time, then separate the details and store the data into the respective arrays (13) 3 Display a suitable message in a dialogue box, after the extraction of the data. kjuest2_p x | Data Extracted ! | NOTE: Only the name of the debtor and the amount needs to be stored. Page 8 of 14

Downloaded from hlayiso.com 2.3.2 Button 2.3.2: Display details of the debtors, by calling the procedure written in (2./) above Q) SAMPLE OUTPUT a —_ “| [Debtor Balance | |Moodliar aT R4 587,35 Zungu BM R6 3542 | RF 961,30 | R1652.31 \ Ra 347,24 i Singh & Ri2 545,55 i Dlamini PO R345.54 Naidoo $ R5 250,24 {Pillay RE R2 450.25 {Smith TW! R19 654.54 lgantho TR R3 544,34 [tari L RB 755,33 | etty CL Ri 782 I Shange HP Ré 543 | érumugarn ST R&S 723.2 Shaik MH RS 422,52 Buthelezi M Re 391.32 Mahommed & Red 124,26 — — = 2.3.3 Button 2.3.3: Display the total fees owed by the debtors, then calculate and display the average fee being owed by debtors. Display output in the rich-edit with a suitable caption. Use the function declared in (2.2) in your code. SAMPLE OUTPUT: (4) j 2.3.4 Button 2.3.4: Display the details of the debtors, who owe less than R2500. Display output in the rich- edit in tabular form with a suitable caption. Also determine and output the number of debtors who fall in this category. (5) SAMPLE OUTPUT: Page 9 of 14

Downloaded from hlayiso.com te) uo in Debtor Var vk AK Govender S Dlamini FD Fillay RE Chetty CL Mahommed S& The following debtors Balance R1652.31 Ra 347.24 RAS. 54 R2 450,25 ‘¢ balance less than R2500; 5 Button 2.3.5: ee All fees incur an annual debt fee increase of 5%, Adjust each of the debt amounts by this percentage amount. Display a message in a dialog box, indicating that the fee increase has been effected! (4) quest2_p Fee increase has been effected! | QUESTION 3: DATABASE APPLICATION The hospital has a database of current patients admitted to the hospital in a database called HospitalDB.mdb. TOTAL QUESTION 2: 40 The database has a table called PatientsTB, with the following field structure: Field Name PatientiO SatientName CdtnName Gender Age QateAdmitted DaysStay Data Type Short Text Short Text Short Text Short Text Number Date/Time Number SAMPLE DATA from PatientsTB Page 10 of 14

Downloaded from hlayiso.com dinwame ~~ Gender + toad Ts (Tuberculasis} fel 55 2015/06/07 “DaysStay ~ co Xathumiba H Pneumonia ht 2015/06/42 3 Whites NM Tumar Nd La Nephritis f i urysen Ml Zz Black Lung F 5/02/23 Lo High Choles F /o4/20 8 34 3 65 7 OG44 Hawthorn Bronchitis E 2015/06/21 7 The program should be able to connect to the database named HospitalDB.mdb. If you find that the connectivity is not in place, use the following steps to establish connection with the database: v¥ Click on the TADOTable component . Y 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. The connection string is already defined. You may haye to change the provider. Select Microsoft Jet 4.0 OLE DB if the database extension is mdb. Click on Next. The first option on the Connection tabsheet allows you to browse and find the HospitalDB.mdb file. Remove the user name Admin. Click on the Test Connection button. Click OK on each one of the open dialogue windows. NB. If you cannot establish connectivity with the database at all when you execute the program you must still code and submit the programming code for marking. LLNS KX The following database application was developed to retrieve data from the database: aneurysm im Black Lung r 4 10 olestaral F Migesine i abscess m Vauvanwu Male Patents Senior Citzens Page 11 of 14

3.1 3rlel Bald w w rus) ie Downloaded from hlayiso.com Code on-click events for each of the following buttons as outlined below: Complete the code behind the following buttons in the Quesr 3./ tab to display the required outcome in each case, using CODE CONSRUCT/FILTERS AND NOT SQLs Male Patients Display the details of the male patients only, SAMPLE OUTPUT: PatientID Patienthlame Cdintdame CaysStay b A611 TB {Tuberculosis} M | age? Prgumonia M BIS Tumor M Bra Aneurysm M OF34 — Sevantel Migraine M DEAS Smiths MN i 0G35— Naidoo G Uber iy D. Govender § Kidney fatlure M Zenade hi Stoke M bISs9 Baidu F Parkinson's F738 Maharaj GB7B Maicker T GB33_0 Mahomed § owe wt ww en © Senior Citizens Display the details of all patients 60 years or older. SAMPLE OUTPUT: DeysStay PatentID PanentName Cetnhiame Gender Age a Mt m > OFAS Complete the code behind the following buttons in the Quest 3.2 tab, using appropriate SQL commands. Sort Write an SQL statement to display the name, gender and age of all patients, sorted in descending order of age SAMPLE OUTPUT. Page 12 of 14 (3) (5)

Downloaded from hlayiso.com Maidu F M 53 Patientame gender age D Mahar MM 63 ' Govender 5 M a7 Smiths MM M 4g Naidoo G M 57 Dlamini kv F ST Hoosen ZK F 37 Marimuthu M4 F 56 Branson C F 56 Brown M F 56 Coraivelu R F 58 | | Govender BT mM 55 _| Females Over 50 Write an SQL statement to display the patient ID, patient name and age of all female patients over S0 years of age. (6) SAMPLE OUTPUT: PatentID Patentame age j } BGS? Bronson € 56 DK iG Doraivelu FR 56 FE29 Marimuthu h 56, FGA? Ahmed AS 54 FHE7 Zungu Me 53 FH?3 Olamini ky 37 FYS6 Brown M 56 GES oy Complete the code behind the following buttons in the Quest 3.3 tab, which would read through the data in the table and determine the required outcome and display in the output area(rich edit). Use CODE CONSTRUCT AND NOT SQLs. Longest Stay Write code to determine the name of the patient as well as the number of days in hospital, for the patient who has had the longest stay in the hospital. Display output together with suitable statements, in the rich-edit. 1) SAMPLE OUTPUT: Page 13 of 14

Downloaded from hlayiso.com iThe maximum stay is 11 days This was by patent Branson C | 3.3.2 Pereentage Write code to calculate and display the percentage of patients whose stay in hospital was 10 days or more. Display output as a percentage correct to 1 decimal in the rich- edit, together with a suitable statement. (6) SAMPLE OUTPUT: | 17.1% patients stayed for 10 days or more ! | TOTAL QUESTION 3: 30 GRAND TOTAL = 120 Page 14 of 14