QUESTIONS
Question 1
- Set your paper to portrait and the margins to 2.4cm(or 0.94’’) all round (2 Marks)
- Type the document as it is using Times New Roman font face, font size 12 and save it as ‘SDLC’ (30 Marks)
- Set the column spacing to 2.4cm (or 0.94’’) (2 Marks)
- Copy the document above and save it in a new file called ‘SYSTEMS’ (2Marks)
- 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.
- Change the character spacing of the title to the following settings: (3 Marks)
- Scale 87%
- Spacing -Expanded
- Kerning - 13 points
- Create a diagonal watermark text called ‘STAREHE BOYS’ CENTRE’ on the SYSTEMS document saved above (2 Marks)
- Indent the Paragraph beginning with the words "System design" as follows: (2 Marks)
- Left 0.5cm
- Right 1.2cm
- Insert page numbers e.g. 1 of X centered, on the footer with your index number on the right margin (2 Marks)
- 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
- Reserves is 10% of Gross Profit.
- Net profit = Gross profit – (Expenditure + Reserves)
- Create a workbook and enter the details as above. Save as Vendor. (20 marks)
- 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)
- Format the figures in sale column to 2 decimal places. (2 marks)
- Use appropriate formulae/function to calculate:
- Gross profit for each member. (3 marks)
- Reserves for each member. (3 marks)
- Net profit for each member. (3 marks)
- Use “IF function” and net profit to analyse the vendors, taking the following remarks: (6 marks)
- If net profit > = 500, then “V.good vendor”
- If net profit >400, then “Good vendor”.
- If net profit < = 300, then “Dormant vendor”.
- 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)
- 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/-
Get on WhatsApp 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