COMPUTER PAPER 2 - 2019 LAINAKU JOINT MOCK EVALUATION EXAMINATION

QUESTION 1

1. Type the following passage exactly as it appears using a word processor and save it as EXERCISE (20marks)
2. 1. PROCESS OF INFORMATION SYSTEM DEVELOPMENT
      INTRODUCTION TO INFORMATION SYSTEM DEVELOPMFNT
      The methodology area can justly be described as a jungle. Firstly there appears to exist many hundreds of the system development methodologies. Longworth (1985) in a recent study identified over 300. If all these are different, then it is no wonder that there is so much confusion. However, it may be that the differences are trivial and are made solely to differentiate methodologies in the market place
      WHAT IS A METHODOLOGY?
      The term methodology is not well defined either in Literature or by practitioners.
      There is very little agreement as to what it means other than at a general level. The term is usually used very loosely and yet it is used very extensively.
      This loose use does not mean that there are no definitions, simply that there are no universally agreed definitions. At the general level, it is regarded as a recommended series of steps and procedures to be followed in the course and developing an information system. In a brief adhoc survey, this proves to be about the maximum that people will agree to and of course such a definition raise many more questions than it answers.
      For example:
      • What is the difference between a methodology and a method?
      • Does a methodology include a specification of the techniques and tools which are to be used?
      • Does a collection of techniques and tools constitute a methodology?
      • Should the use of a methodology produce the same results each time?
        The questions that arise are fundamental as well as numerous. Unfortunately the most that can be achieved is to air the issues. The information system community is in the process of debating the meaning of the term methodology in an information system context, and it may one day have a universal definition. However, it may be more realistic to assume that this will never be achieved. An information system's methodology has been defined as a recommended collection of philosophies, phase, procedures, rules, techniques, tools, documentation, management and training for developers of information systems.(Madison 1983). According to this definition, a methodology has a number of components.
        Which specify:
      • How a project is to be broken down into stages
      • What tasks are to be carried out at each stage
      • What outputs are to be produced
      • When they are to be carried out
      • What constraints are applied
      • What support tools may be utilized
        In addition, the methodology is supposed to specify how the project is to be managed and controlled and support the training needs of the users of the methodology. This is all encompassed in a view or philosophy concerning the important and critical aspects of information systems development.
        Required:
   2. Remove the underline from all the underlined and change the text to bold and italics. Apply hanging ident to the first two paragraphs. Save the document as EXERCISE 2. (6marks)
   3. Select the text starting from the words "For example:…….information systems development" (at the end of the passage) and move it to a new page and save as EXERCISE 3.  (5 marks)
   4. 1. Retrieve EXERCISE document and convert it to two columns of the same width and height and justify them. (6marks)
      2. Double space the first paragraph of the passage and fit the entire passage into one page(4marks)
      3. Insert your name into the passage as a footer so as to appear as © your name. Save the document as EXERCISE 4.  (5marks)
   5. Print EXERCISE, EXERCISE 2, EXERCISE 3, EXERCISE 4 (4marks)
3. Table 1, table 2 and table 3 are extracts of records, kept in a carpentry shop. Use the information to answer the questions that follow;
   Carpenter Table                                                            

4. CAPENTER _ID	CAPENTER NAME
   CAP_001	JAMES
   CAP_002	JOHN
   CAP_003	ALEX
   CAP_004	ISAAC
   CAP_005	MAURICE

   
   Customer Table
   

   CUSTOMER _ID	CUSTOMER NAME
   CUST_01	MARY K.
   CUST_02	DIANA K.
   CUST_03	ALEX N.
   CUST_04	MARTHA K.
   CUST_05	SARAH W.
   CUST_06	JOHNSON G.

    
5. Order Table
   

   CARPENTER _ID	CUSTOMER _ID	ORDER _NO	ITEM ORDERED	MONTH	AMOUNT
   CAP_001	CUST _01	1721	Bench	January	18,000
   CAP_002	CUST _02	1722	Coffee table	January	25,000
   CAP_003	CUST _03	1723	Office table	January	10,000
   CAP_004	CUST _04	1724	Single bed	January	18,000
   CAP_005	CUST _05	1725	Arm chair	January	60,000
   CAP_001	CUST _01	1726	Double bed	February	75,000
   CAP_002	CUST _04	1727	Dining table	February	85,000
   CAP_004	CUST _03	1728	Arm chair	February	60,000
   CAP_001	CUST _02	1729	Double decker bed	February	72,000
   CAP_002	CUST _06	1730	Kitchen table	February	82,000
   CAP_004	CUST _02	1731	Bench	March	18,000
   CAP_003	CUST _06	1732	bench	march	18,000

   
   
   1. 1. Using database application package, create a database file named;
         CARPENTERINFORMATION                                                                                                  (1mk)
      2. Create three tables named Carpenter Table, Customer Table and Order Table that will be used to store the above data.                                                                         (10mks)
      3. Set the appropriate primary key for the tables                                                                         (2mks)
      4. Create relationship among the tables (2mks)
   2. 1. Create a data entry form for each table and give them relevant names (3mks)
      2. Enter the data in Carpenter Table, Customer Table and order Table respectively (11mks)
   3. 1. Create a query named individual income to display the amount received from each customer every month.                                                 (4mks)
      2. Create a query that computes Total income for each month. Save the query as totalIncome. (6mks)
   4. Create a query named loyalty to compute the total number of orders made by each customer over the three months.                                                                         (3mks)
   5. Create a report to display order details, save the report as Order report                         (4mks)
   6. Print the three tables and the report                         (4mks)

 MARKING SCHEME

QUESTION 2