September 1, 2022

Kenya Certificate of Secondary Education 2017 Computer Studies – Paper 3 (PROJECT) March to September 2017 7 months Mwanzo Baraka Management Information System Mwanzo Baraka organisation is a self help group intended to improve the economic status of its members through pooling of financial resources. The organisation sustains itself through registration fees of its members, monthly contributions, interest accrued through loans given to members, and penalties for delayed payments. The members benefit by getting cheap loans from the organisation. Membership to the organisation is by registration. There are two types of membership; individual and group. Group membership constitutes two or more individuals who have common interests. An individual member pays a registration fee of Kshs. 2,000 while a group pays Kshs. 5,000. During the registration of individuals, personal details are captured. When registering a group, details of the group and those of its individual members are captured. An individual member contributes a monthly share of not less than Kshs. 1,000 to the organisation. For those registered under a group, each member contributes a monthly share of not less than Kshs. 1,000 where Kshs. 200 is the group share contribution by the member. All monthly contributions are treated as shares for the contributor and attract annual dividends. Members can borrow loans from the organisation based on their total shares. Members registered as individuals can be loaned up to three times their share contribution. The repayment period does not exceed three years and the loan attracts interest at a rate of 1.2% per month on the principal amount borrowed. Members registered under a group can be loaned up to four times their individual share contribution. The repayment period does not exceed four years and the loan attracts an interest at a rate of 1% per month on the principal amount borrowed. A group can also get a group loan, amounting to three times the group’s total share contribution which attracts interest at a rate of 0.8% per month payable within five years. All payments to the organisation are monthly and must be made by the last day of the month. Any defaulted payments are penalised at a rate of 10% per month. Every end of the year, the organisation determines the total interest charged on all loans and total penalties on defaulted amounts. 60% of this amount is paid as dividends to the shareholders each getting an amount proportional to their total share contributions. The balance is retained to run the organisation. Design a computerised database system with its documentation for the Mwanzo Baraka organisation that should be able to: 1. Maintain records of members and groups. 2. Maintain records of registration fees. 3. Maintain records of monthly contributions. 4. Maintain records of loan borrowed. 5. Compute loan repayments and interest. 6. Compute income for the organisation. 7. Compute dividends to each shareholder. 8. Generate reports on demand.

KKCSE Past Papers 2017 Computer Studies Paper 2 2017 Computer Studies – Paper 2 1. Mavuno Group of hotels offer accommodation services to clients. The accommodation rooms are categorised as single, double or VIP; each attracting different rates. The rooms with fridges stocked with drinks attract an extra cost. The management of the hotel intends to use a spreadsheet program to compute the revenue from the rooms. Open the spreadsheet program and create a worksheet to appear as shown in Figure 1. Save the workbook as room charges. (15 marks) (b) Name the cell containing the value; 1500 as SR, the cell containing 2800 as DR, the cell with 3200 as VP and the cell with 300 as FR. (4 marks) In the column with title Room Charges, enter a formula that can be copied down the column to multiply the value in days by SR if the room status value is S or multiply the value in days by DR if the room status value is D or multiply the value in days by VP if the room status value is V. (8 marks) (ii) In the column with the title Fridge Charges enter a formula that can be copied down the column to compute Fridge Charges. (3 marks) (iii) In the column with the title Total Charges, enter a formula that computes the total of the Room Charges and Fridge Charges for each guest. (2 marks) (d) Format the Room Charges, Fridge Charges and Total Charges values as currency with zero number of decimal places. (2 marks) (e) (i) Copy all the contents of the current work sheet to a new worksheet (1 mark) (ii) Name the initial worksheet as ORIGINAL and the copied worksheet as NEW (2 marks) (I) (i) In the sheet named NEW, extract only the records whose ROOM STATUS is S. (2 marks) (ii) Create a column bar chart that compares the Room Charges and Fridge Charges for guests whose Guest Id are RM003, RM006 and RM0I2. (4 marks) (iii) Insert the following labels in the chart created in (ii) Chart Title X—axis Y—axis Single Room Revenue Guest ID Revenue in Ksh. (iv) Rename the chart sheet as SREVENUE. (g) Printout later each of the following: (i) ORIGINAL Worksheet (ii) NEW Worksheet (iii) SREVENUE Chart 2. The management of a county scout movement intends to award certificates of participation to the scouts who attended a fire rescue seminar. Assuming that you have been tasked to design the certificates. (a) Open a Desktop Publishing program and make the following page settings. (4 marks) (i) Orientation (ii) Units (iii) Paper size (iv) Margins landscape centimetres A 4 2 cm all round (b) Create the certificate as it appears in Figure 2. Save the design as Certificate.(45 marks) (c) Printout the certificate later. (1 mark)  

