Computer Studies Paper 1 Questions and Answers - Form 4 End Term 1 Exams 2022

Share via Whatsapp

« Previous Topic
Business Studies Paper 2 Questions and Answers - Form 4 End Term 1 Exams 2022

Next Topic »
Home Science Paper 1 Questions and Answers - Form 4 End Term 1 Exams 2022

Download PDF for future reference Get on Whatsapp for 50/-

Questions

SECTION A (40 MARKS)

What is meant by
1. Analogue data
2. Digital data (4mks)
Distinguish between transcription and transposition types of errors and give an example of each (4mks)
1. what are peripheral devices? (1mk)
2. Give two examples of peripheral devices (1mk)
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)
What actions should be taken in case of a fire outbreak in the computer laboratory? (4mks)
1. What is an Internet Service Provider? (1mk)
2. An employee in a business company is charged with the responsibility of putting the company advertisements 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)
Differentiate between COM ports and LPT ports (2mks)
Explain two ways in which ICT can enhance commerce. (2mks)
Explain the following software terms:
1. Portability (1 mk)
2. Modularity (1 mk)
1. State two application areas of a desktop publishing software. (2mks)
2. Explain the following graphic terms:
  1. Rotate (1 mk)
  2. Crop (1mk)
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)
List two methods of gathering information during system development process.(2mks)
Name three types of optical disks. (3mks)
The diagram below shows a formatted plate surface of a storage disk.
Shade and label:
1. one sector ( 1mk)
2. One block
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

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)

Distinguish between the following sets of terms as used in spreadsheets. (2mks)
1. Worksheet and workbook
2. Filtering and sorting
State one way in which a user may reverse the last action taken in a spreadsheet package. (1 mk)

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

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)

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
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
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

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
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)
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
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
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)
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 advertisement 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
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.
Explain two ways in which ICT can enhance commerce
- Through better advertisement on the internet
- Through better services in retail shops via point of sale terminals
- Through electronic funds transfer
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.
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)
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.
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)
List two methods of gathering information during system developments process. (2mks)
- Observations - Interviews
- Automatic data capture - Studying reports
Name three types of optical disks ( 3 mks)
- CD- ROM
- CD- RW
- CD- R
- CD – W
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
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 advertisements on the Internet
    - Through creation of posters
    - Through discussion groups on the internet
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
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
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