2013 KCSE Computer Studies Past Paper
4.9.1 Computer Studies Paper 1 (451/1)
SECTION A (40 marks)
Answer all the questions in this section in the spaces provided.
1. Write each of the following acronyms in full as used in computing.
2. A school keeps student records in a database. The data is coded before entry.
3. State three reasons why the coding is necessary.
4. Differentiate between Bcc and cc in an email.
5 . State three risks posed by improper cabling in a computer laboratory.
6. List two career opportunities directly associated with computer networking.
A retailer uses a spreadsheet program to calculate proﬁts. Figure 1 shows the spreadsheet.
(a) Which row contains labels only?
(b) Write the formula that has been entered in cell F2. (2 marks)
(1 mark) 7. State three reasons why an organisation may opt to develop its own software in-house rather than buy off-the-shelf software.
8 The topology below is formed by combining two types of topologies.
(a) Give one name for the combined topology in ﬁgure 2. (1 mark)
(b) Name the two topologies forming the combined topology in ﬁgure 2. (2 marks)
9 An organisation intends to replace an existing system by carrying out the process in stages.
(a) Name this implementation strategy. (1 mark)
(b) Give two reasons why the organisation is opting to use the implementation strategy in (a) above. (2 marks)
10 (a) Explain the importance of disk partitioning. (2 marks)
(b) Differentiate between pull-down menu and pop-up menu as used in Graphical User Interface (GUI) operating systems. (2 marks)
11 The 21st century has had many forms of ICI‘ technologies improving the various means of communication. However, these changes have brought many challenges. State three negative social impacts of these technologies. (3 marks)
12 Explain why a DTP application would be preferred to a word processing application when designing a publication. (2 marks)
13 A computer is idle but the hard disk light is blinking, indicating some activity. State two possible causes of this. (2 marks)
14 Describe compatibility as a factor to consider when purchasing a computer. (2 marks)
15 identify the appropriate output device for the production of each of the following:
(a) receipts where carbon copies are required;
(b) an architectural drawing where precision is required; (1 mark)
(c) output where the user is visually impaired.
SECTION B (60 marks)
Answer question 16 and any other THREE questions from this section in the spaces provided.
16. (a) Figure 3 shows a ﬂowchart. Use it to answer the questions that follow.
(i) Determine the output from the ﬂowchart if:
I. X = 5; (2 marks)
II. X = 7. _ (2 marks)
(ii) Write a Pseudocode for the ﬂowchart in ﬁgure 3. (5 marks)
(iii) Modify the ﬂowchart so that it can be used to get the sum of integers between 50 and 100. (4 marks)
(b) List two programming language translators. (2 marks)
17 (a) Describe three types of validation checks as used in data processing. (6 marks)
(b) A company has opted to store its employees’ personal details in a computer system.
Describe two software methods that may be used to prevent unauthorized access to these details. (4 marks)
(c) (i) Describe each of the following data processing modes: ‘ l. real-time; I (2 marks)
II. interactive. (2 marks) (ii) State an application area where real-time data processing mode is applied. (1 mark) 18 Figure 4 shows an advert placed in a newspaper. Use it to answer the questions that follow.
(a) (i) Deﬁne a laptop computer. (l mark)
(ii) The screen is said to be 17 inches. Explain what this means. (2 marks)
(b) State one advantage of having each of the following provided with a laptop.
(i) modem ……………………………
(iii) free suite
(c) State the software package in the free suite which is most suitable for each of the following:
(i) computing budgets
(ii) creating documents ……………………. ..
(iii) designing of brochures
(iv) records management
(d) (i) State three advantages of using a computer to design an advert such as the one in Figure 4. (3 marks)
(ii) State two beneﬁts of having the advert uploaded on the internet. (2 marks) A worker is unable to travel to the ofﬁce but may still be able to do the ofﬁce work through telecommuting.
19 (a) Explain why the worker may use each of the following:
(i) email; (2 marks)
(ii) fax; (2 marks)
(iii) digital camera; (2 marks)
(iv) ﬁrewall. (2 marks)
(b) The worker needs to make regular backups of documents sent to the ofﬁce. State three reasons for this. (3 marks)
(c) Explain two beneﬁts that the employer will get by allowing this worker to do the ofﬁce work through telecommuting. (4 marks)
20 a) Differentiate between 0ne’s complement and two’s complement in data representation. (2 marks)
(ii) Explain the preference of binary number systems over decimal number systems in computers. (2 marks)
(b) (i) Using one’s complement, subtract 1000112 from 0100102. (4 marks)
(ii) Convert the number 21 0312510 to its binary equivalent. (S marks)
(c) Perform the following binary operations.
Computer Studies Paper 2 (451/2)
1. Table 1, table 2 and table 3 are extracts of records kept in a health centre for patients, doctors and consultations respectively.
i Using a database application package, create a database ﬁle named PATIENTSINFO. (1 mark)
ii Create three tables named PATIENTS, DOCTORS and CONSULTATIONS that will be used to store the data in table 1, table 2 and table 3 respectively. (14 marks)
iii Set the primary key for each table. (3 marks)
iv Create the relationships among the tables. (2 marks)
b) (i) Create a data entry form for each table. (3 marks)
(ii) Enter the data in table 1, table 2 and table 3 into the Patients, Doctors and Consultations tables respectively. (9 marks)
c) (i) Create a query named PatientAge to display Patients’ Names, Gender and Age on the year of visit. (4 marks)
(ii) Create a query named Beatricedetails to display Patients’ Names, Ailment and Consultation Dates for patients treated by Doctor Beatrice. (3 marks)
d) (i) Create a report to display the Patients’ Names, Consultation Dates, Ailments and the Names of the Doctors consulted. The records in the report should be grouped by Patients‘ Names and the number of consultations by each patient should be displayed. (5 marks)
(ii) Title the report as “Consultations Per Patient” and save it as Consultations. . (2 marks)
e) Print the following:
(i) Tables: Patients, doctors and consultations;
(ii) Queries: PatientAge and Beatricedetails;
(iii) Report: Consultations;
(iv) Form: Consultations.
2. The Figure on page 5 shows the design of the cover page of a book. It comprises of the front, the back and space in between where book pages will be attached. Use a desktop publishing package to design the cover page as follows:
a) Create a new publication named book cover with the following page layout.
(i) paper size: A4,
(ii) orientation: landscape,
(iii) margins: 3 cm or 1.18 inches all round.
b)Enter the text and objects and format them as they appear in the Figure. The front and back sections of the book cover,_each measures 18 cm (7.1 inches) by 12.5 cm (4.9 inches) and the space between them measures 1.7 cm (0.7 inches). (45 marks)
c) Save and print the publication.
2013 KCSE Computer Studies Past Paper-Marking Scheme/Answers
5.9.1 Computer Studies Paper 1 (451/1)
1. (a) CAD – Computer aided design.
(b) DVD – Digital video disk digital versatile disk.
(c) WORM – Write once read many.
(d) POS – Point of sale/point of sale terminal.
2. – Indexing becomes easier. Minimises on memory used. Ease of data entry. Reduces redundancies/double entry. Speedy searches due to shortened comparisons Simpliﬁes validation
3. In cc, all the recipients of the mail are able to see other recipients of the same mail.
Bcc: In Bcc, all recipients of the mail are not able to see other recipients. 2 marks
4. – Risk of electric shocks to the users. Risk of ﬁre outbreaks in the laboratory. Risk of tripping and injuries.
5. List two career opportunities associated with computer networking. Network administrators Network engineers – Network technicians
6. (a) Row 1 or 1
(b) = D2 * E2; = product (D2. E2)
OR = Product (D2: E2)
7. – Customised to suit business needs of the organisation. It can be upgraded as needed by the organisation. The organisation can have a module that the competitors don‘t have. The organisation develops only the modules needed/memory eptimization. or storage/space.
(a) Hybrid topology/tree/hierarchical (1 mark)
(b) Star and Bus topologies (line/linear) (2 marks)
9. (a) The implementation strategy is:phased change-over/modular
(1 mark) (b) Reasons for partial approach.It gives employees opportunity to learn Organization can revert to old system in case of failure. Reduces resistance by employees.
l0. (a) Importance of disk partitioning.Disk partitioning enhances logical management of ﬁles since ﬁles can be grouped into partitions based on their roles. Enhances disk maintenance since partitions can be formatted, deleted or modiﬁed individually without affecting ﬁles stored in other partitions. Partitioning helps in virus management. This is done by keeping system ﬁles in one partition with limited access rights. Viruses would therefore lack access to the system ﬁles. Enables installation of more than one operation system. (2 marks)
(b) Difference between pull-down and pop-up menus
A pull-down menu is a list of commands that appears as a list from the menu bar going down which is invoked by the click or alt key whereas a pop-up menu is a list that appears anywhere on the screen when there is a click.
11. Negative social impact of ICTslntemet addiction Privacy violation Exploitation (sexual) through Ponography Crime – fraud on the intemet Cyber terrorism Recuirtment to drug trafﬁcking/drug abuse
12. Explanation of DTP preference over word processor in designing a publication. DTP is designed with facilities to support and manipulate graphics that are not found in traditional wordprocessors. eg. the facilities are such as page layout, colour libraries and object layering.
13. Possible causes of Hard disk blinking. Virus executing itself. Updating of some software applications. Network access taking place.
14. Compatibility factors on computer choice. Compatibility with available software. Being able to have the available software installed. Having the available peripherals in the market being able to be connected.
. (2 marks)
15. Appropriate output devices
(i) Carbon copies – impact printers e.g.dot matrix.
(ii) Architectural design – plotter
(iii) Visual impairment – speakers brailles.
16. (a) (i) Output from the ﬂow chart if:
(l) when X = 5,output = I5 (2 marks)
(iii) Modifying the ﬂowchart sum between 50 and 100
(b) Language translatorsAssemblers Compilers Interpreters
l7 (a) Validation checks uRange checks: checks that data lies within a range of values. Presence checks: checks that data is there and has not been missed out. Length checks: checks that ﬁelds are of the right number of characters. Type checks: checks that the data is of the right type. Format checks: checks whether data is in the correct format.
Any 3 x 2
(b) Methods to prevent unauthorised access:Password: A secret word; a string of characters known only to a restricted group for authentication. User Access levels: A case where each group is granted different levels of BCCCSS User Access rights: An individual is granted access or denied access to (c) (i) (I) Real-time
ln a real-time processing, there is a continual input. process and output of data instantaneously upon receipt of command. (11) Interactive processing
A computer processing in which the user can modify the operation appropriately while observing results at critical steps.
(ii) Application area for real-time mode
Airline booking. medical system, car tracking system, hotel booking system, banking system.
Deﬁnition of a laptop computer
12 (a) (i) ls a portable computer small enough to be used on laps.
(evidence of portability, mobility, small size) l7″ screen (ii) Diagonal length of the screen. An indication of the size of the screen. (mention of size only 1 mark)
(b) Advantages of the following:
(i) modemFor internet connectivity Converts analog signal to digital signals and vice versa. It is wireless technology of internet at any point. (ii) USB Most peripheral devices are connected to the computer via USB ports. Has high speed rate. Supports both power and data transmission. One USB can support 127 devices at a time.
(iii) Free suite:
The user is not required to buy a licence for use of the software. (several software packed as one) (c) Package suitability
(i) Computing budgets – spreadsheets.
(ii) Creating documents – word processor.
(iii) Designing brochures < DTP.
(iv) Records management – Databases/spreadsheet.
(d) (i) Three advantages of using a computer for designing an advert such as the one in ﬁg. 4 Advert can be stored for future use. Modiﬁcation of the advert is easy. Ease of design due to tools and template availability advantages/does not require an expert. Ease of upload. Can be electronically sent. (ii) 2 beneﬁts of Intemet advertising as in ﬁgure 4. Wider coverage. Feedback from viewers/ visitors can be received instantly. Service is throughout. cost is low.
19. (a) E-mail: – used to send and receive electronic documents to/from the ofﬁce.receive instructions from the supervisor or co-workers. (any e-mail related work) Fax: – Used to send documents which are in non-electronic format (any fax related work) Digital camera – Used to capture images in picture form/video conferencing. Firewall – Used to prevent intrusion to the home computer because telecommuting involves connection to the intemet.
(b) – Communication systems may fail/communication channel may fail. The document sent may get lost due to sending to wrong address. The documents may be re-used or updated. Malfunctioning of either sending/ receiving computers (failure of DTE).
(c) Employer will only pay for work done. The working time is not limited to ofﬁcial working hours/ofﬁce available 24 hours. Employer saves on ofﬁce space. Does not have to pay for commuter allowance. Employer may not require permanent employees. Employer may outsource expert skills that are not available locally.
(a) (i) In one‘s complement, a negative number is represented by taking all its bits in the positive number and inverting them. In two’s complement, you start with one’s complement but add 1 to the results.
In two’s complement, there are no two ways of presenting a zero. In one’s complement, overﬂow bit is added back to the answer but ignored in two’s complement.
(ii) Binary number system over decimalit is easy to program. uses bi-state devices which can either be ON or OFF. Binary can be used to represent all types of data.
(b) (i) Subtract l 000112 from 0100102 using one’s complement method.
5.9.2 Computer Studies Paper 2 (451/2)
1 a (i) Creating a database named PATIENTSINFO Caps
Table 1 ii) Creating and naming the table (Patients) 1 mark
Creating and naming ﬁelds (underscored or joined or spaced) 4 ﬁelds
Creating and naming the table (Doctors)
Creating and naming ﬁelds
Creating and naming the table (Consultations)
Creating and naming ﬁelds
5 @ 2 mark each
(iii) Primary keys
Table 1: Patients number
Table 2: Doctors number
Table 3: Consultation number
(iv) Two relationships (correct ﬁelds)
(b) (i) Creating data entry forms (forms with all ﬁelds)
(ii) Data entry – 18 records
(C) (i) Display of patient names and gender
Naming query – Patient Age
Computation age column
Age(Year[consultation date]-[year of birth])
(ii) Selecting conect ﬁelds – Name Ailment
Consultation date 2 mark, Criteria – Beatrice 2
Doctor name = “Beatrice”
Saving the query – Beatricedetails
d) (i) Selection of tables patients and doctors
Selection of ﬁelds 4 (Names. Consultation date, ailment, names of doctors)
Grouping (patient name)
Grouping total (count of number of consultations)
(ii) Saving the report – Consultations
Report title – Consultations per patient
(c)(i) Printing 3 tables
(ii) Printing 2 queries
(iii) Printing 1 report
(iv) Printing l form (consultation)
2 (a) Margin – page layout 4
Orientation (order/arrangement of back/spine/front)
Saving (Book Cover)
Fit of the three parts – back, spine and front
(b) Authors / Rectangle
Text typing I mark text either case
Text box positioning/text position at centre
lnsertion of Rectangle/text-box
Fill type (gradient shading)/gradient centre
Positioning the rectangle
Inserting textbox/thick outline border
text typing (capital) text + title case
positioning in relation to the front cover
Position of the computer
Drawing four polygons
Filling polygons 4 penalise for wrong
Six sided star 5 sided and 8 sided
Copying and pasting star
Positioning star 1 and star 2
Filling (ﬁll) different from the border
Revised edition triangle
Right angled triangle
Fill (white) – no shade
Text typing 1 mark )
Quick revision guide
Typing text (text & caps + initial)
Background colour of the textbox
Positioning of textbox
Nyota Publishing Press
Positioning of textbox
Typing of text (text & case)
Positioning of text box
Background (ﬁll pattem)
Fitting in between
Resizingl I star ﬁtting inside the spine
Copying star/existence of the star
Positioning star 2
Outline (thick border)
Filling (no ﬁll)/ white
Sizing/ﬁtting proportional to the rectangle
Text in rounded rectangle
Typing text 4 paragraphs (existence and completeness
Bullets (style & character)
title case -last paragraph
Text ISBN 2145
Bars varying thickness
Position of ISBN and Bars
No ﬁn ISBN and bars
Text at bottom
Text and case