Computer Studies P1 Questions and Answers - Butula Sub-County Post Mock Exams 2021/2022

INSTRUCTIONS TO CANDIDATES

Write your name , school and index number in the spaces provided above
This paper consists of TWO sections A and B
Answer ALL questions in section A
Answer question 16 and any other THREE questions from section B
ALL answers should be written on spaces provided on the question paper
This paper consists of 15 printed pages
Candidates should check the question paper to ascertain that All pages are printed as indicated and that no questions are missing

FOR EXAMINERS USE ONLY

SECTION	QUESTION
A	1-15
B	16
	17
	18
	19
	20
	TOTAL MARKS

QUESTION

State one function for each of the following elements of a computer system:
1. Hardware (1 mark)
2. Software (1 mark)
3. Liveware (1 mark)
Explain two health issues that could arise from the use of an unsuitable computer desk (4 marks)
List two categories of system software (1mark)
Explain two contents of a warranty that should be considered when purchasing computer hardware (4 marks)
Students of a school intend to elect their school captain by secret ballot. State three ways in which computers can be used to improve the election process (3 marks)
Figure 1 and figure 2 show icons representing commands used to manipulate graphics in a desktop publishing package.

Explain the use of each of the icons labeled figure 1 and figure 2
Give two differences between a Graphical User Interface (GUI) and a command line Interface. (4 marks)
Identify each of the following symbols as used in a system flowchart.
1. (1 mark)
2. (1 mark)
A student typed a letter in a word processor and the last line of the letter flowed to the second page. State three ways in which the student could have adjusted the letter to fit on one page without changing the paper size. (3 marks)
A computer user is unable to retrieve a file stored in a server in an organization. State three reasons why the user would need to contact the network administrator (3 marks)
State three ways in which mobile phones have affected money transactions in the country (3 marks)
State two items that an electronic mail should have for it to be sent. (2 marks)
List four devices that use scanning technology that would be used to capture data directly from source. (2 marks)
State two ways in which hardware failure is a threat to data security. (2 marks)
Given the binary number 101011101111011, determine the number of:
1. Nibbles (1 mark)
2. Bytes (1 mark)

Section B (60 marks)
Answer question 16 and any other three questions from this section in the spaces provided

1. state the advantages of using low level programming languages (2 marks)
2. other than flowcharts, state three tools that can be used to present an algorithm (3 marks)
3. A form one admission interview consists of four tests:
  Mathematics, English, Kiswahili, and Science. In order to qualify for admission, an applicant must attain a minimum average of 65% in four tests and not less than 70% in Mathematics. All applicants must for the interview. Draw a flowchart that would read the scores for each applicant and determine whether an applicant is successful or not. (10 marks)
1. with the aid of a diagram, describe time sharing mode as used in a computer data processing (5 marks)
2. A company’s management has opted to use computers to process data. State four factors that the management needs to consider when selecting the company data processing mode. (4 marks)
3. Explain the purpose of each of the following in system documentation:
  1. User manual (1 mark)
  2. Sample data (1 mark)
  3. Table descriptions (1 mark)
1. State the role of each of the following data communication devices
  1. Repeater (1 mark)
  2. Router (1 mark)
2. Figure 3 shows a network based on the bus topology.
  1. Identify the component P (1 mark)
  2. State the function of the component labeled P (2 marks)
3. Students of Neema secondary school formed an environmental club with a goal of taking part in environmental conversation activities. Outline three ways in which they can use the internet to achieve this goal. (3 marks)
4. 1. A company has three branches A, B and C where A is the headquarter. The local area network (LAN) at A is directly connected to the LAN at B also directly connected to the LAN at C. Explain two benefits of having the LAN at B also directly connected to the LAN at C. (4 mks)
  2. State three ways in which a company can protect its computer network from hackers (3 mks)

The following is an extract from a document created using a word processor.

Other challenges include:
- Identify crisis: Who am i?
- Lack of self confidence and low esteem: I am worthless?
- Sense of hopelessness: where am I going?
- Confusion and ambiguity concerning moral issues: what is right and wrong?
- Negative impact of electronic media: Entertainment?
- Competitiveness in education the even playing field: Excellence by whom?
  Not Me
  Identify six formats that have been applied on the extract. (3 marks)
State three tools in a word processor that would help a user to minimize spelling mistakes when creating a document (3 marks)

The following is an extract of a spreadsheet created to manage sales. Use it to answer the questions that follow.

	A	B	C	D
1	ITEM NAME	UNIT PRICE	UNITS SOLD
2	Bed	12,300	2
3	Wardrobe	16,000	4
4	Blanket	5,000	4
5	Mattress	7,000	5
6	Table	10,000	3

Write a formula that will compute the number of items whose unit price is more than 10, 000. (3 marks)
if the formula =$B2 * C$2 was placed in D2, state the output if it was copied to D3.

