Computer Studies P1 Questions and Answers - Momaliche 4 cycle Post Mock Exams 2021/2022

QUESTIONS

SECTION A (40 Marks)
Answer ALL the questions in the spaces provided.

1. Describe the following computer memories.
   1.                        
      1. Register (1mk)
      2. Cache (1mk)
   2. Give two differences between a compiler and an interpreter. (2mks)
2. List any four threats to a computer system (2 mrks)
3. In database the field properties specify finer details related to the fields and table entries expected. Explain the functions of the following
   1. Caption (1mk)
   2. Required (1mk)
   3. Input mask (1mk)
4.                          
   1. State four reasons why fibre optic is a number one choice in today’s data communication. (2mks)
   2. What is meant by the term virtual reality? (1mk)
5. Distinguish between relative and absolute cell references as used in spreadsheet.(2mks)
6. Convert the binary number 10101111010110111.01 to its
   1. Octal equivalent (show the working) (1 mark)
   2. Hexadecimal equivalent (show the working) (1 mark)
7. Consider the module flowchart extract below.
   
   
   1. Name the looping structure demonstrated (1 mark)
   2. After scanning images in DTP, you can either crop them or resize them. Distinguish between cropping and resizing of images. (2 marks)
8.                    
   1. List four advantages of secondary storage devices which make them indispensable /popular part of a computer system. (2 marks)
   2. Give two reasons why magnetic tape is not a popular secondary storage device.
9. Describe the functions of the following network components.
   1. Router (1 mark)
   2. Hub (1 mark)
10. State 2 reasons why an organisation may use other strategies of software acquisition other than developing their own. (2 marks)
11. Given below is an algorithm that will never end.
    Set count to 0
    While count is non-negative
    Print the count
    Add 1 to count
    
    1. Explain why the loop will never end. (1 mark)
    2. What changes would you make to the algorithm so that it ends executing the loop once. Make changes to the statement add 1 to count to read Subtract 1 from count (1 mark)
12. Consider the worksheet given below
    1. Give a formula that can be typed in cell D6 to return the fees paid by female students (2 marks)
       

       	A	B	C	D
       1	admn no.	student name	sex	fees paid
       2	4988	Pollycarp Ekirapa	M	7,800
       3	4990	Rose Nabalayo	F	10,200
       4	4950	Risper Chepkemei	F	9,800
       5	4987	Peter Okong'o	M	7,700

    2. Give a formula that can be typed in cell C6 to return the number of male students.(1 mark)
13.                                
    1. Identify the four main application areas of artificial intelligence (2 marks)
    2. Define the following as used in word processing (1 mark)
       1. Word wrap
       2. Drop cap
14. As regards database systems:
    1. Distinguish between a primary key and a foreign key (2 marks)
    2. Define the term normalization. (1 mark)
15.                      
    1. What is the difference between simplex and full –duplex transmission? (2 marks)
    2. Give any two advantages of telecommuting. (1 mark)

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

16.                            
    1. What will be the value of product when printed in the following flow chart? Show how you arrive at your answer(2 mrk)
       
    2. Explain what happens when the expression A=A+1 is changed to A =A-1 (3 marks)
    3. Study the flowchart below and answer the questions that follow
       
       
       1. State the main type of control structure used in the flowchart (2 mark)
       2. Dry run the above flowchart (5 marks)
    4. Dr. Fundi would like to demonstrate a concept using a computer program on his laptop to members of his village health committee.
       Give two reasons why he would prefer a laptop to his desktop computer. (3 marks)
17.                            
    1. Describe two health issues related to working with computers and give a remedy for each. (4 marks)
    2. Robots are introduced into a factory which makes car engines. Describe three ways this could affect the workers. (6 marks)
    3. Name any two computer related courses that are offered at public universities in Kenya. (1 mark)
    4. List two duties performed by the following personnel
       1. database administrator (2 marks)
       2. Computer trainer (2 marks)
18.                            
    1. Give any two factors one should consider before enrolling for an ICT course in a college. (1 marks)
    2. With the aid of a sketch, explain the main stages of data processing cycle. (4 marks)
    3. State and explain any three system changeover strategies that one can use to replace on old system with a computerized system. (6 marks)
    4. State three reasons for developing a new system. (3 mrks)
    5. Define the term feasibility study as used in system development. (1 mark)
