Computer Studies Paper 2 Questions and Answers - Form 3 End Term 3 2022 Exams

QUESTIONS

1. Type the following passage exactly as it appears using a word processor and save it as EXERCISE (25marks)
PROCESS OF INFORMATION SYSTEM DEVELOPMENT
INTRODUCTION TO INFORMATION SYSTEM DEVELOPMENT
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 raises 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:

1. 1. How a project is to be broken down into stages
   2. What tasks are to be carried out at each stage
   3. What outputs are to be produced
   4. When they are to be carried out
   5. What constrains are applied
   6. What support tools maybe 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 to
2. Remove the underline from all the underlined and change the text to bold and italics.
   Apply hanging indent to the first two paragraphs. Save the document as EXERCISE 2.
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 (6marks)
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)

2. Employees of Sunshine Company are paid salaries which comprise of Basic salary, house allowance and medical allowances. The gross salary is calculated as the total of the three payment categories.
Below is a list of allowances and basic salaries for ten employees in the month of July 2003.

1. Using the above information, design an appropriate spreadsheet and enter the given sample data. Give the spreadsheet an appropriate title and save as MOCK _1 (12marks)
2. Calculate the gross salary for each employee. Label it appropriately on the spreadsheet. Write the formular used for Saru’s gross salary, on the sheet provided. (6marks)
3. Fatuma Ndeche joined the company at management level and was paid 20% basic salary more than Krishna was paid. If her medical allowance and house allowance was calculated at 30% and 50% of her basic salary respectively. Calculate and fill a record for Fatuma Ndeche on the spreadsheet. Write the formulae used on the answer sheet provided. Save the spreadsheet as MOCK _2. (6marks)
4. Calculate the average of basic salary house allowance and medical allowance for the employees. Label these averages appropriately and write the formular used to calculate the average for basic salary on the answer sheet provided. Save the spreadsheet as MOCK _3. (7marks)
5. Count all the employees whose house allowance is above Kshs. 10,000 and place your results in an empty cell. Label the result appropriately. Write the formular used on the answer sheet provided. (6marks)
6. The company would like you to help them sort out the employees in the management from others. By labeling a column STATUS, generate the appropriate status for each employee given that those who earn a basic salary above Kshs. 20,000 are in the management while others are uniosable. Write on the answer sheet provided the function you used for Krishna. Save the spreadsheet as MOCK_4. (6marks)
7. Plot a line graph of employees against gross salary. Add a title, axes and a legend. Save the graph as MOCK_5. (5marks)
8. Print MOCK_1, MOCK_2, MOCK_4 and MOCK _5. (2marks) 

MARKING SCHEME

Question 1

1. Typing full passage = 25mks
2. Removing underline = 1mk
   Bolding =1mk
   Italising = 1mk
   Indenting = 1mk each x 2 = 2mks
   Saving as Exercise 2 = 1mk
3. Moving all text =4mks
   Saving as Exercise 3 = 1mk
4.                                      
   1. Creation of 2 columns =2mks
      Same width and height = 2mks
      Alignment (justification) =2mks
   2. Double spacing =2mks
      Fitting into one page =2mks
   3. Typing in the footer section =2mks
      Inserting the symbol = 1mk
      Typing name in the footer = 1mk
      Saving as Exercise 5 =1mk
5. Printing the 4 documents each @ 1mk x 4 = 4mks

Question 2

1. Typing text fully = 9mks
   Inserting appropriate title = 2mks
   Saving as Mock – 1 =1mk (total 12mks)
2. Calculating gross salary for each = 4mks
   Writing formula for Saru’s gross salary = 2mks
   Total = 6mks
3. Inserting the record = 1mk
   Calculating basic salary = 1mk
   Calculating medical allowance = 1mk
   Calculating house allowance = 1mk
   Writing the formula = 1mk
   Saving as mock _2 = 1mk (total = 6mks)
4. Calculating the average – each @ 1mk x 3 = 3mks
   Labeling the average = 2mks
   Writing the formula for on the sheet =1mk
   Saving the spreadsheet as mock_3 = 1mk (total =7mks)
5. Counting using formular = 3mks
   Labeling = 2mks
   Writing formula on the sheet = 1mk
   (Total = 6mks)
6. Labeling column = 1mk
   Calculating status using IF function = 3mks
   Writing formula on the sheet =1mk
   Saving as Mock _4 = 1mk
   Total =6mks
7. Ploting =3mks
   Adding title, axes, legend = 1mk
   Saving as Mock 5 = 1mk (total = 5mks)
8. Printing each @ ½ x 4 = 2mks

CONFIDENTIAL

1. Ensure that each candidate is provided with a computer which has a CD writing capability installed with Ms Office.
2. There is at least one quality blank re-writable compact disk (CD-RW) for each candidate.
3. Ensure that in the regional and language options of the computers, the standards and formats are set to English (United Kingdom).