Computer Studies Paper 2 Questions and Answers - Nyeri Mocks 2021 Exams

INSTRUCTIONS TO CANDIDATES

• No passwords should be used when saving your work.
• Save your work in one folder with your Adm.no and full name.
• All questions carry equal marks. Answer all the questions.

QUESTIONS

1. Create the following Publication using a DTP package and save it as MCHANGO_1 and 
   Set paper size: A4 portrait margins 2cms all round. (5 marks)
   1. Create the front page in page 1 and back page in page 2 of your publication (25 marks)
      
   2. Using the master page insert the heading “EDUCATION IS THE KEY TO LIFE” (5 Marks)
   3. Insert thefooter of your names and index no. (2 marks)
   4. Insert page 3 and 4,then copy the front page publication to appear as 4 objects in one page one after the other. Rather fit four front page publications in one page (page 3). Using page 4 fit the back page publication to appear as 4 publications in a single page (page 4) (10 marks)
   5. Print the entire publication above (3 marks)
2. 2Queens ICT Services is a company with numerous branches in Kenya. In order to monitor the performance of the branches and that of the cities in which the branches are located, a database to organize the information is required.
   1. Create a database file and name it TeamEretria_dbms. (2 marks)
   2.                  
      1. Create a table containing the following fields. (4 marks)
         

         Field Name	Field Type
         Warehouse_NO	Number/Numeric
         Location	Text/Character
         County	Text/Character
         noOfEmployees	Number/Numeric

      2. Make the field Warehouse_NOthe primary key and save the tables as MafisiT. (2 marks)
   3.                    
      1. Create a form from theMafisiTtable and save it as Jazia_1. (5 marks)
      2. Use the form to enter the records below. (5 marks)
         

         Warehouse_NO	Location	County	noOfEmployees
         10	Alihahr co	Garissa	100
         20	Turkana ltd	Turkana	142
         30	Kiawagogi org	Nairobi	210
         40	Karura  ltd	Kiambu	150
         50	Komorocks	Mombasa	90
         60	Kogallo	Kisumu	16
         70	Moshi	Nairobi	89
         80	Tanamwanga	Kakamega	700
         90	Mogotio sisal	Nakuru	120
         100	Chebunye	Bomet	600

   4.                        
      1. Modify the MafisiTtable to include an additional field with the heading SALES (USHS) (3 marks)
      2. Enter the information below for each of the stores. (2 marks)
         

         Warehouse_NO	SALES(USHS)
         10	789,300
         20	685,400
         30	376,958
         40	255,420
         50	457,800
         60	682,458
         70	541,000
         80	235,420
         90	152,415
         10	133, 443

      3. Apply USHS as currency symbol and two decimal places to all monetary value. (2 marks)
   5.                              
      1. Create a query from the MafisiT table to display the fields Location, County, noOfEmployees and SALES (USHS) for stores whose sales are less than 400,000 and Location starts with letter K. Name it as: Start_K (3 marks)
      2. Sort the records in the query above in alphabetical order of Location field and save it as Marudio. (2 marks)
   6.                      
      1. Create a tabular report with landscape orientation from the MafisiT table to display the fields in the following order. Warehouse, Location, SALES (SHS) and compute the total sales. Save the report as MY DETAILS (4 marks)
      2. Sort records in the report in alphabetical order of the Location field. (1 mark)
      3. Insert auto number 1, 2, 3-10 at the end right side of the details. Label it RANKS. (5 marks)
      4. Placetwo straight lines cutting across the page, one above and one below the sales total. (2 marks)
   7.                    
      1. Insert a header 2QUEENSSERVICES PERFORMANCE in the report having font size 19 and centre it across the page. (3 marks)
      2. Remove the report pagination and insert your name and index numberin MY DETAILS report. (2 marks)
   8. Print MafisiT table, Marudio query and MY DETAILS report. (3 marks)

MARKING SCHEME