ICT FINAl JUNE EXAM 2023

What is 10101110 binary in decimal?

174

Convert the hexadecimal number, AC, to decimal.

172

One gigabyte is approximately equivalent to how many bytes?

1 billion bytes

The specification of a Core i5 CPU is 4.2 GHz. What does the "GHz" refer to?

Speed

Which type of program acts as an intermediary between application software and computer hardware, like a hard disk?

Operating system

A file name ending in .txt can contain a(n) __________________

None of the above (.txt is plain unformatted text only — no images, no bold, no tables)

How many bytes does Unicode use to represent character?

2

Identify the logic gate below [AND-shaped body with a bubble at the output]

NAND

Flash disk is an example of __________________

persistent memory

In the XOR logic gate, if the first input is 0 and the second input is 1, what would the output be?

1

Looking at the last cell in the first row of the following table designed using Microsoft Word, we can say that _________________

the last cell is created using cell merge command

When the next version of Microsoft Office comes out, it is expected that the Microsoft Word program that is bundled with it will be ______________ with Word file formats that we have developed so far.

backward compatible

Numbers in a computer are expressed in binary because ______________

the two binary values can correspond to the on and off states of electric switch

What is "emphasis" in a PowerPoint animation?

None of the above is correct (Emphasis is its own animation category that highlights objects already on the slide)

What does the animation painter in PowerPoint do?

Allows an effect to be copied from one object to another

Themes in PowerPoint allow which of the following?

Easily make every slide look similar

Special effects between slides are called __________________

transitions

In Paint.net, what tool should you use to copy an exact piece of an image to another part of the canvas?

Clone stamp

Image editing is about all of the following, except __________________

incorporating a transition

The colour of an image in Paint.net can be adjusted using all of the following methods, except using __________________

recolour

In Paint.net the first step if you want to crop an image is __________________

Rectangle select

In Paint.net, you can select areas in the active layer of similar colour using the __________________

None of the above (the Magic Wand tool does this — it is not listed among the options)

A presentation has 10 slides. What is the quickest way to delete slides 7 to 10?

Click slide 7, Shift-click slide 10, then press Delete

You can allow the presenter in PowerPoint to choose the next slide by __________________

putting in a hyperlink to the same file

How can you view all your slides at once in PowerPoint?

Through Slide Sorter View

Which is the best way to create another copy of a PowerPoint slide?

From the Insert tab, choose Duplicate Slide

Addition of an animation to a slide should _______________

add useful information

To preview a motion path effect using the custom animation task pane in PowerPoint, you should __________________

click the Play Button

Which of these is a way to name a slide?

Click View, Outline View, click to the right of a slide number, type the name

A well-designed slide should __________________

None of the above (avoid crowding text, overusing animations, and using too many colours)

Changes in text style in a slide should __________________

assist with making the point of the slide

What is the term used when you press and hold the left mouse key and move the mouse around the slide?

Dragging

Which of the following can you use to add times to slides in a presentation?

All of the above (Rehearse timing button, Slide show menu, and Slide transition button can all set slide timing)

The boxes in which you can insert text or pictures are called _________________

Placeholder

In PowerPoint a transition is the __________________

action on switching from one slide to another

Alternatives to PowerPoint __________________

may be free but you can be charged for extra storage

PowerPoint can be used for __________________

All of the above (making a slide show, a movie, or a poster)

All of the following are true of PowerPoint, except __________________

it is free of charge and has no restrictive licence

What does AX23 represent in Excel?

The cell at the AX column and row 23

The opposite of <= is

>

As you can see in the following diagram, we see column GQ next to column A, and row 235 is next to row 1. How can this happen?

It is an effect of freezing panes

What would be a possible scenario where we use the following formula (that refers to the taxable column where "Yes" means taxable): =IF(E5="Yes", D5 + D5*7.5%, D5)?

Return the value plus 7.5% of the value if the item is taxable

What formula should be entered in cell D5 to calculate "Discount A" by multiplying the price (C5) with the discount amount in A14.

=$A$14*C5 (both row and column of A14 are locked so the reference does not shift when copied)

What formula should be entered in E10 (to calculate the total discount for "Discount B")?

=SUM(E5:E9)

In the diagram below, what will happen if we click on the Ok button of the dialog box? [Goal Seek: Set cell B7 to value 75 by changing $B$6]

Excel will change the value of B6

