uganda national examination board past papers for computer studies 2007

PAPER 1
SECTION A
1. The scientific milestone of using Integrated Circuits (IC) was a characteristic of the
A. First generation
B. Second generation
C. Third generation
D. Fourth generation.
2. What major invention defined the second generation of computers?
A. Magnetic cores
B. Machine language
C. Micro processor
D. Transistors
3. A device that interprets and executes the instructions in the computer and also called the brain of the computer is the
A. System unit.
B. Base Unit
C. CPU
D. ALU
4. In which computer classification is a mainframe categorized?
A. process
B. Size
C. Process power
D. Purpose
5. Which of these factors does not affect internet speeds?
A. Band width
B. Type of media
C. Traffic
D. World Wide web
6. Which one of the following is a set of impact printers?
A. Inkjet printers
B. Bubble jet printers
C. Line printers
D. Thermal printers.
7. One way of protecting the information on a computer is . . . . .
A. Defragmenting the disk
B. Formatting the disk
C. Sorting the data on the disk
D. Backing up the data onto different media.
8. Computer programs used in tasks such as removal of viruses or data compression can be categorized as
A. Word processors.
B. Desktop publishing.
C. Utility programs.
D. Communication programs.
9. Which one of the following is not a word processor?
A. Microsoft word.
B. Word wrap
C. Word perfect
D. Lotus word pro
10. The contents of an entire text file can be referred to as a
A. Document.
B. Word processor
C. Paragraph
D. Page
11. A mega byte is equivalent to . . . . . . . kilobytes.
A. 1024
B. 1048576
C. 11534336
D. 104857600.
12. . . . . . . . . . . . . are programs that manipulate numbers and figures and also perform advanced chart drawing.
A. Word processors.
B. Databases
C. Spreadsheets.
D. Presentations
13. This networking protocol does not relay information out of a LAN.
A. HTTP
B. TCP/IP
C. TELNET.
D. NETBEUI.
14. . . . . . . . . . . . . . is a local area network of computers whose users use web pages and transmission protocol to communicate with each other on the network.
A. Intranet
B. Extranet.
C. Client server
D. Internet
15. The basic use of a primary key in database is to
A. Uniquely identify a record.
B. Act as an alternative identifier.
C. Sort records
D. Modify a file structure.
16. In . . . . . . . . . Software, a field is the entire column that contains similar data.
A. Word processor
B. Database.
C. Spreadsheet.
D. Presentation
17. The primary purpose of presentation software is to . . . . . . . . .
A. Create awareness, documents, letters and reports.
B. Design, create and edit slides for overheads
C. Create and edit graphics.
D. Create newsletters, brochures and booklets.
18. The process of computing data entered in a database with a set of predefined rules or values to check if the data is acceptable is known as
A. Browsing.
B. Validating.
C. Sorting
D. Querying.
19. Rights enforceable by law accorded to a developer of software is called
A. Copyright
B. Patent rights
C. Trade secret right
D. Trade mark
20. The future generation of computers will be characterized by advanced robotics, computer vision-based mobile robots and
A. low processing systems
B. expensive computer systems
C. expert systems
D. mechanical systems.

SECTION B
21. (a) State any three advantages and three disadvantages of dot matrix printers over laser jet printers.
(b) Identify any three advantages of display devices such as monitors over printers.
( c) (i) Distinguish between primary and secondary storages .
(ii) Give an example of each type of storage in (c) (i) above.
(iii)Identify one disadvantage of a hard disk over a floppy disk.
(d)State a device that should be acquired along with a computer to help a user save work when electricity is switched off.
22. (i) what do you understand by the terms below in reference to word processing ?
Formatting
Editing
Saving
(ii) Give two advantages of a hard copy over a soft copy.
(b) Identify four advantages of using a word processing software instead of an ordinary typewriter.
( c) describe one situation where it is more beneficial to use Desktop publishing software instead of word processing software.
( d) Name the labeled bars on a word processing screen below
X....................................................................
Y....................................................................
Z....................................................................
23. The worksheet below shows company bills (in dollars) paid for the months of July, August and September:

	A	B	C	D	E	F
1		July	Aug	Sept	Total($)	Average($)
2	Rent	72	72	106	250	83.33
3	Electricity	24	0	66	90	30.00
4	Telephone	96	90	114	300	100.00
5	Stationery	48	38	64	150	50.00
6	Total	240	200	350	790

