uganda national examination board past papers for computer studies 2008

PAPER 1
SECTION A
1. Computer system configuration information is stored in . . . . . . . . . . . . . .
A. CMOS
B. BIOS
C. RAM
D. CD-ROM.
2. All files ending with the following extensions are executable except. . . . . . . . .
A. .bat
B. .com
C. .exe
D. .dos
3. A . . . . . . . . . . . .is a computer output device.
A. Light pen
B. Plotter
C. Digital camera
D. Scanner
4. What is the meaning of the term range as used in spreadsheets?
A. Intersection of rows and columns.
B. A reference to a particular cell
C. A group of adjacent cells.
D. A collection of worksheets.
5. The term TCP/IP refers to . . . . . . . . . . . .
A. Translated control Protocol/Internet protocol
B. Translated control protocol/Intranet protocol
C. Translated control protocol/Internet protocol
D. Translated control protocol/Information protocol
6. . . . . . . . . . . . . . . is an example of a presentation program.
A. Excel
B. Lotus 1-2-3
C. Access
D. Power point
7. The device that stores programs and data when working with a computer and is lost when power is switched off is . . . . . . . .
A. CPU
B. ROM
C. GUI
D. RAM
8. Which of the following is necessary for running application software?
A. Operating
B. Network interface Card
C. Utility program
D. Graphical user interface
9. When the pointer on a computer screen does not move well ,what device is more likely to be causing the problem?
A. Pentium processor
B. Keyboard
C. Mouse
D. Monitor
10. Which of the following attaches itself to a program in your computer?
A. Computer virus
B. Computer bug
C. Computer object
D. Computer code.
11. Which of the following statements are correct?
I Each web browser has a unique IP address
II HTTP is a communication protocol
III An internet domain may be referred to as HTML
IV The internet is a network of networks.
A. I & II only.
B. I,II & III only
C. II &IV only
D. II, III & IV only.
12. A . . . . . . . . . . . . .is a term used in web design to connect one document or file to another.
A. Linker
B. Hyperlink
C. Hypertext
D. Hyper web
13. The text which appears in the lower margin of a page is called a . . . . . . . . . . . .
A. Header
B. Gutter
C. Margin text
D. footer
14. Which of the following is not a representation of a type of network topology?
A. Hub
B. Ring
C. Bus
D. Star
15. Files containing highly structured and organized data are . . . . . . . . . . . . . . .
A. Documents
B. Worksheets
C. Databases.
D. Communications
16. An area of artificial intelligence that stimulates certain experiences using special headgear, gloves and software that translates data into images is. . . . . . . . . . . . . .
A. Collaborative technology
B. Virtual reality
C. Hypermedia
D. Shell
17. Tables are primary requirements most applied to. . . . . . . . . . . . . . . . . .
A. word processing
B. Presentations
C. Web publishing
D. Databases.
18. . . . . . . . . . . . . . . invented the tabulating machine that was used in the USA population census in the 18^th century.
A. Blaise Pascal
B. Hollerith
C. Napier
D. Aiken
19. Achen wants to get some information from the internet on designing success cards for her Fine Art examination .What kind of software would she need to use to get his information?
A. web browser
B. web authoring software
C. E-mail software.
D. Desktop publishing
20. The points of connection between a computer (motherboard) and its peripherals are . . . . . . . . . .
A. network cards
B. ports.
C. cables.
D. sockets.

SECTION B
21. (a) Describe the term evolution of computers.
(b) Mention four main characteristics of the first generation computers.
(c) How do the second second generation computers differ from fifth generation computers? List down four differences.
22. The database below contains data about items that have been ordered from various suppliers.

SUPPLIER	CODE	DELIVERY DATE	PRICE ($)
AD12	2146	28/09/07	44.99
CO35	3724	30/09/07	249.50
MO18	5613	05/10/07	98.15
LO47	5613	11/10/07	102.75
PO29	7215	17/10/07	127.50
RO16	4639	19/10/07	22.89

(a) State the data type of the fields in the given table.
(i) SUPPLIER. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(ii) CODE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(iii) DELIVERY DATE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(iv) PRICE. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(b) The following search condition is input
(CODE =5613) AND (PRICE ($)<100)
Write down the output using only the SUPPLIER field.
(c) Write down a search condition that will search for all items with a price more than $ 50 that will be delivered in October.
(d) Write down using only the SUPPLIER field if the records were sorted in descending order.
1. (a) (i) What is a spreadsheet ?
(ii) Give three examples of spreadsheet software.
(b) Name three types of data that can be placed in a spreadsheet cell.
(c) What is a chart in spreadsheets?
24. (a) in relation to computers, explain the meaning the meaning terms.
(i) Intranet. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(ii) Internet. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(b) (i) Outline three benefits of networking computers.
(ii) Outline three demerits of networking computers.
(c) What is a server in a computer network?
25. (a) A computer system is a composition of several components. List any four components that make up a computer system.
(b) Briefly, explain the function of any three components you have given in (a) above.
26. (a) (i) Explain what is meant by the operating system.
(ii) Give any two features of a graphical interface.
(b) (i) Describe as precisely as possible the use of each of the following features':
List Box . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Drop down list. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(ii) Clearly state one example where anyone of the above features in (b) (i) can be used.