KCSE Past Papers 2017 Computer Studies Paper 1 2017 Computer Studies – Paper1 1. State the meaning of the term computer software. (2 marks) 2. State three features of fifth generation computers. (3 marks) 3. Differentiate between home page and web page as used in the lnternet. (2 marks) 4. State three characteristics of mainframe computers. (3 marks) 5. The management of an organisation intends to purchase a printer. State three factors that they should consider during the purchase (3 marks) 6. Describe each of the following computer cables: (a) Parallel cable; (2 marks) (b) Serial cable; (2 marks) 7. A computer technician has observed a lot of dust on computers in the computer laboratory. State three precautions that need to be put in place to avoid this. (3 marks) 8. Explain the term proofreading as used in word processing. (2 marks) 9. State the function of each of the following computer keyboard keys when using a word processor: (a) End (1 mark) (b) Insert (1 mark) (c) Backspace. (1 mark) 10. Explain two problems associated with the computer hard disk. (4 marks) 11. State the spreadsheet function that can be used to obtain each of the following values in a worksheet: (a) Number of cells with values in a column. (1 mark) (b) Mean of values in a range of cells. (1 mark) 12. A school intends to install wireless media in their communication system. State three advantages of this mode of communication media. (3 marks) 13. State two ways in which one can create a password which cannot be easily accessed by hackers.(2 marks) 14. State two ways through which a computer user can minimise Repetitive Strain Injuries (RSI)associated with the use of a computer. (2 marks) 15. Identify four tasks that can be achieved using a Desktop Publishing programme from the following list of tasks. (2 marks) I. Managing students records in a school II. Creating a calendar III. Designing a building structure IV. Creating a banner V. Creating a book cover VI. Processing of examination results VII. Creating business cards Section B Answer question 16 and any other three questions from this section. 16. (a) State two qualities of a good pseudocode. (2 marks) (b) With the aid of flowchart diagrams, describe each of the following programme control structures: (i) sequence (3 marks) (ii) selection (3 marks) (c) Draw a programme flowchart that would accept three ntunbers and find their sum. If the sum is greater than 200. It adds 30 to the sum, otherwise subtracts 20 from the sum. The programme should then display the results. (7 marks) 17. (a) Describe three arithmetic errors that may occur during computerised data processing. (6 marks) (b) Arnold a programmer intends to create a user input interface screen for a system. State three factors that he should consider. (3 marks) (c) With the aid of an example in each case describe the following types of maintenance. (i) adaptive; (2 marks) (ii) perfective; (2 marks) (m) corrective. (2 marks) 18. (a) Distinguish between a microwave transmission and a radio transmission. (4 marks) (b) Figure 1 shows a computer, network topology Use it to answer the questions that follow. (ii) State the function of each of the parts labelled A and B. (4 marks) (c) A computer laboratory experiences power supply problems. Describe three power related problems that should be addressed. (6 marks) 19. (a) A school has been advised to employ a database administrator. State three responsibilities of this personnel in the school. (3 marks) (b) Explain two ways in which computers can be used in the transport industry. (4 marks) (c) Mary was advised to partition a hard disk for her computer. Explain two reasons that may have necessitated this. (4 marks) (d) Explain a reason for conducting each of the following studies in systems development: (i) Schedule feasibility; (2 marks) (ii) Technical feasibility. (2 marks) 20. (a) Explain three functions of an information system in an organisation. (6 marks) (b) Explain two benefits that a company would gain from using batch processing method for data processing (4 marks) (c) (i) Convert the number l 1101.112 to its decimal equivalent. (3 marks) (ii) Perform the following binary operation 110112 + 1012 (2 marks)  

