Computer Studies Paper 1 Questions and Answers - Form 4 End Term 1 Exams 2022 - EasyElimu: Learning Simplified (2024)

Questions

SECTION A (40 MARKS)

1. What is meant by
   
   1. Analogue data
   2. Digital data (4mks)
2. Distinguish between transcription and transposition types of errors and give an example of each (4mks)
3. 1. what are peripheral devices? (1mk)
   2. Give two examples of peripheral devices (1mk)
4. 1. What meant by the term user-friendly as used in software development? (1mk)
   2. Distinguish between the terms single-tasking and multi-user as used in operating systems (2mks)
5. What actions should be taken in case of a fire outbreak in the computer laboratory? (4mks)
6. 1. What is an Internet Service Provider? (1mk)
   2. An employee in a business company is charged with the responsibility of putting the company advertisem*nts on the Internet.
      1. State the professional title of the employee. (1mk)
      2. Give an example of software used by this employee to carry out the above task. (1mk)
7. Differentiate between COM ports and LPT ports (2mks)
8. Explain two ways in which ICT can enhance commerce. (2mks)
9. Explain the following software terms:
   1. Portability (1 mk)
   2. Modularity (1 mk)
10. 1. State two application areas of a desktop publishing software. (2mks)
    2. Explain the following graphic terms:
       1. Rotate (1 mk)
       2. Crop (1mk)
11. 1. List two arithmetic operations that can be performed on a row of numeric data in a word processing table. (1 mk)
    2. In each case of (a) above, write the expression used. (2mks)
12. List two methods of gathering information during system development process.(2mks)
13. Name three types of optical disks. (3mks)
14. The diagram below shows a formatted plate surface of a storage disk.
    Shade and label:
    1. one sector ( 1mk)
    2. One block
15. The diagram below shows a formatted plate surface of a storage disk.
    
    Shade and label:
    
    1. One sector
    2. One block

SECTION B (60 MKS)
Answer question 16 and any other three questions from this section in the space provided

15. 1. Study the flowchart below and answer the questions that follow
       
       
       1. Name the control structures used in the flowchart (2mks)
       2. Determine the values of M, N, P and Q. (4 mks)
       3. Write the pseudo code for the flowchart (7mks)
    2. List four functions of an assembler (2 mks)
16. 1. Distinguish between the following sets of terms as used in spreadsheets. (2mks)
       1. Worksheet and workbook
       2. Filtering and sorting
    2. State one way in which a user may reverse the last action taken in a spreadsheet package. (1 mk)
    3. The following is a sample of a payroll. The worksheet row and column headings are marked 1, 2, 3, and A, B, C. respectively
       

       	A	B	C	D	E	F	G	H
       1	Name	Hours Worked	Pay Per Hour	Basic Pay	Allowances	Gross Pay	Tax Deductions	Net Pay
       2	Korir	12	1500
       3	Atieno	28	650
       4	Mutiso	26	450
       5	Asha	30	900
       6	Maina	18	350
       7	Wanjiku	22.5	250
       8	Wayama	24.5	250
       9	Olesane	17	180
       10	Moset	33	700
       TOTALS

       
       Use the following expressions to answer the questions that follow:
       • Basic pay = hours worked x pay per hour
       • Allowances are allocated at 10% of basic pay
       • Gross pay = basic pay + allowances
       • Tax deductions are calculated at 20% of gross pay
       • Net pay = Gross pay – tax deductions.
         Write formulae using cell references for the following cells;(5mks)
         1. D2
         2. E4
         3. F10
         4. G7
         5. H5
    4. 1. State three ways of moving round the page in a Desktop Publishing window. (3mks)
       2. State two ways on how information & Communication Technology (ICT) can be used to reduce the spread of HIV/AIDS (2mks)
