Computer Studies P1 Questions and Answers - Wisdom Pre-Mock Form 4 Exams 2021/2022

INSTRUCTIONS TO CANDIDATES

• Write your Name, Class, Admission Number and Index Number in the spaces provided.
• Answer ALL the questions in section A
• Answer question 16 (Compulsory) and any other three questions from section B.

For Official Use Only

Questions

SECTION A: (40 MARKS)
ANSWER ALL QUESTIONS IN THIS SECTION

1.                          
   1. State any two types of data processing methods (1 mark)
   2. During a visit to the typing room, Jane a computer student observed a type of printer that uses a beam to create an image on a rotating drum. As the beam hits the drum, some regions attract ink toner particles. The toner is then fused onto a piece of paper.
      1. State the name of this type of printer and indicate whether it is an impact or non-impact printer. (1 mark)
      2. List two advantages of using the printer mentioned in a. above. (2 marks)
2. Bunamfan Water Company sends out field officers to take consumer meter readings. The data collected by the officers is then keyed into the computer. The system then generates utility bills which are printed and sent to the consumers.
   1. State two transcription errors that are likely to occur during meter reading or input (2 marks)
   2. State two ways such errors can be avoided (1 mark)
   3. State the type of processing carried out (1 mark)
3. Highlight the dangers associated with the following in a computer laboratory set up:
   1. High humidity in the computer laboratory (1mark)
   2. Purchasing software before assessing requirements (1mark)
   3. Using foreign flash disks on the computer. (1mark)
   4. Entering the computer lab with food (1 mark)
4.                            
   1. Mention at least two trends in the technological revolution of computers. (1 mark)
   2. To process an instruction, the CPU goes through a cycle of three stages. Name each of the stages. (3 marks)
5.                          
   1. Explain the importance of the following spreadsheet operations. (2 marks)
      1. Freezing columns
      2. Data validation
   2. Name two types of relationships that can be applied in database design. (2 marks)
6. Briefly explain any four block operations that can be performed on data in word processing (4 marks)
7.                          
   1. Mutiso wanted to upgrade the RAM of his computer. State two factors Mutiso should consider when purchasing a RAM module. (2 marks)
   2. Define the following terms: (2 marks)
      1. Computer Port
      2. Power supply unit
8. Mkulima Bora is a society that embraced E-Commerce recently. The manager is convinced that there is illegal access to the company’s system. State TWO ways in which the society can overcome this problem. (2 marks)
9.                            
   1. Study the diagram below and answer the questions that follow.
      
      
      1. Name the communication media depicted in the above diagram (1 mark)
      2. Name the parts labelled A, B, C, and D (3 marks)
         A____________________________________________________________________
         B ___________________________________________________________________
         C ___________________________________________________________________
         D ___________________________________________________________________
10. In a desktop publishing document, an image embedded can be transformed in various ways. Name any three ways one can use to make the image fit in a designated area. (3 marks)
11. Differentiate between source program and object program. (2 marks)
12. Differentiate between the following terms in Internet (4 marks)
    1. Drafts and outbox
    2. cc and bcc
13. State two characteristics of a computer that is infected by computer viruses. (2 marks)
14. Identify each of the following symbols as used in system flowchart . (1 mark)
    
15. Differentiate between bullets and numbering as used in DTP. (2 marks) 

SECTION B (60 MARKS)
Answer question 16 and any other three questions from this section in the spaces provided.

16.                                        
    1. State any three activities that occur in a program compilation process. (3 marks)
    2. A program is needed for calculating the average age of students in a class. Write a pseudocode that will read the age of the students and calculate the average age. The program should terminate if the value of 999 is entered for age and output the number of times the statements within the loop were executed. (10 marks)
    3. Give two types of errors that may be detected during program testing (2 marks)
17.                                
    1. State four functions which are specific to Network Operating Systems (4 marks)
    2. State two advantage of using fibre optic cables over satellite in data communication. (2marks)
    3.                              
       1. The figure below shows how data is transmitted through a public telephone line .(4 marks)
          
          Name A, B, C, and D
    4.                              
       1. List any two items that may be referred to as data terminal equipments in a network .(2 marks)
       2. Write the acronym MODEM in full (1 mark)
       3. Explain the purpose of a modem when connecting to the internet (2 marks)
18.                                      
    1. State THREE roles of a programmer in system development life cycle. (3 marks)
    2. State four activities that may be carried out when disposing off an old system in an organization. (4 marks)
    3. Distinguish parallel changes over from straight change over as used in system implementation. (2 marks)
    4. Discuss any two fact finding methods. (4 marks)
    5. Differentiate between an open system and a closed system. (2 marks)
