Subjects Covered: Fundamentals of Computing, Word Processing, Spreadsheet Management, and Database Management
SECTION A – OBJECTIVE TEST (With Answers)
1. A device that takes data from user and converts it into a form that can easily be understood by a computer is c. Input
2. A computer’s general-purpose software is basically a d. Application software
3. Data entered into the computer through keyboard and mouse is an example of c. Direct input
4. The intermediary between a computer hardware and software is d. System software
5. Colours that are contained by colour guns of computer screen are a. Red, green and blue
6. Information in computer’s read only memory (ROM) is stored by c. Manufacturer
7. Form of information which is written as a phrase or sentence is termed as c. Text
8. Group of bits in a memory which is used to represent information or data of some type is known as a. Byte
9. Computer hardware consists of d. All the above
10. The term used to describe physical components of a computer is c. Hardware
11. Who is the inventor of “Difference Engine” b. Charles Babbage
12. A CPU contains a b. Control unit and an arithmetic logic unit
13. The first computers were programmed using b. Machine language
14. Coded entries which are used to gain access to a computer system is called b. Passwords
15. You organize files by storing them in b. Folders
16. EBCDIC stands for a. Extended binary coded decimal interchange
17. What is embedded system? d. The computer and software system that control the machine
18. Where are data and programmes stored when the processor uses them? a. Main memory
19. ……… represents raw facts, whereas ……… is data made meaningful. b. Data, information
20. Chief components of first-generation computer is b. Vacuum tubes and valves
SECTION B – SPREADSHEET MANAGEMENT
- What is the difference between a row and column?
A row runs horizontally in a spreadsheet (e.g. Row 1, Row 2), while a column runs vertically (e.g. Column A, Column B). - What is a formula in spreadsheet management?
A formula is an expression that calculates the value of a cell. Example:=SUM(A1:A5)
SECTION B1 – DATABASE MANAGEMENT
List FIVE data types in database system:
- Text
- Number
- Date/Time
- Currency
- Boolean (Yes/No)
What is a Primary key?
A primary key is a unique identifier for each record in a database table.
Example: Student ID in a student records table.
SECTION B2 – WORD PROCESSING (PRACTICAL TASK)
COST IMPLICATION
Please, find below the cost breakdown of scope of work for this project, consisting of the cost for the equipment, IT infrastructure and training sub-heads.
Computers, Software and Networking:
| S/N | Description | Qty | Unit Price (GH₵) | Total Price (GH₵) |
|---|---|---|---|---|
| 1 | Campus Area Network Networking materials, Implementation & labour for Wireless 50 computer network | Lot | 350,000.00 | 350,000.00 |
| 2 | C – Band Internet Infrastructure with 1mbps/256 kbps Bandwidth - Modem 5w BUC, 2.4 Antenna, LNB, 1FL Cables; Installation, Activation, Transport, Concrete works | Lot | 1,650,000.00 | 1,650,000.00 |
INSTRUCTIONS:
- Type the document above
- Type using Times New Roman and set the font size to 12
- Make the main heading uppercase, bold and underline
- Use justify for the text alignment and center for heading
- Margin – Narrow
- Save your work as your name and index number
- Print your work