2018 Computer Studies – Paper1 2 1. (a) In a school, students reside in three dormitories Red, Blue and Orange. Each dormitory is managed by a patron and each student is required to register for a game. (i) Open a database program and create a database named schoolgames that would be used to manage the games. (1 mark) (ii) Create the tables named; Student, Patron, Dormitory and Game in the database created in (i) using the following specifications. (7 marks) Student table   Field name Description Stud No Contains  unique registration code Studname Contains the name of a student Gamecode Contains codes of each game Dormcode codes codes of each dormitory Patron table   Field name Description Patroncode Contains the  patronode name Patronname Contains the patron name Dormitory table   Field name Description Dormcode Contains the Dormcode name Dormname Contains the domitory code Patroncode Contains the domitory patron code Game table   Field name Description Gamecode contains the game code Gamename contains the name of the game (iii) Create the relationships between the tables. (3 marks) (b) (i) Create a form for each table that would be used for data entry. (2 marks) (ii) Enter the following data into their respective tables:(9 marks) Student table   Stud No Stud name Gamecode Dormcode Koo1 Ann Gmoo4 D003 Koo2 Chris Gmoo3 D001 Koo3 Jared Gmoo1 D002 Koo4 Julian Gmoo4 D003 Koo5 Marion Gmoo1 D003 Koo6 Janet Gmoo2 D003 Koo7 Tom Gmoo2 D002 Koo8 Jerry Gmoo3 D002 Patron table   Patroncode patronname Poo1 Maurice Poo2 Edward Poo3 Jane Dormitory table   Dormcode Dormname Patroname D00l Red P001 D002 Blue P002 D003 Orange P003 Games table   Gamecode Gamename Gmoo1 Basketball Gmoo2 Volleyball Gmoo3 Table Tenis Gmoo4 Netball (c) Create a query to extract each of the following details: (i) StudNo, Studentname and Gamename for all students who reside in the Orange dormitory or play Basketball. Save the query as orangeq. (5 marks) (ii) StudNo, studentname, gamename for the students whose studentname start with letter “J”. Save the query as Jquery. (3 marks) (d) (i) Create a tabular report showing the StudNo, Studentname, Dormname, Patronname, Gamename and grouped by Gamename. Save the report as reportgame. (8 marks) (ii) Format the report created in (i) as follows: I Replace the report title with the text “players for each game” (1 mark) II Enter your name and index as a report footer. III Bold the dormitory names in the report. (e) Print out each of the following: (i) Student, Patron, Game and Dormitory tables (ii) Jquery and orangeq (iii) reportgame 2 (a) (i) Open a word processing program and key in the following text as it appears. Save the documents as socialnetwork. (11 marks) SOCIAL NETWORKING Social networking platforms are used by organisation to improve communication and productivity by disseminating information among different groups of employees in a more efficient manner. The advantages and disadvantages of social media are as follows. Advantages • Facilities open communication. • Allows employees to discuss ideas. • Provides an opportunity to widen business contracts. • Targets a wide audience. • Improves business reputation and client base. • Expands market research. Disadvantages   Susceptible to fraud Potentially results to hate speech Destructs normal business operationsEmployers do have the right to ban computer activity that is not work related, this approach may not yield optimal results. If employees are to be allowed access to social networking platforms then a comprehensive and well defined policy should be established to prevent abuses. (ii) Format the document as follows: I Title: Font size l8pts, font colour red, font type Tahoma. (3 marks) II Apply double line spacing for the text under the sub title “Advantages”. (2 marks) III Apply a 4 lined drop cap on the first letter of first paragraph. (3 marks) IV Apply a two-columns format with a line between for the text with the two subtitles such that “Advantages” are to the left column and “Disadvantages” are in the right column. (4 marks) V Apply bold, italic and underline to subtitles “Advantages” and “Disadvantages”. (iii) Apply the following format to the document: (3 marks) I Insert a water mark with the text “social media” on the document of a font size of 20 and running diagonally from left to right. (4 marks) II Insert page numbers at the bottom centre of every page. (2 marks) III Insert the text “social networks” as a header aligned to the right. Apply italics to the header. (3 marks) (b) The following is a letter from a Principal of Malimali school to other Principals inviting them for a seminar at the country education offices. (i) Open a new document and create the following as it appears. Save the document as Malimali (2½ marks) The Principal > Dear Sir RE: SEMINAR MEETING You are invited to attend the Principal’s seminar which is scheduled to be at the county education office on the 2nd of June 2015. You are booked to be in <> We are looking forward to a successful event. Yours Faithfully Lilango Jotema Malimali School Principal (ii) Use a mail merge feature to generate customised mails for the addresses shown in the following table. Save the mail merged document as Aletters. (9½ marks) School Room Ginga School Room 6 Lubi School Room 8 Trans School Room 10 (c) Print out each of the following:(i) socialnetwork (ii) Malimali (iii) Aletters (3 marks)

