Computer Studies Paper 1 Questions and Answers - 2021 KCSE Eldoret Diocese Mock Exams

Share via Whatsapp

Questions

Instructions to candidates

  • This paper consists of two sections: A and B.
  • Answer all the questions in Section A.
  • Answer question 16 and any other three questions from section B.
  • Candidates should answer the questions in English.

Section A (40 marks)
Answer all questions in this section

  1.  In the history of computing, various innovations or key development were associated with individuals, organizations and sometimes a civilization. For each of the key innovations listed on the left of figure 1 , associated them with individuals, organizations or civilizations on the right by drawing a straight line to connect them.. ( 2 marks)
     Key development Individual/Organization/Civilization responsible 
    Abacus 
    Difference Machine 
    Stepped reckoner 
    First Computer Programmer 
     Charles Babbage
    Gottfried Wilhelm Von Leibniz
    Ada Lovelace
    Howard Aiken
    Joseph Jacquard
    Babylonians
    Figure 1
  2.      
    1. List down two text formatting activities that can be carried out on a word processed document. ( 1 mark)
    2. List down two paragraph formatting activities that can be carried out on a word processed document.( 1 mark)
  3. One way of ensuring safety of data held in a computer system by requiring users to provided a password when accessing the system. Describe three characteristics of password that can be used to determine it’s strength. (3 marks)
  4. BCD is one of the symbolic representation of data used in computing.
    1. Write the acronym BCD in full, (1 mark)
    2. Write the BCD equivalent for the denary number 25. (1 mark)
  5. A family has purchased a wireless router for use in their home to allow their devices to be connected via WiFi to form a wireless local area network (WLAN).
    1. What is a router? (1 mark)
    2. Other than WiFi, list two other methods of wireless communication in a network. ( 1 mark)
  6. State three ways by which ICT may have assisted in the fight against Covid19 pandemic.(3 marks)
  7. Describe the purpose of DTP under each of the following subheadings:
    1. Printing, ( 1 mark)
    2. Graphic design, ( 1 mark)
    3. Page layout. ( 1 mark)
  8. Describe each of the following terms associated with the internet:
    1. Blog, ( 1 mark)
    2. Wiki, ( 1 mark)
    3. Cookie. ( 1 mark)
  9. Describe how each of the following are used in determining the integrity of data:
    1. Accuracy, (1 mark)
    2. Timeliness, (1 mark)
    3. Relevance. (1 mark)
  10. State two functions of a computer file. ( 2 marks)
  11. Three examples of language translators and four definitions are shown below. Draw lines to link each language translator to the correct one or more definitions. ( 3 marks)
    Eld21compp1qa11m
  12. Describe each of the following ICT careers:
    1. Social Media Influencer, ( 1 mark)
    2. Social Media Manager, (1 mark)
    3. Social Media Strategist. ( 1 mark)
  13. With the aid of an example in each case, State the effects of ICT on employment under each of the following subheadings:
    1. Job creation, ( 1 mark)
    2. Job replacement, ( 1 mark)
    3. Job displacement. ( 1 mark)
  14. Describe three feasibility studies that may be carried out during system development. (3 marks)
  15. 15 State three circumstances that may necessitate the replacement of an existing ICT system with a new one. ( 3 marks)

