Skip to content
Information Technology November 2020 P2 (Eastern Cape)

81 questions answered · 150 marks · Eastern Cape DoE

Information Technology Grade 11 November 2020 P2 (Eastern Cape) Questions and Answers

Grade 11 November Examination November 2020 81 answered

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.

Tip: hide the answers and try each question first Hide answers Expand all

Section A: Short questions

15 questions

Systems Technologies Hardware
  • A High-level programming languages
  • B Low-level programming languages
  • C Middle-level programming languages
  • D Rapid application development
Answer

B: Low-level programming languages.

Low-level languages are close to the hardware, so they give small, fast code.

Solution Development (Algorithms)
  • A 0
  • B 2
  • C 4
  • D 3
Answer

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.)

Systems Technologies Hardware
  • A process.
  • B program.
  • C thread.
  • D multitasking.
Answer

A: process.

A process is a program (or part of one) being run by the CPU.

Social Implications Issues
  • A Data validation
  • B Data verification
  • C Processing
  • D Authorisation
Answer

B: Data verification.

Verification checks that the data entered matches the source, which a person judges.

Solution Development (Algorithms)
  • A 1Team
  • B Begin
  • C _Discount
  • D Subject?
Answer

C: _Discount.

A name may not start with a digit, be a reserved word or contain a symbol such as ?. _Discount is valid.

Database Programming SQL
  • A Data processing
  • B Data maintenance
  • C Data independence
  • D Data manipulation
Answer

B: Data maintenance.

Adding, deleting and editing records is data maintenance.

Network Technologies Basics
  • A Modulator and Demodulator
  • B Modulation and Demodulation
  • C Morden and demodex
  • D Both B and C
Answer

B: Modulation and Demodulation.

The memo gives Modulation and Demodulation.

Systems Technologies Hardware
  • A Assembler
  • B Coding
  • C Machine code
  • D Assembly code
Answer

C: Machine code.

Machine code is the only form the CPU executes directly.

Social Implications Issues
  • A Acceptable Use Policy
  • B Accelerated User Policy
  • C Acceptable Uniform Policy
  • D Access Usage Program
Answer

A: Acceptable Use Policy.

An Acceptable Use Policy sets out what users may do on a network.

Social Implications Issues
  • A Outsourcing
  • B Office automation
  • C Centralisation
  • D Teleprocessing
Answer

B: Office automation.

This is office automation.

Database Programming SQL
Answer

Data redundancy

Social Implications Issues
Answer

Telecommuting

Database Programming SQL
Answer

Anomalies

Solution Development (Algorithms)
Answer

Constant

Social Implications Issues
Answer

Jailbreaking

Section B: System technologies

16 questions
Question 2: laptop specifications

Two 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.

Specifications and package details of Spec A and Spec B. Question 2: laptop specifications, Information Technology Grade 11 November 2020 P2 (Eastern Cape), Question 2.1.1 to 2.5.2

Systems Technologies Hardware
Answer

DIMM (Dual Inline Memory Module).

Systems Technologies Hardware
Answer

Volatile memory.

RAM loses its contents when the power is off.

Systems Technologies Hardware
Answer

The DIMM (RAM) slot.

Systems Technologies Hardware
Answer

A 32-bit operating system can only see and use about 4 GB of RAM.

Systems Technologies Hardware
Answer

RAM temporarily stores the data and instructions (programs) that the CPU needs before it can work with them.

Systems Technologies Hardware (2 x 1)
Answer

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.

Systems Technologies Hardware
Answer

\( 8 \times 1024\ \text{MB} = 8192\ \text{MB} = 8\ \text{GB} \)

8 GB

Systems Technologies Hardware
Answer

Double Data Rate.

Systems Technologies Hardware
Answer

Intel Core i7 9750H (the CPU in Spec A).

Systems Technologies Hardware
Answer

The machine cycle.

Systems Technologies Hardware (4 x 1)
Answer

The four steps of the machine cycle are:

  1. Fetch the instruction and data from memory (RAM).
  2. Decode the instruction.
  3. Execute the instruction.
  4. Store (transfer) the result back to memory.

Systems Technologies Hardware (2 x 1)
Answer
  • 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.

Systems Technologies Hardware (2 x 1)
Answer
  • Intel RX 5700XT 8GB (Spec A)
  • NVDIA GTX 1660 4GB (Spec B)