(a) Write down the formulas to calculate ;
(i)Totals for the month of July, August and September
Rent................................................................................
Electricity.......................................................................
Telephone......................................................................
Stationery......................................................................
(ii) Average for the months of July, August and September
Rent................................................................................
Electricity.......................................................................
Telephone......................................................................
Stationery......................................................................
(b) It was an error to enter zero (0) in cell C3 .State the cells in which the values would change automatically when the correct amount is put.
(c) List the values in the range B3:D4 in the above table
(d) Shade on the worksheet above the cells that must be used to create the pie chart below:


24 (a) Explain the following terms;
(i) Hyper link
(ii) Web browser (give examples)
(iii) Web master
(iv) web site
(b) (i) write URL in full and state its use.
(ii) Give an example of URL.
(C) (i) What is an ISP in full in relation to internet ?
(ii) State the use of an ISP.
(iii) State any three factors that should be considered in choosing an ISP.
25 (a) Describe briefly the functions of the following views as used in presentation software:
(i)Outline view
(ii)Slide sorter view
(iii) Notes pages view
(b) What is Auto Content Wizard in presentation software?
(c) (i) What is a slide show as used in presentations?
(ii) Explain the following terms as used in a slide show:
Transitional effect
Timing
(d)What is a Master Layout is as is used in presentations?
26. (a) (i) What is a Database Management System(DBMS) ?
(ii) Give any three examples of (i) above.
(b) Various DBMS use different data types .Specify any five data types used in DBMS.
(c) State any five advantages of using database management Systems instead of manual databases.

SECTION C.
27.Describe the various categories of computer application software available today.
28. Reasonably predict the future in computing; from the perspective of the past and the present development in the technology and use of computers.
29. Describe the merits and demerits of using internet.

PAPER 2
SECTION A
1. (i) Type the text below using a word processing program:
CHOOSING WORD PROCESSING SOFTWARE
Word processing is using the computer to enter, store, manipulate and print in letters, reports, books and so on.
Once you have used word processing, you will probably wonder (like a million others before you) how in the world you ever survived without it.
As more word processing packages come on the market, choosing the right software can become confusing.
Nevertheless, there is probably a word processing package that will serve your needs. As you begin looking, ask yourself these questions:
I What types of documents am I now producing?
II what types of features do I need?
Want?
Document types can range from simple letters and memos to proposals, reports, legal documents, books, newsletters, scientific papers, form letters and so on. The point is, match the features you need with the features you need with the features in the software package. For example, if you write articles that require references, you will need the footnoting feature; if you develop a newsletter, having the multicolumn layout feature would be handy; if scientific notation is needed, you will want superscripts (X2+Y2) and subscripts (A21); and if you send "personalized" form letters the mail-merge feature is a necessity.
A number of add-on programs are available to enhance the functionality of word processing packages. These include:
On-line thesaurus
Spelling checker
Grammar checker
Style checker
Idea processor (outliner)
What you can do with word processing is limited only by your imagination and willingness to learn the system.Goodluck in your Computer-assisted writing adventures-now and in the future!
(ii) Insert in the header the word: Tips on the left hand corner and "Word processing" on the right hand corner.
(iii)Bold the heading font size 22 point, underline and centre it.
(iv)Block indent paragraph one by 1 inch in the right and left margins.
(v)In the paragraph starting with "Document" bold the second sentence.
(vi)Make 2 the superscript of X and Y in the expression (X2+Y2) and 21 the superscript of A in the expression (A21).
(vii)Insert bullets on the list of functionality of word processing packages given in the text.
(viii)Insert a footnote of your name and index number on the left and page number on the right hand corner.
(x)Save the work as choosing software and make a print out.
(b) (i) Create a worksheet and enter the data below;

SCHOOL CANTEEN	Q1/2006	Q2/2006		Q3/2006		Q4/2006		YTD
Sales Revenue	22500	38000		52800		85700
Cost of goods sold
Gross Margin
Variable Expenses
Fixed Expenses	6000		6000		6000		6000
Net Profit

Note: Q1, Q2, Q3, Q4 are four quarters of the year.

Complete the worksheet using the following information.
(ii) The cost of Goods sold and variable Expenses for the school canteen are 55% and 10% of the sales Revenue respectively.
(iii)Enter a formula for each quarter to calculate the gross margin which is equal to sales Revenue minus Cost of goods sold.
(iv)Net Profit is equal to gross Margin minus Variable and fixed Expenses.
(v)Add a column called YTD that totals the figures from the four quarters.
(vi)Draw a bar graph for net profit for the four quarters.
(vii)Add a title "School canteen Net Profit"and label the x-axis as "quarterly net profit "and the Y-axis as "Amount in shillings".
(i) Save your worksheet as your surname and print.
SECTION B:

