Computer Studies Paper 1 Questions and Answers - Asumbi Girls Pre Mock Examinations 2023

Share via Whatsapp

Instructions to Candidates

  1. This Paper consists of two sections A and B.
  2. Answer ALL the questions in section A.
  3. 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

  1.                          
    1. Define the term computer booting. (1 mark)
    2. State three reasons that can make a user to warm boot a computer (3 marks)
  2. Direct data capture is one major way of inputting data into computers. State Three advantages for using an optical bar recognition. (3 marks)
  3. State the function of the following keyboard keys. (2 marks)
    1. Scroll Lock
    2. Num Lock
  4. Explain why powder and liquid fire extinguishers are not recommended in a computer laboratory. (2 marks)
  5. Distinguish between relative cell referencing and absolute cell referencing as used in computing giving an example in each case (2 marks)
  6. 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 ......................................................
  7. Describe each of the following computer cables
    1. Universal serial Bus cable (USB) (2 marks)
    2. Serial cable (2 marks)
  8.                          
    1. Define the term proofreading as used in word processing (1 mark)
    2. Name four types of proofreading tools used in word processing (2 marks)
  9. 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)
    1. Power sag
    2. Power surge
    3. Brownout
  10. Define the term networking as used in computing. (1 mark)
  11. Differentiate between softcopy output and hard copy output in computers. (2 marks)
  12. Explain the following monitor terminologies as used in computing. (3 marks)
    1. Resolution
    2. Color depth
    3. Pixels
  13. Differentiate between registers and Buses as used in computing. (2 marks)
  14. Explain the following types of memories . (2 marks)
    1. Buffer memory
    2. Cache memory
  15.                        
    1. Define the term troubleshooting as used in computing. (1 mark)
    2. 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

  1. 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.
    1. List two translating programs required to do that process. (2 marks)
    2. 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)
    3. 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.
      1. Write a pseudocode used to solve this problem. (5 marks)
      2. Draw a flowchart for the above program. (6 marks)
  2.                        
    1. Define the term data processing (1mk)
    2. Distinguish between the following sets of terms as used in data processing
      1. Indexed sequential and Serial file organization (2mks)
      2. Interactive and Batch processing modes (2mks)
      3. Master file and Report file (2mks)
    3. Explain Three computer crimes that compromise data integrity (6mks)
    4. Explain WORM with respect to viruses. (1mk)
    5. Identify the name given to the type of error that results from an arithmetic operation failing to produce an expected result (1mk)
  3.                        
    1. Describe how data is represented in an optical storage device. (2 marks)
    2.                          
      1. Convert the decimal number 38.62510 to binary (2 mrks)
      2. Convert the Hexadecimal number DA3.BC16 to Octal (2 mrks)
    3.                      
      1. Letter N is represented by 1001110 using a certain coding scheme. Identify the type of coding scheme used (1 mark)
      2. Using the same coding scheme named in C (i) above , show how letter K can be represented (2 marks)
    4. Using twos complements, 8-bit representation, subtract 4310 from 2710 giving your answer in decimal notation (5 marks)
    5. Using Binary coded decimal (BCD), find the value of 23410 (1 mark)
  4.                                    
    1. Explain the following functions of operating system
      1. Memory management (2mks)
      2. Input/Output management (2 marks)
    2. 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)
    3. Identify two ways in which operating system organizes information in a computer (2 marks)
    4. Distinguish between portability and authenticity in relation to computer software (2mks)
    5. 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

    6.                     
      1. Differentiate between Firmware and Utility software (2 marks)
      2. Name the application software used to create presentations inform of slides (1 mark)
  5. A school wishes to be connected to the internet to enhance its service delivery.
    1. State any two internet connectivity requirements that should be considered for the school to get connected. (2 marks)
    2. 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)
    3. The figure below shows an extract from compose e-mail window. Use it to answer questions that follow.
      20 c adadada
      1. Name the icon labeled X and explain its purpose in e-mail. (2 marks)
      2. Write in full the meaning of the abbreviations Cc and Bcc respectively. (1 mark)
    4. One advantage of a database management system is centralization of data and enforcement of integrity.
      1. Explain what is meant by enforcing integrity in databases. (1 mark)
      2. Identify the type of database models depicted in each of the figures Q and R below. (2 marks)
        Figure Q
        figure q adada
        Figure R
        figure r sda
    5.                  
      1. Define the following terms as used in desktop publishing. (2 marks)
        • Master page
        • Cropping
      2. State three factors considered when choosing a desktop publishing software. (3 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:

  • Resize the column heading  to fontsize 16 and applying bold.  
  • Applying  borders to all cells containing data. 
  • Grey background colour to all column headings

2

1

1

 

(g)   (i) Label % increment in cell A16 and a value 7 as percentage data

1

 

(ii) Inserting a column before Term1

  • Using absolute cell referencing =($C$16*C2)+C2 to calculate the total number of registrations for Term 3 2020.
  • Labelling the column as T3-2020.

½ 

2 

½

 

(h)   Using a function in cells B17 and B18 respectively determine:

  • Total registrations =COUNTIF(F2:F8,">1500")
  • Minimum number of registrations for Term 2 =MIN(D2:D8)

2

2

 

(i)     Copying data in sheet 1 to sheet 2
Rename it as Graph.

1

1

 

(j)     Creating bar graph and labeling as required

  • Chart title:                   Welfare Registrations 2021
  • Y-axis:                         Total Number of Registrations
  • X-axis                          School Name
  • Legend Position:         Right

1

 1

1

1

1

 

(k)   Printing

  • Reg 1 sheet.
  • CHART

1

1

 

TOTAL MARKS

50

 

 

 

QUESTION 1  -WORDPROCESSOR

MAX MARK

AWARDED

A

  • Creating WORD document  MYVISA
  • Typing of the  word document(Data entry
  • Strike through(1mk)
  • Bullets   (1mk)
  • Superscript/Subscript(2mks)
  • Logo        
    • Shapes(Stars/Banners/ellipse)    (3mks)
    • Shape fillS/Grouping

                                                                                                             TOTAL

1

05

01

01

02

03

03 

16MKS

 

  • Footer
  • Presence/acccuracy

02

 

B

  • Alignment   :Centre                                                                                                
  •         Font style    :   Algerian
  •         Font size      : 16

01

01

01

 

 C. Dropcap

  • Presence
  • Drop by 4 lines

01 

01

 

d Margins 

  • Top 1.0cm
  • Left 1.0 cm

02

 

E

  • Line spacing columns

01

02

 

  F Table

  • 4 rows/3colums
  • Data entry on the table

01 

04

 

 G Correct formular for:

  •  Total
  • average

02

02

 

h.

  • Data source table
  • 7columns/4 rows
  • Table data entry
  • Saving as CC

 

01

 

03

01

 

i

  • Automated mail merging with 3 documents
  • Saving MYVISACC

04

01

 

j

  • Page numbers
  • Top tight

01

01

 

 

k.

  • MY VISA
  • MYVISACC addressed to Mukami Faith

 

01

01

 

TOTAL MARKS

50

 

 

Join our whatsapp group for latest updates

Download Computer Studies Paper 1 Questions and Answers - Asumbi Girls Pre Mock Examinations 2023.


Tap Here to Download for 50/-




Why download?

  • ✔ To read offline at any time.
  • ✔ To Print at your convenience
  • ✔ Share Easily with Friends / Students


Get on WhatsApp Download as PDF
.
Subscribe now

access all the content at an affordable rate
or
Buy any individual paper or notes as a pdf via MPESA
and get it sent to you via WhatsApp

 

What does our community say about us?