Solution Development (Algorithms) (2 x 2)
Answer

Two programming language translators are:

  1. Compiler: translates the entire program into machine language in one go.
  2. Interpreter: translates and runs the program one line at a time, converting the current line into machine language.

Systems Technologies Hardware (2 x 1)
Answer

It transfers uncompressed video, and compressed or uncompressed digital audio, from a computer to a monitor, projector, digital TV or other digital audio device.

Systems Technologies Hardware
Answer

High Definition Multimedia Interface.

Section C: Communication and network technologies

14 questions

Network Technologies Basics
Answer

A computer network is a collection of computers or other devices connected by a communication medium so users can share software, hardware, data and information.

Network Technologies Basics (2 x 1)
Answer

Two reasons for having a network are:

  1. Fast and efficient communication.
  2. Sharing of hardware resources such as printers (other valid answers: centralised data, file transfer, increased control and security, flexible access).

Internet Technologies WWW
Answer

Global Area Network (GAN) (also accepted: World Wide Web).

Network Technologies Basics (2 x 1)
Answer

(a) Wi-Fi

(b) 3G/4G/LTE/5G

Network Technologies Basics (2 x 1)
Answer

(a) Wi-Fi

(b) Ethernet

Network Technologies Basics
Answer

It sends and receives radio signals so that devices can connect wirelessly to a wired network.

Network Technologies Basics
Answer

Base station.

Network Technologies Basics (2 x 1)
Answer
  • 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.

Network Technologies Basics
Answer

Skype (also accepted: Google Voice, Viber, Vonage, Jitsi and similar).

Network Technologies Basics (2 x 1)
Answer

Two disadvantages of VoIP are:

  1. The call quality can be poor on a slow Internet connection.
  2. Video calls can use up your data cap quickly.

Network Technologies Basics (2 x 1)
Answer

Two types of data compression are:

  1. Lossy compression: reduces file size by losing some insignificant data.
  2. Lossless compression: reduces file size without losing any data.

Network Technologies Basics (2 x 1)
Answer
  • Lossy: audio, video or still images (for example JPEG or MP3).
  • Lossless: documents, spreadsheets or databases (for example ZIP).

Internet Technologies WWW (2 x 2)
Answer

Two types of Internet connection are:

  1. Fixed location Internet access: high-speed data transmission to homes and businesses using cabled technology.
  2. Mobile Internet access: connecting to the Internet over wireless networks such as the cellular phone network.

Internet Technologies WWW (2 x 1)
Answer
  • Fixed location: ADSL.
  • Mobile: 3G, 4G/LTE or 5G.

Section D: Data and information management

8 questions

Database Programming SQL
Answer

A DBMS is software that allows you to work with (create and manage) electronic databases.

Database Programming SQL (3 x 1)
Answer

Three functions of a DBMS are:

  1. Creating the database.
  2. Editing the structure of the database.
  3. Adding, editing and deleting data, and querying (searching) the data.

Database Programming SQL
Answer

Bigtable.

Database Programming SQL (3 x 1)
Answer

Three validation measures are:

  1. Format check.
  2. Data type check.
  3. Range check (other valid answers: presence check, check digit).

Social Implications Issues (3 x 1)
Answer

Three qualities of valuable information are:

  1. It is accurate and without errors.
  2. It is verifiable.
  3. It is timely.
Question 4.3: student tables

A school database stores students and their transactions in two tables.

Table tblStudent with its fields. Question 4.3: student tables, Information Technology Grade 11 November 2020 P2 (Eastern Cape), Question 4.3.1
Table tblStudentTransactions with its fields. Question 4.3: student tables, Information Technology Grade 11 November 2020 P2 (Eastern Cape), Question 4.3.1

Database Programming SQL (5)
Answer
  • 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.

Database Programming SQL (2 x 1)
Answer
  • 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.

Database Programming SQL (3 x 1)
Answer

Three functions of a database administrator are:

  1. Managing and maintaining the databases.
  2. Controlling users and their access rights.
  3. Implementing a good backup policy (also accepted: routine maintenance, updating the DB software, ensuring enough storage and memory).

Section E: Solution development

12 questions

Solution Development (Databases & Files)
Answer

ASCII (American Standard Code for Information Interchange).

Solution Development (Databases & Files)
Answer

CSV (comma-delimited).

Solution Development (Databases & Files)
Answer

It links the file variable txtStock to the file Goods.txt on the disk.

