Computer Studies P2 Questions - Momaliche 4 cycle Post Mock Exams 2021/2022

Share via Whatsapp

QUESTIONS

Question 1

  1. Set your paper to portrait and the margins to 2.4cm(or 0.94’’) all round (2 Marks)
  2. Type the document as it is using Times New Roman font face, font size 12 and save it as ‘SDLC’ (30 Marks)
  3.  Set the column spacing to 2.4cm (or 0.94’’) (2 Marks)

system development cycle

  1. Copy the document above and save it in a new file called ‘SYSTEMS’ (2Marks)
  2. Spell check the document and format the heading ' SYSTEMS DEVELOPMENT LIFE CYCLE’ to have the following styles (3 Marks)
    • Centred across the page.
    • Font face: Arial.
    • Font size: 45.
    • Background colour: grey.
  3. Change the character spacing of the title to the following settings: (3 Marks)
    • Scale 87%
    • Spacing -Expanded
    • Kerning - 13 points
  4. Create a diagonal watermark text called ‘STAREHE BOYS’ CENTRE’ on the SYSTEMS document saved above (2 Marks)
  5. Indent the Paragraph beginning with the words "System design" as follows: (2 Marks)
    • Left 0.5cm
    • Right 1.2cm
  6. Insert page numbers e.g. 1 of X centered, on the footer with your index number on the right margin (2 Marks)
  7. Re Save your work and print the two documents. (2 Marks )

Question 2

The following is a worksheet extracted from business partner’s vendors. They have come together to do a business of selling computer accessories
PARTNER’S VENDORS

Names

Cost

Sales

Gross profit

Expenditure

Reserves

Net profit

Remarks

Samson Too

700

350

 

450

     

Victor Onyango

400

700

 

50

     

James Ahenda

200

950

 

250

     

Peter Kimaiyo

300

650

 

300

     

Alice Visaho

100

300

 

100

     

Salome Nyarago

400

550

 

50

     

Joseph Opiyo

650

600

 

40

     

Sonia Wambui

555

885

 

55

     

Mary Wayudo

250

850

 

70

     

Leah Wanjera

500

360

 

54

     

Joy Maelo

700

350

 

45

     

Mohammed Dida

900

1000

 

180

     

Kevin Momanyi

850

950

 

25

     

Michael Karanja

110

700

 

50

     

Hilda Njeri

350

800

 

150

     


Additional information

  1. Reserves is 10% of Gross Profit.
  2. Net profit = Gross profit – (Expenditure + Reserves)

 

  1. Create a workbook and enter the details as above. Save as Vendor. (20 marks)
  2. Keep the title of the workbook to be PARTNER’S VENDORS and format it to be bold, font size 14 and align at 45°. (3 marks)
  3. Format the figures in sale column to 2 decimal places. (2 marks)
  4. Use appropriate formulae/function to calculate:
    1. Gross profit for each member. (3 marks)
    2. Reserves for each member. (3 marks)
    3. Net profit for each member. (3 marks)
  5. Use “IF function” and net profit to analyse the vendors, taking the following remarks: (6 marks)
    1. If net profit > = 500, then “V.good vendor”
    2. If net profit >400, then “Good vendor”.
    3. If net profit < = 300, then “Dormant vendor”.
  6. Use names of the vendor and cost to insert line graph, keep the title of the graph to be PRODUCTIVE ANALYSIS, format it and place it in a separate sheet. (5 marks)
  7. Print the “PARTNER’S VENDOR” and “PRODUCTIVE ANALYSIS” chart. (4 marks)

Download Computer Studies P2 Questions - Momaliche 4 cycle Post Mock Exams 2021/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?

Join our community on:

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