The words "Bears", "Dolphins" and "Whales" in the image below are called the chart's _______________

legend

A ____________ is a group of cells that form a rectangle on the screen.

cell range

Patrick has created a Bar Chart for his report, but his boss has asked him to use a Column Chart instead to represent the data range. Is it possible to do this?

Yes (right-click the chart, Change Chart Type, and select Column Chart — no need to recreate it)

In the following diagram, logarithms are calculated in column D using the numbers in column B with bases in column C. If cell D3 is selected, what formula would be displayed in the formula bar? NOTE: the name of the function to calculate logarithms in Excel is Log.

=Log(B3, C3) [South African Excel uses semicolon as argument separator: =Log(B3

C3)]

What feature did we use to quickly apply the formatting shown in the diagram below? [cells colour-coded and showing directional arrows based on value]

Conditional formatting

Which of the following is true about Public Key Encryption?

Anyone can encrypt with the public key and only one person can decrypt with the private key

What characters should you use for a password to make it strong?

All of the above (mixed-case letters, numbers, and special characters)

Cambridge Analytica is an example of a company that __________________

Both: used data obtained on false pretences AND did targeted political advertising on social media

Quoting Einstein on the importance of bees is an example of _________

argument from false authority (Einstein was a physicist, not an expert on bees or biology)

The POPI law __________________

Both: allows you to obtain information about yourself from the government AND from private companies

We have discussed in class the information processing path. Explain, in brief, how this model applies to a registration system when you provide information and documents, and you get a registration slip.

• Data: student details and documents submitted to officer • Input/Process: officer captures and validates data in the system • Output/Information: system generates and prints the registration slip

Sometimes, the officers use a tablet to process the registration. In such a case, explain whether the tablet the registrar officer uses is an input or output device.

Both: the touchscreen is an input device (officer types/taps data in) and the display is an output device (information is shown on screen)

Explain the purpose of using a sound card in computers, especially from a data representation point of view?

• Converts analog audio signals to digital binary data (ADC) for recording/input • Converts digital binary data back to analog audio (DAC) for playback/output • Bridges real-world analog sound and the computer's digital representation

Google has keywords that we can use together with our search strings to narrow the search. What keyword do we use for such a purpose? How do we issue our query to get information about the Graduate Recruitment Program from the Rhodes website?

• Keyword: site: operator • Full query: Graduate Recruitment Program site:ru.ac.za

In Microsoft Word, how do you change the Heading 1 style to Arial font, size 18, and apply it to all existing Heading 1 headings automatically?

Right-click Heading 1 in the Styles pane, select Modify, change font to Arial size 18, then choose "Update all instances" so every Heading 1 in the document updates

How do you format second-level headings (such as 3.1, 4.1) as Heading 2 in Word?

Select each second-level heading text, then click Heading 2 in the Styles pane

How do you insert a page break before a specific title in Word?

Place the cursor immediately before the title, then go to Insert tab and click Page Break (or press Ctrl+Enter)

How do you insert page numbers at the bottom centre of every page in Word?

Insert tab, Page Number, Bottom of Page, select the centred option

How do you move a paragraph to the end of a document in Word?

Select the paragraph, Cut (Ctrl+X), click at the very end of the document, then Paste (Ctrl+V)

How do you insert an image in Word, centre it, and add a figure caption below it?

Insert tab, Pictures, select image, set alignment to Centre, then right-click the image and choose Insert Caption, type the caption text

How do you justify all body paragraphs and add a first-line indent in Word?

Select all body text, click the Justify button, then open the Paragraph dialog and under Special set First Line indent

Write out 5 things you should NOT do in a PowerPoint presentation (bad ways to design slides).

• Do not crowd slides with excessive text • Do not use too many different fonts or clashing colours • Do not use excessive or distracting animations • Do not use poor contrast between text and background • Do not read slides verbatim to the audience

Explain how to create the following effect in PowerPoint: you click on a circle while presenting and it moves from the bottom left to the top right.

• Select the circle, go to Animations tab, click Add Animation, choose Motion Paths and draw or select a line path from bottom-left to top-right • Set the Start option to On Click • Test in Slide Show view

Use the Max function to retrieve the best mark from each student's test scores for column E.

=MAX(B3:D3) — replace range with all test-score columns for that row, then fill down

Use the Large function to get the second-best mark for column F.

