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.
(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.
(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. 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.
(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.
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.
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.
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.
5. List two career opportunities associated with computer networking.
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.
(a) Hybrid topology/tree/hierarchical (1 mark)
(b) Star and Bus topologies (line/linear) (2 marks)
9. (a) The implementation strategy is:
(1 mark) (b) Reasons for partial approach.
l0. (a) Importance of disk partitioning.
(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 ICTs
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.
14. Compatibility factors on computer choice.
. (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
l7 (a) Validation checks u
Any 3 x 2
(b) Methods to prevent unauthorised access:
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:
(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
19. (a) E-mail: - used to send and receive electronic documents to/from the ofﬁce.
(b) - Communication systems may fail/communication channel may fail.
(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 decimal
(b) (i) Subtract l 000112 from 0100102 using one’s complement method.
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
Kenya Scholarships for Undergraduate Students » Kenya Scholarships for Postgraduate Students » Undergraduate Scholarships for Kenyan Students » Kenya Undergraduate Scholarships » Full Undergraduate Scholarships for Kenyans » Kenya Postgraduate Scholarships » Scholarships & Grants » Undergraduate Scholarships » Universities in Kenya » Kenya Universities and Colleges Central Placement Service (KUCCPS) » Colleges in Kenya » KASNEB Registration & Results » Secondary Schools Scholarships in Kenya » Undergraduate & Graduate Scholarships for Kenyans
Scholarships for African Students » Undergraduate Scholarships » African Women Scholarships & Grants » Developing Countries Scholarships » Erasmus Mundus Scholarships for Developing Countries » Fellowship Programs » Funding Grants for NGOs » Government Scholarships » LLM Scholarships » MBA Scholarships » PhD and Masters by Research Scholarships » Public Health Scholarships - MPH Scholarships » Refugees Scholarships » Research Grants » Scholarships and Grants
Scholarships in Australia » Scholarships in Belgium » Scholarships in Canada » Scholarships in Germany » Scholarships in Italy » Scholarships in Japan » Scholarships in Korea » Scholarships in Netherlands » Scholarships in UK » Scholarships in USA