Downloaded from hlayiso.com
NATIONAL
SENIOR CERTIFICATE
GRADE 12
INFORMATION TECHNOLOGY P1
EXEMPLAR 2018
MARKS: 150
TIME: 3 hours
This question paper consists of 19 pages.
Copyright reserved Please turn over
Skip to contentAll 2018 papers 





View all





Information Technology Grade 12 P1 Exemplar 2018 QP (Eng)
Grade 12 Information Technology Paper 1 question paper from the Exemplar 2018 (English), 19 pages. Read online or download the free PDF.
Information Technology · Grade 12 · Exemplar · 2018. Question paper, 19 pages. Read online or download the PDF.
- Subject
- Information Technology
- Grade
- Grade 12
- Document type
- Question paper
- Year
- 2018
- Exam period
- Exemplar
- Paper
- 1
- Curriculum
- CAPS
- Pages
- 19
- File size
- 960.0 KB
Free to read online, no sign-up needed
Loading document…
Loading document…
1 of 19
This exam
Exemplar 2018
- Paper 1Question paperMemo
Questions in this paper
Document textSearch extracted text and jump to a page.
Downloaded from hlayiso.com
Information Technology/P1 2 DBE/2018
CAPS – Grade 12 Exemplar
INSTRUCTIONS AND INFORMATION
1. This paper is divided into FOUR sections. Candidates must answer ALL the
questions from all FOUR sections.
2. 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.
3. 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.
4. 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.
5. Answer only 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.
6. 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.
7. 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.
8. All data structures must be defined by you, the programmer, unless the data
structures are supplied.
9. 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.
10. Make sure that your examination number appears as a comment in every
program that you code, as well as on every event indicated.
11. 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.
12. 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/2018
CAPS – Grade 12 Exemplar
13. 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:
DataENGExem2018.exe.
Click on the extract button.
Enter the following password: Exemplar2018
Once extracted, the following list of files will be available in the folder
DataENGExem2018:
Question1: Question3:
Question1_P.dpr Player_U.pas
Question1_P.dproj Players.txt
Question1_P.res Question3_P.dpr
Question1_U.dfm Question3_P.dproj
Question1_U.pas Question3_P.res
Question3_U.dfm
Question3_U.pas
Question2: Question4:
dbConnection_U.dcu Question4_P.dpr
LanFans.mdb Question4_P.dproj
LanFansBackup.mdb Question4_P.res
Question2_P.dpr Question4_U.dfm
Question2_P.dproj Question4_U.pas
Question2_P.res Scores.txt
Question2_U.dfm
Question2_U.pas
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 4 DBE/2018
CAPS – Grade 12 Exemplar
SCENARIO
LAN FANatics is a group of young IT entrepreneurs who created a business that hosts
LAN gaming parties at different venues in their home town.
SECTION A
QUESTION 1: GENERAL PROGRAMMING SKILLS
The LAN FANatics group is in the process of creating software that can be used in the
registration and planning of the LAN party events that they host.
Do the following:
Compile and execute the program found in the Question1 folder. The user
interface displays FOUR different sections named Question 1.1 to Question 1.4.
The program has no functionality currently.
Example of graphical user interface (GUI):
Complete the code for each section of QUESTION 1, as described in
QUESTION 1.1 to QUESTION 1.4.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 5 DBE/2018
CAPS – Grade 12 Exemplar
1.1 Button [Register Player]
Write code to use the information entered in the Player Name and E-mail
edit boxes to compile a registration message. A message that indicates that
the registration was successful must only be displayed if information has
been entered in both the edit boxes, otherwise an error message must be
displayed. The message must be compiled in the following format:
<Player Name> with e-mail address <e-mail address> has been registered.
Example of output for Peter Joubert with the e-mail address pete@gmail.com:
Example of output if NO information was entered in any one of the edit boxes:
(6)
1.2 Button [Calculate Cost of Meals]
The LAN party organisers provide meals to the players. The meals have to be
ordered from the following menu:
Toasted sandwich – R25.00
Burger and chips – R32.80
Medium-size pizza – R45.75
The user must select one of the meals from the combo box and the number
to be ordered from the spin edit box. The user must tick the checkbox if the
vegetarian version of the selected meal is preferred.
Write code to calculate the amount to be paid based on the selected
information. Decrease the amount by 10% if the vegetarian option has been
selected.
Display the calculated amount in the edit box provided, formatted to currency
with TWO decimal places and in blue text.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 6 DBE/2018
CAPS – Grade 12 Exemplar
Example of output if four vegetarian toasted sandwiches were ordered:
(14)
1.3 Button [Calculate Tables and Power]
The number of tables required for the number of players who will take part
must be calculated. Each table at the venue can accommodate six players.
A constant variable Tablesize is provided. Write code to calculate the
minimum number of tables that will be required to accommodate the number
of players that was entered in the relevant edit box.
Also write code to calculate the total amount of power that will be required by
the computers used by the players, rounded to the nearest kilowatt (kW).
Assume that the average amount of power required by a computer is
0,66 kW. Also assume that each player will use one computer during the
event.
Display the calculated values in the edit boxes provided.
Example of output if the number of players that has been entered is 86:
(8)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 7 DBE/2018
CAPS – Grade 12 Exemplar
1.4 Button [Calculate Days]
The organisers must buy units of electricity before hosting a LAN party. The
user must enter the total number of units of electricity required to host the
event in the provided edit box.
Write code to randomly generate a value in the range from 50 to 149, which
represents the estimated daily usage of electricity during the event, and
display the value in the relevant edit box.
Write code to calculate the number of units left after each day's game play
using the estimated usage figure. Display the information as shown in the
example below. The memo box must be cleared before the output is
displayed.
Example of output if a value of 500 was entered for the number of units the
organisers plan to buy and the random value of 89 has been generated as
the estimated daily usage figure:
(12)
NOTE: The output will depend on the units entered and the randomly
generated daily usage figure.
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 8 DBE/2018
CAPS – Grade 12 Exemplar
SECTION B
QUESTION 2: SQL AND DATABASE
The LAN FANatics group has developed a database called LanFans.mdb, which
contains information about players and the games they have played.
The LanFans.mdb database contains two tables called tblPlayers and tblGames.
The records contained in the tblPlayers table consist of the following fields:
PlayerID – a unique five-character identification code (text data type) which is the
primary key (PK)
Name – name of player (text data type)
Email – e-mail address of player (text data type)
DateOfBirth – date of birth of player (date/time data type)
Example data from the tblPlayers table:
The records contained in the tblGames table consist of the following fields:
GameIndx – unique index code for each game (number data type) starting from
the value of 1(PK)
GameDate – date on which game was played (date/time data type)
PlayerID – code of player who played the game (text data type)
Duration – number of minutes the game lasted (integer data type)
Score – score obtained by the player who played the game (integer data type)
Example data from the tblGames table:
The PlayerID field has been used to link the two tables.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 9 DBE/2018
CAPS – Grade 12 Exemplar
NOTE:
The date format might be displayed differently on your computer due to the
regional settings on your computer.
Connection code has been provided.
The database is password-protected. Therefore you will not be able to access the
database directly.
Do the following:
Compile and execute the program in the Question2 folder. The program limited
functionality.
Complete the code for each question as described in QUESTION 2.1 and
QUESTION 2.2.
The program provides a GUI with two tab sheets: Qst2.1 SQL and Qst2.2 DB.
2.1 SQL
Select tab sheet Qst2.1 SQL, which displays the following GUI:
NOTE: When the Restore Database button is clicked, the data in the database
tables will be restored to the original data.
Complete the SQL code to meet the requirements specified in QUESTION 2.1.1 to
QUESTION 2.1.5.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 10 DBE/2018
CAPS – Grade 12 Exemplar
2.1.1 Button [Show All Players]
All the fields must be displayed for all the players in the tblPlayers table. The
records must be displayed in ascending order according to the Name field.
Example of output of the first four records:
(3)
2.1.2 Button [Players Born in September]
Display the Name and DateOfBirth fields for all players born in September.
Example of output:
(3)
2.1.3 Button [Average Game Times]
Display the average duration of the games played each day in a new field
called AverageDuration. The values must be rounded off to ONE decimal
place.
Example of output:
(5)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 11 DBE/2018
CAPS – Grade 12 Exemplar
2.1.4 Button [Highest Scores]
Display the Name of the player and the highest score that the player obtained
in any game so far in a field called HighestScore.
Example of output:
(5)
2.1.5 Button [Add Game]
Add a new game with the number 76 as GameIndx to the tblGames table.
The game was played by a player with PlayerID 'HM008' on
24 December 2017. The player scored 6 655 points and the game lasted
250 minutes.
Example of output:
(4)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 12 DBE/2018
CAPS – Grade 12 Exemplar
2.2 DATABASE MANIPULATION
Select tab sheet Qst2.2 DB, which displays the content of both tables as well as the
three buttons for the questions that need to be completed:
NOTE: NO marks will be allocated for the use of SQL statements for QUESTION 2.2.
The names of the tables to be used in your code must be tblPlayers and
tblGames.
Complete the code to meet the requirements specified in QUESTION 2.2.1 to
QUESTION 2.2.3.
2.2.1 Button [Domain Users Count]
An input box must be used to enter an e-mail domain name, e.g.
'gmail.com'.
Display the names and e-mail addresses of players who use an e-mail
address which contains the domain that was entered.
Display headings, as shown in the example below.
Show the total number of addresses at the bottom of the list.
Example of output if the domain name 'gmail.com' has been entered:
(9)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 13 DBE/2018
CAPS – Grade 12 Exemplar
2.2.2 Button [Change Score]
An additional 250 points can be added to a player's score in some cases,
after a dispute has been resolved in favour of the player. Write code to
increase the score of the player of the current active record in the
tblGames table display grid, with 250 points. (4)
2.2.3 Button [Add Game]
Write code to add a new game to the tblGames table according to the
following requirements:
The GameIndx assigned to the new game must be compiled
automatically and follow on the number that was assigned to the previous
game.
NOTE: Records in a database table are indexed starting at 1 up to
the number of records in the table.
The GameDate must be the date the game was added to the table using
the 'today's date' function.
The PlayerID must be obtained from the selected record in the
tblPlayers table.
Input boxes in the supplied code must be used to allow the user to enter
values for the Duration field and Score field.
Example of a new record that has been added for Sue Prins who played
a game for 111 minutes and obtained a score of 2 222:
(7)
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 14 DBE/2018
CAPS – Grade 12 Exemplar
SECTION C
QUESTION 3: OBJECT-ORIENTATED PROGRAMMING
The LAN FANatics group is designing software to assist with the registration of players
who want to take part in the LAN parties that they host.
Do the following:
Open the incomplete program in the Question3 folder.
Open the incomplete object class Player_U.pas.
Compile and execute the program.
The following user interface is displayed with limited functionality:
NOTE: Code has been supplied to obtain today's date when the program is executed
and display the date in the Date edit box. This is done to show the date format
that is used by your computer. You need to use the displayed format when
entering dates to ensure that any date-based calculations will function
correctly.
Complete the code as specified in QUESTION 3.1 and QUESTION 3.2.
3.1 The provided incomplete object class (TPlayer) contains the declaration of four
attributes which describe a Player object.
The attributes for a Player object have been declared as follows:
fEmail – the e-mail address that uniquely identifies the player
fName – the name of the player
fDateOfBirth – the player's date of birth
fApproved – a flag indicating whether the registration of the player has
been approved or not
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 15 DBE/2018
CAPS – Grade 12 Exemplar
The following methods have also been provided:
create – used to instantiate the object
toString – used to provide output of all attributes of the object
Complete the code in the object class as described in QUESTION 3.1.1 to
QUESTION 3.1.5.
3.1.1 Write an accessor method called getEmail for the fEmail attribute. (2)
3.1.2 Write a mutator method called setApproved to receive a Boolean
value (true/false) as a parameter and assign the received value to the
fApproved attribute. (3)
3.1.3 Write a private method called testEmail that can be used to test the
validity of the supplied e-mail address. The testEmail method must
receive the e-mail address as a parameter and return a Boolean
value (true/false) based on the following test:
The address may only start with a letter from the alphabet (upper
case or lower case) and with NO other character or digit. (5)
3.1.4 Change the provided constructor method called create to use the
testEmail method in order to test whether the e-mail address format
is valid before allocating it to the fEmail attribute.
If the e-mail address is invalid, the word 'ERROR' must be allocated
to the fEmail attribute. (5)
3.1.5 Write a public testAge method that will receive the minimum age
requirement for registration as a parameter and determine whether a
player is old enough to be registered. The player's age must be
calculated using today's date and the player's date of birth.
If the player's age meets the minimum age requirement, the word
'APPROVED' must be returned. If the player is too young, the word
'REJECTED' must be returned. (7)
3.2 An incomplete program has been supplied in the Question3 folder. The
program contains code for the object class to be accessible and declares an
object variable called objPlayer.
Write code to perform the tasks described in QUESTION 3.2.1 to
QUESTION 3.2.3 on the next page to approve and register players.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 16 DBE/2018
CAPS – Grade 12 Exemplar
3.2.1 Button [Submit Details]
The user needs to enter the player's e-mail address, name and date
of birth. The date format that you use for the date of birth must be the
same as the format of the current date displayed in the Date edit box.
Write code to do the following:
Use the details that were entered to instantiate a new objPlayer
object.
Clear the Display area and the Age Test Result edit box.
Call the toString method to display the details of the object that
has been instantiated in the Display area.
Example of output in the Display area if an object with an invalid
e-mail address has been entered:
(7)
3.2.2 Button [Test Age]
The user must enter the minimum age requirement in the edit box
provided. Use the age that was entered as an argument to call the
testAge method to test whether the player's age adheres to the
minimum requirement to be registered for the LAN party. Display the
result in the edit box provided.
Example of output for an age that has been approved:
(3)
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 17 DBE/2018
CAPS – Grade 12 Exemplar
3.2.3 Button [Approve]
Use the result of the age test and the content of the e-mail attribute of
the object to determine whether the player's application can be
approved or not.
If the age has not been approved or the e-mail address has an error,
the following message must be displayed in a message box: 'The
player's age or e-mail address has been rejected.' Also call the
correct method to ensure that the fApproved status of the object is
'false'.
If the application meets all the requirements use the correct method
to change the fApproved status of the object to 'true'.
Clear and update the content of the Display area to show the latest
fApproved status of the player object. (8)
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 18 DBE/2018
CAPS – Grade 12 Exemplar
SECTION D
QUESTION 4: PROBLEM-SOLVING PROGRAMMING
The LAN FANatics group will be hosting an elite Master Players competition. They
want to select all the players with scores above that of average players. A text file that
contains the names and scores of all the players has been supplied.
Do the following:
Compile and execute the program in the Question4 folder. The program has no
functionality currently.
Complete the code for each question as described in QUESTION 4.1 and
QUESTION 4.2.
The following GUI is displayed when the program is executed:
The following has been provided:
A text file called Scores.txt, which contains the names and scores of all the players
who participated in the game play events. The information is supplied for each
player in the following format in the file:
<name>,<score>
A Load Scores button, which contains code to read the data from the Scores.txt
file into two parallel arrays called arrNames and arrScores.
A procedure to display suitable headings and the names and scores contained in
the two parallel arrays.
Write code to perform the tasks described in QUESTION 4.1 and QUESTION 4.2 on the
next page.
Copyright reserved Please turn over
Downloaded from hlayiso.com
Information Technology/P1 19 DBE/2018
CAPS – Grade 12 Exemplar
4.1 Button [Remove Duplicates]
More than one game score was captured for some of the players in the file.
Write code to ensure that only the highest scores and the corresponding
names remain in the provided arrays.
Example of output that shows only the highest score for each player when the
Display procedure which displays the content of the arrays are executed:
(16)
4.2 Button [Display Master Players]
Obtain the names and scores of all players with scores higher than the
average score of all players. Use the array, which contains only the
highest scores, to calculate the average score. That is the array where
lower duplicate scores of the players have been removed.
The average score must be displayed as part of the heading in the output
area.
Save the names and scores of these players in another array called
arrHighScores as a string in the following format: <Name>#<Score>
Example: John Smith#5623
Sort the content of the array arrHighScores alphabetically and display
the sorted names and scores in the Display area.
Example of output:
(14)
Enter your examination number as a comment in the first line of the program file.
Save your program.
Make a printout of the code if required.
TOTAL SECTION D: 30
GRAND TOTAL: 150
Copyright reserved
Study this subject
Recommended for this subject

Memorandum
Information Technology Grade 12 P1 Exemplar 2018 Memo (Eng)

Question paper
Information Technology Grade 12 P1 Eastern Cape Mock 2018 QP

Question paper
Information Technology Grade 12 P1 Eastern Cape Mock 2018 QP

Question paper
Information Technology Grade 12 P1 Eastern Cape Mock 2018 QP

Question paper
Information Technology Grade 12 P1 Eastern Cape Mock 2018 QP

Question paper
Information Technology Grade 12 P1 NSC June 2018 QP (Eng)
More from Grade 12 Information Technology

Memorandum
Information Technology Grade 12 P1 NSC June 2025 Memo (Eng)

Memorandum
Information Technology Grade 12 P1 2024 Memo (Eng)

Memorandum
Information Technology Grade 12 P2 2024 Memo (Eng)

Memorandum
Information Technology Grade 12 P1 2023 Memo (Afr)

Memorandum
Information Technology Grade 12 P2 2023 Memo (Afr)

Memorandum