SECTION C
27. "Computers are a necessary requirement." How do computers affect people in everyday life?
28. (a) Explain what is meant by volatile and non volatile when referring to primary memory.
(b) Explain the advantages and disadvantages of using primary and secondary storage devices.
29. What are the possible characteristics of the future generation of computers?

PAPER 2
SECTION A
1. (a) You the secretary to the schools Funds for funds" program and you are required to send out acknowledgement letters to people who have so far made contributions towards the program .the letter contents are the same for all the persons except the addresses ,names and nature of contributions .
Below is the letter to be sent and a table of people who have made contributions.
Mukisa senior secondary school,
P.o.Box 21146
IGANGA.
12^th / June, 2007
[ADRESS]
Dear [NAME],
Thank you for your contribution of [NATURE OF CONTRIBUTION] towards the "Funds for Food "program.
This project is in its inaugural year but it has been a resounding success.
The learners and staff agree that it should become an annual event. The principal would like to thank you and hopes for more support in future.
Thank you very much.
. . . . . . . . . . . . . . . . . . . . . . .. . . .
PRINCIPAL
NAMUKASA FLORENCE.

	NAME	ADRESS	NATURE OF CONTRIBUTION.
1	Lugayizi John	P.O.BOX 14,KAMULI	$430
2	Musiime Molly	P.O.BOX 92,MBARARA	500,000/=
3	Nsibambi Eriya	P.O BOX 160, BULOBA.	20Kg of maize
4	Nakasolya Juliet	P.O.BOX 1413,KAMPALA	40bags of rice

(i) Use an appropriate method in any word processing program to make a letter to be sent to each person in the table.
The address and names should be bolded and the contribution in italics.
(ii) Save your work as your index number.
(iii) Print each of the four letters.
(b) (i) Enter the data below into a suitable application program and save it as "raw- marks".

	A	B	C	D	E	F	G
1
2
3	STUDENT NUMBER	NAMES	TELEPHONE NUMBER	TEST A	%	TEST B	%
4	01	Lule Nabil	0414-372 475	34		43
5	02	Okello Oryem	0712-312 130	56		22
6	03	Nantongo.F.	0414-421 666	76		34
7	04	Sempa.H.	0414-927 384	54		67
8	05	Senabulya.S.	0414-991 622	34		65
9	06	Kato .P.	0782 421 333	67		34
10	07	Semujju K	0414 696 471	89		56
11
12
13
14
15
16
17
18
19
20
21

(ii) Copy the work in (i) and paste it in worksheet 2 of the same workbook. Name the worksheet 2 as "percentage -marks".
(iii) Given that test A and test B are marked out 90 and 70 respectively , enter appropriate formulae to calculate the percentage marks for both tests using "percentage-marks" worksheet.
(iv)Use functions to obtain the difference between the highest and the lowest percentage marks in Test A in cell E21.
(v) Calculate the average mark for the Test B in cell G21
(vi) Save your work
(vii) Print your work.

SECTION B
2. The table below shows books in a library.
DATABASE OF BOOKS IN THE LIBRARY.

CODE NUMBER	TITLE	NAME OF AUTHOR	PAPER BACK (P) Or Hard BACK (H)	BORROWER NUMBER	DATE DUE BACK
2043	The Great Gatsby	F.Scott	P	15234	01 June 08
5284	Jane Austen-A life	C.Tomalin	H	11356	02 June 08
4033	Harry potter and the Philosopher's Stone	J.K.Rowling	H	16582	26 May 08
0549	Northern Lights	P.Pullman	P	12982	28 May 08

DATABASE OF BORROWERS

Borrower Number	Name of borrower		Address of borrower		Borrowers 'Phone number
11356		Tobias Ahendra		658,Uhuru Highway, P.O BOX 2809		0772-344 567
16582		Carlos Moyes		12,Avenue De Lupin, P.O Box 65432		0712-417 398

Computers are now widely used in libraries. Using a database management systems program:
(a) Create a table of books and enter the data.
(b) Create another table of borrowers and enter the data.
(c) Sort the records in part (a) in descending order of code numbers.
(d) Using fields :code number,title,name of author, paper back and or hard back ,date due back, create a query showing borrowers number that is above 12506 using table in 2(a).
(e) Create a query, showing only books with Hard back and the names of the author. The names of the authors should be in ascending order.
(f) Create a relationship between the books' and borrowers' tables.
(g) Put your name and index in the header and put the current date and time in the footer of both tables.
(h) Save the database as "library database".
3. You have been selected as the web -master for the school's Computer Club" to design a website for the club .In your planning stage you decide to include the following features on the website:
(i) Membership
(ii) Organizational structure of the club
(iii)Activities
(iv)News
(v)Feedback
Design the website including a logo to make it professional .Include also the source, date when written, contact of author, last update and references where necessary.
4. Road accidents are very rampant in Uganda. Many people have lost their lives in road accidents. You are required, using presentation software to educate Ugandans about road accidents. Create four slides as indicated in parts (i)-(iv).Every slide should:

• use minimal graphical effects to make the presentation entertaining.
• be able to convey the appropriate message to the community.
• run with a click of the mouse.
• have your name and index number as a footer

(i)Slide I - Should include the title, your name and your school name.
(ii)Slide II _Should include the actual causes of road accidents in Uganda.
(iii) Slide III_ should include the contribution of the traffic police in the prevention of road accidents.
(iv) Slide IV_ should include the preliminary precautions to avoid road accidents.
(v) Save the presentations as "Road Accidents".
(vi) Print your slides