Print this page

Bunyore Maranda MOCKS 2016 Computer Studies Paper 2

Rate this item
(0 votes)
Download PDF for future reference Install our android app for easier access
    1. Create a database and save it as school database.
    2. Create a Table called 'Students Table' in the school database with the following. (7 marks)

      FIELD NAME DATA TYPE FIELD SIZE/FORMAT 
       ADM-NO  Text  10
       Name  Text  15
       Surname  Text  15
       Tel-No  Number  Long Integer
       Date of Birth  Date/time  Medium date
       Fee - Paid  Currency  Currency
       Foreigner  Yes/No  Yes/No
    3. Make the "AM_Number" Find the Primary Key (1 mark)
    4. Open the "Students Table" and enter the following records. (3 marks)

      ADM-NO Name Surname Tel-No Date of Birth Free-paid Foreigner
       4567 John Maina Muiru 55-67543 19/09/1990 25000 No
       4576 Mary Nthenya Mutua 44-23456 20/12/1991 27000 No
       4398 Mark Okech Otieno 22-65473 13/03/1992 20000 No
       5678 Peter Rick Ben 11-76742 15/06/1994 29000 Yes
       4378 Joan Liz Patel 13-89734 18/09/1990 26000 Yes
       4897 Peter Amos Ben 33-37482 17/04/1993 20000 Yes
       4643 Muoka Muoki Nzoki 44-45362 12/12/1991 23000 No


    5. Insert the record given below as record 4. (2 marks)
      4120   Rebecca Kalewa   Ben   44-24242   13/10/1990   27000   No

    6. Delete Mary Nthenya's record from the database file. (2 marks)
    7. Sort the table in Ascending order by surname. (2 marks)
    8. Move the Date-of-Birth and Tel-No fields so that Date-of-Birth field is now directly after the surname field. (4 marks)
    9. Change the field size of the surname to 20 (1 mark)
      1. Create a Form with all fields on the Students Table. (2 marks)
      2. Name the form student Entries. (1 mark)
    10. Insert a picture in the form in a way that all text is visible. (3 marks)
      1. Create a report based on the Student's Table showing the Fields Name, Surname and Tel No. (3 marks)
      2. Name report Telephone list. (1 mark)
    11. Insert a picture in the report header. (2 marks)
      1. Create query 1 showing all fields of those students whose surname is Ben. (3 marks)
      2. Create query 2 showing all fields of those students born after 1991. (3 marks)
      3. Create query 3 showing only the Student's name, Student's Surname and Student's Date of birth. (3 marks)
      4. Create query 4 showing the fee balance of all students given the total fee is 35000 and Fee-balance = Total_Fee - Fee_paid (3 marks)

    12. Print Students table, Student Entries form, Telephone list, query_1, query_2 and query_3, query_4 (4 marks)


  1. The following is a worksheet extracted from business Join Venders. They have come together to do a business of selling computer accessories.
    Names Cost Sales Gross Profit Expenditure Reserves Net profit Remarks
    Benson 700 350   450      
    Betwel 400 700   50      
    Kimwat 200 900   200      
    Amos 300 1000   300      
    Tembur 100 500   100      
    Korir 400 600   40      
    Towett 600 850   55      
    Maritim 500 350   70      
    Kerich 200 350   45      
    Beney 500 1000   40      
    Danson 600 900   170      
    Kones 900 1000   20      
    Koech 100 800   130      

    Additional Information
    (a) Gross profit = Sales - Cost
    (b) Net profit = gross profit - (expenditure + reserves)
    (c) Reserves = 10% gross profit
    (d) Remarks are: "very good vendor," "good vendor", "domain vendor", "burden vendor", "Quite vendor"

    1. REQUIREMENT
      1. Create the workbook and enter the details, save as vendor. (15 marks)
      2. Keep the title of the workbook to be JOIN VENDORS and format it to be bold, font size 14 and align at 20(4 marks)
    2. Format the figures in sale column to 2 decimal places. (3 marks)
    3. Insert two rows between Tembur and Koris and enter the records below: (5 marks)
      Name Bii, cost 100, sales 500 and expenditure 10
      Name Mutai, Cost 800, Sales 2000 and expenditure 80
    4. Use non function to calculate gross profit for each member (3 marks)
    5. Use product function to calculate reserves for each member. (3 marks)
    6. Use "IF function" and net profit to analys the vendors, taking the following remarks. (6 marks)
      1. If net profit >= 55, then "very good vendor"
      2. If net profit >= 400, then "good vendor"
      3. If profit <= 300, then "domain vendor"
      1. Use names of the vendor and cost to insert a line graph. Keep the title of the graph to be PRODUCTIVE ANALYSIS, format it and place it in a separate sheet. (5 marks)
      2. Save the changes as productive analysis. (2 marks)
      3. Print the "Join Vendor" and "productive analysis" including gridlines. (4 marks)
Read 664 times Last modified on Monday, 04 September 2017 14:40
Print PDF for future reference Join our whatsapp group for latest updates

Related items