17. 1. Describe the following terms with reference to security of data: (2mk)
       1. Log files
       2. Firewalls
    2. A student‟ database comprises of students‟ details table and fees received table as shown below:
       Student's details table
       

       Surname

       Middle name

       First Name

       Admission Number

       Course

       
       Fees Received Table
       

       Date

       Amount

       Receipt No.

       
       
       1. State the primary key field for each table. (2mks)
       2. State the field, which should serve as the linking field for the two tables
    3. Describe the following terms with respect to computer security:
       1. Logic bombs (2mks)
       2. Physical security (2mks)
       3. Tapping (2mks)
    4. List three functions of antivirus software. (3mks
18. Define the following web related terms:
    1. 1. Web browser (1mk)
       2. Hyperlink (1mk)
       3. Hypertext document (1mk)
    2. List six activities performed on the web (3mks)
    3. Below is an email address:
       ggitau @moest .edu.ke
       ↓ ↓ ↓
       A B C
       Name the parts labeled:
       1. A
       2. B
       3. C
19. A computer C directory has folders for form 1, form 2, Form 3 and form 4. Each class has student‟s folders labeled according to their number. The students create their own folder for the subject the are studying based on the table shown below
    

    Form 1	Form 2	Form 3	Form 4
    OS	SP	Pr.	ADB
    WP	DTP DB	Internet

    
    
    1. Assuming there is one student per class, draw the corresponding directory tree structure. (6mks)
    2. 1. a form four student wants to create a folder to store her project.
          State the path for that project folder. (2 mks)
       2. Suggest how the student can ensure that
          1. Work is not lost in case the hard disk fails. (1mk)
          2. The project is not copied by other students. (1mk)
    3. 1. Other than I/O devices, list other three devices under the control of the operating system. (3mks)
       2. Explain any one of the devices named in C (i) above (1mk)
    4. Define the term trouble shooting (1mk)
    5. State and explain three ways that can be followed to replace the current system (6mks)

Marking Scheme

1. What is meant by:
   1. Analogue data: Data that is based on physical variations such as loudness and
      pitch, electoral voltages etc
   2. Digital Data- Data, which use the computer‟s binary number systems 0 and 1
2. Distinguish between transcription and transportation types of errors and give an example of each
   • A transcription error is a specific type of data entry error that is commonly made by human operators or by optical character recognition (OCR) programs
     E.g. Name: Stamley (wrong) instead of Stanley (Correct)
   • A transposition error is an error caused by reversing two or more digits of an amount while posting transactions. These are almost always human in origin
     An Example is ZIP code: 57429 (wrong) instead of 54729 (correct)
3. 1. What are peripheral devices? (1mks)
      • Any device connected externally to the CPU
   2. Give two examples of peripheral devices (1mk)
      • Mouse, Monitor, Keyboard, printer etc
4. 1. What is meant by the term user – friendly as used in software development?
      • Software that is easier to use or work with (1mk)
   2. Distinguish between the terms single- tasking and multi- user as used in operating systems (1mks)
      • Single tasking – the O/S allows one program to be processed at a time
      • Multi – user an O/S that allows several tasks/ programs to be simultaneously
5. What actions should be taken in case of a fire outbreak in the computer laboratory? (4mks)
   • Switch off main electrical supply
   • Vacate the room
   • Inform master in charge
   • Call for help
   • Try to extinguish using the appropriate fire extinguisher (not water)
6. 1. What is an internet service provider?
      • A company that provides internet services. Connects users to the internet
   2. An employee in a business company is charged with the responsibility of putting the company advertisem*nt on the internet
      1. State the professional title of the employee (1 mk)
         • Web administrator, web designer
      2. Give an example of software used by this employee to carry out the above task (1 mk)
         • HTML, Dream weaver, MS Front Page
7. Differentiate between COM ports and LTP ports
   • COM port also known as a serial port transmits data bit by bit
   • LTP port also known as a parallel port transmits multiple bits simultaneously at a time.
8. Explain two ways in which ICT can enhance commerce
   • Through better advertisem*nt on the internet
   • Through better services in retail shops via point of sale terminals
   • Through electronic funds transfer
9. Explain the following software terms
   1. Portability (1mk)
      • Ability of a software to work/ function in several computer hardware and O/S platforms (
   2. Modularity
      • Ability of software to be broken down into several sections for easier understanding and maintenance.
10. 1. State two applications areas of desktop publishing software. (2mks)
       • Posters
       • Book publishing
       • Card design
    2. Explain the following graphic terms
       • Rotate- to turn an image through an angle (1mk)
       • Crop – to trim the edges of an angle (1mk)
11. Distinguish between margins and borders as used in word processing (2mks)
    • A border is a decorative frame that surrounds a page or elements on a page. The border can be a simple rule line or an elaborate set of lines and curves. A border can be composed of repeating graphic elements. Borders can be used to set apart, draw attention or unify disparate elements.
    • Margin The blank space that surrounds the text on a page or the boundary line or the area immediately inside the boundary or the blank space that surrounds the text on a page.
12. 1. List two arithmetic operations that can be performed on a row of numeric data in a word processing table
       • +,-,x,/
    2. In each case of (a) above, write the expression used (2mks)
       • = Function name (left) or = function name (right) e.g. = sum (left) (2mks)
13. List two methods of gathering information during system developments process. (2mks)
    • Observations - Interviews
    • Automatic data capture - Studying reports
14. Name three types of optical disks ( 3 mks)
    • CD- ROM
    • CD- RW
    • CD- R
    • CD – W
15. 
    
16. Study the flowchart below and answer the questions that follow
    1. Name the control structures used in the flowchart.
       
       • Selection
       • Sequencing
    2. Determine the values of M, N, P and Q.
       M………17………………..N……………….17…………………..
       P………..17………………..Q……………….17………………….
    3. Write the pseudo code for the flowchart
       START
       Initialize M=6, N=17
       P= M-N
       Q= N+M
       IF P>Q THEN DO
       N=M
       Q=N
       P=M
       ELSE
       M=N
       Q=M
       P=N
       PRINT N,M,P,Q
       STOP
17. 1. Distinguish between the following sets of terms as used in spreadsheets
       1. Worksheet and workbook
          • Worksheet – The working area in an electronic spreadsheet on which a user enters the spreadsheet data.
          • Workbook – A spreadsheet file. A workbook can obtain severalworksheets
       2. Filtering and sorting
          • Data filtering is a way of organizing spreadsheet data for ease of analysis.
          • Often spreadsheet filters are used to “hide” rows of data that do not meetcertain specified criteria. This allows you to analyze (e.g. count, observe etc) only certain “Filtering” groups of data.
            Data sorting: Is a way of arranging record according to one of the fields in either ascending or descending order.
    2. State one way in which a user may reverse the last action taken in a spreadsheet package (1 mks)
       • Use the undo command (ctrl + z)
    3. The following is a sample of a payroll. The worksheet row and column headings are marked 1, 2, 3, and A, B, C respectively.
       Write formulae using cell references for the following cells
       1. D2 = B2 * C2
       2. E4 = 10% * D4 or 10% * (B4 * C4)
       3. F10 = D10 + E10
       4. G7 = 20% * F7
       5. H5 = H5 – G
    4. 1. State three ways of moving round the page in desktop publishing window (3 mks)
          • Use cursor keys
          • use mouse scroller
          • Use scroll buttons (horizontal and vertical)
       2. State two ways on how information & communication technology (ICT) can be used to reduce the spread of HIV/ AIDS ( 2 mks)
          • Through advertisem*nts on the Internet
          • Through creation of posters
          • Through discussion groups on the internet
18. 1. Describe the following terms with reference to security of data:
       1. Log files
          • A file that lists actions that have occurred. For example, web servers maintain log files listings every request made to the server. With log file analysis tools, its possible to get a good idea of where visitors are coming from, how often they return and how they navigate through a site.
       2. Firewalls. (1mark)
          • A firewall is an information technology (IT) security device which is configured to permit, deny or proxy data connections set and configured by the organization's security policy. Firewalls can either be hardware and/or software based.
          • A firewall!\s basic task is to control traffic between computer networks with different zones of trust. Typical examples are the Internet which is a zone with no trust and an internal network which is (and should be) a zone with high trust. The ultimate goal is to provide controlled interfaces between zones of differing trust levels through the enforcement of a security policy and connectivity model based on the least privilege principle and separation of duties
    2. 1. State the primary key field for each table.
          • Student table- Admission Number
          • Fees Received table - Receipt Number
       2. State the field, which should serve as the linking field for the two tables.
          • Admission number
            (Note: Make Admission Number a foreign key in the fees table
    3. Describe the following terms with respect to computer security:
       1. Logic bombs (2 Marks)
          • A computer virus that is activated after a series of event/commands/date
       2. Physical security (2 Marks)
          • Threats that threaten the physical nature of computer equipment e.g. Fire,
          • Lightening water, building access etc
       3. Tapping. (2 Marks)
          • Telephone tapping (or wire tapping/wiretapping) is the monitoring of telephone and Internet conversations by a third party, often by covert means. The telephone tap or wire tap received its name because historically, the monitoring connection was applied to the wires of the telephone line of the person who was being monitored and drew off or tapped a small amount of the electrical signal carrying the conversation
    4. List three functions of antivirus software.
       • Identify a virus/Warn
       • Heal/Clean a virus
       • Prevent/Protect infection
       • Quarantine infected file
19. 1. Define the following web related terms:
       1. Web browser (1 mark)
          • A browser is an application program that provides a way to look at and interact with all the information on the World Wide Web.
       2. Hyperlink (1 mark)
          • This is the clickable link in text or graphics on a Web page that takes you to another place on the same page, another page, or whole other site.
       3. Hypertext document (1 mark)
          • A document usually web document (file) where the user interacts with the whole document using hyperlinks
    2. List six activities performed on the web (3 marks)
       • Browsing for information
       • Communication via email and chat groups
       • Electronic commerce.
       • Advertising of goods and services.
       • Transfer of information thro' FTP
    3. An institution has ten stand alone computers.
       1. Suggest with reasons the most appropriate topology required to interconnect the computers. (3 marks)
          1. Bus
             Reason: Easy to set up, Low cost in terms of cabling QR
          2. Star
             Reason: Speed of data transmission is high, Easy to troubleshoot via central hub or switch
       2. State the necessary steps required to connect the computers to the Internet. (4 marks)
          • Connect server to modem (router) and telephone/or use satellite dish/or radio
          • Get an ISP to configure the Internet protocol
          • Configure the rest of the computers to Internet access through a peer-topeer configuration or a client-server configuration.
    4. Below is an email address:
       Name the parts labeled:
       1. The local-part of the address/username
       2. host name domain-part
       3. generic (organizational) top level domain
       4. country code top level domain
20. 1. 
       
    2. 1. A form four student wants to create a folder to store to project State the path for flat project folder. (2 marks)
          C:\FORM4\STUDNO\ADB\PROJECT
       2. Suggest how the student can ensure that: -
          1. work is not lost in case the hard disk fails. (1 mark)
             • Keep backup copies of the project on offline secondary storage media.
          2. The project is not copied by other students. (1 mark)
             • Use passwords for opening and modifying the project
    3. 1. Other than I/O devices, list other three devices under the control of the operating
          • Main memory
          • CPU/Processor
          • Secondary storage
          • Communication device
       2. Explain any one of the devices named in c(i) above. (1mrk)
    4. Define the term trouble shooting
       • Systematic approach to locating the cause of a fault in an electronic circuit or system