the software. System Implementation And Testing Involves The Practical Work Of Transferring From The System Design Into a Working System. An information system is dynamic and must be responsive to the changing needs of the company and those who use it. The process of modifying and adjusting an information system to meet changing needs and make it adaptive is known as system maintenance. Just like a new automobile will need some screws tightened after a few hundred miles, an information system will need some just after implementation. Thereafter and throughout the production stage of the system life cycle, the system will be modified many times
separator for the thousands Insert currency symbol in Ksh. Use an appropriate function to award the sales representatives managing the branches using the scale given below (4 Marks) 80,000 and above: GOLD 65,000 to 79,999 : SILVER 50,000 to 64,999 :BRONZE Below 50000: NO PRICE Use an appropriate function to establish the number of those awarded GOLD (2 Marks) Use a formula to calculate the monthly total sales for all the six months and re-save. (2 Marks) Prepare an appropriately labeled bar graph to show the Monthly TotalSales for the six months. Save the graph as a new sheet called “MONTHLY RECORDS” (5 Marks) . Print PROJ1, PROJ2, MONTHLY RECORDS and formulas in PROJ2, on one page each (5 Marks) END.
PARTNER’S VENDORS Cost Gross profit Expenditure Reserves Net profit Remarks Samson Too 700 350 450 Victor Onyango 400 700 50 James Ahenda 200 950 250 Peter Kimaiyo 300 650 300 Alice Visaho 100 300 100 Salome Nyarago 400 550 50 Joseph Opiyo 650 600 40 Sonia Wambui 555 885 55 Mary Wayudo 250 850 70 Leah Wanjera 500 360 54 Joy Maelo 700 350 45 Mohammed Dida 900 1000 180 Kevin Momanyi 850 950 25 Michael Karanja 110 700 50 Hilda Njeri 350 800 150 Additional information Reserves is 10% of Profit.
Apply hanging ident to the first two paragraphs. Save the document as EXERCISE 2. (6marks) c) 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. (5marks) d) (i) Retrieve EXERCISE document and convert it to two columns of the same width and height and justify them. (6marks) (ii) Double space the first paragraph of the passage and fit the entire passage into one page (4marks) (iii) Insert your name into the passage as a footer so as to appear as © your name. Save the document as EXERCISE 4. (5marks) d) Print EXERCISE, EXERCISE 2, EXERCISE 3, EXERCISE 4 (4marks) Employees of Sunshine Company are paid salaries which comprise of Basic salary, house allowance and medical allowances. The gross salary of each employee 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. MEDICAL ALLOWANCE HOUSE ALLOWANCE BASIC SALARY MURTAZA 5,000 10,000 20,000 WASIM 3,000 8,000 16,000 MWANGI 3,500 8,000 16,000 ISHO 6,000 12,000 25,000 MITESH 2,500 6,500 12,000 MITHEU 2,500 6,500 12,000 KRISHNA 7,000 15,000 30,000 MBUGUA 3,500 8,000 16,000 KASOO 3,500 8,000 16,000 SARU 3,500 8,000 16,000 Using the above information, design an appropriate spreadsheet and enter the given sample data. Give the spreadsheet an appropriate title and save at MOCK_1. (12marks) 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). 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)
Month only Vijhu Machu Yec/074 29.11.97 1000.00 55 811015 Honorary Member (c) (i) Insert the field called “more than 4000” that will accommodate Y for Yes and N for No. (3 marks) Indicate in these new fields those members who have paid more than sh.4000.00 with Y otherwise N. (3 marks) (iii) Save as Club2. (1 mark) (d) (i) Create a query that contains the field Membership Number, Last Name, Date of registration, Membership fee paid and status for all members who have paid less than sh.4000.00 and registered after 15/4/1995 or are above 35 years of age. (9 marks) (ii) Write on the paper provided the query expression you used. (2 marks) (iii) Save the query as ClubQ. (1 mark) (e) (i) Excluding the status field, create a report for all members and give it the title: ENTEREPRENEURS CLUB. (12 marks) (ii) Save the report as ClubR. (1 mark)
2. The following is a worksheet extracted from business partner’s vendors. They have come together to do a business of selling computer accessories. PARTNER’S VENDORS Cost Gross profit Expenditure Reserves Net profit Remarks Samson Too 700 350 450 Victor Onyango 400 700 50 James Ahenda 200 950 250 Kimaiyo 300 650 300 Alice Visaho 100 300 100 Salome Nyarago 400 550 50 Joseph Opiyo 650 600 40 Sonia Wambui 555 885 55 Mary Wayudo 250 850 70 Leah Wanjera 500 360 54 Joy 700 350 45 Mohammed Dida 900 1000 180 Kevin Momanyi 850 950 25 Michael Karanja 110 700 50 Njeri 350 800 150 Additional information Reserves is 10% of Gross Profit.
Monica Akinyi Benta Moraa Beth Wangoi P.O. BOX 5678 P. O. BOX 5678 P. O. BOX 5678 Nanyuki Nanyuki Nanyuki Typist Secretary Accountant Ksh.2000 Shs.3000 Shs.4500 Insert data fields in main document and generate the notes for the employees.(14mks) (d) Print the notes. (6mks) (e) Generate envelope labels for these notes with the fields of names and address. (9mks) (f) Print the labels. (6mks)
Required: Align the title to the center and underline it (1mk) Add border to the title. (2mks) Replace all the Roman numbers with bullets. (2mks) Insert the footer “Computer Districts Mock 2008”. (2mks) Insert the header “Your name and index No” (2mks) Set the line spacing to exactly 1.5 (4mks) Insert word Art “COMPUTER” and set it to appear behind the text. (5 mks) Search for words “Computer” and replace all with “PC”. (2 mks) Move paragraph with the heading “how a computer operates” to the end of the document. (2mks) Set the font style of the document to Arial black (3 mks) Save your work as “computer Literacy” (1mk) Print your document. (2 mks) 2. (a) Create a new workbook and name it as form 2 computer Exams. (1mk) Name Adm. No: CAT 1 CAT2 CAT3 Total Average Class Position Remark Maina John E 7984 80 70 59 Ken Korir W 7896 75 55 72 Bernard K. E 8092 86 59 75 John Soi E 7460 80 79 70 Kipsang Bett W 7892 76 75 80 E. E 7800 38 48 25 Mark J. W 8490 37 51 29 Koech Ben W 8184 30 86 75 James W. E 8082 25 27 20 Abuya Ken E 8083 30 25 25 Leonand B. W 8047 39 24 25 (b) Enter the following data in sheet 1 (20mks) (c) Rename the sheet as Term one results (1mk)
Find : Totals (2mks) Average (2mks) Use the IF function to award remarks as follow (3mks) A student whose average is above or equals 65 is given “Excellent” An average of 55 or above but less than 65 award “average work” An average less than 55 award “work below average” (f) Award position to student basing on the average scored. (3mks) On the last rows formulas to count students from both classes (2mks) (g) Sort the students list by class position in ascending order. (2mks) (h) Copy the entire worksheet onto sheet2 and rename it “lower group” (2mks) Filter “Lower group” sheet to display students from “E” class and whose average score is below 50. (4mks) (i) Draw a bar graph to display the following information (3mks) The three cats Names Title as “TERM ONE COMPUTER RESULTS” Place the legend at the bottom of the graph (1mk) Save the chart on a new sheet and name it graphical analysis (1mk) (j) The filtered group (1mk) The (1mk) Term one results (1mk)