2018 Computer Studies – Paper1 1. State two reasons for the increased use of laptop computers in government offices. (2 marks) 2. Computer network technicians prefer to use command-line based operating system when configuring networks. State three reasons for the preference. (3 marks) 3. State three measures that should be put in place in a computer laboratory to safeguard users’ health. (3 marks) 4. State three ways in which barcode readers may be used in schools.(3 marks) 5. State three advantage of flat panel monitors over cathode ray tube monitors as used in computers. (3 marks) 6. State three possible reasons for the extinction of daisy wheel printers in the market. (3 marks) 7. State three ways in which an operating system secures a computer system. (3 mark) 8. A law firm prefers to use hard copy output over soft copy output when handling documents for legal matters. State two reasons for this preference. (2 marks) 9. State the function of each of the following features in a word processor application: (a) Thesaurus;(1 marks) (b) Comments.(1 marks) 10. With the aid of an example, explain the term multi-level list as used in word processing. (3 marks) 11. Distinguish between real-time operating system and distributed operating system. (3 marks) 12. Explain the function of protect sheet feature in a spreadsheet program. (2 marks) 13. State four computer-based careers introduced as a result of computerised data processing method at the airport. (2 marks) 14. In a spreadsheet, the formula =If(A1>10, A1*77, A1*50) is entered in a cell. Interpret the results. (3 marks) 15. State a stage in systems development life cycle where each of the following activities are carried out: (a) identifying the technologies that may be used in a proposed system; (1 mark) (b) identifying shortcomings of a system; (1 mark) (c) preparing the system migration plan.(1 marks) . SECTION B (60 marks) Answer question 16 and any other three questions from this section in the spaces provided. 16. (a) With the aid of a flow chart, describe a loop control structure as used in programming.(4 marks) (b) Study the following pseudocode and answer the questions that follow. 1. Start 2. Get value l and value2 3. If value I > value2 Then 4. Maximum = valuel 5. Else If value l < value2 Then 6. Maximum = value2 8. Else Go to 9 9. Display Maximum 10. Stop (i) State the purpose of the pseudocode.(1 mark) (ii) Draw a flowchart equivalent to the pseudocode. (6 marks) (c) Distinguish between a source program and a compiler as used in computer programming.(4 marks) 17. (a) (i) Explain the term search engine as used in the Internet.(2 marks) (ii) Peter intends to download a movie from the Internet. State the three factors that may determine the total time taken to complete the download. (3 marks) (b) Wakulima online is an organisation that runs a web based system for assisting farmers to obtain market for their farm produce. State four technological reasons that may cause a farmer not to access the organisation’s system. (4 marks) (c) Explain a situation when each of the following Desktop Publishing program features may be used when creating a publication: (i) cropping;(2 marks) (ii) transparency.(2 marks) (d) List two areas where infrared waves are used in data communication.(2 marks) 18. (a) State four activities of the planning stage of systems development. (4 marks) (b) Explain a circumstance when each of the following feasibility studies are carried out during systems development: (i) Technical;(2 marks) (ii) Economic;(2 marks) (iii) Schedule.(2 marks) (c) Table 1 and Table 2 are related tables in a database. Use them to answer the questions that follow. Table 1   Dept Code Dept Name 001 Computer 002 Aviation 003 Engineering Table 2   Dept ID Students Registration No. Students Name 002 st1 Alex Toro 003 st2 Naomi Komi 002 st3 Peter Kengo (i) Identify the appropriate primary key for each table. (1 mark) (iii) Explain two benefits of enforcing referential integrity in the database. (4 marks) 19. (a) Describe each of the following validation checks as used in data processing: (i) Preserve check;(2 marks) (ii) Data type check;(2 marks) (iii) Check digit.(2 marks) (b) Write each of the following abbreviations in full: (i) BCD;(1 marks) (ii) EBCD;(1 marks) (iii) ASCII.(1 mark) (c) Using 10 — bits binary number system, perform the following decimal operation using two’s complement (6 marks) l2910 12810 20. (a) The figure shows a network design. Use it to answer the questions that follow. (i) Explain the function of each of the following in the network. I Router; II Firewall;(2 marks) III File server.(2 marks) (ii) State two categories of software that must be installed in a computer so that users can use it to access the internet. (2 marks) (b) State four ways in which computers may be used to manage data in a research environment.(4 marks) (c) Some computer companies have opted to use the Internet to provide shared processing resources and online application services to users. State three advantages that this approach will have on their customers. (3 marks)  

Kenya Certificate of Secondary Education 2019 Computer Studies – Paper 2 1.Form 1 Class Teachers of Mwango secondary school intend to use a data base to manage students o Secondary School intend to use a database to manage students performance in three examinations: opener,mid term and endterm examination. (n) Open a database program and create a database named analysis. (1 mark) (b) (i) Create three tables named Class, StudDetails and StudMarks in the database file created in (a) using the following details: (14 marks) Class Table   Field Name Data Type and Properties ClassID ClassID Text (size 2) ClassName ClassID Text (size 25) Teacher ClassID Text (size 25) StudDetails Table   Field Name Data Type and Properties    AdNo Number StudName Text (size 25) Gender Yes/No (yes for female) ClassID Text (size = 2) Look up values,IE,IN,IW StudMarks Table   Field Name Data Type and Properties AdNo Number Opener Number MidTerm Number EndTerm Number (ii) Create the relationships between the tables. (2marks) (iii) Create a form for the Class table and add a subform for the StudDetails table using the format in £gure 1. Save the form as dataentry. ClassID ClassName Teacher   AdNo StudName                    Gender ClassID (iv) Enter the following data into their respective tables in the database (l2½ marks) Class TabLe   ClassID ClassName Teacher                 IE Form One East   Elvis Barongo                 IN Form One North    Alice Nadiya                 IW Form One West Paul Mkacharo StudDetails Table       AdNo StudName Gender ClassID 7984 Mary Kikoti Female 1E 7460 Erica Kamburi Female 1E 7800 Axlam Khan Male       1E        8083     Martin Mkanjala Male       1E       8092     Esther Peresian         Female 1N 8490     Micah Lokiyoto         Male 1N      8082     Mohamed Ayan Male 1N     7896 Mark Kwalima         Male     1W     7892     Morgan Lema        Male 1W     8184     Emily Mawasi Female 1W     8047     Edward Omogeni Male 1W       AdNo Opener MidTerm EndTerm 7984       85 Female 82 7460 73 Female 79 7800        78 Male 86        8083         81 Male 87       8092 73         Female 83 8490 71         Male 87      8082 81 Male 90 7896 88         Male 88 7892      85        Male 89 8184     85 Female 83 8047         90 Male 86 (c) Create a query to display the fields: (i) AdNO, StlldName, ClassID, Opener, MidTerm and EndTer m for all students in Form One East. Save the query as FIE. (4½ marks) (ii) AdNo, StudName, ClassID, Opener, MidTerm and EndTerm arld a Calculated field named meanscore to display the average in the three examinations. Save the query as overall. (6 marks) (d) Create a report to display details of each student as it appears in Figure 2 (2 ½ marks) (e) Print out each of the following: (3 marks) (i) the three tables (ii) the two queries (iii) report for the first two students 2. The Chief Printer of Zenith Printers Company would like to have business cards. As a Desktop Publishing (DTP) expert, you have been tasked to design the card for the officer. (a) (i) Open a Desktop Publishing program and set the page layout as follows: • Paper size: 8.5 cm width by 5.5 cm height • Layout type: multiple pages per sheet • Target paper size: A4 • Orientation: Portrait • Margin: 0.75cm all round (5 marks) (ii) Save the publication as business card. ( 1 mark) (b) Design the card as it appears in Figure 3 ensuring that the card covers all the space in the page. (42 marks) (c) Print out 10 copies of the card on a single A4 page.(2 mark)

