KCSE 2014 Computer Studies Paper 2 Questions with Marking Scheme

QUESTIONS

1. Singlen Clean Limited is a waste management company. They have new services which they would wish to introduce to their clients through a letter. An invoice for previous services offered will be attached to the letter.
   The following is a letter and an invoice to one of their clients.
   
   
   
   1. Using a wordprocessing package, create a document with the following as they appear.(1)
      1. The letter
      2. The invoice on the next page.
      3. Save the document as Singlen.(42¹/₂) marks)
   2.                          
      1. Copy the content of the document named Singlen into a blank document, Save the document as Newsinglen.(1¹/₂ marks)
      2. Convert the data in the columns; code, item description and fee per unit into a table without retyping,(2 marks)
   3. Use wordprocessing formulae to calculate the following in the invoice on the document named Newsinglen.
      1. Total amount for each item.(1 mark)
      2. Grand total.(1 mark)
         Save your work
   4. Print each of the following on both sides of the printing paper.
      1. Singlen.(1 mark)
      2. Newsinglen.(1 mark)
2. The figure below shows an extract of a worksheet showing sales and expenses for Amani Company for the months of January to June. Use it to answer the questions that follow.
   
   
   1. Create the worksheet as it appears in the figure in a spreadsheet package and save it as Incomestatement.(9 marks)
   2. Use a function that references only to cells to calculate:
      1. Total sales from January to June.(1 mark)
      2. Total for rent expenses and apply the formula to obtain the total for other expenses.(2 marks)
      3. The profit or loss for each month.(2 marks)
   3. Format the worksheet as follows:
      1. Merge the cells from A₂ to H₂ (1 mark)
      2. Resize the title to fontsize 16 and apply bold.(2 marks)
      3. Apply a single line border to all the cells containing data.(1 mark)
      4. Align to the right all the column headings in the worksheet.(1 mark)
      5. Apply a grey background colour to all column headings.(1 mark)
   4.                            
      1. Rename the current worksheet as Profit.(1 mark)
      2. Copy the content of the worksheet named Profit to a new worksheet and rename the new worksheet Modified.(1 mark)
   5. The company is expected to remit 15% of their sales as sales tax to a revenue authority
      1. Insert a blank row below the sales row and label it as "Sales Tax"(1 mark)
      2. Compute the sales tax for January using absolute cell referencing to obtain the tax for the other months.(3 marks)
      3. Calculate profit or loss for each month after taxation.(2 marks)
   6.                                      
      1. Insert a blank row below the profit or loss row and label it as "Comment".(1 mark)
      2. Use the "IF function to display comments for the profit or loss as follows:
         Profit or loss                                                         Comment
         More than 60,000                                                        OK
         More than 30,000 and less than 60,000                    Break even
         Less than 30,000                                                       Check                            (4 marks)
   7. Create a bar chart to compare the sales and the total expenses for each of the six months and:
      1. Insert the chart title: "Sales Expenses Analysis";
      2. Insert the x-axis label: "Month":
      3. Insert the y-axis label: "Amount":
      4. Insert data labels for the sales series;
      5. Save it as a new worksheet named Comparison.(11 marks)
   8. Set page orientation of the worksheet named Modified to landscape.(1 mark)
   9. Print the following worksheets:
      1. Profit;
      2. Modified:
      3. Modified showing the formula;
      4. Comparison(5 marks)

MARKING SCHEME

1.                          
   1.                          
      1. Logo
         • Word Art text (the text)
         • word Art
         • Curve layout
         • Limited (text)
         • Large L
         • Limited layout
         • Logo Layout
         • Logo position (centre)
           
           
         • Company contacts typed
         • Company contact format (bold, centred case)
         • Six lines text (completeness, position) @ 21
         • RE: Subject text
         • RE: Format (Title case, bold, underline)
         • First paragraph (existence, completeness)
         • Last paragraph (existence, completeness)
         • Other lines (existence, completeness)
         • Other lines format
         • Three columns at 1 mark
         • Tab headers format (BCs)
         • First left tab/right tab
      2. Invoice Table
         • Add table
         • R1 Merged/shading
         • R1 text (completeness, position)
         • R1 reverse text
         • R1 text format (case, centre, italics)
         • R2 Merged
         • R2 text “invoice” (bold, upper case)
         • R2 text “invoice “(underline)
         • R2 text “invoice” (vertical, centre)
         • R3 (4 columns)
         • R3 text (completeness, position)
         • R3 text format (bold, case)
         • R4 text (completeness, position)
         • R4 text format (case x 4)
         • R5 merged
         • Row 6 text (5 columns)
         • Row 6 text format
         • Row 6 text (completeness, position)
         • Row 6 text direction (No)
         • Row 7, 8, 9 text (3 rows)
         • Adjusted to fix text
         • Row 12 text (completeness, position)
         • Row 12 format ( bold, case)
         • Row 12 double border
         • Row 13 merged
         • Row 13 text (completeness, position)
         • Row 13 text format (bold, case)
      3. Saving Singlen
   2.                      
      1. Saving Newsinglen
      2. Converting columnar text to table (3 x 5)
   3. Formulae used
      1. = product / =C7*D7
      2. = sum / =E7+E8....... +E11
   4. Printing
      1. Singlen (0.5, 2 sides 0.5)
      2. Newsinglen (0.5, 2 sides 0.5)
2.                            
   1.                    
      • Saving “Incomestatement”
      • 7 columns @ 1 mark each
      • Header text (exists and complete)
      • All other text
   2.                        
      1. Total sales formula = sum (B5:G5)
      2. Total rent (Jan - June) = sum (B8:G8)
         Copying formula to other cells
      3. Profit or loss formula = B5 - Sum (B8:B12)
   3.                      
      1. Merging cells A2 - H2
      2. Title font 16
         Bold
      3. Single line border
      4. Right aligning months labels
      5. Applying grey background
   4.                            
      1. Renaming sheet to ‘Profit’
      2. Copying worksheet
         Renaming as Modified
   5.                        
      1. Inserting a blank row and naming
      2. Absolute formula = B4 * $B17
      3. Profit or loss formula = B5 - Sum (B6:B12)
         Copying to other cells
   6.                        
      1. Inserting blank row and naming
      2. = IF((B15 > 60,000), “OK”, IF(B15 >=30,000 “Break even”, check”))
         Correct function
         First selection condition
         Correct output
         Last selection condition
         Correct output
         Copying to other cells
   7. Choosing correct chart type (Bar)
      • Summing expenses
      • Choosing correct series
        • Month
        • Sales
        • Total expenses
      • Chart title
      • Labels
        • X - axis - mouth
        • Y - axis - amount
      • Moving chart to new worksheet
      • Renaming worksheet 
      • comparison
      • Data labels
   8. Changing orientation - Landscape
   9.                    
      1. Profit printing
      2. Modified printing
      3. Modified with formulas printing
      4. Comparison printing