81 questions answered · 150 marks · Eastern Cape DoE
Information Technology Grade 11 November 2020 P2 (Eastern Cape) Questions and Answers
Every question from the Grade 11 November Examination (Eastern Cape DoE, November 2020), with a full answer written from the Grade 11 Information Technology textbook and the official marking approach. Open a question to see its answer, or use Hide answers to practise first.
Instructions
A theory paper with six sections: short questions, system technologies, communication and network technologies, data and information management, solution development and an integrated scenario.
Section A: Short questions
15 questionsB: Low-level programming languages.
Low-level languages are close to the hardware, so they give small, fast code.
B: 2.
20 MOD 3 = 2, so the bracket is 10 - 2 = 8. Then 20 DIV 8 = 2. (The memo lists A, but the correct result is 2.)
A: process.
A process is a program (or part of one) being run by the CPU.
B: Data verification.
Verification checks that the data entered matches the source, which a person judges.
C: _Discount.
A name may not start with a digit, be a reserved word or contain a symbol such as ?. _Discount is valid.
B: Data maintenance.
Adding, deleting and editing records is data maintenance.
B: Modulation and Demodulation.
The memo gives Modulation and Demodulation.
C: Machine code.
Machine code is the only form the CPU executes directly.
A: Acceptable Use Policy.
An Acceptable Use Policy sets out what users may do on a network.
B: Office automation.
This is office automation.
Data redundancy
Telecommuting
Anomalies
Constant
Jailbreaking
Section B: System technologies
16 questionsTwo laptops are compared. Spec A: Windows 10 Pro (64 bit), 16 x 1024 MB DDR3 RAM, Intel Core i7 9750H, 960 GB NVMe storage, Intel RX 5700XT 8GB video card, Kaspersky, OfficeSuite 10.5. Spec B: Windows 10 Home (32 bit), 8 x 1024 MB DDR3 RAM, Intel Core i5 8265H, 1.5 TB 9200 RPM hard drive, NVDIA GTX 1660 4 GB video card, ESET, LibreOffice v10.2.

DIMM (Dual Inline Memory Module).
Volatile memory.
RAM loses its contents when the power is off.
The DIMM (RAM) slot.
A 32-bit operating system can only see and use about 4 GB of RAM.
RAM temporarily stores the data and instructions (programs) that the CPU needs before it can work with them.
Any one specification:
- Spec A: Windows 10 Pro is the operating system and Kaspersky is utility software.
- Spec B: Windows 10 Home is the operating system and ESET is utility software.
\( 8 \times 1024\ \text{MB} = 8192\ \text{MB} = 8\ \text{GB} \)
8 GB
Double Data Rate.
Intel Core i7 9750H (the CPU in Spec A).
The machine cycle.
The four steps of the machine cycle are:
- Fetch the instruction and data from memory (RAM).
- Decode the instruction.
- Execute the instruction.
- Store (transfer) the result back to memory.
- The built-in video adapter is used for normal tasks, because it uses less power and saves battery life.
- The video card is used by programs that need good graphics.
- Intel RX 5700XT 8GB (Spec A)
- NVDIA GTX 1660 4GB (Spec B)
Two programming language translators are:
- Compiler: translates the entire program into machine language in one go.
- Interpreter: translates and runs the program one line at a time, converting the current line into machine language.
It transfers uncompressed video, and compressed or uncompressed digital audio, from a computer to a monitor, projector, digital TV or other digital audio device.
High Definition Multimedia Interface.
Section C: Communication and network technologies
14 questionsA computer network is a collection of computers or other devices connected by a communication medium so users can share software, hardware, data and information.
Two reasons for having a network are:
- Fast and efficient communication.
- Sharing of hardware resources such as printers (other valid answers: centralised data, file transfer, increased control and security, flexible access).
Global Area Network (GAN) (also accepted: World Wide Web).
(a) Wi-Fi
(b) 3G/4G/LTE/5G
(a) Wi-Fi
(b) Ethernet
It sends and receives radio signals so that devices can connect wirelessly to a wired network.
Base station.
- A hotspot is an area, usually public (airport, hotel lobby, restaurant), where people can connect wirelessly to the Internet through an access point.
- Bandwidth is the total amount of data that can be transferred from one point to another in a given period of time.
Skype (also accepted: Google Voice, Viber, Vonage, Jitsi and similar).
Two disadvantages of VoIP are:
- The call quality can be poor on a slow Internet connection.
- Video calls can use up your data cap quickly.
Two types of data compression are:
- Lossy compression: reduces file size by losing some insignificant data.
- Lossless compression: reduces file size without losing any data.
- Lossy: audio, video or still images (for example JPEG or MP3).
- Lossless: documents, spreadsheets or databases (for example ZIP).
Two types of Internet connection are:
- Fixed location Internet access: high-speed data transmission to homes and businesses using cabled technology.
- Mobile Internet access: connecting to the Internet over wireless networks such as the cellular phone network.
- Fixed location: ADSL.
- Mobile: 3G, 4G/LTE or 5G.
Section D: Data and information management
8 questionsA DBMS is software that allows you to work with (create and manage) electronic databases.
Three functions of a DBMS are:
- Creating the database.
- Editing the structure of the database.
- Adding, editing and deleting data, and querying (searching) the data.
Bigtable.
Three validation measures are:
- Format check.
- Data type check.
- Range check (other valid answers: presence check, check digit).
Three qualities of valuable information are:
- It is accurate and without errors.
- It is verifiable.
- It is timely.
A school database stores students and their transactions in two tables.


