Computer Studies Paper 2 Questions and Answers - Lanjet Joint Mock Exams 2023

INSTRUCTIONS TO CANDIDATES

• Write your name and index number on the CD/removable storage medium provided
• Write the name and version of the software used for each question attempted in the answer sheet provided
• Answer all the questions
• All questions carry equal marks
• Passwords should not be used while saving in the CD/removable storage Medium
• Hand in all the printouts and the CD/removable storage medium used
• All the work should be saved at the desktop of your computer in a folder named with our name and index number. All the work in your folder should be burned to the CD/WR provided

1. The Management of a company owning a chain of hotels intend 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, 3star, 4 star and 5 star. Figure 1 below shows an extract of the worksheet.
   
   1. Open a spreadsheet program and create the worksheet extract as it appears in Figure 1. Save the workbook as Task 1 (11 marks)
   2. Use a function and cell addresses to calculate:
      1. Total revenue for each quarter; (2 marks)
      2. Total revenue for each hotel. (2 marks)
   3.  
      1. Insert two rows above row 1 and type the title "MBALAMBALA GROUP HOTELS" in cell Al (2 marks)
      2. Merge the cells in the range Al: G1. (l mark)
      3. Apply bold and font size 15 to the title. (1 mark)
   4. 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)
   5. Apply thick outside borders and regular inside borders to cells in the range A3:G18  (2marks)
   6.  
      1. Copy all the contents of the current worksheet to a new worksheet. (2marks)
      2. Rename the old worksheet as original and the new worksheet as formatted  (2 marks)
   7.  
      1. Change the page layout orientation of the formatted worksheet to landscape and the page size scaled to 80%. (2 marks)
      2. Enter the values 2, 3, 4 and 5 in the cell range B20: B23 respectively representing the hotel star category ratings. (1 mark)
      3. Using a function and cell references:
         1. Compute the total revenue for each hotel references;
         2. 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)
      4. Sort the revenues from the hotels in descending order of hotels. (2 marks)
   8.  
      1. Create a column chart that compares the revenues of the hotels in star category 4 for the 1st and 2nd quarter. (4 marks)
      2. Format the chart created as follows:
         1. Chart title "FIRST AND SECOND QUARTER REVENUES" (2 marks)
         2. Move the chart to a new sheet and rename the sheet as FourStar Revenues. (2marks)
   9. Save the changes and print later each of the following:
      1. Original worksheet showing the column and row headings; (2 marks)
      2. Formatted worksheet;  (1 mark)
      3. FourStar Revenues chart. (2marks)
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.
   1.  
      1. Open a desktop publishing program and set the page layout orientation to portrait and paper size to A4. (2 marks)
      2. Save the publication as Task 2 (l mark)
   2. Create the city plan as it appears in Figure 2 ensuring that the design covers the entire printable area of the page. (46 marks)
   3. Save the changes and print the publication later.    (1 mark)
                                                                  142
                                                       POPO CITY PLAN
      

                                                                                MARKING SCHEME