2. The table below gives information on some staff members of a computer school called "COMTECH ACADEMY"

EMP NO.	SURNAME	FIRST NAME	SEX	TITLE	DEPARTMENT	SALARY (shs)	DATE OF BIRTH
CA001	ADUWO	JANE	F	DEPUTY	ADMINISTRATION	620,000	17-06-36
CA050	HOLOWO	MOSES	M	TEACHER	BUSINESS	510,000	06-08-77
CA061	WAPAKABULO	JAMES	M	TEACHER	BUSINESS	600,000	05-06-70
CA150	NAKUMUSANA	MARY	F	SECRETARY	INFORMATION	2275,000	20-07-36
CA168	KOMAKECH	MIKE	M	TEACHER	BUSINESS	500,000	15-06-63
CA170	MUTEBI	JOHN	M	DIRECTOR	ADMINISTRATION	1,000,000	17-07-66
CA190	NDAULA	SARAH	F	CASHIER	ADMINISTRATION	600,000	14-04-68
CA201	OKELLO	JOHN	M	DRIVER	ADMINISTRATION	265,000	16-05-63
CA215	ALIYO	JOYCE	F	SECRETARY	COMPUTING	275,000	20-08-70
CA307	NASSUNA	HARY	F	LIBRARIAN	INFORMATION	310,000	07-11-74

NOTE:EMP NO.represents Employee number.
(a) (i) You are required to design a suitable database to manage the above information,namethe database EMPLOYEE DATABASE.
(ii) Create a table using Design view ,and name it EMPLOYEE TABLE .
(iii)Create a form called Employee Entry Form and enter the above records.
(b) (i) Create a query displaying all the fields in the above table to filter out only employees from the department of information .save it as INFORMATION DEPARTMENT.
Print the query and its output
(ii) Create another query displaying all the fields of employees with salary less than 300,000. Name it "salary scales employees less than 300,000."
Print the query and its output.
(iii)The academy 's retirement age is 55years.Create a query to filter out the employees whose ages are above 55years.Name it "RETIREMENT AGE"
Print query and its output.
(iv)Create a report using the employee table and group the records by department and name it "REPORT BY DEPARTMENT"
Print the report and the query.
3. You have been contacted to design a website for Human Local Government Administration which includes the following:
(a) An index page with the title "HUMA" and heading "HUMA LOCAL GOVERNMENT ADMINISTRATION".
The page should have:
(i)Provision for inserting the administration block photograph. The building is still under construction.
(ii) Six local government department i.e.
_ Administration department
_ Finance department
_ Human Resource department
_ Health department
_ Education and sports department
_ Security department
(iii)The following three column table:

First name	Last name	Department
James	Okello	Finance
Hellen	Mukisa	Human Resource
Isa	Lutalo	Health

(b) Create a link on the Education and sports department in (a)(ii) above which will lead you to a page explaining what the department does.
(c) Include the districts's mission statement at the bottom of the index page .
(d) Provision should be made for originality,creativity,innovation and appropriate use of graphics.
(e) Save your work in your name and index number.
(f) Print your work.
4. Create a suitable 7-slide show presentation for your school,with the following items:
NOTE: Your slide should :
(i)Use appropriate animation schemes to view your presentation.
(ii) use appropriate transition for your show
(iii) apply clips and word art where applicable.
(iv)apply appropriate Design templates and background colour.
(v)have a header as your name and index number.
(a) A title slide with the name of your school
(b) A text slide with the departments in the school
(c) A text slide with the subjects taught in the school.
(d) A two column text slide with the names of teachers in the school.
(e) A text slide with co-curricular activities in the school.
(f) A tabular slide with ten (10) imaginary senior four candidates with their imaginary marks in end of term two computer studies test.
(g) A line graph for analyzing performance of the candidates in (f) above.
(h) Save your work as your name and index number.
(i) Print your slides.
5. East African community (made of Uganda, Tanzania and Kenya-UTAKE) is gradually moving into political, economical and social federation. The three countries are determined to form the most powerful economic giant on the African continent.
Using any available web publishing software, design a web page for the East African Community. Make sure your home page is impressive, creative and has appropriate graphics and not slow to download.
(i)The home page should have a short story about East Africa of about 100 words.
(ii)The homepage should have a link to each of the three countries; Uganda, Tanzania and Kenya.
(iii)Each linked page, in (ii) should have a short story about that country.
(i) Indicate your name and index number as a footer.
(ii) Save your work as HEAC-surname.
(iii) Print your work including your links.