NSC exam, Information Technology P2, November 2013
Assignment Type: Revision Paper
Total Marks: Unmarked
SECTION A - MULTIPLE-CHOICE QUESTIONS
QUESTION 1 - Various options are given as possible answers to the following questions. Choose the answer and type only the letter (A–D) as your answer.
Marks: 10
Question 1:

A … is the smallest addressable unit of space on a hard disk drive.

Your Answer:
Question 2:

The encryption protocol using public key encryption for encoding data sent over the Internet is known as …

Your Answer:
Question 3:

Which ONE of the following is NOT part of the machine cycle?

Your Answer:
Question 4:

A hardware interrupt is …

Your Answer:
Question 5:

Quad pumping is ...

Your Answer:
Question 6:

Which ONE of the following Boolean expressions is correct?

Attached Resource:
8f1b67fe-33a2-40fb-9b8e-0c4ed2f67cbd.png
Your Answer:
Question 7:

A rootkit is ...

Your Answer:
Question 8:

… takes place when the sender address and other parts of an e-mail header are altered to appear as though the e-mail originated from a different source.

Your Answer:
Question 9:

Which ONE of the following is an example of a correctly constructed URL for a secure website?

Your Answer:
Question 10:

The two files below are examples of music files.Which ONE of the following file extensions is most likely to be associated with these two files? 

Attached Resource:
e2ece75e-020f-48fc-bc36-b5afedeb218c.png
Your Answer:
SECTION B - HARDWARE AND SOFTWARE
Attached Section Resource:
d4c1a783-3a32-4317-9df1-85d5f481fb24.png
QUESTION 2
2.1 - The managers at the centres were given a choice to use one of the following two devices to perform their tasks:
Marks: 17
Attached Section Resource:
c18c071e-6ea2-4229-b62a-ceb76c7e412a.png
Question 1:

Give TWO reasons why the managers requested to be issued with the laptop rather than the tablet.

Your Answer:
Question 2:

A tablet uses an SSD for storage of data and files.
(a) What does the acronym SSD stand for?
(b) List THREE comparative differences between the features and performance of an SSD and an HDD in table format.

Your Answer:
Question 3:

The tablet has a system recovery partition on its SSD.
(a) Explain what partitioning of a disk means.
(b) Briefly explain why there is a need for a system recovery partition, specifically on tablets.

Your Answer:
Question 4:

Both a tablet and a laptop use cache memory. Explain the purpose of cache memory in a computer system.

Your Answer:
Question 5:

DDR RAM improves the transfer of data between the RAM and the CPU when compared to SD RAM. Explain how this improvement is accomplished.

Your Answer:
Question 6:

Give TWO reasons why a tablet and a laptop cannot use the same type of RAM.

Your Answer:
2.2 - All the laptop and desktop computers that will be used during the competition have Intel Core i7 CPUs while the tablets have ARM CPUs.
Marks: 10
Question 1:

List FOUR of the basic components a CPU must contain to be able to execute instructions.

Your Answer:
Question 2:

Different CPUs use different instruction sets. What is a CPU instruction set?

Your Answer:
Question 3:

Both types of CPU support multithreading. Explain the concept of multithreading.

Your Answer:
Question 4:

Name TWO physical aspects of CPUs that are built in during the manufacturing process to improve the performance of CPUs.

Your Answer:
2.3 - The managers have been told that they can use FireWire 800 or USB 3.0 to upload video material of the performances of contestants to the competition's website.
Marks: 3
Question 1:

State TWO advantages of USB over FireWire.

Your Answer:
Question 2:

Would the software used for the editing of videos be considered application software or system software?

Your Answer:
2.4 - Cellular modems are used to connect to the Internet and upload the results of the competition each week. The results are stored in a 'cloud'.
Marks: 5
Question 1:

Name the type of connection the modem will use with the uploading of results.

Your Answer:
Question 2:

Explain what is meant by the term cloud in this context.

Your Answer:
Question 3:

Is the storing of results in a cloud a good idea? Motivate your answer.

Your Answer:
2.5 - The results need to be printed each week. The volume of printing is large because of the high number of contestants at each venue.
Marks: 6
Question 1:

The managers decided to use inkjet printers because they are less expensive. Persuade them to use laser printers instead by giving TWO good arguments in favour of laser printers.

Your Answer:
Question 2:

Spooling is a technique that is used to accommodate large volumes of printing. Explain what spooling is.

Your Answer:
Question 3:

The USB-port used to connect the printer uses serial data transfer. Explain the difference between serial and parallel data transfer.

