KCSE 2016 Computer Studies Paper 2 Questions with Marking Scheme

Share via Whatsapp
  1. Perfect Pizza Factory manufactures pasta for distribution to restaurants in Nairobi.Assuming that you are now working for the factory and have been given the following sales data:
    table
    1. Enter the data shown above into a spreadsheet and save it as Exam 1.(10 marks)
    2. The sales for Appetos for October have been entered incorrectly, and should be 115669. Update the information in the spread sheet. (3 mark)
    3. Move the row containing Tika's information to the beginning of the list above Nankos. (1 mark)
    4. Delete the blank row after Shooters. (1 mark)
    5. Format all numeric values to 2 decimal places and use comma separators.(2 marks)
    6. Use a formula in Column H2 to calculate the Total Sales for the first restaurant.(1 mark)
    7. Copy the formula down (he column to calculate the Total Sales for all restaurants. (I mark)
    8. Use a formula to calculate the Total Sales for the Month of July. (2 marks)
    9. Copy the formula across the row to calculate the totals for the other months.(1 mark)
    10. Using an appropriate function, calculate the Average Sales for each restaurant in Column 1. (3 marks)
    11. Format Columns H and I to currency with 2 decimal places. (1 mark)
    12. Given that the July sales were 10% above the sales for June in all restaurants:
      1. enter the label *% increment' in cell A16 and a value 10 in cell Bl 6;(1 mark)
      2. insert a column before July and use absolute cell referencing to calculate the sales for June; (5 marks) 
      3. save the file as EXAM 2. (2 marks)
    13. Using a formula on cells B17 and B18 respectively, determine:
      1. the number of restaurants whose sales were above 60000 for the month of November; (2 marks)
      2. the maximum sales for the month of December. (2 marks)
    14. Create a line graph on a new sheet (monthly sales) using the file EXAM 2 in part (1) above and label the following: (8 marks)

      Chart title: Monthly Pasta Sales July-Dec 2005
      Y-axis: Total Monthly Sales
      X-axis: Month
      Legend Position: Right
    15. Print EXAM 1, EXAM 2 and the graph in landscape orientation. (6 marks)
  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: 
    1. Create a new publication named book cover with the following page layout.
      1. paper size: A4,
      2. orientation: landscape,
      3. margins: 3 cm or 1.18 inches all round.(4 marks)
    2. 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)
    3. Save and print the publication. (1 mark)

MARKING SCHEME

  1. Perfect Pizza Factory manufactures pasta for distribution to restaurants in Nairobi.Assuming that you are now working for the factory and have been given the following sales data:
    table
    1. Enter the data shown above into a spreadsheet and save it as Exam 1.(10 marks)
      Answer
      Award 1 mark for each of the 10 rows (for correct entruies only)
    2. The sales for Appetos for October have been entered incorrectly, and should be 115669. Update the information in the spread sheet. (3 mark)
      Answer
      115699 to replace 105669
    3. Move the row containing Tika's information to the beginning of the list above Nankos. (1 mark)
      Answer
      Moving row 7 to row 2
    4. Delete the blank row after Shooters. (1 mark)
      Answer
      Deleting of R12
    5. Format all numeric values to 2 decimal places and use comma separators.(2 marks)
      Answer
      Formatting to 2 d.p
      comma separator
    6. Use a formula in Column H2 to calculate the Total Sales for the first restaurant.(1 mark)
      Answer
      B2+C2+D2+E2+F2+G2
    7. Copy the formula down (he column to calculate the Total Sales for all restaurants. (I mark)
      Answer
      Copy of the formula in (f)
    8. Use a formula to calculate the Total Sales for the Month of July. (2 marks)
      Answer
      =Sum(B2:B10)
    9. Copy the formula across the row to calculate the totals for the other months.(1 mark)
      Answer
      Copy the formula in h
    10. Using an appropriate function, calculate the Average Sales for each restaurant in Column 1. (3 marks)
      Answer
      =Average(B2:G2)
    11. Format Columns H and I to currency with 2 decimal places. (1 mark)
      Answer
      Formatting of "Total Product sales" and "average" to carry 2 dp
    12. Given that the July sales were 10% above the sales for June in all restaurants:
      1. enter the label *% increment' in cell A16 and a value 10 in cell Bl 6;(1 mark)
        Answer
        Value 10 in cell B16
      2. insert a column before July and use absolute cell referencing to calculate the sales for June; (5 marks)
        Answer
        Insertion of a column
        Formula C2*$C$16
        copy of formula
        saving (file= Exam 2) 
      3. save the file as EXAM 2. (2 marks)
        Answer
    13. Using a formula on cells B17 and B18 respectively, determine:
      1. the number of restaurants whose sales were above 60000 for the month of November; (2 marks)
        Answer
        =Count if(G2:G10,">60000")
      2. the maximum sales for the month of December. (2 marks)
        Answer
        =max (H2:H10)
    14. Create a line graph on a new sheet (monthly sales) using the file EXAM 2 in part (1) above and label the following: (8 marks)

      Chart title: Monthly Pasta Sales July-Dec 2005
      Y-axis: Total Monthly Sales
      X-axis: Month
      Legend Position: Right
      Answer
      Chart sheet
      data selection
      V chart type
      Chart title
      Axes title
      Legend placement

    15. Print EXAM 1, EXAM 2 and the graph in landscape orientation. (6 marks)
      Answer
      landscape orientation
      hardcopies
  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: 
    1. Create a new publication named book cover with the following page layout.
      1. paper size: A4,
      2. orientation: landscape,
      3. margins: 3 cm or 1.18 inches all round.(4 marks)
        Answer
        2a
    2. 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)
      Answer
      2b
      2bc
      2bcc
      2bccc
    3. Save and print the publication. (1 mark)
      Answer
      Award one mark for printing
Join our whatsapp group for latest updates

Download KCSE 2016 Computer Studies Paper 2 Questions with Marking Scheme.


Tap Here to Download for 50/-




Why download?

  • ✔ To read offline at any time.
  • ✔ To Print at your convenience
  • ✔ Share Easily with Friends / Students


Get on WhatsApp Download as PDF
.
Subscribe now

access all the content at an affordable rate
or
Buy any individual paper or notes as a pdf via MPESA
and get it sent to you via WhatsApp

 

What does our community say about us?

Join our community on:

  • easyelimu app
  • Telegram
  • facebook page
  • twitter page
  • Pinterest