COMPUTER PAPER 2 - 2019 LAINAKU JOINT MOCK EVALUATION EXAMINATION

Share via Whatsapp
Download PDF for future reference

QUESTION 1

  1. Type the following passage exactly as it appears using a word processor and save it as EXERCISE (20marks)
    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)
      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)
    4. Print EXERCISE, EXERCISE 2, EXERCISE 3, EXERCISE 4 (4marks)
  2. 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                                                            
  3. 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.

     
  4. 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. 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)
      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)
      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)
    1. Create a query named loyalty to compute the total number of orders made by each customer over the three months.                                                                         (3mks)
    2. Create a report to display order details, save the report as Order report                         (4mks)
    3. Print the three tables and the report                         (4mks)

 MARKING SCHEME

   

Max score

Candidate score

1a

Correct typing of the text

10

 

Document saved as EXERCISE

2

 

Heading capitalized, bold and centered

3

 

The subheading “introduction to…….development” left aligned, underlined and capitalized

3

 

Applying justified alignment on the first and last paragraph

2

 

Bolding and italicizing the subheading ”What is a Methodology”

2

 

1st line indentation on the 2nd paragraph

2

 

Underlining the words in the 2nd and 4th paragraphs

4

 

Applying bullets on the 3rd and 5th paragraphs

2

 

b

Remove underline from all the underlined

1

 

Applying bold and italics on the underlined words

2

 

Applying hanging indent to the 1st 2paragraphs

2

 

Saving EXERCISE 2

1

 

C

Moving the text to a new page

2

 

Saving the document EXERCISE3

2

 

D (i)

Converting   EXERCISE Doc. into 3 columns of same width and height

4

 

Justifying EXERCISE Doc

2

 

(ii)

Double spacing the first paragraph of the passage

2

 

Fitting the entire passage into one page

2

 


QUESTION 2

     

Mark allocation

Score

A

i)

CARPENTERINFORMATION

 

1mk

 

ii)

Carpenter Table

Customer Table

Order Table

Availability of all field names@½mk

Correct data types @½mk

5mks

5mks

 

iii)

Carpenter Table

Customer Table

One primary key on each of the two table@ 1mk>

2mks

 

iv)

Relationship

Correct llinks@1>

2mks

 

B

i)

Entry form for the three tables

@1mk

3mks

 

ii)

Data entry

Award 1mk for any two correct records

11mks

 

C

i)

Individual income query

Correct formulae 2mks

Correct output 2mks

4mks

 

ii)

Total income Query

Correct formulae 3mks

Correct output 3mks

6mks

 

iii)

Loyalty Query

Correct formulae 2mks

Correct output 1mk

3mks

 

e

Order report

 

1mk

 

f

Order table macro

 

3mks

 

g

Print outs

Print out@1mk>

4mks

 

Download COMPUTER PAPER 2 - 2019 LAINAKU JOINT MOCK EVALUATION EXAMINATION.


Tap Here to Download for 50/-


Read 600 times Last modified on Wednesday, 21 October 2020 13:12

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.

Print PDF for future reference Join our whatsapp group for latest updates