Computer Studies Paper 2 Questions and Answers - Mathioya Mock Exams 2022

Share via Whatsapp

Questions

Instructions to candidates

  • Indicate you name and index number at the top right hand corner of each printout.
  • Write your name and index number on the CD/Removable provided.
  • Write the name and version of the software used for each question attempted in the answer sheet.
  • Answer all the questions
  • All questions carry equal marks.
  • Passwords should not be used while saving in the CD/Removable provided.
  • All answers must be saved in your CD/Removable provided.
  • Make a printout of the answers on the answer sheet.
  • Arrange your printouts and staple them together.
  • Hand in all the printouts and the CD/Removable used.
  • Candidates should answer the questions in English.

 

  1. The following is a worksheet extracted from Mathioya Youth Group Vendors. They have come together to do a business of selling computer accessories.
            MATHIOYA YOUTH GROUP VENDORS
    NET PROFIT ANALYSIS
     Vendor Name Cost  Sales  Gross Profit  Expenditure  Reserves  Net Profit  Remarks 
     Susan Muthoni 7 000   13 500    1 450       
     Dennis Ikahu 4 000   7 000    1 500       
     Judith Nekesa 2 000  9 800   800      
     Peter Kiondo 3 000  6 500    800       
     Alice Ruguru  1 000 3 000    700       
     Salome Maina  4 000 5 500    500       
    Joseph Opiyo 6 500 8 000   400      
    Sonia Wambui 5 550 8 885   550      
    Mary Watiri 2 500 8 850   700      
    Leah Wanjeri 5 000 9 360   540      
    Joy Maelo 7 000 10 350   450      
    Mohammed Dida 9  000 12 000   1 800      
    Kevin Nyutu 8 500 10 950   1 250      
    Michael Karanja 1 100 5 700   1 500      
    Hilda Njeri 3 500 8 000   1 150      
    Additional information
    1. Gross profit = Sales – Cost
    2. Reserves is 10% of Gross Profit.
    3. Net profit = Gross profit – (Expenditure + Reserves)
      1. Create a workbook and enter the details as above. Rename the worksheet as Partner’s Vendor hence save your file as Youth Group. (18 marks)
      2. Keep the title of the centered across the table and format it to be bold, font size 16 and Rockwell font. (2 marks)
      3. Apply a text direction of 45° to all column labels in the table above. (2 marks)
      4. Format the figures in sale column to 2 decimal places. (1 mark)
      5. Using Data Validation tool apply a rule to the cells under Vendor names label as follows: (3 marks)
        Settings: Allow text whose length is larger than five.
        Input Message: With a title, “Vendor Name” and a message “Kindly enter a vendor name in this cell”.
        Error Alert: Title, “Invalid Input” and a message “The name you entered is too short for this cell. Please try again”. With a style Stop.
      6. Use appropriate formulae/function to calculate:
        1. Gross profit for each member. (2 marks)
        2. Reserves for each member. (2 marks)
        3. Net profit for each member. (2 marks)
      7. Use “IF function” and net profit to analyse the vendors, taking the following remarks: (4 marks)
        1. If net profit > = 5000, then “V.Good vendor”
        2. If net profit > 2500 to 4999, then “Good vendor”.
        3. If net profit < = 2500, then “Dormant vendor”.
      8. Type the labels Sales Above 5000 and Total Expenditure above 500 in cells A21 and A22 respectively. (1 mark)
      9. Using appropriate functions work out the Number of Sales exceeding 5000 and then Total Expenditure exceeding 500 into cells C21 and C22 respectively. (2 marks)
      10. Insert a new column between Expenditure and reserves and label it as Expenditure Rank. Use the new column to find the expenditure position using an appropriate function. The vendor with the least expenditure should be given Position 1 while the one with highest should be given the last position. (4 marks)
      11. Use names of the vendor and cost to insert line graph, the title of the graph to be Productive Analysis, format it and place it in a separate sheet. (5 marks)
      12. Print the Partner’s Vendor and Productive Analysis chart. (2 marks)
  2.    
    1. Use a DTP software to design the following publication as it is with the following settings:
      1. paper size = A4
      2. orientation = Landscape
      3. page margins = 0.5 inches all around
      4. Guides = 3 equal column guides
      5. File name = DotNetGen (5 marks)
    2. Create the three textboxes containing the story. Link the textboxes so as to have the text Autoflowing to the next textbox once the previous one gets filled up. (5 marks)
    3. Design the publication as it appears on the following page on the page you have created and fit all the items within the page. (31 marks)
    4. Disable automatic hyphenation from the story in the textboxes. (3 marks)
    5. Insert your name and admission number as header, then your class and page number as footer. (4 marks)
    6. Print the publication. (2 marks)

Comp2q02

Confidential

