uganda national examination board past papers for computer studies 2009

PAPER 1
SECTION A
1. Disks come with a . . . . . . . . . . . feature as a measure of guarding against accidental erasing.
A. Write protect
B. Saving
C. Format
D. Default
2. . . . . . . . . . . . . .refers to the number of computers controlled by a central host computer.
A. Servers
B. Stand alones
C. Clients
D. Switches
3. Which of the following characteristics will be associated with future computers?
A. Expensive computers.
B. Advanced robotics.
C. Big sized system
D. Inadequate storage systems.
4. A web page has a unique address called . . . . . . . . .
A. Uniform Resource locator
B. Hyper text transfer protocol.
C. Virtual Reality Modeling
D. Transmission control protocol /internet protocol
5. Choose the software program used during meetings to enhance speakers ideas.
A. Word processing
B. MS Excel
C. Presentation
D. Desktop publisher
6. Which of the following can be written to, only once?
A. Diskette
B. Hard disk
C. Flash disk
D. CD-ROM
7. The word processing tool that offers similar words or alternatives is called a . . . . . .
A. Word checker.
B. Thesaurus
C. Word scanner
D. Spell checker.
8. Real time processing is a task of . . . . . . . . . . . . .
A. Utility program
B. Tailor made application
C. Programming language
D. Operating system.
9. . . . . . . . . . . . . Is an example of a boolem data type?
A. 001011
B. $ 200
C. YES/NO
D. 26/04/2040
10. . . . . . . . . . . . . . . Software uses hyper link as one of its tools for developing a web page .
A. Web browsers
B. Web publishers
C. Presentations
D. Communications
11. . . . . . . . . . . . . Is not an example of an input device?
A. OCR
B. MICR
C. OMR
D. LCD
12. A Local Area Network (LAN) without a dedicated server is called . . . . . . . . .
A. A client server
B. A peer to peer
C. A ring
D. An intranet
13. Computers are electronic devices that accept instructions, process input and produce . . . . . . . .
A. Information
B. Prewritten programs.
C. Data
D. End users.
14. Data from a floppy disk is transferred to the computer through . . . . . . . .
A. Read -write heads
B. Access arms
C. Drive gate
D. Drive A
15. Which of the following languages was being used for students new to programming?
A. FORTRAN
B. COBOL
C. BASIC
D. PASCAL
16. Special files that make a computer start when switched on are called . . . . .. . .
A. Document files
B. Command files
C. Hidden files
D. Boot files
17. The text you type using a computer is directly stored in ...
A. Ram
B. A file
C. A directory
D. ROM
18. One of the most useful features of the spreadsheet is the ability to . . . . . . . . .
A. Perform what-if analyses
B. Spell check
C. Create tables
D. Perform calculations
19. A computer program which used to display information on the internet is called a . . . . . . .
A. Gopher site
B. Browser
C. Web site
D. Home page
20. Which of the following is an interactive computer program that helps users solve problems?
A. Robot
B. Perception system
C. Expert system
D. Natural language

SECTION B
21. (a) DESCRIBE THE COMPUTER TERMS BELOW :
(i) Line spacing .......................................................
(ii) Changing case.......................................................
(b) Explain the following terms in presentation software:
(i) Transition Looping . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(ii) Slide Master . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . .
(iii) Slide Layout . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ...
22. (a) State any two functions of a Central Processing Unit (CPU).
(b) Define the following memory storage terms:
(i) Bit . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . .
(ii) Byte . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . .
(c) State two categories of computer memory giving an example in each case .
(i)
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Example
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(ii)
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Example
. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(d) Describe the major difference between the two categories of computer memory in (c).
23. Describe a relative address'.
(b) Give four advantages of electronic spreadsheets over manual spreadsheets
(c) A teacher keeps a class list containing the following data for each student: Name, Student index number, test scores.
(i) State the data type for each of these fields:
Name. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Student index number: . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
Test scores . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(ii) Which field can serve as a primary key for the record?
24. (a) What is a micro processor?
(b) Describe the difference between a digital computer and an analog computer. Give an example of each.
(c) What electronic technology characterized each of the four generations of computers?
(i) First generation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

(ii) Second generation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(iii) Third generation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
(iv) Four generation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .
25. (a) Explain the following terms with examples:
(i) Off-the shelf software
(ii) Custom software
(b) (i) What is a utility program?
(ii) State any four functions of utility programs.
26. (i) Distinguish between internet and World Wide Web.
(iii) Mention any two services offered by the internet.
(b) Define the following terms.
(i) Band width
(ii) Packet switching
(c) Name four basic items that are required to gain access to the internet.
SECTION C
27. A Computer system comprises hardware, software, user data and communication. Describe the importance of each component.
28. "The Internet is a harmful tool to man". What is your opinion?
29. Suggest ways in which computers can be used in business and industry in Uganda.