- tblStudent: PK = StudentID.
- tblStudentTransactions: PK = TransactionID and FK = StudentID.
- Link tblStudent.StudentID to tblStudentTransactions.StudentID.
- The relationship is one-to-many: 1 on the tblStudent side and many (∞) on the tblStudentTransactions side, because one student can have many transactions.
- A composite key is a combination of more than one field that together identify a record uniquely.
- A primary key is a field that identifies each record with a unique value.
Three functions of a database administrator are:
- Managing and maintaining the databases.
- Controlling users and their access rights.
- Implementing a good backup policy (also accepted: routine maintenance, updating the DB software, ensuring enough storage and memory).
Section E: Solution development
12 questionsASCII (American Standard Code for Information Interchange).
CSV (comma-delimited).
It links the file variable txtStock to the file Goods.txt on the disk.
It opens an existing file for writing with the file pointer at the end, so new data is added after the existing data.
Step-and-watch (stepping through the code with a watch).
Data persistence is the ability of data to be saved and then retrieved and used again later.
It converts real values to strings of equal length (with leading spaces) so decimals line up under one another.
The parts of the format string mean:
- %: the text that follows is a formatting instruction, not normal text.
- 10: the final string must be 10 characters wide.
- 2: the number must show 2 decimal places.
- f: the value is a floating-point (real) number.
- rWeight: the variable whose value is formatted into a string.
m, which tells Format that the value is monetary.
- Selection sort uses two For loops and moves the smallest (or largest) element to its place at the top of the list.
- Bubble sort bubbles the smallest (or largest) element to the end of the list by repeatedly swapping neighbours, using a Boolean flag and a loop.
Code: value3 := 10; value1 := 30 - 5 * 5; value2 := 32 - value1 * value1; value4 := (value1 + value2) - value2/value1; value2 := value3 MOD 4; value1 := value3 DIV value2; then value1, value2, value3 and value4 are added to redOut (lines 7 to 10).

Working: value1 = 30 - 25 = 5; value2 = 32 - 5 x 5 = 7; value4 = (5 + 7) - 7/5 = 12 - 1,4 = 10,6; value2 = 10 MOD 4 = 2; value1 = 10 DIV 2 = 5.
| Line | Value1 | Value2 | Value3 | Value4 | Output |
|---|---|---|---|---|---|
| 1 | 10 | ||||
| 2 | 5 | ||||
| 3 | 7 | ||||
| 4 | 10,6 | ||||
| 5 | 2 | ||||
| 6 | 5 | ||||
| 7 | 5 | ||||
| 8 | 2 | ||||
| 9 | 10 | ||||
| 10 | 10,6 |
- Readln reads a line of text from the text file and places it in a string variable.
- Writeln writes a line of text to the text file and adds an end-of-line character.
Section F: Integrated scenario
16 questionsThree changes IT has brought to the workplace are:
- Better record keeping and data storage.
- Better communication and virtual presence.
- Automation (also accepted: artificial intelligence and sensor-driven computing).
Two ways IT has helped musicians are:
- They can record an album more easily and cheaply than before.
- They can distribute and market their music directly, and customers can download it over the Internet.
- A workplace is wherever work takes place.
- Employment practices are how people are employed, for how long, how they are paid, and where and when they are expected to work.
Outsourcing is contracting a specialist business to run parts of your business that are essential for it to function but fall outside your own area of expertise.
In the settings of the server operating system.
Three aspects of an AUP are:
- A code of conduct that governs user behaviour on the network and Internet.
- Restrictions on installing hardware or software.
- Clear consequences of breaking the AUP (also accepted: rules for portable storage devices, steps to follow after identity theft or malware, avoiding plagiarism and copyright breaches).
Restrictions.
Three ways ICT helps government are:
- Better communication.
- More efficient administration.
- Census, statistics and elections (also accepted: weather services and predictions).
Three reasons people fear ICT are:
- Not enough knowledge of, or exposure to, ICT.
- ICT exposes them to risks they cannot manage.
- Criminals abuse ICT through hacking and cybercrime, and malware adds to the fear.
Globalisation is the integration of economies, cultures, ideas and groups across the world, driven by a worldwide network of communication, transport, trade and immigration.
Three results of globalisation are:
- An efficient market where what buyers will pay balances what sellers will accept.
- More competition between companies, which improves service and quality.
- Countries depend on each other, which adds security, and poorer nations get more job opportunities.
Two sectors that benefit from the 4IR are:
- Agriculture: AI machine vision can measure crop numbers and detect weeds and pests, and robotic sprayers apply herbicide precisely.
- Healthcare: precision medicine lets doctors analyse a patient's genome, history and lifestyle, so diagnosis is more reliable.
Three human errors that cause data loss are:
- Accidentally deleting files or reformatting a disk.
- Not making regular backups.
- Entering incorrect data, or losing portable storage devices.
Three backup tips are:
- Schedule or automate the backup so it is not forgotten.
- Back up to an external storage device such as a portable hard drive.
- Keep backups off-site, and test them from time to time by restoring some files.
Three data validation methods are:
- Format check.
- Data type check.
- Range check (also accepted: presence check, minimising user input).
Mandatory fields are fields that are compulsory and must be filled in.
