Information Technology Paper 2 (English)

November 2023 — Grade 12 / Matric — Information Technology

Past Paper 2023 Grade 12 English

↓ Download PDF 📄 595.5 KB View Memorandum

Preparing document

📋 Document Analysis

🎯 150 marks ⏱️ 3h 📄 17 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.1Choose a term from COLUMN B that matches the description in COLUMN A. Write only the letter (A P\next to the question numbers (1.1.1 to 1.1.10\in the ANSWER BOOK, e.g. 1.1.11 Q. COLUMN COLUMN B

1.1.10The efficient and environmentally responsible design and disposal of computer equipment The interconnection of computing devices embedded in everyday objects, enabling them to send and receive data via the internet

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

1.2.1to a group of compromised computers or mobile devices connected to a network used to attack other networks. Botnet Zombie cookie Skynet

1.2.2ROM SSD HDD Cache memory (1\

1.2.3provided free for use, modification and redistribution. Proprietary Shrink wrap

1.2.4Most of today s internet connections are ... connections that are capable of transmitting large amounts of data across the network.

1.2.5The answer to the expression given below: 24 MOD 7 * 5 DIV 2

7.5(1\ Information Technology/P2 DBE/November 2023 NSC Copyright reserved Please turn over

1.3Give ONE word/term for each of the following descriptions. Write only the word/term next to the question number s (1.3.1 to 1.3.5\ in the ANSWER BOOK, e.g. 1.3.1 Computer

1.3.1A third party program that extends the built in functionality of an application or browser (1\

1.3.2A data structure that consists of a collection of tables that are joined through linked fields (1\

1.3.3A type of malware that prevents a user from accessing his or her data on a device until a fee is paid (1\

1.3.4A creator s exclusive legal right to reproduce, publish or sell intellectual property (1\

1.3.5The ability of a system to increase or decrease its resources depending on the number of users (1\ TOTAL SECTION A: 20 Information Technology/P2 DBE/November 2023

Q2— Section header —

2.1It has been suggested that t he desktop computers in the admin istration building should be replaced.

2.1.1State TWO characteristics of a motherboard that should be considered when purchasing new desktop computers. (2\

2.1.2Except for the CPU, name ONE other component that will process data in a computer system. (1\

2.1.3The secondary storage capacity is an important consideration when purchasing devices. Give TWO examples of flash storage devices that could be used in the admin istration

2.2The IT department at the university suggested that cloud based servers could be used for the admin istration department.

2.2.1Briefly explain what a cloud based virtual server is. (2\

2.2.2Justify the use of cloud based virtual servers. (2\

2.2.3Software as a Service (SaaS\rrently used on the computers in the admin istration building. Except for the benefit of renting instead of buying software, state TWO other benefits of using SaaS.

2.2.4Some of the software being used require licen es Motivate why acquiring a site licen e is better than acquiring a

2.3Critical to the success of the institution is e nsuring no downtime and that regular backups of important data at the university are made

2.3.1Explain what a backup strategy is and how it can help prevent downtime at the university. (3\

2.3.2A cloud storage service could be used to backup data off site. State TWO disadvantages of using cloud storage to backup data off site. (2\

2.4An Engineering Graphics and Design course, using AutoCAD as a drawing tool, is offered at the university. Give ONE term for the

2.5Data security is essential to safeguard computer systems at the university against malware threats. One such threat is a computer worm.

2.5.1State TWO characteristics of a computer worm. (2\

2.5.2Explain why an antivirus product, rather than a firewall, will protect a system from being infected by a computer worm. (2\

2.6The new computers will be equipped with solid state drives which do not need to be defragmented to optimise performance. Discuss why there is no need to defragment a solid state drive. (2\ TOTAL SECTION B:

Q3— Section header —

3.1Study the school network layout and answer the questions below

3.1.1Define the term network (2

3.1.2Why do you think the school will benefit from investing in modern comm unication and network technologies (2\

3.1.3Identify and motivate the need for at least TWO components used in a LAN. (4\

3.1.4The switches are connected to one another from the computer lab to Block B of the school (from Switch 1 to S witch 5\ (a\

3.1.4(a\ (2\ Computer lab 40 PCs Administration office 3 PCs Principal's office 2 PCs

3.2A network can be made up of wired and wireless communication media.

3.2.1Suggest ONE type of wireless technology that can be utilised in an extended network. (1\

3.2.2Explain how the wireless capability of the school s network can be extended to cover the entire school ground (2\

3.2.3The school needs to provide network access to their hostel at another location about one kilometre away. Suggest a possible solution and indicate how your solution would solve this problem. (2\

3.3The school would like to incorporate VoIP technology in the classrooms.

3.3.1(a\ Write out the acronym VoIP (1\ (b\ How does VoIP differ from traditional telephone calls? (2\

3.3.2Assess the possible technical challenges that might be faced when using VoIP at school. Discuss at least TWO challenges. (4\

3.4One of the short term goals of the school is to set up an intranet. Briefly explain what an intranet is and give a practical example of how it could be used in a school environment. (2\

Q4— Section header —

4.1Study the table above and a nswer the questions that follow

4.1.1State the pu rpose of a primary k ey in a table (1\

4.1.2State requirement of a primary key except not having duplicate values. (1\

4.1The structure of the table above will result in anomalies. (a\ What design error in this table might lead to an anomaly? (2 (b\

4.2Data verification and data validation are important database management processes. Compare the concepts of verification and validation to clearly indicate why

4.3The school uses a Microsoft Access database as their DBMS solution.

4.3.1What programming language is mostly used to extract data from a database? (1\

4.3.2Identify a typical scenario when a server based database would be required and explain how a server based database would serve to cater for the needs of the scenario identified. (3\

4.4An audit trail is used in the school s database.

4.4.1How does the creation of an audit trail enhance data security in the school database? (2\

4.4.2Besides using an audit trail, suggest an alternative method to enhance the security of the school s database and explain how it can be used. (2\ TOTAL SECTION D: Information Technology

Q5— Section header —

5.1Efforts are made to identify and improve code segments in the current software system utilised by the admin istration department. Study the extract of Delphi code below and answer the questions that follow:

5.1.1Write down the line number of any line of code from the provided code segment above that implements the following

5.1What will be the value of iCounter after the above code has been executed? NOTE

5.1.3Provide the output of the program after the code above has been executed (2\

5.1.4Rewrite the second loop ( for iCol := 1 to 5 do \as a conditional loop. (3\ Information Technology /P2 13

5.2A prototype application was developed for the human resources (HR\ department that will allow them to search for student names. An array has been declared as follows: arrNames: array [1..5] of String =

5.3Write pseudocode to input a word and display the word in reverse letter order. EXAMPLE If the word database

5.4An object class is required to create a student card object. The details required on the student card are shown in the table below Details on student card: Example: Unique student number 013795 Name of the student

Q6— Section header —

6.1Registration for an open day event at school takes place by using QR quick response

6.1.1Explain what a QR code is and how it can be captured. (2\

6.1.2When completing a form online it often happens that personal information such as your e mail address

6.2A video of a 3D tour of the school campus is placed on the school s website for learners who cannot attend the open day.

6.2.1A computer with the latest operating system and multiprocessing specifications was used to create the video. (a\ Explain what multiprocessing is. (2\ (b\ Discuss how the

6.2.2When a person visits the school s website more than once, it opens much faster because of the web cache Explain the process of web

6.2.3The online 3D tour can be downloaded or streamed. Critically discuss the increased use of streaming material rather than downloading. (4\

6.3The school s website is an example of a Web 1.0 generation website.

6.3.1State TWO characteristics of a Web 1.0 website (2\

6.3.2Give any TWO reasons that led to websites evolving from Web 1.0 to Web 2.0. (2\ Information Technology /P2

6.4All the data of the prospective learners are saved i n an online database. he following variation of data

6.4.1iscuss why the data above might compromise the quality of input data (2\

6.4.2State WO different techniques on how the form in which the data

6.4.3Data gathered from form needs to be used for decision making The process of

6.5The school is one of many schools in the LearnMore School franchise enrolling new learners A distributed database is used to save the data required for use by the school.

6.5.1Why would a distributed database be a more suitable option for this scenario

6.5.2Private information that is transferred over public networks such as the internet , should always be encrypted. Briefly explain how

6.5Suggest which distributed database model will be most suitable for this scenario and motivate your answer. (2\ Data (a\ (b\ Decisions Information Technology

6.6Technology has made it possible for more people to gain access to information.

6.6.1Give TWO examples of digital communication platforms that can be used to promote the open day event of the school. (2\

6.6.2It has been reported that confidential information about parents and learners have been distributed without their knowledge. Which policy document can be used as motivation for the need to take disciplinary action against the perpetrator?

Topics Identified

Word ProcessingDatabasesProgrammingNetworkingHardware

Mark Allocation

Total150 marks

Paper information

SubjectInformation Technology

Year2023

SessionNovember

TypePast Paper

PaperPaper 2

LanguageEnglish

Pages17

Downloads8

Examination context

Decade2020s

Years ago3y

SeasonSpring (SH)

Start daySunday

Exam periodNovember 2023

Days since exam1,083

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 size595.5 KB

Pages17

Archived on7 September 2026

File age46d

ContributorFreeMode

FingerprintD6B794319E5E

Questions and learner discussion

No questions or discussions have been posted yet.