MULTIPLE CHOICE QUESTIONS/ SHORT ANSWER

OUTPUT DEVICES are hardware components that get processed information out of a computer.

Eg: to a printer, computer screen, or even to speakers.

INPUT DEVICES are hardware components that get data into a computer.

Examples: A mouse, a keyboard, and a scanner are all input devices.

TYPES OF COMPUTERS

1. Embedded Computer - used in automobiles for controlling functions like engine management and consumer electronics for managing device operations

2. Personal Computer

3. Desktop Computer

4. Mainframes

5. Supercomputers

TRUE/FALSE - A laptop is a form of personal computer

COMPONENTS OF A PROCESSOR (CPU)

• The CU (Control Unit) - Directs the operations of the CPU

• ALU (Arithmetic logic Unit) - Performs calculations and logic operations 

MEMORY is a form of storage that enables a computer to temporarily store instructions and data.

EPROM (Erasable Programmable ROM): Can be programmed more than once by ultraviolet rays

IS RAM NON-VOLATILE? No, Ram is volatile

VOLATILE MEMORY is temporary and loses its contents when the power to the computer is turned off

IPOS CYCLE represents the four basic tasks of any computer

BACKUP PROCESS refers to the process of creating copies of important files and storing them in a secure location to protect against data loss.

HOW MANY MEGABYTE MAKE A KILOBYTE? 1024 MB

DIRECT INPUT: Barcode reader

SYSTEM SOFTWARE VS APPLICATION SOFTWARE: System software controls hardware and how all other software works, while application software is any program that allows the computer to carry out one or more task

A PIVOT TABLE is a tool that allows you to quickly summarize data in a spreadsheet.

STEPS OF CREATING A PIVOT TABLE:

1. Highlight the cell where you would like to create the pivot table

2. Select the Insert tab from the toolbar

3. In the table screen click on the pivot table button

4. A window called ‘Create Pivot Table’ appears. Select the range of data to be used in the pivot table

5. Click on the OK button

6. Choose the fields to add

GUI (GRAPHICAL USER INTERFACE) is the common user interface that deals with graphical representation.

CLI (COMMAND LINE INTERFACE) is a text-based interface used for interacting with a computer system or software

MENU DRIVEN INTERFACE allows users to control the computer by using commands and available options from a menu.

SECONDARY STORAGE EXAMPLES INCLUDE: HDD (Hard Disk Drives), USB flash drives, DVD Drives

DATA VS INFORMATION: Data consists of raw (unprocessed) material, whereas information is processed data

A HUMAN READABLE DOCUMENT is a document that can be read by humans but is not in a form that the computer can readily accept.

A TURNAROUND DOCUMENT is a computer-generated form that is filled out, sent out, and returned to the computer.

VERIFICATION is double-checking for errors with the data.

VALIDATION is the computerized checking of input data for errors before it is processed.

TRUE/FALSE Range check is a form of verification.

SERIAL DATA ACCESS means data is sent or received bit by bit in a continuous stream over a single communication channel or wire

RANDOM FILE ACCESS allows you to quickly access any part of a file without having to go through all the preceding data.

TRUE/FALSE Random file access is the fastest access

A COMPUTER NETWORK is a collection of interconnected computers that allows them to communicate, share resources like data and applications, and work together efficiently.

TYPES OF COMPUTER NETWORKS:

1. PAN (Personal area network)

2. LAN (local area network)

3. WAN (Wide area network)

4. MAN (Metropolitan area network)

TRUE/FALSE wireless communication is ungiven

TRUE/FALSE I have access to onedrive. One drive is useless in the case where connectivity is limited.

RELATIVE VS ABSOLUTE CELL REFERENCE: Relative cell references change when a formula is copied or moved, while absolute cell references stay fixed to a specific cell.

CLOUD STORAGE is the process of storing digital data in an online space that spans multiple servers and locations. It is usually maintained by a hosting provider: iCloud, Google Drive

ADVANTAGES:

• Disaster recovery: provides a backup in the case of a disaster

• Data retrieval: Data can be accessed virtually anywhere on any device

• Collaboration ability: By accessing the same information, teams can work together

DISADVANTAGES:

• Host Trust: There is a third-party involved so privacy is not secure

• Internet is needed

LOCAL STORAGE is the process of storing digital data on physical storage devices, such as HDDs (Hard Disk Drives) and SSDs (Solid State Drives) or external storage devices, such as thumb drives or discs.

ADVANTAGES:

• Speed: Accessing data is much quicker than uploading and downloading from cloud

• Security Control: You have complete control over how data is stored

DISADVANTAGES:

• No internet access needed

• Cost: More expensive

• Complete control comes with accessibility

• Local backups would be destroyed in an off-site disaster

GPS means Global Positioning System

WIFI means Wireless Fidelity

STRUCTURED QUESTIONS (50 MRKS)

MICROSOFT WORD QUESTIONS

URLs are specific addresses used to access internet resources.

LINKS are clickable elements on web pages that navigate users to other pages or resources.

WEB ADDRESSES are URLs that pinpoint the location of content on the internet.

WHAT ARE THE MEANINGS OF:

• FTP: File Transfer Protocol

• HTML: Hypertext Markup Language

• HTTP: Hypertext Transfer Protocol

ENCRYPTION is the process of converting readable data (plaintext) into a secret code (ciphertext) using a mathematical algorithm and a key. This ensures that only authorized parties can decode and read the original data.

TEXT FORMATTING FEATURES IN WORD: Bold, Italic, Underline

THE FOUR ALIGNMENT IN WORD: Right, Center, Left, Justify

DATABASE QUESTION

TYPES OF DATA TYPE INCLUDE:

• Text- words, precisely a sequence of alphanumeric characters

• Numeric- numbers can be integer (whole numbers) or real (decimal numbers)

• Logical- true or false, sometimes known as Boolean or Yes/No

• Currency- monetary values

• Date/time - various formats for holding the date and time

FOREIGN KEY appears in a table where it doesn't really belong but allows two tables to be linked

A QUERY IS a concise command used to retrieve or manipulate data stored in a database, typically written in SQL.

A RELATIONSHIP defines how tables are connected based on common keys

A PIECHART visually represents the proportion of different categories within a dataset.

IN WHAT CASE DO YOU USE PIE CHART? Pie charts are typically used in databases when you want to visually represent the proportional distribution of categorical data.

BAR GRAPH VS COLUMN GRAPH A bar graph has horizontal bars, while a column graph has vertical bars

SPREADSHEET QUESTIONS

WHICH TAB IN A SPREADSHEET IS USED TO SORT A TABLE? Data Tab & Home Tab

HOME TAB IN SPREADSHEETS contains essential tools for formatting text, aligning cells, applying borders and fills, and basic editing functions.

DATA TAB IN SPREADSHEETS provides tools for sorting, filtering, analyzing, and managing data within tables or ranges.

SORTING DATA is the arranging of data in an ordered sequence. It systematically arranges data in groups; separated according to type.

WAYS TO SORT: General sort, Custom sort, Multi-level sort

FILTERING DATA is the separation of specific data from a data set.

WAYS TO FILTER DATA include general filter & advanced filter

GENERAL FILTER STEPS

1. Highlight data table

2. Selecting sort and filtering

3. Select the column using the arrow down.

4. Selecting based on criteria.

ADVANCED FILTER STEPS

1. Create a criteria

2. Select advance filter

3. Complete criteria listing (data set, criteria

UNFILTERING DATA means displaying the entire dataset without any applied filters, showing all rows of data.