ICT Practical Questions Part 2

1. Use Desktop publishing software to prepare a brochure for JK computer Center with the following details:

Company Name:	JK Computer Center
Motto:	Computer skills for better standards
Location:	Seventh Street, Jinja Road
Address:	P.O. Box 23, Kampala
Telephone Contact:	0773458098, 0712070797, 0707587473
Email Address:	This email address is being protected from spambots. You need JavaScript enabled to view it.
Website:	http://www.jkcomputer

Introduction: JK Computer Center is a home of computer services and accesories. We have customer centered service providers. Please come and enjoy our excellent services.

Services offered: Internet services, Printing, Photocopying, Scanning, Binding, Mobile Money, Computer and phone repair, Computer and phone accessories, Airtime selling, Telecommunications services, Report writing, Typing and Computer lessons.

a) Divide each page into three panels

b) Enter the given details in suitable panels

c) Use appropriate images, fonts and background in the brochure

d) Add your names and personal number as a footer

e) Save your brochure as your name and personal number

f) Print your work.

2. a) Using any database management system of your choice, create a database to handle patients’ data. Save it as your name and personal number.

b) Open a file called Patients.xlx, copy that data and use it to create a database table called OPD table.

c) Apply the most appropriate data types to the fields in OPD table

d) Apply a primary key on an appropriate field.

e) Use a Lookup Wizard for the SEX field and fill in Male and Female

f) Sort the data in the table in descending order of AMOUNT PAID

g) Create a form called Patient’s Form containing all the fields in OPD table.

h) On this form, create a new field called NEW AMOUNT PAID if AMOUNT PAID is increased by 10%

i) Create a query called Aged patients showing patients born before 1900.

j) Create another query called Typhoid bush showing patients with Typhoid and come from Bushenyi district

k) Create a report showing patients born before 1990. Call it Aged Report,

l) Insert a footer as your name and current date in the report.

m) Print all your work.

3. a) Access the file IntrodWP.rtf and saveit as your name and personal number.

b) Set the margins as: Top 1”, Bottom 1” Left 1” and Right 1”.

c) Format text to font size 12 and apply double line spacing.

d) Apply a Drop Cap on the first paragraph

e) i) Make a bulleted list from the data in the second paragraph.

ii) Split the list into two columns

f) Insert an appropriate heading for the text.

g) Draw a 4½ point colored line below the heading.

h) Insert a picture from folder Image 1 and send it behind text.

j) Save a print your work.

4. The following students sat for their term two examinations in Mathematics (mat), Computer Studies (comp) and Commerce (com), and obtained the following marks:

John scored 40 in mat, 20 in comp and 50 in com. Mary scored 90 in mat, 60 in comp and 30 in com. Tania scored 70 in mat, 65 in comp and 90 in com. Samuel scored 55 in mat, 40 in comp and 80 in com. Paul scored 50 in mat, 20 in comp and 35 in com. Albert scored 50 in mat, 60 in comp and 50 in com.Cissy scored 60 in mat, 70 in comp and 50 in com. Merseyi scored 20 in mat, 90 in comp and 77 in com. Muzamil scored 80 in mat, 69 in comp and 50 in com while Timothy scored 30 in mat, 60 in comp and 57 in com.

a) Enter the given data in a spreadsheet using appropriate column headings and a table title. Save your work as your name and personal number.

b) Use a formula in column E to compute the average score for each student and name it AVERAGE MARK.

c) Sort the data in descending order based on column E.

d) Incline the column headings to an angle of 45⁰

e) i) Create a column graph for the students’ marks in the three subjects. label your graph appropriately.

ii) Move the graph to a new sheet and rename it as Students’ Marks.

f) Use an appropriate formula in column F to grade the students with the criteria below:
EXCELLENT for all students with an average mark of 70 and above;
PASS for those with a n average mark below 50.

g) Apply all borders on the data.

h) Save and print all your work.

5. Use presentation software to design a five-slide presentation on Safe Water Management.

a) The slides should include:

i) Slide I: Title and introduction
ii) Slide II: Sources of water
iii) Slide III: Ways of making water safe for drinking
iv) Slide IV: Water-borne diseases
v) Slide V: Conclusion