Section B (60 Marks)
Answer question 16 and any other three

  1.        
    1. State two categories of high level programming languages ( 2 Marks)
    2. With the aid of a flowchart segment in each case, describe each of the following programcontrol structures:
      1. Repeat ...Until loop, (3 marks)
      2. While….Do loop. (3 marks)
    3. Develop a flowchart for a program that would prompt user to enter ten integers then display the largest integer. ( 7 marks)
  2.          
    1.    
      1. Many teachers feel that monitoring student academic progress is an important part of the teaching and learning process. Describe three features of a spreadsheet can be used by a teacher to help monitor student progress. ( 3 marks)
      2. The spreadsheet formula =(E$20+$C5)/K12 is currently in cell address N10 of a spreadsheet. When copied to a different cell address, the formula changed to =(B$20+$C1)/H8.
        1. Identify the type of cell referencing used in the formula. ( 1 mark)
        2. Determine the address to which the formula was copied to. (2 marks)
    2.          
      1. Differentiate between a flat file database and a relational database. ( 2 marks)
      2. State three advantages of using a relational database as compared to a flat file database.( 3 marks)
      3. A library uses a database table in figure 2 below called GENRE, to keep a record of the number of books it has in each Genre.
        ID GenreName Total  Available Loaned Overdue
        ABI Autobiography 500 250 250 20
        BIO Biography 650 400 250 0
        EDU Education 20200 10000 10200 1250
        HFI Historical Fiction 6300 3500 2800 0
        HNF Historical Non-Fiction 8000 1523 6477 0
        Figure 2
        Complete the query-by-example grid presented below to display any genres with overdue books. Only display the ID,GenreName and Overdue fields in order of the number of books overdue from largest to smallest ( 4 marks)
        Eld21compp1q17B
  3.            
    1. When a system has been developed, two types of documentation are produced, technical and user documentation.
      1. Explain why user documentation is needed. ( 2 marks)
      2. Explain why technical documentation is needed. ( 2 marks)
    2. A small company makes toys and then delivers them to shops.

      Throughout the day orders are received by the company from its customers. The office workers in the finance department create and store an invoice for each order. They are too busy to be disturbed from their work.

      Delivery drivers receive copies of the invoices which they will pass on to their customers. The drivers make a large number of deliveries per day and do not return to the office until next day.

      A systems analyst is required research the current system and suggest improvements to be made.

      For each type of employee identified above, describe the most suitable method of collecting information from them during information gathering stage of systems development, giving a reason for your choice in each case.
      1. Office workers
        Method ……………………………………………………………… ( 1 mark)
        Reason (2 marks)
      2. Delivery Drivers
        Method ..................................................................................... ( 1 mark)
        Reason (2 marks)
    3. In Systems development:
      1. State the meaning of the term information system. (1 mark)
      2. Other than System Analysis, describe any other two stages of systems development (4 marks)
  4.          
    1. State the meaning of each of the following data representation terms:
      1. bit, (1 mark)
      2. word ( 1 mark)
    2. Explain why binary number system is the most suitable to be used in representing data in a computer system. (3 marks)
    3.        
      1. Determine the one’s complement of the denary number Ten. Leave your answer in 8 bits.( 4 marks)
      2. using two complement, subtract 7716 from 778 leaving your answer in base ten. (6 marks)
  5.  
    1. State three cable data communication media use in computer networking ( 3 marks)
    2.            
      1. Other than the backup file, name four other types of computer processing files.( 2 marks)
      2. State two advantages of using magnetic tapes rather than flash memory for backing up data. ( 2 marks)
      3. State two disadvantages of using magnetic tapes rather than flash memory for backing up data. ( 2 marks)
    3. With the aid of a well labeled diagram, describe the bus network topology. ( 6 marks)

Marking Scheme

Instructions
This markscheme is the property of the CaSPA ELDORET DIOCESE and must not be reproduced or distributed to any other person without their authorization.

his mark scheme is published as an aid to teachers and candidates, to indicate the requirements of the examination. It shows the basis on which Examiners were instructed to award marks. It does not indicate the details of the discussions that took place at an Examiners’ meeting before marking began, which would have considered the acceptability of alternative answers.

Examiners should be aware that in some cases, candidates may take a different approach, which if
appropriate should be rewarded. If in doubt, check with your team leader.

Marks must be awarded in line with the following principles

  • Marks are awarded for correct/valid answers, as defined in the mark scheme. However, credit is given for valid answers which go beyond the scope of the syllabus and mark scheme, referring to your Team Leader as appropriate
  • Marks are awarded when candidates clearly demonstrate what they know and can do. Marks are not deducted for errors
  • Marks are not deducted for omissions
  • Answers should only be judged on the quality of spelling, punctuation and grammar when these features are specifically assessed by the question as indicated by the mark scheme. The meaning, however, should be unambiguous
  • Rules must be applied consistently, e.g. in situations where candidates have not followed instructions. For instance if candidate attempts all section C questions, only the first three options i.e. questions 17,18 and 19 should be assessed. Question 20 will be ignored.
  • Maintain a positive marking attitude by looking out for candidates achievement instead of failure.
  • Marks awarded are based solely on the requirements as defined in the mark scheme. Marks should not be awarded subject to considerations such the gender of the candidate.