The information contained in this document is to enable the headteacher of the school and the teacher in charge of Computer Studies (451/2) to make adequate preparation for this year’s examination.

 
Each school offering Computer Studies should ensure that:
  1. Each candidate is provided with a computer which has:
    • a new blank CD-RW (i.e. compact disk re-writable)
    • a DVD writing drive
    • The following software installed:
      1. DTP - MS publisher or PageMaker
      2. Word processor - MS Word
      3. Spreadsheet - MS Excel
      4. Database - MS Access
  2. Enough computers and fast printers. Two shifts of candidates are recommended.
  3. Provide IBM compatible computers
  4. Computer teacher should disable the network and computer related examination in the beginning of each session.

Marking Scheme

  1.      
    1. Create a workbook and enter the details as above. Rename the worksheet as Partner’s Vendor hence save your file as Youth Group.
      18mks
      • Entering all data into a worksheet
      • Correctness/accuracy in entry of data
      • Application of borders to the table
      • Bolding the header row and title
      • Typing title in two lines/rows (i.e. not as one continuous line)
      • Renaming the worksheet as Partner’s Vendor
      • Correctly saved file as Youth Group
    2. Keep the title of the centered across the table and format it to be bold, font size 16 and Rockwell font.
      • Merging and cantering the title across the table
      • Bolding, Font size and Font
    3. Apply a text direction of 45° to all column labels in the table above.
      At least 4 Correctly rotated labels @ ½
    4. Format the figures in sale column to 2 decimal places.
      Correct format of decimals in sales values to 2 d.p.
    5. Using Data Validation tool apply a rule to the cells under Vendor names label as follows:
      Comp2qa01e
      Settings: Allow text whose length is larger than five.
      Input Message: With a title, “Vendor Name” and a message “Kindly enter a vendor name in this cell”.
      Error Alert: Title, “Invalid Input” and a message “The name you entered is too short for this cell. Please try again”. With a style Stop.
    6. Use appropriate formulae/function to calculate:
      1. Gross profit for each member.
      2. Reserves for each member
      3. Net profit for each member.
    7. Use “IF function” and net profit to analyse the vendors, taking the following remarks:
      1. Attempt to use IF function
      2. Use of IF Function correctly as follows
        =IF(G4>=5000,"V.Good vendor",IF(G4>=2500,"Good vendor","Dormant vendor"))
      3. Copying the formula to all cells
    8. Type the labels Sales Above 5000 and Total Expenditure above 500 in cells A21 and A22 respectively. (1 mark)
    9. Using appropriate functions work out the Number of Sales exceeding 5000 and then Total Expenditure exceeding 500 into cells C21 and C22 respectively.
      • =COUNTIF(C4:C18, “>5000”)
      • =SUMIF(E4:E18, “>500”)
    10. Insert a new column between Expenditure and reserves and label it as Expenditure Rank. Use the new column to find the expenditure position using an appropriate function. The vendor with the least expenditure should be given Position 1 while the one with highest should be given the last position.
      • Inserting Column
      • Attempt to insert RANK function
      • Using RANK function correctly i.e. =RANK(E4,$E$4:$E$18,1)
      • Copying the formula
    11. Use names of the vendor and cost to insert line graph, the title of the graph to be Productive Analysis, format it and place it in a separate sheet.
      Comp2qa01k
      • Line Chart
      • Correct Series
      • X-Axis Labels
      • Title
      • Y-Values
    12. Print the Partner’s Vendor and Productive Analysis chart.
  2.   
    1. Use a DTP software to design the following publication as it is with the following settings:
      • paper size = A4
      • orientation = Landscape
      • page margins = 0.5 inches all around
      • Guides = 3 equal column guides
      • File name = DotNetGen
    2. Create the three textboxes containing the story. Link the textboxes so as to have the text Autoflowing to the next textbox once the previous one gets filled up.
      • Drawing/inserting three textboxes into respective columns @ 1mk
      • Creating Links between the boxes @ 1mk
    3. Design the publication as it appears on the following page on the page you have created and fit all the items within the page.
      Attempt to use correct fonts
      Heading in the shape:
      • Enlarged font size
      • White Font colour
      • Correct shape
      • Shape fill colour

        Text Below heading: By Timothy Williamson…
      • Italics
      • Right aligned

        Text In Columns
      • Completeness
      • Alignment (Justify)
      • Bolding (any four @ ½)
      • Italicizing (any four @ ½)
      • Paragraph spacing
      • Drop cap
      • Vertical text (19th Century computers)
      • White font colour
      • Large font
      • Vertical direction

        Circular Logo
      • Word art
      • Drawing
      • Arrangement

        Box at Bottom right Corner
      • Compound border
      • Inserting Symbol
      • Facebook logo
      • Text alignment (center)
    4. Disable automatic hyphenation from the story in the textboxes.
      • Removal of hyphens in each text box @ 1mk
    5. Insert your name and admission number as header, then your class and page number as footer.
      • Attempt to insert header
      • Correct Header
      • Attempt to insert footer
      • Correct Footer
    6. Print the publication.

Download Computer Studies Paper 2 Questions and Answers - Mathioya Mock Exams 2022.


Tap Here to Download for 50/-




Why download?

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


Join our whatsapp group for latest updates
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?