Instructions to Candidates
- This Paper consists of two sections A and B.
- Answer ALL the questions in section A.
- Answer question 16 (compulsory) and any other THREE questions from section B.
FOR EXAMINER’S USE ONLY
Section |
Questions |
Candidate’s score |
A |
1-15 |
|
B |
16 |
|
17 |
|
|
18 |
|
|
19 |
|
|
20 |
|
|
TOTAL SCORE |
|
QUESTIONS
Section A (40 Marks).
Answer all questions in the spaces provided
-
- Define the term computer booting. (1 mark)
- State three reasons that can make a user to warm boot a computer (3 marks)
- Direct data capture is one major way of inputting data into computers. State Three advantages for using an optical bar recognition. (3 marks)
- State the function of the following keyboard keys. (2 marks)
- Scroll Lock
- Num Lock
- Explain why powder and liquid fire extinguishers are not recommended in a computer laboratory. (2 marks)
- Distinguish between relative cell referencing and absolute cell referencing as used in computing giving an example in each case (2 marks)
- Computer technology has evolved from the first to the fifth generation computers. Name the technology, memory and programming language used in the 2nd generation computer. (3 marks)
Technology ......................................................
Memory ......................................................
programming language ...................................................... - Describe each of the following computer cables
- Universal serial Bus cable (USB) (2 marks)
- Serial cable (2 marks)
-
- Define the term proofreading as used in word processing (1 mark)
- Name four types of proofreading tools used in word processing (2 marks)
- A computer system needs a stable power supply. To filter out power problems such as black out, brownout, power surge and power sag, connect your computer to an interruptible power supply (UPS).
What do you understand by the following terms? (3 marks)- Power sag
- Power surge
- Brownout
- Define the term networking as used in computing. (1 mark)
- Differentiate between softcopy output and hard copy output in computers. (2 marks)
- Explain the following monitor terminologies as used in computing. (3 marks)
- Resolution
- Color depth
- Pixels
- Differentiate between registers and Buses as used in computing. (2 marks)
- Explain the following types of memories . (2 marks)
- Buffer memory
- Cache memory
-
- Define the term troubleshooting as used in computing. (1 mark)
- State Three problems that may be experienced when using windows operating system (3 mrks)
Section B (60 Marks).
Answer Question 16 and Any Other Three Questions from this Section
- While developing software, the source code must be converted to object code, so that the computer can understand and execute the instructions; that process is called translation.
- List two translating programs required to do that process. (2 marks)
- State two reasons why some programming experts prefer low-level languages over high-level languages while developing programs for use in a computer. (2 marks)
- A MOKASA class sat for a test in eight subjects. A student must get an average of 60% in all subjects in order to pass. A program is needed to accept data, process and generate a report that will show the name, marks obtained by each student per subject, the average mark and whether the student has passed or failed.
- Write a pseudocode used to solve this problem. (5 marks)
- Draw a flowchart for the above program. (6 marks)
-
- Define the term data processing (1mk)
- Distinguish between the following sets of terms as used in data processing
- Indexed sequential and Serial file organization (2mks)
- Interactive and Batch processing modes (2mks)
- Master file and Report file (2mks)
- Explain Three computer crimes that compromise data integrity (6mks)
- Explain WORM with respect to viruses. (1mk)
- Identify the name given to the type of error that results from an arithmetic operation failing to produce an expected result (1mk)
-
- Describe how data is represented in an optical storage device. (2 marks)
-
- Convert the decimal number 38.62510 to binary (2 mrks)
- Convert the Hexadecimal number DA3.BC16 to Octal (2 mrks)
-
- Letter N is represented by 1001110 using a certain coding scheme. Identify the type of coding scheme used (1 mark)
- Using the same coding scheme named in C (i) above , show how letter K can be represented (2 marks)
- Using twos complements, 8-bit representation, subtract 4310 from 2710 giving your answer in decimal notation (5 marks)
- Using Binary coded decimal (BCD), find the value of 23410 (1 mark)
-
- Explain the following functions of operating system
- Memory management (2mks)
- Input/Output management (2 marks)
- Maria, the school secretary prefers to compress her disk instead of using it in its original form. Give Two reasons for her preference (2 marks)
- Identify two ways in which operating system organizes information in a computer (2 marks)
- Distinguish between portability and authenticity in relation to computer software (2mks)
- A file is a group of related data designated by file name and the extension. The table below shows the file extension and the description of the file. Fill the blank spaces (2 marks)
File extension
File description
.Sys
System file containing commands loaded during boot up
.txt
___________________________________________________
_______________
Ms-word document file
-
- Differentiate between Firmware and Utility software (2 marks)
- Name the application software used to create presentations inform of slides (1 mark)
- Explain the following functions of operating system
- A school wishes to be connected to the internet to enhance its service delivery.
- State any two internet connectivity requirements that should be considered for the school to get connected. (2 marks)
- Nashipae wants to download a music album from a website to her computer. State two factors that determine the time taken to complete the download. (2 marks)
- The figure below shows an extract from compose e-mail window. Use it to answer questions that follow.
- Name the icon labeled X and explain its purpose in e-mail. (2 marks)
- Write in full the meaning of the abbreviations Cc and Bcc respectively. (1 mark)
- One advantage of a database management system is centralization of data and enforcement of integrity.
- Explain what is meant by enforcing integrity in databases. (1 mark)
- Identify the type of database models depicted in each of the figures Q and R below. (2 marks)
Figure Q
Figure R
-
- Define the following terms as used in desktop publishing. (2 marks)
- Master page
- Cropping
- State three factors considered when choosing a desktop publishing software. (3 marks)
- Define the following terms as used in desktop publishing. (2 marks)
MARKING SCHEME
QUESTION 1 - SPREADSHEET |
MAX MARK |
AWARDED |
(a) (i) Creating spreadsheet file named WELFARE REG (ii) Data entry (appropriate) |
1 14 |
|
(b) Use of SUM function in column E2 (i) E2=sum(B2:D2) Total registrations per school (ii) Total registrations per term B9=sum(B9:D9) |
3 3 |
|
(c) Computing average number of registrations for each term in column F USING formula =(B2+C2+D2)/2 |
2 |
|
(d) Renaming the sheet 1 as Reg 1. |
1 |
|
(e) (i) Using the “IF” function to display comments: =IF(F2>=1500,"Optimum",IF(F2>=700,"Fair",IF(F2<700,"Too low"))) (ii) Using the COUNTIF function to display the number of schools who managed to have a fair registration =COUNTIF(G2:GF8,">1500") |
4 1 |
|
(f) Formating worksheet 1 (Reg 1) as follows:
|
2 1 1 |
|
(g) (i) Label % increment in cell A16 and a value 7 as percentage data |
1 |
|
(ii) Inserting a column before Term1
|
½ 2 ½ |
|
(h) Using a function in cells B17 and B18 respectively determine:
|
2 2 |
|
(i) Copying data in sheet 1 to sheet 2 |
1 1 |
|
(j) Creating bar graph and labeling as required
|
1 1 1 1 1 |
|
(k) Printing
|
1 1 |
|
TOTAL MARKS |
50 |
|
QUESTION 1 -WORDPROCESSOR |
MAX MARK |
AWARDED |
A
TOTAL |
1 05 01 01 02 03 03 16MKS |
|
|
02 |
|
B
|
01 01 01 |
|
C. Dropcap
|
01 01 |
|
d Margins
|
02 |
|
E
|
01 02 |
|
F Table
|
01 04 |
|
G Correct formular for:
|
02 02 |
|
h.
|
01
03 01 |
|
i
|
04 01 |
|
j
|
01 01
|
|
k.
|
01 01 |
|
TOTAL MARKS |
50 |
|
Download Computer Studies Paper 1 Questions and Answers - Asumbi Girls Pre Mock Examinations 2023.
Tap Here to Download for 50/-
Get on WhatsApp for 50/-
Why download?
- ✔ To read offline at any time.
- ✔ To Print at your convenience
- ✔ Share Easily with Friends / Students