A school administers examinations to all students in science, humanities and languages. Use the entities: EXAMINATIONS, STUDENTS, SCIENCES, HUMANITIES and LANGUAGES to illustrate a network database model.(4 marks)

1. Describe the octal number system. (2 marks)
2. Convert each of the following to the number system indicated:
  1. 111.101₂ to decimal (3 marks)
  2. 14.6875₁₀ to binary (4 marks)
3. Convert the number -17₁₀ into 8-bit:
  1. Signed magnitude representation. (2 marks)
  2. Two’s compliment (2 marks)
4. Perform the arithmetic operation. (2 marks)
  110.11₂ + 11.011₂

MARKING SCHEME

	SECTIONA(40 marks)
QNS	RESPONSES		MARKS
1.	Function of:-
	(a)Hardware: To perform tasks of inputting, storage, outputting, processing
	during data processing and communication.		1
	(b)Software:-Instructs the hardware/computer on what to do during data		1
	Processing.
	-Provides interface between hardware and liveware.
	-Accept functions of software based category i.e. system/
	application/ working/uses.		1
	(c)Liveware: Meant to design or operate a computer.
2.	Problems arising from use of unsuitable computer desk. √ It could lead to back problems if the desk is of an unrealistic height. √ If it does not provide good positioning of the monitor, it could result in eyestrain. √ Wrist problems will arise if the key board and mouse seating positions are bad. √ Injury as a result of falling computer components due to weak computer desks/ small size. (First 2 x 2)		4
3.	Categories of system software √ Firmware; √ Networking software; √ Operating system; √ Utilities.	(First 2 x ½)	1
4.	Two factors to consider when evaluating warranty √ Period/duration/scope of cover: The warranty should specify the duration of time covered. √ Service agreement/level: The warranty should indicate the type of service to be provided. √ Cost implication/ liability agreement: Cost sharing between the dealer and the buyer in the event of any loss or malfunction. √ Call out response. (First 2 x 2)		4

Three ways of using computers in electing school captain

√ Registering voters/(faster);
√ Voter identification(accurate);
√ Actual voting;
√ Tallying process (speedy).
(Any3 x 1)

Figure1:Bring to front or bring to back

Used when the target graphic is hidden by other objects. When clicked, the target graphic is brought to the front.

Figure2:Textwrap

It is used when a graphic is placed within the text area and the user needs to define how the text flows around the graphic.

Distinction of GUI and command line operating systems

GUI

Command line

Makes use of emerging software/ and hardware technologies
Their interfaces have:

ribbons
control buttons
scrollbars
menus
can process complex graphics The user interacts by:
- clicking
- scrolling
- mouse over More user friendly.

Hardly makes use of emerging hardware/software technologies. Their interfaces have:

typed commands
prompt
editor window
cannot process complex graphics Users interact by typing in commands
Less user friendly.

(Any2 x 2 )

A system flow chart symbols

Report or documentation
Disk/master file/database

Ways of adjusting a document to fit a page

√change page orientation.
√change the font;
√decrease font size;
√reduce margin size;
√reduce character spacing;
√reduce line height.
√change font style eg. bold/italic
(Any3 x 1)

10.

Role of network administrator

√to confirm that the network services are running;
√to confirm that the user is granted appropriate privilege to access the Network services/password/authentication;
√to confirm that the network infrastructure is in good condition;
√to confirm that the files sought are inexistence.
(First 3 x 1)

11.

Impact of mobile phones

√Users no longer queue in the bank in order to deposit or withdraw money;
√Easy acquisition of financial statements;
√Easy payment of bills;
√Online banking is possible;
√Money transfer is fast.
√Safer transfer of money.
√Provides wide coverage.
√Can offer services anywhere anytime.
√Cheaper money transfer services.
√Increase in fraud.
(First 3 x 1)

12.	Items that an email must have: √the email address of the recipient; √the content or message being communicated.	2
13.	Direct input methods √OBR √MICR √OCR; √OMR; √Image scanner; √Magnetic strip technology; √Image recognition/face recognition/fingerprint. (First 4 × ½)	2
14.	Insecurity arising from hardware failure √Data loss due to total system failure e.g. HD crash; √The experts called upon to repair can access critical/ valuable information; √Data recovery software may be used to make unauthorized backups. (First 2 x 1)	2
15.	Nibbles-4 Bytes - 2	1 1
	SECTIONB(60marks)
16.	(a) Advantages of using low-level language √program execution is immediate; √they require no compilation, no interpretation/translation hence they are faster; √hardware optimization is extensive; √program developed takes less memory space; √suitable for micro devices; √easy to design electronic device. (First 2 x 1) (b) Three tools that can be used to develop an algorithm √Decision table √pseudo code; √natural language; √top down charts; √flowcharts. √DFD/context diagram √ERD √decision tree (First 3 x 1)	2 3
	(c)