Section A (40 marks)
Answer all questions in this section 1. .

  1.      
    Eld21compp1qa1   
  2.        
    1. Bolding
      Italizing
      Underlining
      Fonts
      Drop caps
      Change case
      Superscript/subscript
      (first 2 @ 1/2 a mark each for 1 mark) 
    2. alignment ii) indenting spacing
      Section breaks
      bullets and numbering
      (first 2 @ 1/2 a mark each for 1 mark)
  3.    
    Length Complexity
    Presence Personal information such as use of ones name, birthdates e.t.c Age of the password— how long has be same password been used
    (first 3 @ 1 mark each for 3 marks. Descriptions must be given)
  4.     
    1. Binary Coded Decimal.
      (Mark as a whole @ 1mark for 1 mark )
    2. 00100101.
      (Mark as a whole @ 1mark for 1 mark )
  5.    
    1. A router is a networking device that forwards data packets between computer networks
      (Mark as a whole @ 1mark for 1 mark. Must show evidence of connecting different networks )
    2. Microwave satellite Bluetooth LiFi
      Infra red
      (first 2 @ 1 mark each for 1 mark)
  6. Social media can be used to create awareness
    Spreadsheet can be used to analysis statistics on infection rates Database can be used to keep a record of vaccination
    AI. Can be used to predict / simulate the spreading pattern of the diseases AI can be used to come up with a vaccine quickly
    DTP can be used to publish awareness posters
    Wordprocessor can be used to notify a person of their test results on convid
    (first 3 @ 1 mark each for 3 mark)
  7.        
    1. Reproduction of a design to a hardcopy / on paper
      ( 1 @ 1 mark for 1 mark)
    2. creation of visual content/drawings/lettering that communicates a message.
      ( 1 @ 1 mark for 1 mark)
    3. the arrangement of visual elements on a page
      ( 1 @ 1 mark for 1 mark)
  8.     
    1. Personal internet journal/online diary Short for web log
      ( any 1 @ 1 mark for 1 mark)
    2. web application/site that allows a group of people to edit the content
      ( 1 @ 1 mark for 1 mark)
    3. small files that websites send to your device that the sites then use to monitor you and remember certain information about you — like what's in your shopping cart on an e- commerce site, or your login information (OWTTE)
      ( any 1 @ 1 mark for 1 mark)
  9.   
    1. this is the measure of the closeness of data to the actual. The closer the more accurate.
      Refers to error-free records/data that can be used as a reliable source of information
      ( any 1 @ 1 mark for 1 mark)
    2. availability of data at a time that it is required
      ( any 1 @ 1 mark for 1 mark)
    3. The level of consistency between the content of data and the user's areas of interest/
      Needs. i.e how closely the data meets a user needs
      ( any 1 @ 1 mark for 1 mark)
  10. storage of data
    organization of information
    ( First 2 @ 1 mark for 2 marks)
    (3 marks)
  11.       
    Eld21compp1qa11nn
  12.        
    1. is someone who has established credibility in a specific industry, has access to a huge audience and can persuade others to act based on their recommendations They inform their followers of new products, new developments, and even breaking the news. Unlike advertisements that are designed to inform, the information that comes from individual influencers is organic and trusted. OWTTE
      ( any1 @ 1 mark marked as a whole)
    2. -manage an organisation's online presence
      -are in charge of representing a company across social channels as the sole voice of the brand. They respond to comments, compile campaigns
      ( any 1 @ 1 mark marked as a whole)
    3. Social Media experts responsible for planning, developing and implementing company's overall social media strategy in order to support and improve online presence and the overall digital marketing efforts.
      ( any 1 @ 1 mark marked as a whole)
  13.  
    1. the provision of new opportunities for paid employment
      e.g. Computer teacher ,
      ( any 1 @ 1 mark— Accept example if self explanatory)
    2. Happens which a position at work still exists but work is now taken over by computers.
      e.g. robots taking over jobs such as car manufacturing, mining.
      ( any 1 @ 1 mark— Accept example if self explanatory)
    3. occurs when an employer removes a position that is currently being held by an employee.
      This leads to job loss
      e.g. of jobs that have been removed by computers are
      • Pin boys
        Resetting of bowling pins are now automated.
      • Lift operators
        Old lifts were not as easy to operate as they are today. You couldn’t simply press a button for the lift to stop at the floor you want. Instead, a lift operator would need to manually stop the lift, timing it for each floor.
        When technology improved, lifts no longer needed human help finding the right place to stop each time. And so, ‘lift operator’ became another of the jobs lost to technology.
      • Switchboard operators
        There existed a job where a human employee would physically connect calls. They operated the switchboard, inserting phone plugs into the relevant jacks to connect a call.
        Now, switchboard systems are largely automated.
      • Cashiers
        Increasingly, cashiers hold another of the jobs lost to technology. Specifically, self- service technology. Online shopping started to reduce the demand for physical cashiers. Customers instead complete the process themselves.
        In physical stores, self-service machines let customers check out their items themselves. In most cases, a human instead reassures the machines that yes, the customer has put the item in the bagging area.
        As technology progresses and checkout-less shops become more viable, cashier jobs will continue to drop.
      • Bank tellers
        The first instance of some bank teller jobs lost to technology came with the introduction of the ATM (automated teller machine) in the 1960s.
        Add to this the rise of online banking, robo-advisors and financial chatbots, as well as contactless card payments. As technology improves, there’s less and less need for human tellers at the bank. Most banking customers instead serve themselves.
        In return for the job of bank teller, we gain more accessibility, control and convenience when we manage our money.
      • Travel agents
        Thanks to online comparison sites, travel agents are facing reduced demand. Holidaymakers have grown accustomed to planning, putting together and booking their own holidays. As this trend grows, travel agents grow increasingly redundant in tandem.
        ( any 1 @ 1 mark— Accept example if self explanatory)
  14. Technical Feasibility
    • Determines if the available technical resources/technology can support the development of the system
    • Determines if personal involved have the technical skills/abilities to develop the system.
      ( any 1 @ mark for 1 mark)
    • Economic Feasibility
      Determines if the cost versus benefit of the system is justifiable.
      ( any 1 @ mark for 1 mark)
    • Operational Feasibility
      Determine whether—and how well—the organization’s needs can be met by completing the project. Examines how a project plan satisfies the requirements identified in the requirements analysis phase of system development.
      ( any 1 @ mark for 1 mark)
    • Scheduling Feasibility
      Determines if the time it will take to complete the project is viable. Determines if the project can be completed within the stipulated time.. ( any 1 @ mark for 1 mark)
    • Legal feasibility
      Determine if the project outcome violates any law
      Determine if the project outcome shall be within the law e.g. social media laws, privacy laws etc
      ( any 1 @ mark for 1 mark)
    • Political/Cultural/organizational/Social/Acceptance feasibility
      Determine if the project will gain political acceptance by users
      Gain an understanding of how key stakeholders within the organization view the proposed system. The new information systems may affect the distribution of power and can have political ramification. Therefore, those stakeholders not supporting the project may block or disrupt the project.
      (any 1 @ mark for 1 mark)
      (Consider first three only @ 1 mark for 3 marks)
  15.       
    • System becomes obsolete
    • System becomes to expensive to maintain and review
    • Organizations needs have changed/ no longer being met by the system
    • Change in legal environment which require changes to systems e.g. changes in privacy laws. When a supplier / developer of the system is no longer available to give support.
      (first 3 @ 1 mark each for 3marks)
  16.   
    1. third Generation Languages (3GLS)
      fourth Generation Languages (4 GLs)
      Object Oriented Programming (OOPs)
      Internet (scripting) Programming Languages
      (first 2 @ 1 mark each for 2 marks)
    2.       
      1.       
        Eld21compp1qa16bi
      2.       
        Eld21compp1qa16bii

        Eld21compp1qa16b
        Mark Scheme
        Correct use of Symbols Start/Stop = = 1/2
        Input/Output = 1/2
        Processing = 1/2
        Decision = 1
        Flow line = 1/2
        Total = 3

        Functionality
        Input of at least two integers 1
        Two numbers compared 1
        Largest among ten determined 1
        Largest integer displayed 1
        (7marks)
  17.              
    1.         
      1.        
        • Student progress can be shown over time using graphs
        • Comparisons between students can be shown using graphs
        • Comparisons with archive data can be shown using graphs
        • Conditional formatting can be used to show how a student is performing compare to other students or past performance
        • Data can be sorted to show the best performers in the class
        • Calculate average marks to enable comparisons
        • Automatic reporting results to parents
        • Filtering students to show those above/below a threshold
          (First 3 @ 1 mark each for 3 marks)
      2.                 
        1. Mixed cell referencing. (1 mark)
        2. K6 (2 marks. If only row or column identified give max of 1 mark)
    2.              
      1. flat file database is a single file/table database, a relational database is a multiple file/table database ( 2 marks)
      2. State three advantages of using a relational database as compared to a flat file database. Reduced redundancy/Records cannot be duplicated but a flat file cannot stop this
        Faster access to records
        Due to reduced redandacy, database smaller Accurate update of records due to cascading update
        Data does not need to be entered a second time as tables are used Saves time when entering data
        More efficient storage as data is only stored once Simpler to delete/modify details
        Complex queries can be carried out
        Complex reports can be created
        Better security as some tables can be made confidential Avoids inconsistent records
        More data independence Less inconsistency of data
        More ability to cater for future requirements
        ( first 3 @ 1 mark each)
      3.     
        Eld21compp1qa17biii
  18.           
    1.             
      1. To help (users) learn/know how to use the software/system
        To help users to overcome problems
        (Any 1 @ 2 marks –Explained)
      2. To help programmers/analysts to make improvements to the system
        To help programmers/analysts to repair the system
        To help programmers/analysts to maintain the system
        (Any 1 @ 2 marks –Explained)
    2.         
      1. Method:
        Observation of the processes taking place
        Investigation, e.g. looking at existing paper work. (Any 1 @ 1 mark)

        Reason:
        • Enables the systems analyst to see the whole system without interrupting workers There are too many workers to interview them all
        • Other such as Questionnaires/interviews would stop them working on their tasks
          (Any 1 @ 2 marks— Explained)

      2. Method:
        • Questionnaires could be handed out
          (Any 1 @ 1 mark)

          Reason:
        • They can complete them in their own time/at their leisure and return them to work during the next pickup
          (Any 1 @ 2 marks— Explained)
    3.          
      1.      
        • collection of hardware, software and liveware that collect analyse data to produce information
          (1 mark marked as a whole— OWTTE)
      2.      
        • System design System construction
        • System implementation
        • System review and maintenance
          (first 4 @ 1 mark per description for 4 marks)
  19.           
    1.             
      1.  A binary digit (1 mark)
      2. a collection of bits read/write/manipulated as a group by a procerssor.(1 mark)
    2.           
      • Computer is a bi-state device
      • can only code for information/data using the two state
      • Binary number uses only two digits
      • binary digits can map well onto the compute states
      • computer states can be represented by the binary numbers
      • collection of binary digits can be used to code for data/processes/information.
        ( any 3 @ 1 mark each for 3 marks)
    3.      
      1. Conversion to 1010 to binary
        Eld21compp1qa19c
        Ones, complement 11110101
        Conversion to binary 2 marks(1 mark for method, 1 mark for answer)
        Padding to 8 bits 1 mark
        Getting ones complement 1 mark
      2. 7 = 111
        7716=01110111
        778=111111

        Padding to equal number of bits
        778 =00111111
        00111111-01110111
        One complement of 01110111 is 10001000
        Twos complement is thus 10001001
        00111111+10001001 = 11001000
        Using grid to convert to base ten
        128 64 32 16 8 4 2 1
        -1 1 0 0 1 0 0 0
        -128+64+8 = -56
        Conversion of 7716 to binary ( 1/2 mark)
        Conversion of 778 to binary (1/2 mark), padding to eight bits (1 mark) One complement (1 mark)
        Two complement (1 mark)
        Binary answer of the subtraction (1 mark)
        Conversion to base ten (1 mark)
  20.               
    1. Communication with cables
      twisted pair cables
      coaxial cables
      fibre-optic cables
      ( first 3 @ 1 mark each)
    2.      
      1. Master
        Transaction
        Report
        Sort
        Reference
        ( first 4 @ 1/2 a mark each)

      2. Less expensive per GB/gigabyte of memory
        Not as easily lost, as larger in size
        ( first 2 @ 1 a mark each)

      3. Data access time is slower
        Data transfer rate is slower
        Affected by magnetic fields
        They have moving parts therefore less robust
        Read and write is more noisy
        Less compact that flash memory
        Harder to transfer to other devices
        Requires a special reader
        ( first 2 @ 1 a mark each)
    3.        
      Eld21compp1qa20c
      Network topology in which nodes are directly connected to a common link/cable terminated at two ends called a bus.
      A bus topology is a topology for a Local Area Network (LAN) in which all the nodes are connected to a single cable. The cable to which the nodes connect is called a "backbone"
      (diagram 4 marks, description 2 marks) 
Join our whatsapp group for latest updates

Download Computer Studies Paper 1 Questions and Answers - 2021 KCSE Eldoret Diocese Mock Exams.


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?

Join our community on:

  • easyelimu app
  • Telegram
  • facebook page
  • twitter page
  • Pinterest