ICT 101 JUNE FINAL 2019

Data is _____________________.

computer-readable representation of items (data requires processing/interpretation to become meaningful information)

Software _____________________

None of the above (software is NOT the same as a computer program alone, can be used by ordinary users, and is not limited to ordinary users)

Pseudo-code is _____________________

used to express an algorithm (it is a human-readable, informal notation for describing algorithm steps, not executable code)

Flash memory (random access memory) is an example of _________________

persistent memory (flash memory retains data without power — unlike SRAM/DRAM which are volatile)

Computer designers choosing between serial and parallel data transfer, prefer _____________________

serial because it eliminates cross-talk (parallel lines running close together can interfere with each other

modern high-speed designs favour serial)

A power supply unit (PSU) __________________

None of the above (a PSU converts mains AC to DC for the computer but does NOT contain a battery and cannot keep the computer running when power is off — that is a UPS)

Numbers in a computer are expressed in binary because __________________

Both b. and c. are correct (ones and zeroes can be thought of as true and false values AND base two is easier for humans than base ten)

A file name ending in .pdf can contain __________________

a mix of text and images (PDF is a fixed-layout format that can embed text, images, vector graphics, and other media together)

Backwards compatibility means __________________

software that can open recent as well as older types of files

On Windows, a storage device in a path __________________

Both b. and c. are correct (represented by a single letter and colon like C: AND this is the start of the absolute path for a file on the local machine)

A typist who is skilled in typing in France who visits South Africa __________________

Both b. and c. are correct (will have problems because special keys they need are not on the keyboard AND will have problems because the keyboard layout is different)

You want to quote someone's exact words in an essay

this is __________________

Both a. and b. are correct (OK as long as you use quote marks AND OK if you cite a reference — but not OK if most of your document is quotes)

If a URL starts with https __________________

Both a. and c. are correct (a padlock should be displayed next to the URL AND a digital certificate contains a key to allow encryption)

What is a motion path in PowerPoint?

A method of moving items on a slide

What is a trigger, in the context of animations in PowerPoint?

An item on the slide that performs an action when clicked

How can we create a uniform appearance by adding a background image to all PowerPoint slides?

By editing the Slide Master

In Paint.net, what tool should you first use when cropping a photo?

Rectangle Select

Image editing is about all of the following, except __________________

incorporating a transition (transitions are a PowerPoint slide feature, not an image editing operation)

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

None of the above (brightness and contrast, curves, hue and saturation, and levels are all valid colour adjustment tools in Paint.net)

All of the following are true of PowerPoint, except __________________

it is flexible and portable across different platforms (PowerPoint files can have compatibility issues across platforms and versions

this is the least accurate claim)

In Paint.net, the brightness of an image can be achieved through the __________________

Adjustments menu

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

Click slide 7, Shift-click slide 10, press delete

You can edit an embedded organisation chart in PowerPoint by __________________

Both a. and c. are correct (double clicking the organisation chart object AND right clicking the chart object then clicking MS organisation chart object)

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

Through Slide Sorter View

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

From Insert Menu, choose Duplicate Slide

What are the steps to insert slide numbers in PowerPoint?

Choose Insert, then Slide number

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

click the Play Button

Which is the way to name a slide?

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

You can create a new presentation by completing all of the following except __________________

clicking File, Open (this opens an existing file, not a new presentation)

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 add timing to slides)

The boxes that are displayed to indicate the text, pictures or objects are placed in it are called __________________

Placeholder

In PowerPoint the arrangement of elements such as Title and subtitle text, pictures, tables, etc, is known as:

Layout

Propaganda is information that is __________________

Both b. and c. are correct (sometimes true AND deliberately misleading)

An Internet meme is __________________

Both b. and c. are correct (largely spread by social connections AND not always true)

Information on the web __________________

Both b. and c. are correct (needs to be verified AND is only always correct if from a trusted source)

The anti-vax (anti-vaccination) movement is an example of __________________

a false meme (it is misinformation that spreads virally despite being contradicted by scientific evidence)

The invention of the microprocessor made possible __________________

Personal computers

The PoPI Act __________________

Both a and c are correct (allows you to correct inaccurate information about yourself AND prevents information about you being used in a new way without your permission)

Consistency in user interfaces is __________________

Both b and c are correct (important within one program or app AND important across different programs or apps)

In order to copy a formula to adjacent cells you must ________________

left click on the lower right corner and drag it to the desired cells (this uses the fill handle)

MS Excel uniquely identifies cells within a worksheet with ________________

column letters and row numbers (e.g. cell B5 = column B, row 5)

You can use the formula palette to __________________

create and edit formula containing functions

The opposite of > is _____

Which statement is the most correct?

A column in a worksheet is identified by a letter (columns use letters A, B, C… AA, AB… etc.)

The number 12510 (125 in decimal) is expressed in binary (base 2) as ________

11111012 (64+32+16+8+4+0+1 = 125)

What formula must be typed into cell P2 that it can be dragged into cells P3 to P59 so that it will calculate the total marks each student got for the practicals?

=SUM(F2:O2) — sums across the practical columns in the same row

dragging down adjusts the row number automatically

What formula must be typed into cell Q2 that it can be dragged into cells Q3 to Q59 so that it will calculate the percentage that each student got for the practicals?

=P2/P$2% — P2 is the student's total, P$2 locks row 2 as the reference denominator when dragging down

The final mark achieved consists of 20% of the practical mark, plus 30% of the test marks, plus 50% of the exam mark. What formula should be typed into cell AB2 so that it can be dragged into cells AB3 to AB59 and will calculate the final percentage that each student achieved?

=Q20.2+Y20.3+AA2*0.5

What formula should be typed into cell F60 so that it can be dragged into cells G60 to AB60 so that it will calculate the average of each column?

=AVERAGE(F3:F59)

The overall class average for the course is ___________. (select the closest answer)

60%

The number of students that got 75% or above for the course is ___________. (select the closest answer)

14

The number of students that got 50% or more but less than 75% for the course is __________________. (select the closest answer)

21

The lecturer decides that the marks for Test 2 must be adjusted so that the test is scored out of 40. In which cell must the value 40 be entered?

T2

Sort the sheet alphabetically by Surname. If needed, use First Names too. What is the final mark of the person who is at the very bottom of the classlist? (select the closest answer)

50%

The equation for the trend line is __________. (select the closest one)

4x + 3

The value for R2 is ________. (select the closest one):

0.85

What are the steps to complete the Question 67 PowerPoint medicinal plant assignment?

Create a 5-slide design theme presentation with table of contents, bottom-aligned grouped images, leaves/roots text description layout placeholders, and customized rehearse timings saved as student metadata