Your Answer:
2.6 - Each week the managers have a group conference call to discuss results and some of the outstanding performances. It is suggested that they use VoIP in order to save costs.
Marks: 4
Question 1:

Briefly explain the basic concept VoIP.

Your Answer:
Question 2:

Name a VoIP client that the managers could use to host the conference call.

Your Answer:
Question 3:

Name ONE other way (besides a conference call) in which the managers could have discussions and collaborate online.

Your Answer:
2.7 - The error message 'Missing DLL files' appeared when one of the managers wanted to use an application installed on his laptop.
Marks: 4
Question 1:

Give ONE possible reason why the DLL files are missing.

Your Answer:
Question 2:

What needs to be done so that the manager will be able to use the software again?

Your Answer:
Question 3:

When new software is installed on a computer system running a Windows operating system an entry is made into the registry of the system. Explain in computing terms what the registry is.

Your Answer:
SECTION C - APPLICATIONS AND IMPLICATIONS
QUESTION 3 - e-COMMUNICATION
Attached Section Resource:
e43fabc2-641e-48c2-844f-a7eb6ac7d809.png
3.1
Marks: 2
Question 1:

Someone requested the managers to e-mail them the video footage as an attachment. Give TWO reasons why this request is possibly not feasible.

Your Answer:
3.2 - The organisers made the videos available as podcasts.
Marks: 3
Question 1:

Explain the concept of podcasting.

Your Answer:
Question 2:

Why will podcasting be an advantage for people who want to watch the video more than once?

Your Answer:
Question 3:

Name ONE example of an electronic medium that can be used to inform friends and family when a new podcast is available.

Your Answer:
3.3 - Friends and family who want to download multimedia files of all the events must preferably have a broadband Internet connection.
Marks: 5
Question 1:

Explain the term broadband.

Your Answer:
Question 2:

ADSL is an example of a cabled broadband connection.
(a) Is ADSL a digital or an analogue connection?
(b) Give ONE advantage of an ADSL connection.


 

Your Answer:
Question 3:

Give an example of another cabled broadband connection.

Your Answer:
QUESTION 4 - SOCIAL AND ETHICAL ISSUES
Attached Section Resource:
94911ffb-a00d-48ce-b295-6cf57190960d.png
4.1 - The parents of the contestants are concerned about personal information such as contact details that are published on the competition's website.
Marks: 3
Question 1:

Justify the parents' concerns by describing TWO ways in which personal information provided on a website can be misused.

Your Answer:
Question 2:

Suggest ONE measure that a contestant can take to protect personal information that needs to be published on the Internet.

Your Answer:
4.2 - Even though personal information can be protected an activity known as social engineering could be used to gain access to the information.
Marks: 3
Question 1:

Explain what social engineering is.

Your Answer:
Question 2:

Describe ONE way in which social engineering can be prevented.

Your Answer:
4.3 - One of the contestants has been removed from the competition because he tweeted insulting remarks about another contestant.
Marks: 2
Question 1:

What is meant by the term tweet?

Your Answer:
Question 2:

What term is used to refer to the practice of publishing insulting remarks about people on an online or public forum?

Your Answer:
4.4 - Some of the contestants want the organisers to create a blog for the competition.
Marks: 2
Question 1:

What is a blog?

Your Answer:
Question 2:

How would the contestants be advantaged by the blog?

Your Answer:
4.5
Marks: 1
Question 1:

Entries must be done electronically on the website. A request was made that there must also be an alternative way to handle the entries because of the digital divide in South Africa. What is meant by the term digital divide?

Your Answer:
4.6
Marks: 2
Question 1:

Members of the IT team can work on the voting system from home instead of at the head office. Discuss the disadvantages of working from home from the IT members' point of view.

Your Answer:
SECTION D - PROGRAMMING AND SOFTWARE DEVELOPMENT
QUESTION 5 - ALGORITHMS AND PLANNING
Attached Section Resource:
85a1b62c-381d-455c-ab1b-783c47f198af.png
5.1 - Before the start of the competition the IT team had to create a user-friendly interface for the organisers to capture information about the contestants. They had to decide on suitable controls for the GUI for the entering of the information.
Marks: 5
Question 1:

The category options of the competition are Dance, Drama and Music. The following two controls have been suggested (see attached resource). Give TWO reasons why Suggestion A is a better choice.

Attached Resource:
4c5bc929-5940-450f-9257-83d72ae4f1d1.png
Your Answer:
Question 2:

The input control in the screen shot below may cause users to select both options when they enter the gender of a contestant. Suggest how this situation can be prevented.