Kenya Certificate of Secondary Education 2019 Computer Studies – Paper 1 Section A Answer all the questions in this section State the hardware technological differences between the second generation and the third generation computers (2 marks) 2. State two ways of ensuring proper ventilation in a computer room. (2 marks) 3. Convert the decimal number 20.373 to its binary number system equivalent. (2 marks) 4. Peter has installed internet in his home computer in order to use it for browsing. State three ways in which he would prevent viruses from infecting his computer. (3 marks) 5. State three ways of transforming a picture embedded in a Desktop Publishing programme in order to fit in a designated space on a document. (3 marks) 6. Differentiate between a line printer and n page printer as used in computers.(2 marks) 7. Describe virtual reality as used in computers. (2 marks) 8. State the function of each of the following features of an email software: (a) Inbox (1 marks) (b) Draft (3 marks) 9. (a) Explain the term loggle key as used in computer keyboard. (2 marks) (b) List examples of toggle keys on a computer keyboard. (2 marks) 10. State the type of error that would occur in data processing for each of the fol1owing cases: (a) Entering the number 315 instead of 351. (3 marks) (b) Entering the text “Kwys” instead of “Keys”. (3 marks) 11. State four factors to consider when selecting an input device for use in a computer room (4 marks) 12. State three functions 0f Un-interrupted power supply (UPS). (3 marks) 13. Distinguish between a page break and a column break as used in a word processor. (3 marks) l4. State three factors to consider when selecting an operating system to instal in a computer (3 marks) 15. Differentiate between analogue data and digital daia as used in computers. (2 marks) Section B Answer question 16 and any other 3 questions from this section. 16. (a) Explain the term dry running as used in program development.(2 marks) (b) Explain three properties of an algorithm. (6 marks) (c) To qualify to get a driving license,an applicant must be 18 years or over. Ten candidates applied for a driving license test. Draw a flow chart that would read the name and age of an applicant and display the names of those who qualify, (7 marks) 17.(a) State four outcomes that may result from using incorrect requirement specifications during system development (4 marks) (b) A school opted to use direct change over approach when installing a new system. Explain three challenges that die school may face as a result of this approach. (6 marks) (c) State three reasons that may lead an organisation to install an intranet.(3 marks) (d) The figure below shows a coaxial cable .State the function of the part labelled A. (2 marks) 18. (a) State three hardware devices that may be required to connect a computer to an existing local area network. (3 marks) (b) A publisher intends to use a desktop publishing programme to create a publication which is to have many graphics. State three ways in which the graphics may be acquired for this purpose. (3 marks) (c) Interpret each of the following spread sheet formula : ; (i) =countif(D2:D9,”>”$B4) (2 marks) (ii) =sumif(B3:B11,”4M”,D3:D11) (d) (i) The following are Ellie fields of products fable in a database created to store records of products manufacturing in a factory: • product number • product name • price • product description 1. State the appropriate data type for each field. (2 marks) II. State three properties to be put in place during table design to ensure integrity of the data entered. (3 marks) 19. Explain three features of a graphical user interface as used in computers (6 marks) (b) State the function of each of the following computer keyboard keys: (i) Caps Lock (1 marks) (ii) Shift (1 marks) (iii) Home (1 marks) (c) Using two’s complement notation,determine the value of the operation 2510-2910 (6 marks) 20. (a) Distinguish between computer Aided Instruction (CAI) and computer Aided Learning (4 marks) (b) (i) State four activities that may be carried out when disposing off an old system in an organisation. (4 marks) (c) State three benefits gained from the advancement in technology in the music industry (3 marks)  