19.                        
    1. Differentiate between a database and DBMS. (1 mark)
    2. List four advantages of using electronic database systems. (2 marks)
    3. In a database system, data integrity ensures the correctness and completeness of the data in the database.
       Differentiate the following types of integrity constraints:-
       1. Validity integrity (2 mark)
       2. Entity Integrity (2 mark)
       3. Referential integrity (2 mark)
    4. Briefly describe any three database models (6 marks)
20.                          
    1. Namarome a form one student out of curiosity loads three programs namely Yahoo Messenger, Ms –Word and Windows multimedia player. She realizes she can use the three programs simultaneously i.e. typing her notes, listening to her favourite song and answering incoming chat messages. She does not understand how a computer can perform such magic. She approaches you for an explanation. Explain to her how the computer does this. (2mks)
    2.                            
       1. Define an expert system (1 mark)
       2. Describe the three components of an expert system (6 mrks)
    3. State two advantages and one disadvantage of using an expert system in passing judgement in courts of law. (3 marks)
    4. State two advantages of command line interface operating system over graphical user interface operating system. (2 marks)

MARKING SCHEME

Answer ALL the questions in the spaces provided.

1. Describe the following computer memories.
   1.                      
      1. Register (1mk)
         • A special high speed storage location or ( memory within the CPU that temporarily stores data/ information/ instructions during processing.
         • Cache A fast memory within the computer that stores frequently used data/ instructions for fast access by the CPU.
   2. Give two differences between a compiler and an interpreter. (2mks)
      

      compiler	interpreter
      translates the entire source code at once	translates a statement at a time as execution takes place
      requires more memory as both the source code and object code have to be stored	less memory required because object code not stored
      it saves time because EXE file is saved and can be run at any time	wastes time since the source code has to be interpreted for the program to run

2. List any four threats to a computer system
   • Computer viruses.
   • Power fluctuations.
   • Poor handling of storage media.
   • Unauthorized access.
   • Theft
   • Sabotage (1x ½ mks)
3. In database the field properties specify finer details related to the fields and table entries expected. Explain the functions of the following
   1. Caption (1mk)
      This property displays the name that will be used to capture data in tables, forms and reports.
   2. Required (1mk)
      Its values are Yes or No. When set to Yes the user has to enter a value in a field i.e a field cannot be left blank. If set to No the user can leave a field blank.
   3. Input mask (1mk)
      Defines how data will be displayed and printed when keyed in.
4.                        
   1. State four reasons why fibre optic is a number one choice in today’s data communication. (2mks)
      • Cannot be tapped
      • Fast data transmission
      • Has low attenuation
      • Wide bandwidth
   2. What is meant by the term virtual reality? (1mk)
      • Use of computers to visualize manipulate and interact with complex data.
      • The ability of a computer to mimic human behaviour.
5. Distinguish between relative and absolute cell references as used in spreadsheet.
   • Relative cell reference – Cell address used in a formula that adjusts itself to reflect its new position in the worksheet. (1 mk)
   • Absolute cell reference - acell address that keeps on referring to a specific cell regardless of its position in the worksheet.
6. Convert the binary number 1010,11110,10110111.01 to its
   1. Octal equivalent (show most the working) (1 mark)
      • 1010_257267.2(8)
   2. Hexadecimal equivalent (show most the working) (1 mark)
      • 15eb7.4(16)   (method ½ mk)
7. Consider the module flowchart extract below.
   
   
   1. Name the looping structure demonstrated REPEAT ... UNTIL loop. (1 mark)
   2. After scanning images in DTP, you can either crop them or resize them. Distinguish between
      • cropping and resizing of images. (2 marks)
      • Cropping – Chopping off some of the parts of an object. (1 mark)
      • Resizing - Adjusting the size of an object. (1 mark)
8.                    
   1. List four advantages of secondary storage devices which make them indispensable /popular part of a computer system. (2 marks)
      • High storage capacity
      • Non-volatile
      • Cheaper than primary storage
      • Portable
   2. Give two reasons why magnetic tape is not a popular secondary storage device.
      • Its bulky
      • Low storage capacity
      • Its contents can only be accessed sequentially i.e slow (2 marks)
9. Describe the functions of the following network components.
   1. Router (1 mark)
      • A device that interconnects different networks and directs the transfer of data packets form source to destinations.
   2. Hub (1 mark)
      • A device that provides a central location for the cables in network that has a common architecture
10. State 2 reasons why an organisation may use other strategies of software acquisition other than developing their own. (2 marks)
    • Tailor made programs can have errors
    • Tailor made programs are usually very expensive
    • Developing the programs, testing and implementing takes a long time. (mark first 2 points)
11. Given below is an algorithm that will never end. Set count to 0 While count is non-negative Print the count Add 1 to count
    1. Explain why the loop will never end. (1 mark)
       • Statement
       • Condition
       • This is because the value of count will not get to negative. The value of count starts from zero and increments.
    2. What changes would you make to the algorithm so that it ends executing the loop once. Make changes to the statement add 1 to count to read Subtract 1 from count (1 mark)
12. Consider the worksheet given below
    

    	A	B	C	D
    1	admn no.	student name	sex	fees paid
    2	4988	Pollycarp Ekirapa	M	7,800
    3	4990	Rose Nabalayo	F	10,200
    4	4950	Risper Chepkemei	F	9,800
    5	4987	Peter Okong'o	M	7,700

    1. Give a formula that can be typed in cell D6 to return the fees paid by female students = Sumif ( C2:C5,’F’,D2:D5) (2 marks)
    2. Give a formula that can be typed in cell C6 to return the number of male students.
       =COUNTIF(C2:C5,’M’) (1 mark)
13.                              
    1. Identify the four main application areas of artificial intelligence (2 marks)
       • Robotics (Robot control)
       • Medical diagnosis.
       • Stock control
       • Finance
       • Heavy industry
       • Online and telephone customer service.(Neural language)
       • Toys and games
       • Aviation
       • News, publishing and writing.
       • Data mining. (½ mark each)
    2. Define the following as used in work processing (1 mark)
       • Word wrap A feature that automatically moves the cursor or text to the next line when the end of the line is reached.
       • Drop cap A character or a group of characters at the beginning of the paragraph that spreads in more than one line.
14. As regards database systems:
    1. Distinguish between a primary key and a foreign key (2 marks)
       • Primary key –A field that uniquely identifies a record in a database.
       • Foreign key – A field use in a table that appears as a primary key in another table.
    2. Define the term normalization. (1 mark)
       • Process of reducing duplicated data items.
15.                  
    1. What is the difference between simplex and full –duplex transmission? (2 marks)
       • Simplex –Communication in only one direction
       • Full –duplex-Communication in both direction concurrently.
    2. Give any two advantages of telecommuting. (1 mark)
       • Less pollution since few people commute to their places of work.
       • Some employee can put in more hours since they will be working from home.
       • The company will spent less on office furniture since employees will not be working from the office
       • An employee can attend to other obligations as he works for the company. For example taking care of the sick or attending to aged parents.
16. What will be the value of product when printed in the following flow chart? Show how you arrive at your answer
    1st run throughh thr flowchart
    product = 1
    A = 1
    product = 2
    
    
    1. Explain what happens when the expression A=A+1 is changed to A =A-1 (2 marks) Indefinite loop –execution will not come to an end since the value of A will never be greater 2
    2. Study the flowchart below and answer the questions that follow
       
    3.                  
       1. State the main type of control structure used in the flowchart (1 mark) Iteration (looping)
       2. Dry run the above flowchart (5 marks) 1,2,2,3,3,3,4,4,4,4
    4. Dr. Fundi would like to demonstrate a concept using a computer program on his laptop to members of his village health committee.
       Give two reasons why he would prefer a laptop to his desktop computer.
       • A laptop is portable
       • A laptop has a rechargeable battery. (2 marks)
17.                                  
    1. Describe two health issues related to working with computers and give a remedy for each. (4 marks)
       

       health issue	remedy
       repetitive strain injury	use ergonomic keyboards
       eye problems and headache	use LCD or CRT screens fitted with antiglare screens
       backache	use standard and chairs

    2. Robots are introduced into a factory which makes car engines. Describe three ways this could affect the workers. (6 marks)
       • job replacement
       • job creation
       • job displacement (6 marks)
    3. Name any two computer related courses that are offered at public universities in Kenya. (1 mark)
       • BSC Computer Science
       • BSC Information Technology
       • BSC Hardware and Software Engineering
    4. List two duties performed by the following personnel
       1. database administrator (2 marks)
          • Designing and developing database applications.
          • Setting up security measures needed to control access to data and information.
          • Keeping databases up to date by adding new records, modifying or deleting unnecessary records.
       2. Computer trainer (2 marks)
          • Training people on how to use the computer and application programs.
          • Developing training reference materials.
          • Guide learners on how to acquire knowledge
          • Preparing learners for ICT exams
18.                                
    1. Give any two factors one should consider before enrolling for an ICT course in a college. (2 marks)
       • Whether it offers ICT courses recognised both locally and internationally.
       • The cost of training with such an institution.
    2. With the aid of a sketch, explain the main stages of data processing cycle. (3 marks)
       • Data collection
       • Data input
       • data processing
       • data output
    3. State and explain any three system changeover strategies that one can use to replace on old system with a computerized system. (6 marks)
       • Direct changeover.
       • Phased changeover
       • Parallel
    4.                                            
       
       
    5. State and explain any three system changeover strategies that one can use to replace on old system with a computerized system
       • direct changeover
       • parallel
       • phased changeover
    6. State three reasons for developing a new system.
       • New opportunities
       • Problems with current system
       • Directive –new requirements imposed by the government, management or external influences.
    7. Define the term feasibility study as used in system development. (1 mark) This is an evaluation of and analysis of the potential of the proposed system.
19.                                  
    1. Differentiate between a database and DBMS. (1 mark)
       • Database – A collection of organised data.
    2. DBMS –Programs that help the user to enter, store, edit, retrieve and print databases. (b)List four advantages of using electronic database systems. (2 marks)
       • Has unlimited storage capacity
       • Has forms that provide a user friendly way of entering records in a database
       • The output is presentable
       • Editing of records is easy
       • Has in-built queries that can help the user extract records that meet the conditions he specifies
    3. In a database system, data integrity ensures the correctness and completeness of the data in the database.
       Differentiate the following types of integrity constraints:-
       1. Validity integrity (1 mark)
          • This ensures that the data entered in the database is correct.
       2. Entity Integrity (1 mark)
          • This is a database concept that ensures that there are no duplicate records within the table and that the field that identifies the record is unique.
       3. Referential integrity (1 mark)
          • This is a database concept that ensures relationships between tables remain consistent. (d)Briefly describe any three database models (3 marks)
    4.                            
       1. Net work model –entities form network of objects.
       2. Flat file model – keeps one set of data.
       3. Relational model –uses tables/relations
       4. Hierarchical model –data items arranged in tree form.
20.                              
    1.           
       1. Namarome a form one student out of curiosity loads three programs namely Yahoo Messenger, Ms –Word and Windows multimedia player. She realizes she can use the three programs simultaneously i.e. typing her notes, listening to her favourite song and answering incoming chat Data collection
          • Data input
          • Data processing Data output Feed back
          • Data processing cycle
          • messages. She does not understand how a computer can perform such magic. She approaches you for an explanation. Explain to her how the computer does this. The processor assigns each task time slices. Within that short time period the task will have sole access tot eh resources of the computer before the control is switched to another task.
    2.                          
       1. Define an expert system (1 mark)
          • This is a software that has been designed to make a computer operate at the level of a human expert in a specific narrow area of specialization.
       2. Describe the three components of an expert system (6 marks)
          • Knowledge base
          • Inference engine
          • User interface
    3. State two advantages and one disadvantage of using an expert system in passing judgement in courts of law. (3 marks)
       • Gives general solutions
       • Does not have common sense
    4. State two advantages of command line interface operating system over graphical user interface operating system. (2 marks)
       • User has got greater control over the system.
       • It offers the user flexibility because a single command can be executed with a variety of arguments.
       • It can also present certain commands that ate completely unavailable in GUI