Department of Commerce and Humanities

Continuous Assessment Internal Examination

DATA MANAGEMENT

ASSIGNMENT 1

DUE DATE 03/04/2026

Assessor: MR GAPARE
Moderator: MR MUTAZU

Contents

Number of Pages: 09

Pass Mark: 50%

Weighting: 50%

This paper consists of:

Question 1: 10 Marks Question 6: 20` Marks

Question 2: 10 Marks Question 7: 30` Marks

Question 3: 10 Marks Question 8: 30` Marks

Question 4: 10` Marks Question 9: 45` Marks

Question 5: 10` Marks Question 10: 25` Marks

Instructions
Use of non-programable scientific calculator is permissible

Read all the questions carefully

Answer all questions in this question paper in the answer sheet provided

Number the answers correctly according to the numbering system used in this question paper

Write legibly

PLEASE READ THE ASSESSMENT RULES AND REGULATIONS THAT FOLLOW

Learners are warned that contravening any of the examination rules or disobeying the instructions of an invigilator could result in
the examination being declared invalid. Disciplinary measures will be taken which may result in the students’ expulsion from GCC
 2

Answer QUESTIONS 1 -5 on the ANSWER SHEET (attached)

Time allocated for SECTION A: 50 minutes

QUESTION 1: COMPUTING CONCEPTS AND APPLICATION SKILLS MARKS: 10

1.1 Various options are given as possible answers to the following questions. Choose the answer
and write only the letter (A–D) next to the question number (1.1.1–1.1.5) on the attached
ANSWER SHEET.

1.1.1 A digital citizen is …

A. any person who uses digital devices.

B. only employed people that connect to the internet.
C. only employed people who use social media.
D. None of the above.

1.1.2 An example of a mobile device is …

A. an ADSL line.
B. a desktop computer.
C. a tablet.
D. All of the above.

1.1.3 Input devices are used to obtain input fron a user, for example:

A. speakers
B. monitor
C. printer
D. None of the above.

1.1.4 Output devices are used to produce output for the user, for example:

A. scanner
B. mouse
C. speakers
D. None of the above.

1.1.5 Peripherals are …

A. Internal devices that provide output, e.g. a network card.

B. external devices that provide input, e.g a keyboard.
C. external devices that provide output, e.g a CPU.
D. None of the above.
(5 x 1) (5)
 3

1.2 Choose a description in COLUMN B that matches a file type in COLUMN A. Write
only the letter (A–H) next to the question number (1.2.1–1.2.5) on the attached ANSWER
SHEET (attached).

COLUMN A COLUMN B
1.2.1 .jpg A Sound file in Media Player

1.2.2 .pptx B WinZip

1.2.3 .exe C Microsoft Excel file

1.2.4 .mp3 D Notepad document

1.2.5 .zip E Picture file in Paint

F Microsoft PowerPoint file

G Internet Explorer file

H Executable file

(5 x 1) (5)
[10]

QUESTION 2: NETWORKING AND COMMUNICATIONS SKILLS MARKS:10

2.1 Choose the correct term from those in brackets. Write only the
answer next to the question number (2.1.1–2.1.5) on the ANSWER SHEET (attached).

2.1.1 A high-powered computer that is used to provide services on the network.

(Server/Personal computer)

2.1.2 A card that uses an antenna to connect wirelessly to a network. (Ethernet NIC/ Wireless
NIC)

2.1.3 This device is used as a common point to connect devices together to form the network.
(Hub/Club)

2.1.4 This cable is used to transmit light signals. (Copper/ Fibre optic)

2.1.5 Technology that uses radio waves to send data over very short distances.
(Bluetooth/ADSL)
(5 x 1) (5)
 4

2.2 Write the following abbreviations in full. Write your answer next to the question number (2.2.1-
2.2.5) on the ANSWER SHEET (attached).

2.2.1 NIC

2.2.2 HAN

2.2.3 ISP

2.2.4 DSL

2.2.5 LAN
(5X1) (5)
[10]

QUESTION 3: DATA, INFORMATION MANAGEMENT AND COMPUTATIONAL

THINKING MARKS: 15

Read the following information regarding the purchase of a laptop and answer the questions that
follows on the ANSWER SHEET (attached).

James Kodisang got an internship at a clothing company. He wants to purchase a new laptop
because he often travels to different provinces with his manager. Because he is only an intern, he
doesn’t earn a high salary as yet. He can afford a maximum of R1 500 per month to pay off his
laptop. One of his primary duties is to do presentations for potential customers and draw up
quotations. He will need a laptop that includes presentation and spreadsheet software.

Option 1:

Lenovo S145 Celeron

R 5 999
or R440 pm on credit
 5

Option 2

3.1 Which laptop offers the biggest RAM? (Name the laptop and the RAM size.) (2)

3.2 Which laptop offers the biggest display? (Name the laptop and the display size.) (2)

3.3 What processor does the MICROSOFT SURFACE offer? (1)

3.4 Which laptop should James consider buying regarding the software he needs to do
presentations and quotations? Give a reason for your answer. (2)

3.5 Which operating system does both laptops offer? (1)

3.6 Which laptop can James afford? Give a reason for your answer. (2)

3.7 Problem-solving consist of FIVE steps using computational thinking.

Name the FIVE steps. (5)

[15]
 6

QUESTION 4: INTERNET AND COMMUNICATION SKILLS MARKS: 10

Choose ONE term from the list below for each of the following descriptions and write it next to the
question number (4.1—4.10) on the ANSWER SHEET (attached). Each word/term may only be used
ONCE.

Internet; world wide web; IPv4; page; Yahoo; Internet Proverb; URL; ISP; IPv6; web browser;
Takealot; world wild web; ethernet; Telkom; DSP; ARL; internet protocol

4.1 [Link] is an example of a ...

4.2 IP stands for ...
4.3 A virtual network that consists of websites and webpages connected across the world.
4.4 A company that allows one access to the internet for a monthly or yearly fee.
4.5 An example of an online shopping service.
4.6 An example of an ISP.
4.7 Application software used to view webpages.
4.8 [Link] is an example of an ... address.
4.9 A global system of interlinked computers and networks which is not owned by any
organisation.
4.10 An example of a search engine.
(10 x 1) [10]

QUESTION 5: DIGITAL CITIZENSHIP MARKS: 10

5.1 Indicate whether the following statements are TRUE or FALSE by writing only 'True' or ’False'
next to the question number (5.1.1-5.1.10) on the ANSWER SHEET (attached).

5.1.1 Ergonomics is the study of a person s physical comfort in the workplace.

5.1.2 Stretching exercises will not reduce strain on one's back.
5.1.3 A negative impact of ICT on the environment is when users increase the use of paper to make
printouts for work-related purposes.
5.1.4 A positive impact of ICT on the environment is when users do not switch off their computers
and waste electricity.
5.1.5 Software piracy is the illegal copying and downloading of copyright software.
5.1.6 Information accuracy is based on facts and correctness.
5.1.7 Cybercrimes excludes hardware-related and software-related theft.
5.1.8 ICT cannot connect people to an online doctor for assistance in case of an
emergency.
5.1.9 Technological addiction has a negative impact on a user's health.
5.1.10 A precaution to limit the negative impact on a user's health is not to have the volume on a
headset at its maximum full when listening to music.
(10 x 1) [10]
 7

5.2 Read the following short scenario and answer the questions.

Julia is a 21-year-old student at university. She spends most of her time online and feels sick and
depressed if she loses access to the internet. She feels 'cut off' from the world.

At one stage she almost found herself to be a victim of cybercrimes. An e-mail was sent to her
personal e-mail account requesting her to provide the sender with her personal banking details.
Luckily, Julia was aware of cybercrimes and didn't provide the sender with any details.

Because of Julia's constant use of her headphones, her hearing has deteriorated. Luckily, she was
able to receive treatment before she went completely deaf. Julia spends most of her time using her
laptop on her bed. This causes her to experience major backache when she goes to sleep.

5.2.1 Why does Julia feel cut off from the world? What negative impact does this
have on her social well-being? (2)

5.2.2 What type of cybercrime was Julia almost a victim of? In the future, what other precaution
can she take not to fall victim to this crime? (2)

5.2.3 What negative and positive impact does ICT have on Julia? (4)

5.2.4 What ergonomic friendly workstation can Julia get to reduce her back pain? (2)
[10]

TOTAL SECTION A: 65
 8

SECTION B: PRACTICAL MARKS: 120

Time allocated for SECTION B: 130 minutes

QUESTION 6: WORD PROCESSING MARKS: 50

TIME: 55 minutes
1. Retrieve the document, RHINOS, saved in the DATA MANAGEMENT folder. (Only make a
PRINTOUT of the EDITED document, do not print and hand in the unedited version).

2. Save the document as QUESTION 6.

3. As a footer in capital letters, insert QUESTION 6 left-aligned and your EXAMINATION NUMBER
right-aligned.

4. Edit the document as indicated in the text and according to the instructions below.

5. Change all margins to 1.27 cm/0.5ʺ.

6. Justify the entire document.

7. Insert FIVE open lines at the top of the document.

8. Choose any WordArt of your choice and insert the heading at the top of the document. Change
the font to Broadway 36 pt; position the following heading in the centre:

SAVE UMKOMBE!

9. Find and replace the words "white rhinos" with "WHITE RHINOS" in upper case, bold and double
underlined.

10. Insert line numbering as indicated in the text. The line numbering must start at 10. Change the line
numbering spacing in the text to 0.2 cm/0.1ʺ.

11. Insert all page breaks as indicated in the text.

12. As a header, insert the following:

Insert the following text in 8 pt, right-aligned and apply a 18 pt glow effect to the text:
Love and protect Rhinos
Insert a single horizontal line from the left- to right-hand margin below the text
 9

13. Insert THREE equal columns with a line between the columns and insert column breaks as
indicated in the text.

14. Change the page orientation of the third page to landscape. The rest of the document must
remain in portrait.

15. Continue to edit the document as indicated in the text below. Use the default font of the document
unless indicated differently.

16. After completing all the editing, print only the edited document. Save the document and place the
PRINTOUT in your EXAMINATION FOLDER.
10
11

[50]
 12

QUESTION 7: SPREADSHEET

QUESTION 7A

TIME: 9 MINUTES

7.1 Create the following spreadsheet.

7.2 Save the document as QUESTION 7A.

7.3 As a header, insert your EXAMINATION NUMBER left-aligned and the

QUESTION NUMBER in capital letters right-aligned.

7.4 Display the figures exactly as indicated and wrap the text in row 3 as indicated.
(The decimal indicator may either be a comma (,) or a full stop (.) – both will be
accepted.)

7.5 Ensure that the column widths and row heights are adjusted to show all data
on ONE page.

7.6 Insert the data in the correct rows and columns as indicated.

7.7 Print the spreadsheet WITH row and columns headings on ONE page in portrait
orientation, save and place the PRINTOUT in your EXAMINATION FOLDER.

A B C
1 SOCIAL MEDIA STATISTICS
2 open row
MEDIA NUMBER OF NUMBER OF
3
PLATFORM USERS: USERS:
4 Facebook 13.5 16.0
5 Twitter 7.7 8.0
6 LinkedIn 5.5 6.1
7 Instagram 3.5 3.8

(9)
 13

QUESTION 7B

TIME: 36 MINUTES

7.1 Retrieve the spreadsheet saved as QUESTION 7A.

7.2 Change QUESTION 7A in the header to QUESTION 7B.

7.3 Save the spreadsheet as QUESTION 7B.

7.4 Make all the changes as indicated on the spreadsheet (page 15) and according
to the instructions below.

7.5 Change the page orientation to landscape.

7.6 Insert all columns, rows and text as indicated on the spreadsheet.

7.7 Insert the following formulae/functions where the alphabet letters appear to do
the following calculations:

A INCREASE IN USERS = NUMBER OF USERS: 2019 minus

NUMBER OF USERS: 2018
(display the answers as a number with one decimal).

B % OF TOTAL USERS: 2019 = NUMBER OF USERS: 2019 divided

by the total of NUMBER OF USERS:
2019
(use absolute cell addresses and display the answers as a percentage
with one decimal).

C TOTAL = Total of each column by using a function

(display the answers as integers).

D AVERAGE NUMBER OF USERS FOR 2018 by using a function

(display the answer as an integer).

E AVERAGE NUMBER OF USERS FOR 2019, by using a function

(display the answer as an integer).

F MINIMUM INCREASE IN USERS, by using a function

(display the answer as a number with one decimal).

7.8 The total in the last column (% OF TOTAL USERS: 2019) must be displayed
as a % with no decimals.

7.9 Copy the formulae to other cells as indicated.

7.10 Insert borders as indicated using the method that you are familiar with.

7.11 Adjust the column widths and row heights in order for the spreadsheet to fit on
ONE landscape page.

7.12 Print the spreadsheet WITHOUT row and column headings on ONE landscape
page, save the spreadsheet and place the PRINTOUT in your EXAMINATION
FOLDER.
 14

QUESTION 7B (CONTINUED)
SOCIAL MEDIA STATISTICS
Merge and centre headings
open row from column A–E
Change font to Comic Sans MS
ʎ SOUTH AFRICA 20 pt, ital ʎ ʎ
open row
Wrap headings as
indicated, bold,
MEDIA NUMBER OF NUMBER OF INCREASE % OF TOTAL right-align and fill
only the row with
PLATFORM USERS: USERS: IN USERS USERS: 2019 the column
headings light grey
ʎ 2018 (IN MILLION) ʎ 2019 (IN MILLION)
open row
Facebook 13.5 16.0
Twitter 7.7 8.0 A B
LinkedIn 5.5 6.1
Instagram 3.5 3.8
open row

ʎ TOTAL C
open row

ʎ AVERAGE USERS D E Apply all borders

as indicated.
ʎ MINIMUM INCREASE F

Sort the spreadsheet

according to the Media
Platform column with
corresponding data in (36)
alphabetical order.
[45]
 15

QUESTION 8: INVOICE 20 MARKS

TIME: 15 MINUTES

1. Retrieve the spreadsheet, SHARKINV, from the DATA MANAGEMENT

folder.

2. As a footer, key in your EXAMINATION NUMBER left-aligned and QUESTION

8 right-aligned.

3. Save the spreadsheet as QUESTION 8.

4. Make all the changes as indicated on the spreadsheet and according to the
instructions below.

5. Insert the following information on the invoice next to the correct headings:

INVOICE NO: SIN23

INVOICE DATE: Insert today's date
CUSTOMER CODE: BRI2DY

6. Insert the image, SHARKLOGO, from the DATA MANAGEMENT folder as

indicated on the spreadsheet and apply the following changes:

Change ONLY the height of the image to 2.54 cm/1"

Apply a 3 pt single-line border around the image
Position the image as indicated on the spreadsheet

7. Insert the following formulae/functions where the letters of the alphabet appear
to do the following calculations; use cell references for all calculations where
possible:

A Calculate the TOTAL: QUANTITY multiply PRICE (EXC)

(display as currency, two decimals)

B SUBTOTAL: Add all the TOTAL amounts

(display as currency, two decimals)

C SUBTOTAL LESS DISCOUNT:

SUBTOTAL minus (SUBTOTAL multiply DISCOUNT)
(display as currency, two decimals)

D VAT: SUBTOTAL multiply VAT RATE

(display as currency, two decimals)

E TOTAL PAYABLE: SUBTOTAL plus VAT

(display as currency, two decimals)

F NUMBER OF PRODUCTS: Make use of a function

(display as integer)

G NUMBER OF BLANK CELLS (A20:B29): Make use of a function

(display as integer)

8. Copy the formulae to the other cells as indicated.

 16

9. Print the spreadsheet without row and column headings on ONE portrait page.
Save the spreadsheet and place the PRINTOUT in your EXAMINATION
FOLDER.

Change heading to Bradley Hand ITC 16 pt, bold

Position image
here, apply
changes
according to
Change font to Bradley Hand ITC instructions

Insert according
to instructions,
centre information

Left-align, centre vertically,

and bold headings

Insert prices,
currency, 2 decimals

bold
and
italics

(20)
 17

QUESTION 9: PRESENTATION MARKS: 20

TIME: 20 minutes

You want to raise awareness about tuberculosis at your campus. Make a short presentation about the
symptoms relating to tuberculosis.

10.1 Retrieve the presentation saved as SYMPTOMS in the DATA MANAGEMENT folder. the
COMPUTER

10.2 As a footer on each slide, key in your EXAMINATION NUMBER and QUESTION 10 in capital
letters. Ensure that the slide number also appears on each slide.

10.3 Make all the changes according to the instructions below and apply all manipulation
instructions as given on the next page.

10.4 Change the theme of the presentation to ORGANIC.

10.5 Save the presentation as QUESTION 10.

10.6 Print each slide on a new page and place the PRINTOUTS in your EXAMINATION FOLDER.

10.7 Print both slides as a HANDOUT on ONE page PORTRAIT orientation and place the
PRINTOUT in your EXAMINATION FOLDER.
 18

Slide 1:

Slide 2:

TOTAL SECTION B: 135

GRAND TOTAL: 200