17	(a) Time-sharing mode This is a processing mode in which a central processor serves two or more users with different requirements. The processor time is divided equally among the tasks in the queue. A user whose task requirements are more than is apportioned is send back to the queue. For example, four jobs requiring times t1, t2, t3and t4to complete is apportioned equal time in each round until when they are done.	3 2
	(b) Factors to consider when selecting data processing mode √The optimization of processing time; √The time factor required for decision arising from the processed data; √The ease of development, use and maintenance; √The control over the resources e.g. files, I/O devices e.t.c; √The need for the shared resources among several users who may afford purchasing their own facilities as in time sharing configuration; √The volume of work involved; √The cost of acquiring the relevant hardware, software, media e.t.c and the cost of maintenance; √The nature of the task to be processed. (First 4 x 1)
	(c) Purpose of user manual It is a documentation whose purpose is to help a user to use the system With little guidance. 2 Purpose of sample data Before the system is implemented, it has to be confirmed that it is functional. Sample data is meant to be used to test whether the system is giving desired output. 2 Purpose of table descriptions They are details of table structures that the system will require for the purpose of designing the actual tables.

18	(a) Repeater A device used to re-construct data signal during data transmission to its Original strength/amplify/boost/regenerate. Router It is a device used to facilitate movement of data or packets between two Or more LANS of different configuration (expansion of networks). Delivers a packet/data directly to destination computers. Interconnects different networks/provides network services.	1
	(b)(i)The component P is the terminator.	1
	(ii)Terminatorinabackboneisusedtopreventdatasignalfrombouncingback/absorbsignals.	2
	(c)Use of internet in environmental conservation club √Source of knowledge on environmental matters; √Collaboration with peers from other schools or organizations; √Dissemination of information on what the club is doing; √Seeking for funding from sponsors. (First 3 x 1)	3
	(d)(i)Benefits of linking branch B and C √Speed of communication between B and C is increased since the traffic between the two branches can be re-routed through the link BC; √If either AC or AB is down, the three branches can still communicate; √If the HQ systems fail, the two branches Band C can communicate using this link. (First 2 x 2)	4
	(ii)Ways to protect company network from hackers √Changing password frequently √Use of encryption; √Use of data proxies; √Use of firewalls to filter unwanted packets; √User restriction e.g. passwords/ biometrics. √Use of complex password. (Any3 x 1)	3
19.	(a)Formats applied Bold, strikethrough, underline, italics, centre alignment, dropcap, bulleted list, line height / spacing, 2 column paragraph, column break, casing, font type, left alignment, column separator. (First 6 × ½)	3

	(b)Tools for proofreading √ Spellchecker and grammar/ dictionary; √ Auto complete; √ Autocorrect; √ Thesaurus. (Any3 x 1)	3
	(c) =@ or + Count if (B2: B6, “>10,000”)(B2:B6)Argument range√ 1(>10,000) Criteria √ 1 AllFormulacorrect√1 AtD3 Formula is $ B3 * C$2√ 1 = 16000#2 =32, 000√ 1	3 2

	(d) Any4 entities each ½ Any4 connectors 4 each x ½	4
20.	(a)Characteristics of octal number system. √each symbol is represented by 3bits. √The number is made of8 symbols0, 1, 2,.................... 7; √Maximum value of a single digit is7 (one less than the value of the base) √This numbersystemusesbase8. (Any2 x 1)	2

(b)(i)111.1012to decimal		210 111=1#2²+1#2¹+1#2⁰ =4 + 2 + 1 = 710 1012= 1#2+0#2+ 1#2 -1 -2 -3 =1#1+0#1+1#12 4 8 =0.5 + 0 + 0.125 = 0.62510 `111.101=7.625 2
111=710√1
0.101= 1+0+1=5√1 OR
2 4 8 8
=0.625
			3
111.1012= 7.62510or7.625 √ 1
(ii)14.687510to binary
1410= 11102√ 1
0.6875#2=1.375
0.375#2=0.75
0.75#2=1.5
0.5#2=1.0 √ 1
Decimal portion=0.1011√1
Numberis1110.10112√1			4
(c)(i) 1710= 10001 or 100012√1 10010001√ 1 binary equivalent of 17Signbit for negative.			2
(ii) 1710= 10001 In 8 bit 00010001 Reverse bits 1 1 1 0 1 1 1 0√1 + 1 1 1 1 0 1 1 1 1 Number is 11 1 0 11 1 12√			2
(d)	110.11₂+11.011₂
	1 1 0.1 1 0
	+0 1 1.0 1 1√ 1
	1 0 1 0 . 0 0 1√ 1		2