Skip to content

Information Technology Grade 12 P1 NSC November 2023 QP

Question paperInformation TechnologyGrade 12202329 pages

Grade 12 Information Technology Paper 1 question paper from the NSC November Exam 2023 (English), 29 pages. Read online or download the free PDF.

Free to read online, no sign-up needed

Answer online

Loading document…

Loading document…

Questions in this paper

Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com NATIONAL SENIOR CERTIFICATE GRADE 12 INFORMATION TECHNOLOGY P1 NOVEMBER 2023 MARKS: 150 TIME: 3 hours This question paper consists of 25 pages, 2 data pages and 2 pages for planning. Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 2 DBE/November 2023 NSC INSTRUCTIONS AND INFORMATION 1. This question paper is divided into FOUR sections. Candidates must answer ALL the questions from all FOUR sections. 2. Two blank pages have been provided at the end of the question paper which may be used for planning purposes. 3. 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. 4. This question paper is set with programming terms that are specific to Delphi programming language. The Delphi programming language must be used to answer the questions. 5. Make sure that you answer the questions according to the specifications that are given in each question. Marks will be awarded according to the set requirements. 6. Answer only what is asked in each question. For example, if the question does not ask for data validation, no marks will be awarded for data validation. 7. 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. 8. Routines, such as search, sort and selection, must be developed from first principles. You may NOT use the built-in features of the Delphi programming language for any of these routines. 9. All data structures must be defined by you, the programmer, unless the data structures are supplied. 10. You must save your work regularly on the disk/CD/DVD/flash disk you have been given, or on the disk space allocated to you for this examination session. 11. Make sure that your examination number appears as a comment in every program that you code, as well as on every event indicated. 12. If required, print the programming code of all the programs/classes that you completed. Your examination number must appear on all the printouts. You will be given half an hour printing time after the examination session. 13. At the end of this examination session, you must hand in a disk/CD/DVD/ flash disk 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 for this examination session. Ensure that all files can be read. Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 3 DBE/November 2023 NSC 14. The files that you need to complete this question paper have been provided to you on the disk/CD/DVD/flash disk or on the disk space allocated to you. The files are provided in the form of password-protected executable files. Do the following:  Double click on the following password-protected executable file: DataNov2023.exe  Click on the 'Extract' button.  Enter the following password: %Learn4Life@ Once extracted, the following list of files will be available in the folder DataNov2023: Question 1: Question 3: Details.txt Question3_P.dpr Question1_P.dpr Question3_P.dproj Question1_P.dproj Question3_P.res Question1_P.res Question3_U.dfm Question1_U.dfm Question3_U.pas Question1_U.pas School_U.pas Question 2: Question 4: ConnectDB_U.pas Question4_P.dpr Question2_P.dpr Question4_P.dproj Question2_P.dproj Question4_P.res Question2_P.res Question4_U.dfm Question2_U.dfm Question4_U.pas Question2_U.pas UniversityDB - Copy.mdb UniversityDB.mdb Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 4 DBE/November 2023 NSC SECTION A QUESTION 1: GENERAL PROGRAMMING SKILLS Do the following:  Open the incomplete program in the Question 1 folder.  Enter your examination number as a comment in the first line of the Question1_U.pas file.  Compile and execute the program. The program has no functionality currently. Example of the graphical user interface (GUI):  Complete the code for each section of QUESTION 1, as described in QUESTION 1.1 to QUESTION 1.5 that follow. 1.1 Button [1.1 - Display name and age] The user must do the following:  Enter a name in the edit box edtQ1_1.  Enter/Select the person's age in the spin edit box spnQ1_1. Write code to do the following:  Extract the name entered from the edit box edtQ1_1 and store the name in the provided sName variable.  Extract the age entered/selected from the spin edit spnQ1_1 and store the age in the provided iAge variable.  Display the name and age, one below the other, using an output dialogue box. Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 5 DBE/November 2023 NSC Example of input: Example of output: (5) 1.2 Button [1.2 - Hockey teams] Learners who are interested in playing hockey are divided into teams of 11 players. A total of 11 players represents a full team in hockey. The remainder of the learners who could not make up a full team will be placed onto a reserve list. A constant variable which is declared as PLAYERS = 11 has been provided. Write code to do the following:  Extract the total number of learners from the edit box edtQ1_2.  Use the total number of learners and the constant PLAYERS to calculate the following: o Number of hockey teams made up of 11 players o Number of learners on the reserve list (9) Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 6 DBE/November 2023 NSC 1.3 Button [1.3 - Calculate] The value of must be calculated using the formula below: √( ) Code has been provided to assign values to the variables rX and rY which represent the x and y values in the formula. Write code to do the following:  Use the provided rX and rY variables and appropriate mathematical functions to calculate the value of .  Display the value of in the edit box edtQ1_3, rounded to THREE decimal places. Example of output for provided values rX = 12.46 and rY = 8.54: (5) 1.4 Button [1.4 - Marathon results] Participants who complete a marathon and finish in one of the top 20 positions will receive a gold, silver or bronze medal, based on their finishing position. All other participants who finish after the 20th position will receive a participation certificate. Code has been provided using an input dialogue box for the user to enter the finishing position of a participant. The user input is assigned to the variable iPosition. Write code that uses a case statement to display an appropriate message in the label lblQ1_4 based on the information in the table below. Finishing position Award 1 Gold medal 2 and 3 Silver medal 4 to 20 Bronze medal After 20 Participation certificate Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 7 DBE/November 2023 NSC Example of input and output if a learner achieved the first place: Example of input and output if a learner achieved the 20 th place: Example of input and output if a learner achieved the 21st place: (6) 1.5 Button [1.5 - Average mark] A text file called 'Details.txt' contains the names and marks of learners in the following format: <Name>#<Mark> Example of the first five lines of text in the text file: Erinn Stansell#87 Michael Dinjes#90 Gabrielle Wadhams#23 Mirelda Berendsen#47 Elmore Skalls#32 Write code to do the following:  Open the text file Details.txt, read through the lines of text in the text file and determine the average mark for all the learners.  Display the average mark on the panel pnlQ1_5, rounded to the nearest integer. NOTE: Your code must work correctly for any number of lines of text in the file. Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 8 DBE/November 2023 NSC HINT: Use the position of the hash character (#) to extract the mark for each learner. Example of output: (15)  Enter your examination number as a comment in the first line of the program file.  Save your program.  Print the code if required. TOTAL SECTION A: 40 Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 9 DBE/November 2023 NSC SECTION B QUESTION 2: DATABASE PROGRAMMING Universities rely on effective administration and communication to facilitate the smooth running of their processes. A database called UniversityDB.mdb, which contains information on the different lecturers and the courses they teach, has been developed. The database contains two tables, tblLecturers and tblCourses. NOTE: The data pages attached at the end of the question paper provide information on the design of the database and its contents. Do the following:  Open the incomplete project file called Question2_P.dpr in the Question 2 folder.  Enter your examination number as a comment in the first line of the Question2_U.pas unit file.  Compile and execute the program. The program has no functionality currently. The contents of the tables are displayed, as shown below on the selection of tab sheet 2.2 - Delphi code. Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 10 DBE/November 2023 NSC  Follow the instructions below to complete the code for each section as described in QUESTION 2.1 and QUESTION 2.2.  Use SQL statements to answer QUESTION 2.1 and Delphi code to answer QUESTION 2.2. NOTE:  The 'Restore database' button is provided to restore the data contained in the database to the original content.  The content of the database is password-protected, i.e. you will NOT be able to gain direct access to the content of the database using Microsoft Access.  Code is provided to link the GUI components to the database. Do NOT change any of the provided code.  TWO variables are declared as public variables, as described in the table below. Variable Data type Description tblLecturers TADOTable Refers to the table tblLecturers tblCourses TADOTable Refers to the table tblCourses 2.1 Tab sheet [2.1 - SQL] Example of graphical user interface (GUI) for QUESTION 2.1: Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 11 DBE/November 2023 NSC NOTE:  Use ONLY SQL statements to answer QUESTION 2.1.1 to QUESTION 2.1.5.  Code to execute the SQL statements and display the results of the queries is provided. The SQL statements assigned to the variables sSQL1, sSQL2, sSQL3, sSQL4 and sSQL5 are incomplete. Complete the SQL statements to perform the tasks described in QUESTION 2.1.1 to QUESTION 2.1.5 below. 2.1.1 Button [2.1.1 - Large enrolments] Display the details of all the courses in the tblCourses table, that can accommodate 100 or more students. Example of output of the first five records: (3) 2.1.2 Button [2.1.2 - Lecturer gender] Display the LecturerName, LecturerSurname and the first letter of the gender of all the lecturers. Display the gender using a column heading called Gender (M/F). Example of output of the first five records: (4) 2.1.3 Button [2.1.3 - Multilingual lecturers] Display the CourseID and CourseName of all courses that have a multilingual lecturer. The results must be sorted in alphabetical order according to the course name. Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 12 DBE/November 2023 NSC Example of output of the first five records: (6) 2.1.4 Button [2.1.4 - Lecturer salaries] A lecturer's salary is determined by the number of courses facilitated by that lecturer. An amount of R10 000 is paid for each course facilitated by the lecturer. For example, if a lecturer facilitates three courses, the lecturer will get a total salary of R30 000. Display the LecturerID and the total salary in a new column with the heading Salary, formatted to currency. Example of output of the first five records: (5) 2.1.5 Button [2.1.5 - Change online option] Write code to change the OnlineOption field to false if the CourseName field contains the word 'Programming'. Code has been provided to display a message to indicate that the content of the database has been changed. Example of the first six records of the tblCourses table before the online option was changed: Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 13 DBE/November 2023 NSC Example of the first six records of the tblCourses table after the online option was changed to false for the programming courses: (4) 2.2 Tab sheet [2.2 - Delphi code] NOTE:  Use ONLY Delphi programming code to answer QUESTION 2.2.1 and QUESTION 2.2.2.  NO marks will be awarded for SQL statements in QUESTION 2.2. Example of graphical user interface (GUI) for QUESTION 2.2: Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 14 DBE/November 2023 NSC 2.2.1 Button [2.2.1 - Average duration of courses] The workload of all lecturers must be determined in order to issue them with a fair number of courses to facilitate. Use the redQ2_2_1 component to display the output. Code has been provided to clear the redQ2_2_1 component. Write code to do the following:  Display the LecturerID, LecturerName and LecturerSurname as a heading in the following format: <LecturerID>: <LecturerName> <LecturerSurname>  Display a numbered list of course names facilitated by each lecturer.  Calculate and display the average duration of the courses facilitated by each lecturer, formatted to TWO decimal places. Example of output for the first two lecturers: (14) 2.2.2 Button [2.2.2 - Register new lecturer] When a new lecturer is appointed, their details must be added to the database. Write code to add a new record to the tblLecturers table using the following details:  LecturerID – ZT032  LecturerName – Zander  LecturerSurname – Thomas  Gender – Male  Multilingual – True Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 15 DBE/November 2023 NSC Example of records in the tblLecturers table, which indicates that the record has been added to the table successfully: (4)  Enter your examination number as a comment in the first line of the program file.  Save your program.  Print the code if required. TOTAL SECTION B: 40 Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 16 DBE/November 2023 NSC SECTION C QUESTION 3: OBJECT-ORIENTATED PROGRAMMING The local schools' district office requires a record of schools in the district and a report on the results of the schools to determine the amount of funding that each school will receive. Do the following:  Open the incomplete program in the Question 3 folder.  Open the incomplete object class School_U.pas.  Enter your examination number as a comment in the first line of both the Question3_U.pas file and the School_U.pas file.  Compile and execute the program. The program has limited functionality currently. Example of the graphical user interface (GUI):  Complete the code as specified in QUESTION 3.1 and QUESTION 3.2 that follow. Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 17 DBE/November 2023 NSC 3.1 The provided incomplete object class (TSchool) contains the declaration of four attributes which describe a School object. The attributes for a School object have been declared as follows: Attribute Data type Description fSchoolName String The name of the school fTotalLearners Integer The total number of learners enrolled at the school fPublicSchool Boolean True if it is a public school, otherwise false fRating Char A rating (A, B, C or Z) assigned to each school based on the percentage pass rate of the school: A – 80% or higher B – From 60% up to 79% C – Lower than 60% Z – Rating not assigned An incomplete constructor method has been provided. NOTE: You are NOT allowed to add any additional attributes or user-defined methods, unless you are instructed to do so explicitly in one of the questions. Complete the code in the object class as described in QUESTION 3.1.1 to QUESTION 3.1.5 below. 3.1.1 Constructor Create has been provided with three parameters. Write code to complete the constructor method as follows:  Assign the values in the parameter list to the corresponding attributes, fSchoolName, fTotalLearners and fPublicSchool.  Assign a default rating of 'Z' to the fRating attribute. (3) 3.1.2 Write an accessor method called getPublicSchool for the fPublicSchool attribute. (2) 3.1.3 Every year the rating of the school will be updated based on the percentage pass rate of the school. The percentage pass rate is calculated using the total number of learners who passed and the total number of learners at the school. The information in the table below is used to determine the school's rating: Rating Percentage pass rate A 80% or higher B From 60% up to 79% C Lower than 60% Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 18 DBE/November 2023 NSC Write code for a method called updateRating to do the following:  Receive the total number of learners who passed as a parameter value.  Use the parameter value and the fTotalLearners attribute to calculate the percentage pass rate of the school.  Use the table provided to determine and set the value of the fRating attribute. (8) 3.1.4 An amount of R145,50 is allocated per learner enrolled at the school. Write code for a method called calcFunding to calculate and return the total amount of funding that will be received by the school. The funding is calculated using the following formula: funding = learners enrolled (4) 3.1.5 Write code for a toString method to return a string which describes the object. The Boolean attribute fPublicSchool must be used to determine whether the phrase 'Public school' or 'Private school' must be added to the string. The format of the string to be returned is shown below. <fSchoolName> ------------------------ Total number of learners: < fTotalLearners > Rating: <fRating> Public school/Private school Example: Alan Turing High School ------------------------ Total number of learners: 1250 Rating: Z Public school (7) 3.2 An incomplete program has been supplied in the Question 3 folder. The program contains code for the object class to be accessible and declares an object variable called objSchool. Write code to perform the tasks described in QUESTION 3.2.1 to QUESTION 3.2.3 that follow. Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 19 DBE/November 2023 NSC 3.2.1 Button [3.2.1 – Instantiate object] The user must enter the school name in the edit box edtQ3_2_1, select the total number of learners in the spin edit spnQ3_2_1 and tick the check box chbQ3_2_1 if the school is a public school. Write code to do the following:  Extract the school name from edit box edtQ3_2_1, the total number of learners in the spin edit spnQ3_2_1 and determine whether the check box chbQ3_2_1 has been checked (ticked) or not.  Use the information extracted to instantiate a new School object.  Use the toString method to display the information of the School object in the rich edit redQ3. Example of input and output for a public school: Example of input and output for a private school: (7) Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 20 DBE/November 2023 NSC 3.2.2 Button [3.2.2 – Rating] The rating of a school is determined by the percentage pass rate of the school. The spin edit spnQ3_2_2 must be used to enter the total number of learners who passed. Write code to do the following:  Call the updateRating method using the value extracted from the spin edit spnQ3_2_2 as an argument.  Call the toString method to display the updated information of the School object in the rich edit redQ3. Example of output if the total number of learners is 1 250 and the total number of learners who passed is 1 183: Example of output if the total number of learners is 1 250 and the total number of learners who passed is 999: Example of output if the total number of learners is 1 250 and the total number of learners who passed is 500: (4) 3.2.3 Button [3.2.3 – Funding] Funding will be available to public schools only. Use the rich edit redQ3 to display the output. Write code to do the following: Use the relevant method to test if the school is a public school.  If the school is a public school, call the calcFunding method to display the amount of funding the school will receive, formatted as currency with a message as indicated on the next page.  If the school is not a public school, display a suitable message indicating that no funding is available. Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 21 DBE/November 2023 NSC Example of output if the school is a public school and has a total number of 1 250 learners: Example of output if the school is NOT a public school: (5)  Enter your examination number as a comment in the first line of the object class and the form class.  Save your program.  Print the code in the object class and the form class if required. TOTAL SECTION C: 40 Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 22 DBE/November 2023 NSC SECTION D QUESTION 4: PROBLEM-SOLVING PROGRAMMING Do the following:  Open the incomplete program in the Question 4 folder.  Enter your examination number as a comment in the first line of the Question4_U.pas file.  Compile and execute the program. The program has no functionality currently.  Two tab sheets named tshQ4_1 and tshQ4_2 are provided on the graphical user interface (GUI). Complete the code for each section of QUESTION 4, as described in QUESTION 4.1 and QUESTION 4.2 below. 4.1 Tab sheet [4.1] Example of the graphical user interface (GUI) for tab sheet 4.1: You have been provided with an array called arrCodes that contains five codes. Each code contains letters, digits and special characters. arrCodes: array [1 .. 5] of String = ('An7J*Q#D&N','pL78K#$.%BV','89@FGh0&Y56#$Q','Bn4m321&*#T', 'P2QwER%$#a'); A special character refers to a character that is not a letter and not a digit. Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 23 DBE/November 2023 NSC Button [4.1 - Codes] Write code to do the following: Remove all the special characters from each code in the array to create a new code. Count how many special characters were removed from each code. Add the new code and the number of special characters deleted from it to the list box lstQ4_1 in the following format: <New code>(number of special characters deleted) NOTE: Your code must work for any set of data in the array. Example of output for the codes currently in the array: (12) 4.2 Tab sheet [4.2] A school timetable has five days and seven periods per day. You have been provided with the following declarations: arrDays: array [1 .. 5] of String = ('Mon.', 'Tue.', 'Wed.', 'Thu.', 'Fri.'); arrTimeTable: array [1 .. 5, 1 .. 7] of String; arrSubjectCodes: array [1 .. 5] of String = ('IT', 'HL', 'ACC', 'PHY', 'MAT'); NOTE: Code has been provided to do the following:  Populate the arrTimeTable array by placing the five subject codes IT, HL, ACC, PHY and MAT randomly in the array, once per day for the five days. There will be two free periods (empty spaces) each day.  Display the seven periods per day for each of the five days on the timetable (Monday to Friday). Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 24 DBE/November 2023 NSC Example of the graphical user interface (GUI) for tab sheet 4.2: 4.2.1 Button [4.2.1 - Extra IT periods] The school principal decided to add four extra periods, once per day (Monday to Thursday), for the subject code 'IT' to the timetable. The extra IT periods must be placed in the arrTimeTable array from Monday to Thursday at the first available period using the code 'IT'. Example of output after the extra IT periods have been placed in the first available periods from Monday to Thursday: NOTE: By default, there will be six free periods available on the timetable after all the subject codes have been placed, including the extra IT periods. Due to the random placement of subject codes, your output may differ from the example above. (6) Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 25 DBE/November 2023 NSC 4.2.2 Button [4.2.2 - Group IT] The IT teacher requested to have both IT periods placed consecutively (one after the other), from Monday to Thursday. Write code to do the following: Rearrange the periods on each day to place the two IT periods one after the other. The first IT period for the day must remain in its place, while the second IT period must be swapped with another period in order to be placed next to the first IT period. Example of output after the IT periods have been grouped together: (12)  Enter your examination number as a comment in the first line of the program file.  Save your program.  Print the code if required. TOTAL SECTION D: 30 GRAND TOTAL: 150 Copyright reserved
Downloaded from hlayiso.com Information Technology/P1 1 DBE/November 2023 NSC INFORMATION TECHNOLOGY P1 DATABASE INFORMATION FOR QUESTION 2: The design of the database tables for the database UniversityDB is as follows: Table: tblLecturers This table contains the details of the lecturers. Field name Data type Description LecturerID Text (5) A unique ID used to identify a lecturer LecturerName Text (25) The first name of the lecturer LecturerSurname Text (25) The last name of the lecturer Gender Text (6) The gender of the lecturer Multilingual Boolean A field that indicates whether a lecturer can present a course in more than one language Example of the records van the tblLecturers table: Table: tblCourses This table contains information on the courses offered at the university. Field name Data type Description CourseID Text (10) A unique ID used to identify a course CourseName Text (35) The name of the course Duration Number The duration of the course (in weeks) MaxStudents Number The maximum number of students allowed in the course OnlineOption Boolean A field that indicates whether an online option is available to students LecturerID Text (5) The ID of the lecturer that presents the course Copyright reserved Please turn over
Downloaded from hlayiso.com Information Technology/P1 2 DBE/November 2023 NSC Example of the first ten records of the tblCourses table: NOTE:  Connection code has been provided.  The database is password-protected; therefore, you will not be able to access the database directly. The following one-to-many relationship with referential integrity exists between the two tables in the database: Copyright reserved
Downloaded from hlayiso.com Information Technology/P1 DBE/November 2023 NSC PLANNING PAGE 1 Copyright reserved
Downloaded from hlayiso.com Information Technology/P1 DBE/November 2023 NSC PLANNING PAGE 2 Copyright reserved

Study this subject

More from Grade 12 Information Technology

View all