Kenya Certificate of Secondary Education 2020 Computer Studies – Paper 2 Section A 1.The management of a company owning a chain of hotels intends to use a spreadsheet program to compute the revenues in thousands of Kenya shillings for the hotels during the 1st, 2nd, 3rd and 4th quarters. The hotels are rated as 2 star, 3 star, 4 star and 5 star. Figure 1 shows extract of the worksheet.   A B C D E F G 1 HOTEL STAR CATEGORY 1st 2nd 3rd 4th TOTAL REVENUE 2 City Inn 4 174,400 177,400 127,900 180,800 3 Forkland 2 173,700 111,300 194,900 10 ,700 4 Highway 4 182,900 136,300 143,900 144,600 5 Hiltop 5 188,500 124,700 173,500 171,200 6 Membley 5 187,800 118,700 115,900 195,500 7 Voyager 3 139,100 178,400 109,600 179,700 8 Eden 2 200,000 112,200 109,100 117,200 9 Palm tree 4 169,800 163,000 173,000 148,300 10 The Shaza 5 163,900 106,800 107,100 150,500 11 12 13 14 Total Quarterly Re venue 15 Administrative cost 16 Percentiige 30% (a) Open a spreadsheet program and create the worksheet extract as it appears in Figure 1. Save the workbook as Task 1. (11 marks) (b) Use a function and cell addresses to calculate: i) total revenue for each quarter; (2 marks) i1) total revenue for each hotel. (2 marks) (c) () Insert two rows above row 1 and type the title “MBALAMBALA GROUP HOTELS” in cell Al (2 marks) ii) Merge the cells in the range Al:GI. (1 mark) (ii) Apply bold and font size 15 to the title. (1 mark) (a) Open a spreadsheet program and create the worksheet extract as it appears in Figure 1. Save the workbook as Task 1. (11 marks) (b) Use a function and cell addresses to calculate: (i) total revenue for each quartei,(2 marks) (ii) total revenue for each hotel.(2 marks) (c) (i) Insert two rows above row 1 and type the title “MBALAMBALA GROUP HOTELS” in cell Al. (2 marks) (ii) Merge the cells in the range AI:G1.(1 mark) (iii) Apply bold and font size 15 to the title.(1 mark) (a) Using cell addresses only, compute the administrative cost for each quarter given that the cost is a percentage of total revenue and the percentage rate is in cell B18.(3 marks) (b) Apply thick outside borders and regular inside borders to cells in the range A3: G18.(2 marks) (c) (i) Copy all the contents of the current worksheet to a new worksheet. (2 marks) (ii) Rename the old worksheet as oi iginal and the new worksheet as formatted. (2 marks) (d) (i) Change the page layout orientation of the formatted worksheet to landscape and the page size scaled to 80%. (2 marks) (ii) Enter the values 2, 3, 4 and 5 in the cell range B20 : B23 respectively representing the hotel star category ratings. (1 mark) (iii) Using a function and cell references: I. compute the total revenue for each hotel references; II. compute the total revenue for each hotel category in the 1st quarter using reference values in the range B20 : B23 in cells C20 : C23. (5 marks) (iv) Sort the revenues front the hotels 1n descending order of hotels. (2 marks) (e) (i) Create a column chart that compares the revenues of the hotels in star category 4 for the 1st and 2nd quarter. (4 marks) (ii) Format the chart created as follows: I. Chart title “FIRST AND SECOND QUARTER REVENUES”(2 marks) II. Move the chart to a new sheet and rename the sheet as FourStar Revenues.(2 marks) (i) Save the changes and print later each of the following: (i) original worksheet showing the column and row headings;(2 marks) (ii) formatted worksheet;(1 mark) (iii) Four Star Revenues chart.(1 mark) 2. Popo City planners intend to use a Desktop Publishing program to draw a plan for a section of a city. Assume you have been given the task. (a)(i) Open a desktop publishing program and set the page layout orientation to portrait and paper size to A4. (2 marks) (ii) Save the publication as Task 2. (1 mark) (b) Create the city plan as it appears in Figure 2 ensuring that the design covers the entire printable area of the page. (46 marks) (c) Save the changes and print the publication later. (I mark)