PAPER 2
SECTION A
1. (a) (i) Type the following information as it is (use font size 14)
The time table will be out by the beginning of next academic year. It should be copied and filled with relevant subjects.

SENIOR FOUR TIME TABLE 2010
	8:00 am _ 9:00 am	9:00am _ 10:00am	B R E A K	10:30am _ 11:30am	11:30am _ 12:30pm	L U N C H	2:00pm _ 3:00 pm	3:00pm _ 4:00pm
MON
TUES
WEDN							F R E E
THUR
FRID
SAT

NOTE: The outer boarders are (3) triple lines
(ii) Put a footer as your name and index number.
(iii) Colour "Senior Four Time Table 2010", BREAK, LUNCH and FREE" green.
(iv) Save your work as your name and index number.
(v) Print your work.
(b) The following students sat for their term two examinations in Mathematics (mat), Computers (comp) and Commerce (com) and obtained the following marks:
John got 40 in mat, 20 in comp and 50 in com. Mary got 90 in mat, 60 in comp and 30 in com. Tania got 70 in mat, 65 in comp and 90 in com. Samuel got 55 in mat, 40 in comp and 80 in com. Paul got 50 in mat, 20 in comp and 35 in com. Albert got 50 in mat,60 in comp and 50 in com.
(i) Enter the data given in spreadsheet. All names should be in column A.
(ii) Use a formula to complete the total for each student and put them in column E
(iii) Sort the data entered in column E in descending order.
(iv) Put the titles for column A,B,C,D and E in orientation 45
(v) Boarder your data and give it a professional look.
(vi) Draw a bar / column graph for the students marks in the three subjects.
(vii) Save your work as your name and index number.
(viii) Print your work.

SECTION B:
2. (a) Create a table using design view with the following fields: NAME, DATE OF BIRTH, SEX, RELIGION AND FEES BALANCE. Set the NAME field as the primary key and save the table as 'candidates table'.
(b) Create a form to enter the records below and save the form as "Candidates form'

NAME	DATE OF BIRTH	SEX	RELIGION	FEES BALANCE
Tina T	Jan/02/90	F	Catholic	40000
Golfer J	Feb/20/89	M	Moslem	60000
Bob Baller	Mar/13/88	M	Protestant	55000
Alice Cricketer	Apr/04/89	F	Pentecostal	20000
Sam Big	Jun/03/90	M	Catholic	25000
Jennifer J	Feb/04/87	F	Adventist	90000
Klez B	Jul/05/98	M	Catholic	40000

(c) Create a query displaying all the students whose names begin with letters B and T. Save it as BT query.
(d) Create another form in Design view with all the available records in the given table in (b) Name it "Design view form"
(e) Generate a report for the above table with FEES BALANCE in descending order. Use columnar layout and portrait as the form orientation. Name this report "columnar Report 1".
(f) Save your database as your name and index number.
3. you are required to make a presentation to a group of web design students about the following multimedia features, namely
(i) Video
(ii) Hyperlink
(iii) Sound.
Include the following information about each of the components.
Video/Movie clips.
Video clips are added to enhance your presentation. This can show authentic movement, which makes the presentation more interesting. Movement is either by click of mouse or automatic.
Hyperlinks
A hyper link is an element in an electronic document or to an entirely different document .typically, you click on the hyperlink to follow the link .Hyperlinks are the most essential ingredients of all hypertext systems, including the World Wide Web.
Sound
Sound as with video or movie clips, is added to enhance your presentation. If for example, your presentation is about weather, a sound clip of thunder can be added. Clicking on the sound clip will activate the sound.
(a) Create a presentation in which each concept (i) (ii) and (iii) is on its own slide. Enhance this with a graphic of your choice.
(b) The first slide should contain links through action buttons to each other slide.
Note;
Each slide must contain a link to the first slide, through an action button.
(c) Include your name and index number on each slide and save your work.
(d) Print your slides.
4. Using any available web publishing software, design a web site about your personal information.
(a) Create a home page for your personal information with appropriate links to other following pages.
(b) Create other pages with following information:
Page I: Page title, Bio-data e.g. name, age, nationality and religion.
Page II: A table of schools attended, period of attendance and qualifications acquired.
Page III:A bulleted list of activities and responsibilities held e.g. head prefect.
Page IV: Hobbies and special skills.
Note:
(i) Create a moving (marquee) page title
(ii) Use appropriate graphics.
(iii) Insert a personal email address (email hyperlink) on the home page.
(iv) Save your work as your name and index number.
(v) Print your work.