Attached Resource:
be560ad3-dd4f-4ba5-a608-a5068dac29f9.png
Your Answer:
Question 3:

Only contestants between the ages of 13 and 18 are allowed to take part in the competition.
The following control is used to enter the age of the contestants (see attached resource). Explain why data entered using this control will be valid but not necessarily correct. Use an example with actual values as part of your explanation.

Attached Resource:
9db2ca63-f82f-40dc-b06c-26cf160ce668.PNG
Your Answer:
5.2 - A database has been created with two tables (tblContestants and tblSchools) containing data about the contestants. Study the structure of the database tables along with the additional information below and answer the questions that follow.
Attached Section Resource:
5dacbbbe-10e1-435c-a690-45da7e82d3de.png
CONTINUATION...
Marks: 2
Attached Section Resource:
68b5958b-a1e8-4666-b97c-f7fae6f9e16a.png
Question 1:

When the secretary tries to add data of newly registered contestants into the tblContestants table, an error message is displayed when she enters a value into the School_ID field.



(a) Select the type of error that occurs in this case from the given list below. Write only the letter (A–C) as your answer:
A-Update anomaly
B-Insert anomaly
C-Delete anomaly


 


b)What needs to be done to be able to register the new contestants that cannot be registered currently?

Your Answer:
5.2.2 - It has been decided to use a database rather than a text file to store the data about the contestants.
Marks: 10
Question 1:

Give TWO reasons why a database is a better structure to keep data about contestants than a text file.

Your Answer:
Question 2:

What type of key is the School_ID field in the tblContestants table?

Your Answer:
Question 3:

Another table needs to be added to convert the database into first normal form. Draw the new table, indicating the name of the table and appropriate fields and keys.



NOTE:
Draw only the new table and NOT the two given tables.

Your answer: Resource(s)
Question 4:

Explain the relationship between the newly defined table in the question above and the relevant given table (tblContestants or tblSchools) with specific reference to the fields involved.

Your Answer:
5.2.3 - When developing a program to manipulate the database it was decided to work with objects.
Marks: 5
Question 1:

Define an object in computer programming terms.

Your Answer:
Question 2:

Give ONE example of an object that needs to be created for this program.

Your Answer:
Question 3:

A class for this program has been defined with public attributes. Give TWO reasons why this is NOT good programming practice.

Your Answer:
5.3 - The name and score of each contestant in the Drama category of the competition are saved using two parallel arrays named arrNames and arrScores. The scores are in the range 0–100 (both included). The following algorithm was developed to determine the winner:
Marks: 8
Attached Section Resource:
2ef72341-b7ce-4a26-a239-6081b7392e46.png
Question 1:

The output will not be correct due to TWO logical errors. Identify the instructions causing the logical errors and write down their line numbers and the correct instructions.

Your answer: Resource(s)
Question 2:

The name of the contestant with the highest score must also be displayed.



Write line(s) of pseudocode that need to be added to the given algorithm to accomplish this task. Use the line numbers to indicate the position where the new line(s) of pseudocode should be inserted into the given algorithm.

Your answer: Resource(s)
5.4 - Programmers who created the software were requested to create a test plan along with other technical documentation to ensure that the software is up to standard.
Marks: 7
Question 1:

The system design document (SDD) is one of the first documents developed. List THREE aspects that form part of the SDD.

Your Answer:
Question 2:

List THREE aspects that should be included in the test plan.

Your Answer:
Question 3:

Why is it important to include hardware and software requirements in user documentation?

Your Answer:
5.5 - A text file is used to store the date, time and password of each user that logs onto the local server at each centre where the elimination rounds of the competition take place. Example of the content of the text file:
Attached Section Resource:
6858b169-6000-4b3c-be65-ad2793234fa2.png
CONTINUATION...
Marks: 11
Attached Section Resource:
93914760-2902-4898-a6c8-8818e15d668c.png
Question 1:

The function/method called in line 6 uses the following two parameters:



• Hour
• Minute



(a) What are parameters in terms of programming?
(b) Suggest a suitable data type for these parameters. Explain your choice of data type.

Your Answer:
Question 2:

The function/method called in line 7 will use 'try …' protection blocks.
Write down the general structure of a 'try …' protection block AND briefly explain the purpose of each section.

Your answer: Resource(s)
Question 3:

Write down the logical condition to complete the IF-statement in line 8 of the given algorithm.

Your answer: Resource(s)
Question 4:

If this algorithm is correctly coded and executed, it will cause an error in line 4 due to a mistake that was made in line 10.
(a) Explain the cause of the error.
(b) Briefly explain how to correct the mistake.