Kenya Certificate of Secondary Education 2020 Computer Studies – Paper 1 Questions Section A Answer all questions in this section 1. Outline three distinctions between a super computer and microcomputer. [3 marks] ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ 2. State four features of fifth generation computers. [4 marks] ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ 3.(a). Explain two uses of forms in database design. [2 mark] ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ (b). i). Define the term control as used in report and form design. (1 mark) ______________________________________________________________________________ ______________________________________________________________________________ (ii). Explain briefly the difference between bound and unbound controls. ( 2marks) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ 4. State any two differences between function keys and special keys of a keyboard. [2 marks] ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ 5. In system development, testing is one of the critical stages. Give three reasons why the testing phase is critical to the systems developer. [3 marks] ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ 6. Write the following abbreviations in full. [3 marks] i). BCD ii). ASCII iii). EBCDIC 7. State two properties that an operating system display about a file. [1 mark] ______________________________________________________________________________ ______________________________________________________________________________ 8. Differentiate between Computer Aided Design CAD and Computer Aided Manufacture (CAM). [4 marks] ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ 9. (a). Distinguish between a primary key and index key as used in databases. [2 marks] ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ (b). Explain the relevance of foreign key in a database entity. (1 mark) ______________________________________________________________________________ ______________________________________________________________________________ 10. List three differences between laser printer and a dot matrix printer. [3 marks] ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ 11. Name an input or output device used in the following tasks. (2 mark) a). Capturing still images ________________________________________________________________________ (b). Printing detailed architectural designs ________________________________________________________________________ (c). Playing flight and driving games ________________________________________________________________________ (d). Capture data at ATM ________________________________________________________________________ 12. What is the use of the search and replace feature in a word-processor. (1 mark) ______________________________________________________________________________ ______________________________________________________________________________ 13. State two ways in which a computer may be used in efficient running of a hospital. (2 marks) ______________________________________________________________________________ ______________________________________________________________________________ 14. The formula = $A4*C$3 was entered in cell D4. What will be the formula if it is copied to cell F10. [1 marks] ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ 15. Name any three methods that can be used to test a program of errors. (3 marks) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ SECTION B [60 MARKS Answer question 16 and any other three questions from this section. 16.[a]. Design a flowchart for a simple program that can be used to categorize people according to age. If the person is above or equal 18 years, output “Adult” otherwise output “Young”. (8 marks) (b).What is the difference between looping and selection? (2 marks) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ [c]. Name the stage of program development cycle when: [2 marks] (i). A user guide would be written ______________________________________________________________________________ (ii). A programmer dry-turn the code ______________________________________________________________________________ (iii). System charts would be drawn ______________________________________________________________________________ (iv). Staff training is done ______________________________________________________________________________ (d). State the three translators used in programming. (3 marks) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ 17.(a). Define the term data communication. (1 mark) ______________________________________________________________________________ ______________________________________________________________________________ (b). Explain the following terms as used in data communication. (2 marks) (i). Bandwidth ______________________________________________________________________________ ______________________________________________________________________________ (ii). Attenuation ______________________________________________________________________________ ______________________________________________________________________________ (c). Explain the following three types of computer networks. (3 marks) i). LAN ______________________________________________________________________________ ______________________________________________________________________________ ii). MAN ______________________________________________________________________________ ______________________________________________________________________________ iii). WAN ______________________________________________________________________________ ______________________________________________________________________________ (d).i). What are robots? (1 marks) ______________________________________________________________________________ ______________________________________________________________________________ (ii). Outline any four advantages of using robots in industries over human beings. (2 marks) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ (e). Describe the following communication modes giving an example in each case. (6 marks) (i). Simplex ______________________________________________________________________________ ______________________________________________________________________________ (ii). Half duplex ______________________________________________________________________________ ______________________________________________________________________________ (iii). Full duplex ______________________________________________________________________________ ______________________________________________________________________________ 18. [a].List two characteristics of good information. [2 marks] ._____________________________________________________________________________ ______________________________________________________________________________ (b(i). What is a database management system? [1 mark] ______________________________________________________________________________ ______________________________________________________________________________ (ii). State and explain three database models. (3 marks) ______________________________________________________________________________ ______________________________________________________________________________ c). Describe the following types of files. (i). Master file (2 marks) ______________________________________________________________________________ ______________________________________________________________________________ (ii). Backup file (2 marks) ______________________________________________________________________________ ______________________________________________________________________________ (iii). Transaction file (2 marks) ______________________________________________________________________________ ______________________________________________________________________________ d). Explain the file organization methods given below. (i). Serial (1 mark) ______________________________________________________________________________ (ii). Indexed sequential (1 mark) ______________________________________________________________________________ (iii). Random (1 mark) ______________________________________________________________________________ 19. (a). A shopkeeper of a small shop at Long is a has bought desktop computer to assist him in performing his business activities. He has been advised that before he can use it to work he has to install it with an operating system. State any six factors to consider when choosing the operating system. [6 marks] ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ b). With reference to disk management explain what is meant by the terms below. i). Formatting (1 mark) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ii). Defragmentation (1 mark) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ iii). Disk partitioning (1 mark) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ c). Give any two reasons that may make the shopkeeper to partition the computer disk. [2 marks] ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ (d). The shopkeeper one day switched on the computer and experienced a number of problems with windows operating system that he had installed. The problems included failure to load the operating system during the booting. After several trials of switching on the computer, it hangs State any four possible causes for the computer’s behaviour. (4 marks) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ 20. (a) Describe the octal number system. (2 marks) ______________________________________________________________________________ ______________________________________________________________________________ (b). Convert each of the following to the number system indicated: i). 111.1012 to decimal; (3 marks) ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ (ii). 14.687510 to binary [4 marks] ______________________________________________________________________________ ______________________________________________________________________________ ______________________________________________________________________________ (c). Convert the number -1710 into 8-bit: (i). signed magnitude representation; (2 marks) ______________________________________________________________________________ ______________________________________________________________________________ (ii). two’s complement (2 marks) ______________________________________________________________________________ ______________________________________________________________________________ (d). Perform the arithmetic operation. (2 marks) 110.112 + 11.011

11.0 CHEMISTRY (233) 11.1 Chemistry Paper 1 (233/1)  