Solution Development (Databases & Files)
Answer

It opens an existing file for writing with the file pointer at the end, so new data is added after the existing data.

Solution Development (Algorithms)
Answer

Step-and-watch (stepping through the code with a watch).

Solution Development (Databases & Files)
Answer

Data persistence is the ability of data to be saved and then retrieved and used again later.

Solution Development (String Manipulation)
Answer

It converts real values to strings of equal length (with leading spaces) so decimals line up under one another.

Solution Development (String Manipulation) (5 x 1)
Answer

The parts of the format string mean:

  1. %: the text that follows is a formatting instruction, not normal text.
  2. 10: the final string must be 10 characters wide.
  3. 2: the number must show 2 decimal places.
  4. f: the value is a floating-point (real) number.
  5. rWeight: the variable whose value is formatted into a string.

Solution Development (String Manipulation) (2 x 1)
Answer

m, which tells Format that the value is monetary.

Arrays Parallel Arrays (2 x 1)
Answer
  • 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.
Question 5.6: trace table

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).

Blank trace table with columns Line No, Value1, Value2, Value3, Value4 and Output. Question 5.6: trace table, Information Technology Grade 11 November 2020 P2 (Eastern Cape)

Solution Development (Algorithms) (5)
Answer

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.

LineValue1Value2Value3Value4Output
110
25
37
410,6
52
65
75
82
910
1010,6

Solution Development (Databases & Files) (2 x 1)
Answer
  • 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 questions

Social Implications Issues (3 x 1)
Answer

Three changes IT has brought to the workplace are:

  1. Better record keeping and data storage.
  2. Better communication and virtual presence.
  3. Automation (also accepted: artificial intelligence and sensor-driven computing).

Social Implications Issues (2 x 1)
Answer

Two ways IT has helped musicians are:

  1. They can record an album more easily and cheaply than before.
  2. They can distribute and market their music directly, and customers can download it over the Internet.

Social Implications Issues (2 x 1)
Answer
  • 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.

Social Implications Issues
Answer

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.

Network Technologies Basics
Answer

In the settings of the server operating system.

Social Implications Issues (3 x 1)
Answer

Three aspects of an AUP are:

  1. A code of conduct that governs user behaviour on the network and Internet.
  2. Restrictions on installing hardware or software.
  3. 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).

Social Implications Issues
Answer

Restrictions.

Social Implications Issues (3 x 1)
Answer

Three ways ICT helps government are:

  1. Better communication.
  2. More efficient administration.
  3. Census, statistics and elections (also accepted: weather services and predictions).

Social Implications Issues (3 x 1)
Answer

Three reasons people fear ICT are:

  1. Not enough knowledge of, or exposure to, ICT.
  2. ICT exposes them to risks they cannot manage.
  3. Criminals abuse ICT through hacking and cybercrime, and malware adds to the fear.

Social Implications Issues
Answer

Globalisation is the integration of economies, cultures, ideas and groups across the world, driven by a worldwide network of communication, transport, trade and immigration.

Social Implications Issues (3 x 1)
Answer

Three results of globalisation are:

  1. An efficient market where what buyers will pay balances what sellers will accept.
  2. More competition between companies, which improves service and quality.
  3. Countries depend on each other, which adds security, and poorer nations get more job opportunities.

Social Implications Issues (2 x 2)
Answer

Two sectors that benefit from the 4IR are:

  1. Agriculture: AI machine vision can measure crop numbers and detect weeds and pests, and robotic sprayers apply herbicide precisely.
  2. Healthcare: precision medicine lets doctors analyse a patient's genome, history and lifestyle, so diagnosis is more reliable.

Social Implications Issues (3 x 1)
Answer

Three human errors that cause data loss are:

  1. Accidentally deleting files or reformatting a disk.
  2. Not making regular backups.
  3. Entering incorrect data, or losing portable storage devices.

Social Implications Issues (3 x 1)
Answer

Three backup tips are:

  1. Schedule or automate the backup so it is not forgotten.
  2. Back up to an external storage device such as a portable hard drive.
  3. Keep backups off-site, and test them from time to time by restoring some files.

Database Programming SQL (3 x 1)
Answer

Three data validation methods are:

  1. Format check.
  2. Data type check.
  3. Range check (also accepted: presence check, minimising user input).

Database Programming SQL
Answer

Mandatory fields are fields that are compulsory and must be filled in.