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.
-
- 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.
- Make the membership number record identifier (the primary key)
- Index on membership number.
- Save table as Clubl.
- 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
MemberSalim Said Yec/101 15.0798 5000.00 50 568880 Fully paid
Ordinary
MemberKamau John Yec/007 01.01.94 2000.00 65 443311 Senior citizen
Member with concessionary ratesOnyango Victor Yec/031 10.02.96 4000.00 37 747419 Ordinary
Member to pay 1500.00Ali Majid Yec/055 19.10.96 3500.00 32 720122 Ordinary
Member to pay 1500.00Katiku Peter Yec/067 15.05.97 0.00 25 71710 Ordinary
Member
DefaulterKorir Kelvin Yec/098 05.03.98 5000.00 38 767822 Ordinary
Member
Fully paidWafula Joyce Yec/023 23.04.95 5000.00 43 500655 Ordinary
Member
Fully paidKikoto 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 - Reserves is 10% of Gross Profit.
- Net profit - Gross profit-(Expenditure + Reserves)
- Create a workbook and enter the details as above. Save as Vendor.
- Keep the title of the workbook to be PARTNER'S VENDORS and format it to be bold, font size 14 and align at 45°.
- Format the figures in sale column to 2 decimal places.
- Use appropriate formulae/function to calculate:
- Gross profit for each member.
- Reserves for each member.
- Net profit for each member.
- Use "IF function" and net profit to analyse the vendors, taking the following remarks:
- 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.
- Print the "PARTNER'S VENDOR" and. "PRODUCTIVE ANALYSIS" chart.
-
- Insert the field called "more than 4000" that will accommodate Y for Yes and N for No.
- Indicate in these new fields those members who have paid more than sh.4000.00 with Y otherwise N.
- Save table as Club2.
-
- 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.
- Write on the paper provided the query expression you used.
- Save the query as ClubQ.
-
- Excluding the status field, create a report for all members and give it the title: ENTEREPRENEURS CLUB.
- 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 |
Download Computer Studies Paper 2 Questions - Mangu High School Mock Exams 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