=LARGE(B3:D3,2) — returns the 2nd largest value in the test score range for that row

Calculate the average Best 1 and Best 2 marks in cells E20 and F20 respectively.

=AVERAGE(E3:E17) in E20 and =AVERAGE(F3:F17) in F20

Write a formula that displays "DP" or "NDP" depending on whether the average of a student's Best 1 and Best 2 marks is 20 or above.

=IF(AVERAGE(E3:F3)>=20,"DP","NDP") — entered in G3 and filled down to G17

Using the compound interest formula A = P(1 + r/n)^(nt), write the Excel formula to calculate the final amount using values from the Age Salary Data worksheet.

=B6(1+C6/D6)^(D6E6) where B=P, C=r, D=n, E=t — adjust cell references to match the sheet layout, then fill down

How do you create a scatter plot for a data set in Excel?

Select the data range, go to Insert tab, choose Scatter chart, select Scatter with only markers

How do you add a chart title in Excel?

Click the chart, go to Chart Design or Layout tab, click Add Chart Element, Chart Title, type the title

How do you display the trendline equation on a scatter chart in Excel?

Right-click a data point, Add Trendline, then check "Display Equation on chart"

How do you estimate a salary for a person aged 22 using an Excel scatter chart trendline?

Read the equation displayed on the trendline (y = mx + b), substitute x = 22 to calculate the estimated salary value

Explain what Internet cookies do.

Small text files stored by the browser that track user activity, preferences, and session data across websites

Why do Internet cookies play a big role in online shopping?

• Track browsing history enabling targeted ads to follow users across sites • Remember shopping cart contents, login sessions, and user preferences between visits

Her friend Busisiwe advised her to use private browsing (incognito in Chrome browser). Give any two reasons why private browsing is recommended.

• Does not save cookies, history, or form data on the device after the session ends • Prevents other users on the same device from seeing browsing activity

In class you learned that there are six factors that you could use to judge the reliability of a website. Name four of them.

• Authority (who is the author) • Accuracy (is information verifiable) • Currency (how up-to-date is it) • Purpose or bias (why was the site created)

Explain briefly any three benefits of a social network.

• Connecting and communicating with friends and family globally • Rapid sharing of news and information • Professional networking and career opportunities

Explain briefly two reasons why one would use the Creative Commons licence.

• To share your work freely while retaining specific rights over how it is used • To legally allow others to use, share, or build on your work without needing individual permission

Explain briefly four rights the CC-BY-SA licence gives a user.

• Share: copy and redistribute the work in any medium • Adapt: remix, transform, and build upon the work • Attribution (BY): must credit the original creator • ShareAlike (SA): derivative works must carry the same licence

Explain briefly two reasons why you shouldn't install a program unless you know exactly what it does.

• Could contain malware or viruses that damage or take control of your system • Could secretly collect private data or install additional unwanted software without your knowledge

Using the cmd prompt, type in ipconfig. What does the IPv4 Address tell you and where is the Subnet Mask found?

• IPv4 Address: your computer's local network address (e.g. 192.168.x.x) shown under the active adapter • Subnet Mask: shown directly below IPv4 Address (commonly 255.255.255.0)

Using the cmd prompt, type in ping ru.ac.za. What does this command do?

Sends ICMP packets to ru.ac.za to test whether the host is reachable and reports round-trip time in milliseconds

Using the cmd prompt, type in systeminfo. Explain briefly why the Total Physical Memory and the Available Physical Memory values are different.

• The operating system and all currently running applications consume RAM • Available memory = Total RAM minus what is already in use by the OS and active processes

What are the steps to complete the Question 61 PowerPoint practical tasks (Covid and its Virus)?

• Create a new presentation with 5 slides and title it "Covid and its Virus" • Slide 2: Type a list of contents for the remaining slides • Slide 3: Insert the three provided PDF images and use the Align tool to align their tops • Slide 4: Add descriptive bullet points next to or under the images • Slide 5: Type out presentation conclusions • Save the file as your student number followed by "covid" (e.g., 21q12345covid.pptx)

In the Windows command prompt, how do you locate your specific IPv4 Address and Subnet Mask?

Type "ipconfig" and press Enter, then look under your active network adapter layout

In the Windows command prompt, how do you check your system's Total Memory, Available Memory, and Original Install Date?

Type "system info" and press Enter, then scroll down the text output to locate those specific labels