Information Technology Paper 2 (English)

Feb-March 2016 — Grade 12 / Matric — Information Technology

Past Paper 2016 Grade 12 English

↓ Download PDF 📄 468.8 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 150 marks ⏱️ 3h 📄 16 pages 📝 92 items found 📚 5 topics

See full analysis

Questions — A Preview of What to Expect in the Document

This section provides a quick preview of questions from the document. It may not display every question or the complete wording of each one. For the full content, including diagrams, tables and other information, view the original PDF above.

Q1— Section header —

1.1Give ONE word/term for each of the following descriptions. Write only the word/term next to the question number (1.1.1

1.1.10\ in the ANSWER BOOK.

1.1.1A company that has a permanent, fast connection to the nternet and sells I nternet access and services a monthly fee (1\

1.1.2Initiatives to design, use and dispose of technology in an environmentally friendly way (1\

1.1A series of steps that need to be followed when designing a database to ensure that no data redundancy occurs (1\

1.1Software that is stored permanently on the ROM chip of a device such as a printer to control the basic operation of the device

1.1rotocol used for the transfer of large files between computers by means of an I nternet connection (1\

1.1.6Software that translates programming instructions written in a high level language into a file with an .exe extension that can be run independently of the programming language (1\

1.1.7A field of study that involves s imulation of human decision making processes by a computer system that is programmed to react on input received from sensors (1\

1.1.8This component generates pulses at regular frequencies to control the activities of the motherboard (1\

1.1.9A technology used by devices to automatically give a notif ication that a new message has arrived (1\

1.1.10The key field in a database table that links to the primary key in another database table in order to create a relationship between the two tables (1\

1.2Various options are provided as possible answers to the following questions. Choose the answer and write only the letter (A D\ next to the question number (1.2

1.2.5\ in the ANSWER BOOK , for example 1.2.6 E.

2.1The concept of packaging data and procedures into a single object to prevent access from outside the object is called object code ncapsulation an object program a control structure

2.2This type of test is performed by end users focuses o n the functionality of a system and the

1.2.3range check ... ensures that users enter only alphabetic data into a field. determines whether the data entered is within a fixed set of

1.2.4

1.2.5Determine the number of times the instructions inside the nested loop below will be executed: Loop with c 1 from 1 to 4 Loop with c

Q2— Section header —

15.6" 360 rotating touch screen monitor Core i7 4510U 3.1 GHz processor 8 GB DDR3 RAM 1 TB 7200 rpm USB 3.0 port and USB 2.0 port HDMI port and an SD card reader RJ45 LAN jack and Gigabit Ethernet Bluetooth 4.0

2.1Explain why each of the following components essential for the functioning of any computer:

2.1ROM (1\

2.1.2RAM (1\

2.2State ONE advantage of a touch screen monitor. (1\

2.3State ONE disadvantage of using a mechanical/conventional hard disk drive in a laptop computer (1\

2.4Windows 8.1 is the operating system on the laptop computer

2.4.1State TWO aspects of memory management that the operating system is responsible for (2\

2.4.2State TWO other functions (except memory management\ of the operating system. (2\

2.5here is no DVD drive n the specifications above Give a reason why DVD drives are no longer cluded in

2.6What is the purpose of the Ethernet port? (1\

2.7What effect would he use of a separate graphics processor have on the functioning of the laptop computer (1\ lash disk

2.8Explain why a flas disk is known as a plug and play device. (2\ Cache memory is found on or near the CPU in a computer.

Q3— Section header —

3.1Motivate the set up of the network by answering the following questions:

3.1.1What is the primary function of a file server (1\

3.1.2A star topology is used in the computer centres. (a\ Describe the term topology (1\ (b\ State TWO advantages of a star topology.

3.1.3Each computer needs a NIC to be part of the cable d network What is the specific role of the NIC in a network, other than connecting the cables to the computer? (1\ Admin istration building

3.1.4The following Internet protocol (IP\ address has been assigned to ne of the computers in Computer Centre (a\ What is an

3.2The server in the admin istration building is connected an ADSL Internet line with a 2 Mbps connection speed The data package used by the school can either be capped or

3.2.1Explain the meaning of the term data cap. (1\

3.2.2The a dministration sta complaining about the low bandwidth of the connection. What does bandwidth refer to? (1\

3.3A wireless access point has been installed in the middle of the school grounds (see diagram on previous page\ to enable the computers in the classrooms to are the Internet connection with the administration building.

3.3.1Explain a possible problem with sharing the Internet access Due to the poor Internet connection, some teachers requested to have a 3G connection in the classrooms.

3.4Which technique is used to ensure that all the d evices have access to the most up date information when stored

3.5Differentiate between a POP3 and an SMTP protocol (2\ VoIP is a lso used when lessons are presented over the Internet. State TWO

3.6The table below shows some network vulnerabilities and ways /techniques to solve or

6.1\ in the ANSWER BOOK, for example

3.6.5ntispam COLUMN A NETWORK VULNERABILITY COLUMN SOLUTION/PREVENTION

3.6.4Trojan applications that install themselves on the system Hacking into the system from outside the network Unexpected breaks in the power supply Get access to confidential information which is sent across

Q4— Section header —

4.1The following tables have been designed for the database tblDepartment Key FieldName DepartmentID DepName DepContactName DepExtensionNum

4.1.1Suggest a suitable data type for the ItemCost field (1\

4.1.2the data in the tables (on the previous page\ and give an example that explain the one many relationship that exists between the tblDepartment

4.1Write SQL statements for each of the following queries (a\ Display all details from the tblStockItems table sorted in alphabetical order by ItemName

4.1.4An incomplete SQL statement that display a list of all the laptop computers and the number of laptop computers is given below rite

4.2Due to the number of people who need access the database has been moved from a stand alone desktop to a server. DBMS software was installed on the server to handle access to the database.

4.2.1Expand the acronym DBMS (1\

4.2.2Name TWO actions that the DBMS software allows the user to perform on the data in the database.

4.3Larger businesses will use a database distributed over several servers.

4.3.1Give TWO reasons why it might not be feasible to have a larger number of users accessing a single database on a single server. (2\

4.3.2Name TWO models that can be used for data synchronisation in a distributed database. (2\

4.3.3Explain how transaction processing ensures data integrity in a distributed database model. (2\ TOTAL SECTION 12

Q5— Section header —

5.1A two dimensional array called arrStock has b een used to record the quantities of the four items for the four departments , as shown in the table below

5.2Various errors can occur while coding and executing a program

5.2.1The three common types of errors are syntax, logical and runtime errors Identify the type of error for each process in the table below.

5.2.1TYPE OF ERROR ERROR ERROR MESSAGE (a\ No semicolon

5.2.2When writing methods, parameters are sometimes used to obtain values from the calling statement. Name TWO aspects that must be taken into consideration when providing the arguments (actual parameters\

5.3Each line of the t ext file called tock Details .txt is used to store the room number the

5.3.1The following incomplete algorithm has been supplied: Open the text file Details The number of ablets and the room number where the tablets are used

5.3.2lthough the text file as reated and he filename was spelt correctly

5.4The following pseudocode was given develop a program t hat must generate four numeric values: arrNumbers is declared as an array that can store the four

Q6— Section header —

6.1Surveillance cameras and other mechanisms have been installed in the school buildings as part of the security process to monitor all the stock.

6.1.1Name TWO security techniques that the school could implem to provide access control to the server room. (2\

6.1.2The Mpeg 4 compression standard used for the recorded security videos uses lossy compression Explain the benefit of using compression (2\

6.1The administrators use an audit trail to keep track of the stock throughout the year Explain what an audit trail (1\

6.3.1Suggest TWO different techniques that will make secure access to the server contain ing the security video footage possible (2\

6.3Differentiate between an intranet extranet Also, i ndicate who would be included in an intranet and an extranet in this context

6.2Encryption is used when data about stock values are communicated over the Internet.

6.2.1What does it mean to encrypt data (2\

6.2.2A technique such as SSL uses public/private key encryption. Briefly explain the difference between the public key private key in this security standard. (3\

6.6Bluetooth technology is used to transfer the data from the mobile devices to the data server.

6.6.1Explain what Bluetooth technology is. (2\

6.6.2Give ONE reason why Bluetooth is a suitable technology to use in this case (1\

6.7The database administrator has decided to rent a server from a cloud based service in which to store the stock

6.7Using cloud based services is a form of out sourcing. Explain what outsourcing is in this context. (2\

6.7State TWO benefits for the school if they were to outsource the data server.

6.7Companies that provide cloud services split the resources of a powerful machine between users to make it appear as if each user has access to his/her own web server. What is this technique called? (1\

6.7State TWO duties of the database administrator. (2\ TOTAL SECTION F GRAND TOTAL:

Topics Identified

Word ProcessingDatabasesProgrammingNetworkingHardware

Mark Allocation

Total150 marks

Paper information

SubjectInformation Technology

Year2016

SessionFeb-March

TypePast Paper

PaperPaper 2

LanguageEnglish

Pages16

Downloads6

Examination context

Decade2010s

Years ago10y

Season—

Start day—

Exam period—

Days since exam—

About Information Technology examination preparation

This Grade 12 examination resource can be used as part of a structured revision programme. Past papers are most useful when learners attempt questions independently, work within a realistic time limit, and review their answers afterwards.

How to use this resource for revision

A past examination paper is most useful when it is treated as an active revision exercise. Try the questions yourself before checking the corresponding memorandum. Where you make an error, identify the reason — was it a knowledge gap, a calculation mistake, an interpretation issue, or an examination technique problem?

For stronger examination practice, complete the paper without unnecessary interruptions and keep track of the questions that take the most time. Afterwards, review the memorandum and separate knowledge gaps from mistakes caused by interpretation, calculation, structure, or examination technique.

understanding question requirements

applying subject knowledge

working under time constraints

checking answers

identifying revision priorities

A practical revision approach

Start by completing the resource without looking at the memorandum. Review incorrect and incomplete answers afterwards and make a short revision list based on the areas that caused difficulty.

Grade 12 subject hubs

Each matric subject has its own dedicated hub on Freemode with every past paper and marking memorandum we have archived for that subject.

➗ Mathematics View papers → 📊 Mathematical Literacy View papers → ⚗️ Physical Sciences View papers → 🧬 Life Sciences View papers → 📒 Accounting View papers → 💼 Business Studies View papers → 📈 Economics View papers → 🌍 Geography View papers → 🏛️ History View papers → 📖 English View papers → 🇿🇦 Afrikaans View papers → 🗣️ IsiNdebele View papers → 🗣️ IsiXhosa View papers → 🗣️ IsiZulu View papers → 🗣️ Sepedi View papers → 🗣️ Sesotho View papers → 🗣️ Setswana View papers → 🌾 Agricultural Sciences View papers →

Corresponding marking memorandum

Marking memorandum available

Use the corresponding memorandum after completing the paper to review your answers and identify areas that require further revision. The memorandum shows the marking approach used by DBE examiners, including method-mark allocations.

Information Technology Memo 2 (English) →

File details

File size468.8 KB

Pages16

Archived on7 September 2026

File age45d

ContributorFreeMode

FingerprintC79192E094FC

Questions and learner discussion

No questions or discussions have been posted yet.