Chemistry Paper 1 (233/1) 1.a)X is water. or H20 b)It is slightly soluble in water. J and denser than air. c) Used in hospitals to resuscitate patients. Used in welding when mixed with acetylene in the ocy-acetylene flame. Used by divers and mountaineers. _ Rocket fuel, hospitals for breathing, steel making.2NaHCO3(S) + com) + H20“) W1) 2AgNO3(s) – > 2Ag(s) + 2NO2(g)+O2(g) 21= 04m -> F6203“) + SO + (1) 3. Crush the seeds in a mortar using a pestle.  Add a suitable solvent (acetone / propanone  Filter out the solid matter.  Evaporate the filtrate to obtain oil.4. a) Aluminium has a stronger metallic bond because it has more delocalised electrons than sodium. b) Sulphur has a tinged structure of S8 molecules whiles chlorine is diatomic. The forces in sulphur are stronger than chlorine. 5. a) It does not sublime. b) Cut a piece of Sodium metal, place it on a defiagrating spoon, heat it briefly then lower it into a gas jar of chlorine . It will continue buming forming Sodium Chloride. 6 a) Cu2+(aq) + 2e —> Cu(s) b) 63.5 g require 2 x 96500 C l.l84g = 63.5 3598.6 coulombs J (1) Q = 1.7.92.2. 3586.5 = 2xt 60 35865 =t = 29.988 2   z 30 minutes ) 1799.3 s =t (V2) 7 (a) (i) X – Calcium carbide or CaC, (ii) Y – CH2 = CHCl Chloroethene or vinylchloride (b) Floor tiles  Rain coats  Plastic bags8 Working diagram. a should be deflected less than B because of its heavier mass. 9. ln water. HCI is ionised ginto H and Cl the Chloride ions are oxidised to chlorine gas by potassium permanganete. In methylbenzene, HCl remains in molecular gform i.e HCl. The Chloride is not available for oxidation hence no reaction. 10 (a) T (b) l5 g t/111 (c) Fractional crystallization 11 (a) NZHW + Ow ~> NMI + 2H:O (b) Bond breaking energy l63 + 4 (388) + 496 = 2211 kJ   Bond making energy 944 + 4 (463) =_27% kl Ethalpy change = Bond breaking + Bond making energies. 2211 +(-2796) = -585 kl/mol 12 a) The acidified permanganete will be decolourised (purple to colourless) b) The permanganate (Vll) is reduced to manganese (II) ion. (i) A white precipitate forms. (ii) Ba2+ +SO2-/3 —> BaSO_ 13 a) [Zn(NH4/3]2+ b) Zn2= + Mg —> Mg2+ + Zn 14 .Charles Law At constant pressure. the volume of a fixed mass of gas is directly proportional to its absolute temperature. 1 b) 1 = vs km P 1v [Ht = I46 dp _1_r =T l1=l8+._73:36lK T : P3: 10! km P1 v =12? T 1><36l H TI:- 98.39 l-16 T 4849313 14364.94 ~ 1- r = 273.22 K 15. a) R and T b) T 16 Zinc granules The gradient of the graph is less” steep (11 because there is less surface area. 17 NO + O —> 2NO b) Because nitrogen is inert. c) Nitrogen (ll) oxide is oxidised to Nitrogen (IV) oxide which is a pollutant. H 18 (a) Water (b) Bubbles of gas and a white ppt CO2. (P/Q) reacts to give CaCO, 19 (a) These are different forms carbon in the same physical state. (b) The hexagonal graphite rings have weak Van der Waals forces between the layers that allow the layers to slide over each other (1) while in diamond the atoms are held by strong Covalent bonds. . 20 (a) The atomic radii increase with increase in atomic number. This is due to increase in energy levels. (b) The group II elements have more protons than group I elements hence this increases the nuclear attraction for the outer electrons. J 21 (a) Cu2 or copper ions (b) C1 and OH’ 22 (a) Copper pyrites chalcocite, malachite (b) To concentrate the ore (c) – Brass – Batteries 23 (a) 100-25=75 cm (b) CxHy + O2 —> C02 + H20 15 cm’ 75 cml 45 cm 1 5 3 Cx Hy =-Iy + 5 O2—> 3 CO2 + 4 H20 x = 3 y = 8 C3H8 t/(1) 24 Ca(NO3)2 —> Ca + 2NO3 RMM of Ca(NO)2 = 164 Concentration of Ca(NO3)2 = 4.1 Conc. in g/l RMM Molarity = = Q 164   = 0.025M J M) 1 mole Ca(NO3)2 E 2 moles Nitrate 0.025 iii E 2 0.025 0.05M 25 It would remain unchanged (1) There is no water to form hypochlorous acid 26 When aqueous sodium chloride is added to Ca2 . There is no ppt while a white ppt is formed when aqueous sodium chloride is added to a solution containing Pb 27 (a) N. being a weak acid provides few H’ to be neutralised by OH” hence there is a slight increase in temperature. (b) CH3COOH + KOH ) —> Cl-l3COOKmq] + H20“) 28 (a) Experiments 1 and 3. J (b) In experiment 1, the ions in K2CO3 are tightly held in position and cannoot move V while sugar solution does not have ions that can carry a current in solution. 29 1 H mass 18 2 1 H mass 20