19.                  
    1. State three standard coding scheme used computing and electronic systems. (3 marks)
    2. Convert each of the following numbers
       1. 1001.001₂ to octal. (2marks)
       2. 125.5₁₀ to hexadecimal. (3marks)
       3. Add 1100.011₂ to 11001.0101₂ and leave your answer in decimal (3 marks)
    3. Using two compliments perform the following arithmetic leaving your answer in binary form. (4 marks
       13₁₀ - 15₁₀
20.                                
    1. Distinguish between axis labels and data labels as used in spreadsheets. (2 marks)
    2. Name an electronic spreadsheet feature that allows one to perform the following actions. (4 marks)
       

       Action	Feature
       Provide pictorial summary of data
       Make one cell out of many
       List items from Highest to lowest or vice versa
       Make many cells out of one

    3. Explain the difference between the printing of multiple pages and multiple copies as used in word processing (2 marks)
    4. Describe the following categories of software (4 marks)
       1. Firmware
       2. Proprietary software
    5. Explain the meaning of solid state storage media giving TWO examples of it.(3 marks)

MARKING SCHEME

1.                              
   1. State any two types of data processing methods (1mark)
      1. Manual
      2. Mechanical
      3. Electronic
         (any two @ ½ mark )
   2. During a visit to the typing room, Jane a computer student observed a type of printer that uses a beam to create an image on a rotating drum. As the beam hits the drum, some regions attract ink toner particles. The toner is then fused onto a piece of paper.
      1. State the name of this type of printer and indicate whether it is an impact or non-impact printer. (1mark)
         Laser printer / Non Impact (both correct @ 1mark)
      2. List two advantages of using the printer mentioned in a. above. (2marks)
         High quality print out
         Speed of printing is fast
         The cost per page of toner catridges is lower than other printers
         (any two @ 1)
2. Bunam Water Company sends out field officers to take consumer meter readings. The data collected by the officers is then keyed into the computer. The system then generates utility bills which are printed and sent to the consumers.
   1. State two transcription errors that are likely to occur during meter reading or input (2 marks)
      • Transposition
      • Misreading
        (both 2 @ 2marks)
   2. State two ways such errors can be avoided (1 mark)
      • Design user interfaces that minimize chances of invalid data entry.
      • Using error detection and correction software when transmitting data.
      • Using devices that capture data directly from the source. E.g. digital cameras, optical character readers
        (any 2 @ 2 marks)
   3. State the type of processing carried out (1 mark)
      • Batch processing
        (correct @ 1 mark)
3. Highlight the dangers associated with the following in a computer laboratory set up:
   1. High humidity in the computer laboratory (1mark)
      • Rusting of the parts of the metallic computer (correct @ 1mk)
   2. Purchasing software before assessing requirements (1mark)
      • May be a pirated software (correct @ 1mk)
   3. Using foreign flash disks on the computer. (1mark)
      • Spread of viruses (correct @ 1mk)
   4. Entering the computer lab with food (1 mark)
      • Clogging of keys if food particles fall on keyboard (correct @ 1mk)
4.                    
   1. Mention at least two trends in the technological revolution of computers (1 mark)
      1. Continual decrease in computer size
      2. Improved speed and power of processing
      3. Decrease in computer physical size and its related facilities cost (any 2 @ ½ mark)
   2. To process an instruction, the CPU goes through a cycle of three stages. Name each of the stages. (3 marks)
      • Fetch
      • Decode
      • Execute
        (correct@ 3 marks)
5.                    
   1. Explain the importance of the following spreadsheet operations. ( 2 marks)
      1. Freezing columns
         • It enable the use to view only required records at a time
           ( correct @ 1mark)
      2. Data validation
         • Ensures the records are valid as per the user need
           (correct @ 1 mark)
   2. Name two types of relationships that can be applied in database design. (2 marks)
      • One to one
      • One to many
      • Many to many
        (any 2 @ 1 mark)
6. Briefly explain any Four block operations that can be performed on data in word processing (4 marks)
   • copying text- creating duplicate copy of the specific text
   • moving text- transferring text to a new location
   • deleting text-Erasing the specific block of text
   • formatting text- to apply a formatting feature like, bold, italics, underline, change style etc
   • Columns- applying columns to the specific text selected
   • Applying bullets and numbering
     (state @1, explain @1mark)
7.                              
   1. Mutiso wanted to upgrade the RAM of his computer. State two factors Mutiso should consider when purchasing a RAM module. (2 marks)
      • Memory capacity of the module
      • Compatibility with the current modules
      • Availability of an empty slot
      • The type of module supported by the motherboard
   2. Define the following terms: (2 marks)
      1. Computer Port
         • Is a special kind of connector or socket on the system unit which a cable from an external peripheral device is plugged to facilitate transfer of data/information
           (correct @ 1 mark)
      2. Power supply unit
         • Is a special unit inside the system unit that supplies power to the motherboard and other internal devices
           (correct @ 1 mark)
8. Mkulima Bora is a society that embraced E-Commerce recently. The manager is convinced that there is illegal access to the company’s system. State TWO ways in which the society can overcome this problem. (2 marks)
   • Encryption
   • Firewall
   • User profile/password/user accounts
   • Limit the number of log-in attempts
   • Audit trail/tracking
9.                            
   1. Study the diagram below and answer the questions that follow.
      1. Name the communication media depicted in the above diagram (1 mark)
         • Satellite communication
      2. Name the parts labelled A, B, C, and D (3 marks)
         • A- Receiving earth station
         • B - Satellite in space
         • C - Down link
         • D - Up link
10. In a desktop publishing document, an image embedded can be transformed in various ways. Name any three ways one can use to make the image fit in a designated area. (3 marks)
    • Rotation
    • Flipping
    • Cropping/trimming/cutting/chopping
    • Stretching/Enlarging/Increasing
    • Squeezing/reducing/shrinking
    • Resizing
11. Differentiate between source program and object program (2 marks)
    • Source code are instructions that a programmer created when writing a program/instructions in the high level language while object code refers to machine language code that is output by a compiler or assembler
    • A translator converts source code to object code
12. Differentiate between the following terms in Internet (4 marks)
    1. Drafts and outbox
       • Drafts contain e-mails that are being worked on and are not yet ready to be sent while outbox contains e-mails that are waiting to be sent.
    2. cc and bcc
       • cc, the recipients of the mail are able to see who else received the mail while bcc, the recipients of the mail are not able to see who else received the mail
13. State two characteristics of a computer that is infected by computer viruses (2 marks)
    • Loss of data
    • Change in file sizes
    • Slower than normal program operation
    • Unusual and frequent error messages
    • System crash
    • Taking long to load/booting
14. Identify each of the following symbols as used in system flowchart (1 mark)
    
15. Differentiate between bullets and numbering as used in DTP (2 marks)
    • Bullets are used to create an unordered list while numbering is used to create an ordered list.
      NB: Accept correctly labelled illustrations.
16.                        
    1. State any three activities that occur in a program compilation process (3 marks)
       • Program code converted into machine language (translation of source program to object code) Program is debugged (checked for syntax errors)
       • Executable format of file is created
       • Testing of the program
    2. A program is needed for calculating the average age of students in a class. Write a pseudocode that will read the age of the students and calculate the average age. The program should terminate if the value of 999 is entered for age and output the number of times the statements within the loop were executed. (10 marks)
       START ½
       SUM = 0 ½
       COUNT = 0 ½
       PRINT “ENTER AGE”
       READ AGE 1
       WHILE AGE<>999 DO 1
       SUM = SUM + AGE 1
       COUNT = COUNT + 1 1
       PRINT “ENTER AGE”
       READ AGE
       ENDWHILE
       AVERAGE = SUM / COUNT 1
       PRINT COUNT 1
       PRINT AVERAGE 1
       STOP ½
       LOGIC 1
       TOTAL 10
    3. Give two types of errors that may be detected during program testing (2 marks)
       • Syntax errors
       • Logical errors
       • Runtime errors
17.                                
    1. State four functions which are specific to Network Operating Systems (4 marks)
       • Provide access to network resources
       • Enables nodes on the network to communicate with each other efficiently
       • Supports interprocess communication
       • Respond to requests from application programs running on network
       • Implement network security
    2. State two advantage of using fibre optic cables over satellite in data communication (2marks)
       • Its immune to interference and eavesdropping
       • Has low attenuation
       • Vast transmission of data at a high speed
    3.                      
       1. The figure below shows how data is transmitted through a public telephone line (4 marks)
          Name A, B, C, and D
          • A - Sending computer
          • B - Digital Signal
          • C - Modem
          • D - Telephone Line/ Analogue Signal
    4.                                  
       1. List any two items that may be referred to as data terminal equipments in a network(2 marks)
          • Computer
          • Printer
          • Visual Display Unit
          • Mobile Phone
          • Tablet
          • Scanner
       2. Write the acronym MODEM inf full (1 mark)
          • Modulator Demodulator/ Modulation Demodulation
       3. Explain the purpose of a modem when connecting to the internet (2 marks)
          • Convert digital signals to analog format before transmission; and incoming signals from analog to digital before processing
18.                                        
    1. State THREE roles of a programmer in system development life cycle (3 marks) 
       • Coding/writing/constructing (building) the system
       • Turning system specification into an Information system
       • Modify existing programs to meet changes in information processing needs (maintenance)
       • implementing/ installing a system
       • Developing system/ program
       • Documenting/ giving technical guide
    2. State four activities that may be carried out when disposing off an old system in an organization (4 marks)
       • Ensuring that all the accounts or other access control facilities that are associated with the system being disposed are eliminated. Any sensitive data on drives should be gotten rid of
       • In the most extreme cases, storage devices may need to be physically destroyed to ensure that sensitive data isn’t leaked to whoever gets the drive next
       • Make sure that physical indicators of a system has been fully decommissioned in a secure manner that they don’t consist of something easily misplaced or overlooked like a sticky note
       • Whoever is responsible for disposing a machine should sign off on the completion of the process
    3. Distinguish parallel changes over from straight change over as used in system implementation. (2marks)
       • Parallel change over both old and new systems are run parallel to end other for some time until users have confidence in new system is stopped and discarded and the new system started immediately. While in straight change over the system is immediately implemented and the old one discarded
    4. Discuss any two fact finding methods. (4marks)
       • Interviews – it is carried out with relevant stakeholders in order to get views about the current system.
       • Questionnaires – Special purpose document that allows a person to collect information and opinions from people who receive and respond to it.
       • Observation – Require the observer to participate or watch closely as a person performs activities in order to learn about the system.
       • Automated method – Used when one wants to get actual data which may be difficult to get through interviews,observation or questionnaires.
    5. Differentiate between an open system and a closed system. (2marks)
       • An Open system is that which interacts and communicates with its environment constantly. It receives inputs from & gives output to the environment.
       • A closed system is that which does not interact or communicate with its environment. It does not communicate to or receive communication from its environment.
19.                          
    1. State three standard coding scheme used computing and electronic systems.(3marks)
       • Binary coded decimal\
       • American standard code for information interchange
       • Extended binary coded decimal interchange code
         (correct @ 3 marks)
    2. Convert each of the following numbers
       1. 1001.001₂ to octal. (2marks)
          001|001.001
          11.1₈ (correct whole number @ 1 mark, correct fractional part @ 1 mark)
       2. 125.5₁₀ to hexadecimal. (3marks)
          

          	125
          16	7 r 13
          16	0 r 7

          = 7D₁₆ (whole number correct @ 1 mark)
          0.5 x 16 = 8.0 (fractional part correct @ 1 mark)
          = 7D.8₁₆
       3.  Add 1100.0112 to 11001.01012 and leave your answer in decimal (3 marks)
          

          	0	1	1	0	0	.	0	1	1	0
          	1	1	0	0	1	.	0	1	0	1
          1	0	0	1	0	1	.	1	0	1	1

          = 100101.1011₂ (binary @ 1 mark)
          

          1	0	0	1	0	1	.	1	0	1	1
          25	24	23	22	21	20	.	2-1	2-2	2-3	2-4
          32	0	0	4	0	1	.	0.5	0	0.125	0.0625

          37.6875₁₀
          (whole number correct @ 1mark, Fraction part correct @ 1 mark)
    3. Using two compliment perform the following arithmetic leaving your answer in binary form. (4marks)
       13₁₀ - 15₁₀
       

       	13
       2	6 r 1
       2	3 r 0
       2	1 r 1
       	0 r 1

       = 1101₂ (correct @1/2 mark)
       

       	15
       2	7 r 1
       2	3 r 1
       2	1 r 1
       	0 r 1

       = 1111₂ (correct @1/2 mark)
       00001101+(-00001111)
       1c(00001111) = 11110000 (correct @1 mark)
       2c =
       

       1	1	1	1	0	0	0	0
       +							1
       1	1	1	1	0	0	0	1

       (correct @1 mark)
       

       	0	0	0	0	1	1	0	1
       +	1	1	1	1	0	0	0	1
       	1	1	1	1	1	1	1	0

       = 11111110₂ (correct @ 1mark)
20.                              
    1. Distinguish between axis labels and data labels as used in spreadsheets (2marks)
       Axis labels refer to data corresponding to the vertical or horizontal lines in a given chart
       Data labels are data that provide additional information about a data marker which presents single data point on a value that originates from a worksheet cell
       (correct @ 2marks)
    2. Name an electronic spreadsheet feature that allows one to perform the following actions. ( 4 marks)
       

       Action	Feature
       Provide pictorial summary of data	Chart / graph
       Make one cell out of many	Split cells
       List items from Highest to lowest or vice versa	sort
       Make many cells out of one	Merge cells

    3. Explain the difference between the printing of multiple pages and multiple copies as used in word processing (2marks)
       • printing of multiple pages is Printing more than one page whereas
       • multiple copies is Printing several copies of the same page
         (correct @ 2 marks)
    4. Describe the following categories of software (4marks)
       1. Firmware
          • Hardware and software instructions recorded on a rom chip
       2. Proprietary software
          • Software whose source code is hidden from users
    5. Explain the meaning of solid state storage media giving TWO examples of it.(3 marks)
       These are devices which don't have moving parts .
       Examples
       • Flash disk
       • Memory card
       • Solid state hard disk