Computer Studies Paper 2 Questions - Mangu High School Mock Exams 2022

Share via Whatsapp

QUESTIONS

Question 1
Munjiru is a secretary for the Entrepreneurs Club. She has been told to use a Database Management System (DBM) to help the club maintain records on the club's members. Perform the following operations just like Munjiru would.

  1.                      
    1. Create a database table (or file) that has the following fields of data for each member last name, first name, membership number, date of registration, membership fee paid, age, telephone number and a memo field status.
    2. Make the membership number record identifier (the primary key) 
    3. Index on membership number.
    4. Save table as Clubl.
  2. Input the following data to the above table:
     Last Name  First Name Membership Number  Date or registration  Membership fee paid  Age  Telephone number  Status 
     Munjiru Margaret  Yec/002  11.08.93  5000.00  45  573223  Fully paid
    Founder
    Member 
     Salim  Said Yec/101 15.0798  5000.00  50  568880  Fully paid
    Ordinary
    Member 
     Kamau John  Yec/007  01.01.94  2000.00  65  443311  Senior citizen
    Member with concessionary rates 
     Onyango Victor  Yec/031  10.02.96  4000.00  37  747419  Ordinary 
    Member to pay 1500.00 
    Ali Majid Yec/055 19.10.96 3500.00 32 720122 Ordinary 
    Member to pay 1500.00 
    Katiku Peter Yec/067 15.05.97 0.00 25 71710 Ordinary
    Member
    Defaulter
    Korir Kelvin Yec/098 05.03.98 5000.00 38 767822 Ordinary
    Member
    Fully paid
    Wafula Joyce Yec/023 23.04.95 5000.00 43 500655 Ordinary
    Member
    Fully paid
    Kikoto Mary Yec/048 09.06.96 2000.00 28 543421 Temporary member for 6 months only
    Vijhu Machu Yec/074 29.11.97 1000.00 55 811015 Honorary member
    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.
      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. Format the figures in sale column to 2 decimal places.
      4. Use appropriate formulae/function to calculate:
        1. Gross profit for each member.
        2. Reserves for each member.
        3. Net profit for each member.
      5. Use "IF function" and net profit to analyse the vendors, taking the following remarks:
        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.
      7. Print the "PARTNER'S VENDOR" and. "PRODUCTIVE ANALYSIS" chart.
  3.                              
    1. Insert the field called "more than 4000" that will accommodate Y for Yes and N for No.
    2. Indicate in these new fields those members who have paid more than sh.4000.00 with Y otherwise N.
    3. Save table as Club2.
  4.                    
    1. Create a query that contains the field Membership Number, Last Name, Date of registration, Membership fee paid and status for all members who have paid less than sh.4000.00 and registered after 15/4/1995 or are above 35 years of age.
    2. Write on the paper provided the query expression you used.
    3. Save the query as ClubQ.
  5.                          
    1. Excluding the status field, create a report for all members and give it the title: ENTEREPRENEURS CLUB.
    2. Save the report as ClubR.

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

Download Computer Studies Paper 2 Questions - Mangu High School 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


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?