Ics2108:Programming Question Paper
Ics2108:Programming
Course:Bachelor Of Science In Public Health
Institution: Meru University Of Science And Technology question papers
Exam Year:2013
QUESTION ONE (30 MARKS) a) State three remarkable discoveries during the 5th generation. (3 marks)
b) Describe the function of the following menu items in MS-Word: (3 marks) i. Edit-?Find ii. Tools-?Word Count iii. Format -?Change Case
c) A large organization with a large warehouse would like to buy some computers for its staff members. As a computer expert advice on the most suitable type of computer to be purchased for the following personnel. Justify your answer. (5 marks) i) Secretaries ii) Market Research Executives iii) A store manager in charge of physically verifying stock in the warehouse iv) Company director for scheduling all his appointments and what to do list v) A database administrator for storing all the data of the organization d) Ann Wekesa architecture has many housing designs for sale to home makers and estate developers, she has been advised to store the designs in Optical disks rather than maintain printed copies in file.
a) Give one example of optical disks (1 mark)
b) Highlight two precautions that Ann Wekesa should take when storing her optical disks. (2 marks)
2
e) An entrepreneur would like to start a cybercafé that will include a business unit where advertisements brochures, letters and documents can be produced. The cybercafé will also support video conferencing for all its clients. i. Explain three hardware devices that would be required for the successful implementation of the cybercafé. (3 marks)
ii. Identify two types of software that would be required in the cybercafé giving a suitable example in each case. (2 marks) f) Explain four application packages that you might consider using on a micro-computer for administrative functions in an organization. Explain how each of these packages can increase an organization’s efficiency. (8 marks)
g) Generate an Ms-Excel IF statement that will be able to display the grades in the worksheet provided below. (3 marks)
Marks ?=80 display grade A Marks 70…79 display grade B+ Marks 60…69 display grade B Marks 50…59 display grade C Marks 40…49 display grade D Marks below 40 display grade E A B C 1 NAME MARKS GRADE 2 ALICE MAINA 62 3 JIMMY MIBEI 78 4 CAROL KARUO 31 5 PHILIP ONYANGO 44
QUESTION TWO (20 MARKS)
a) State three application areas of embedded computers in modern homes. (3 marks)
b) State two application areas of super computers. (2 marks)
c) A copy typist was working on her computer, the mouse failed before she could complete her assignment. State the keyboard keys she would use to perform the following tasks. (3 marks) i. Move the cursor to the end of the line ii. Place data from a clipboard to a document iii. Terminate an application that is not responding d) Define the following features found in Spreadsheets: (3 marks)
3
i. Sheet tab ii. Formula bar iii. Name box
In designing a employee database, the following fields were identified as ideal for the database
table.
? Employee Number ? Monthly Salary (stated in dollars) ? Employment date (dd/mm/yyyy) ? Grade (i.e senior or junior) ? Photo e) State the data types for each of the fields above. (5 marks) f) Explain two applications of computer. (4 marks)
QUESTION THREE (20 MARKS) a) State three advantages of using Computer packages over tailor made software. (3 marks)
b) Define the following terms: (2 marks)
i. Computer ii. Operating system
c) Outline three limitations of a file-based system (3 marks)
d) The computer technician of Ujamaa Institute is installing a peripheral device to protect the computer against electricity interruption. State the name of the device. (1 mark)
e) State three arguments of an IF function as used in MS-Excel. (3 marks)
f) Explain how you would insert a picture in Ms Word. (4 marks)
g) Explain four negative impacts of computers to society. (4 marks) QUESTION FOUR (20 MARKS) a) State four legal methods of acquiring a computer for use. (4 marks)
b) Explain three functional elements of a CPU. (3 marks)
4
c) Kenya air force intends to launch an airspace exploration project in order to strengthen their military airbase. State the type of computer that would be most appropriate for this mission. Justify your answer. (2 marks) d) State three characteristics of good Spreadsheet software. (3 marks)
e) Explain the steps taken to drop cap a letter. (5 marks)
f) Explain what utility programs are and give two examples (3 marks)
QUESTION FIVE (20 MARKS) a) State two differences between a buffer and a register. (2 marks)
b) State the steps that one will use to rename the sheet tab in Ms-Excel (2 marks)
c) Write a keyboard shortcut for: Find and Redo. (2 marks)
d) Differentiate between the following terms. (4 marks)
i. Computer hardware and computer software ii. Digital computer and analogue computer e) Explain any two functions of an operating system. (4 marks)
f) Describe three ways by which you can create a folder in Windows. (6 marks)
More Question Papers