Your Answer:
SECTION E - INTEGRATED SCENARIO
QUESTION 6
Attached Section Resource:
051cbda7-d2e8-47d9-9271-5aee4a3f311c.png
6.1 - The audience in the auditorium has been provided with remote voting controllers that allow them to press a button to transmit their vote wirelessly via Bluetooth technology to a local server at the auditorium.
Marks: 5
Question 1:

Is Bluetooth a suitable technology to use in this scenario? Motivate your answer.

Your Answer:
Question 2:

What is the transmission rate of standard Bluetooth devices (3 Mbps or 3 Gbps)?

Your Answer:
Question 3:

An audience member's voting controller does not connect to the wireless network although the member is within range of the server.


Name TWO possible troubleshooting steps that can be followed to solve the problem. Replacing the voting controller is not an option.

Your Answer:
6.2 - All the votes received from the audience in the auditorium and SMSs from the television audience are stored in a relational database. The database is maintained by a database administrator.
Marks: 5
Question 1:

Explain what a relational database is.

Your Answer:
Question 2:

Give the name of ONE example of an existing database system that could be used to create this database.

Your Answer:
Question 3:

Name TWO specific responsibilities of a database administrator.

Your Answer:
6.3 - The live broadcast of the final round of the event can be streamed.
Marks: 6
Question 1:

Explain what is meant by streamed.

Your Answer:
Question 2:

Name TWO components that are required to be able to stream a live event.

Your Answer:
Question 3:

An entrepreneur is recording the live broadcast on his home computer. He plans to sell copies of the recording. Discuss the ethical issues of these activities.

Your Answer:
6.4 - An existing cabled network is used by the judges at the event centre to transmit their scores electronically to a server at the centre. The organisers are planning to use a wireless network for this purpose in future.
Marks: 5
Question 1:

State TWO advantages of a wireless network over a cabled network.

Your Answer:
Question 2:

State TWO additional hardware components that are required to create the wireless network.

Your Answer:
Question 3:

Which network protocol would be appropriate to use for the wireless network?

Your Answer:
6.5 - While uploading results, one of the organisers noticed suspicious activities on his computer. He suspects unauthorised software is running on his computer to gain access to competition results.
Marks: 5
Question 1:

State TWO types of programs that can be used to retrieve data from a computer without the permission or knowledge of the user.

Your Answer:
Question 2:

Explain how the organiser could check whether there is any unauthorised software running on his computer.

Your Answer:
Question 3:

Describe TWO ways in which the organisers can prevent their computers from being accessed by unauthorised software.

Your Answer:
6.6 - Some judges use Apple Mac computers while others use computers running on the Microsoft Windows operating system. Both these operating systems are proprietary software.
Marks: 7
Question 1:

Describe THREE functions of an operating system.

Your Answer:
Question 2:

State TWO advantages of a proprietary operating system over an open source operating system.

Your Answer:
Question 3:

Explain why software designed for the Apple Mac cannot run on a computer that uses the Microsoft Windows operating system.

Your Answer:
6.7 - The organisers of the competition have been advised to use cloud storage for the video material.
Marks: 6
Question 1:

The cloud server probably uses RAID technology. Briefly explain what RAID is. (Expanding the acronym will NOT be accepted as an answer.)

Your Answer:
Question 2:

Several levels of RAID can be implemented. Motivate why the cloud server will probably use RAID 1 rather than RAID 0.

Your Answer:
Question 3:

'Cloud computing' can be beneficial for green solutions in terms of hardware. Explain this statement briefly.

Your Answer:
6.8 - Projects such as this create a variety of IT-related job opportunities.
Marks: 4
Question 1:

Give a summary of the main responsibilities of a systems analyst.

Your Answer:
Question 2:

Apart from a database administrator and a systems analyst, name TWO other types of IT specialists who will most probably be employed by the organiser of this project.

Your Answer:
6.9 - ICT provides more effective solutions for the capturing of data and generating results than a paper-based voting system.
Marks: 2
Question 1:

Motivate why the above statement is valid by referring to TWO of the following aspects:
• Faster and improved data processing
• Improved data storage
• Improved communication

Your Answer:
6.10 - Some of the parents who do not use the Internet regularly often need some basic information about browsing the Internet.
Marks: 5
Question 1:

Give ONE example of a well-known Internet search engine.

Your Answer:
Question 2:

Give TWO hints for conducting an effective Internet search AND give an example with each hint which is applicable to a search for the website for this competition.

Your Answer:
© 2025, Obami Networks  |  Live