Custom Search
COMPUTER
Tuesday, 21 February 2012 12:10

COMPUTER Paper 1&2 2004

Written by B.K.Sharon

PAPER 1

SECTION A

1.      The following is a group of processors.

A.       80284, 80486, Pentium 0,Pentium I

B.       80286, 80486, Pentium I, Pentium II.

C.      1286,1486, Pentium 0, Pentium II

D.     1286, 1486, 80286, 80487.

2.       What is information technology?

A.      It is the central processing unit and monitor

B.      It is the tangible components of a computer system.

C.      It is all the types of equipment and programs used in processing.

D.     It is the combination of software and programs.

3.      Which of these does not fully represent computer classification by function?

A.      Mainframe, micro, mini computers.

B.      Mini, personal, analog computers.

C.      Digital, mainframe, micro computers.

D.     Personal, analog, micro computers.

4.      Which drive letter usually represents the hard drive?

A.         A

B.         B

C.         C

D.        D

5.      Which one of these became used commonly in offices in the third generation of computers?

A.       Mainframe computer.

B.       Ananometer

C.       Supercomputer.

D.      Microcomputer

6.      What is the function of a MODEM? It

A.       Blocks digital signals from leaving the computer.

B.       Converts digital signals to analog and vice versa.

C.       Converts analog signals to the atmosphere.

D.      Modulates digital signals to mechanical motions.

7.      Back up refers to

A.       Storage of files on a secondary storage device.

B.      Taking in data for rearrangement in order.

C.      Programs designed to check specific parts.

D.     Combining data from more than one file.

8.      Which one of the following is not an operating system?

A.       Windows 3.1

B.       DOS version 6.22

C.       Unix

D.     Microsoft word

9.      Formatting in word processing refers to

A.      Preparing a new floppy diskette for use.

B.      Cleaning diskettes for storage.

C.      Enhancing the appearance of text in a document.

D.     Erasing all data on a diskette.

10. The backspace key:

A.      Deletes any letter towards the right.

B.      Erases any character towards the left.

C.      Moves the cursor to left without deleting any character.

D.     Deletes a character at the cursor position.

11. A work book is a

A. publication.

B. data type entry.

C. range of cells.

D. collection of worksheets in a single file.

12.  Which of the following is not characteristic of spreadsheets?

13.  E-mail stands for

A. electrical mail

B. surfing mail.

C. electronic mail.

D. browsing the net.

14.  A computer network refers to

A. information storage.

B.  linking of computers for resourcesharing.

C.  connecting a computer system to a backup device.

D.  sharing a computer by many people.

15.  In Database,a field is

A. the way information is displayed.

B.  a particular listing with in a file.

C.  the entire collection of data.

D.  each bit of information in a record.

16.  Databases perform the following functions:

A. sorting of slides,retrieving and formatting.

B. formatting , organizing and retrieving  pictures.

C. creating, organizing and managing collection of related data.

D.  entering data,saving,retrieving,drawing graphs.

17.URL stands for

A.  uniform resource locator.

B.  universal resource link.

C.  an email address

D.  a web publishing software.

18.   Which of the following best distinguishes a WAN from a LAN? The

A. number of computers connected.

B. distance between connected computers.

C. model of computers connected.

D. type of operating system used in the network.

19.  WWW refers to

A. web worldwide.

B. world words web

C. wild world web

D. World Wide Web

20.   A problem that is most likely to occur due to future advancement of computers is

A. underdevelopment.

B. under population

C. unemployment

D. insecurity.

 

SECTION B.

21.  (a) write the following abbreviations in full.

(i) LSI

(ii) COBOL

(iii) BASIC

(b)  Distinguish between mainframe and mini computers.

(c )  Name two types of instructions that computers use to do their works.

(d) List down any five components that make up a complete system unit.

(e)(i)  What is a CD-ROM?

(ii)Mention one advantage of a CD-ROM over a hard disk.

22.(a)Mention any three safety/security measures taken in a computer laboratory.

(b)What is system software in a computer system?

(c)Name three examples of system software.

(d)Mention any four functions of utility programs.

(e)What do you understand by the following terms?

(i)Editing . . . . . . . . . . . . . . . .

(ii)Saving . . . . . . . . . . . . . . . .

(iii)Trouble shooting . . . . . . .

23.(a)What is a computer spreadsheet?

(b)Name any four functions of a spreadsheet software.

(c)List three types of entries in spreadsheets.

(d)Mention three types of graphs created in spreadsheets.

(e)  (i)What is a computer virus?

(ii)Mention two ways in which a computer can be infected by a virus.

24.(a)Write the words below in full.

(i)FTP . . . . . . . .

(ii)WAN . . . . . .

(b) State any three factors that affect communication speed on the internet.

(c)Distinguish between the e-mail and the internet.

(d)What is a server?

(e)List any two functions of a server?

(f)Give four differences between the hard disk and the floppy diskette.

25.(a) What is a database?

(b)Distinguish between Microsoft Access and database.

(c)List four examples of data which can be used to create a database.

(d)Mention three examples of database management software.

(e)Give four advantages of electronic databases over manual databases.

26.(a)Explain the following terms as used in presentation software:

(i)Slide show

(ii)Slide sorter

(iii)Slide layout

(b)Explain the importance of presentations.

(c)Describe one function of a slide master.

(d)Outline how you would create a transitional loop?

 

SECTION C

27."Computers have destroyed our culture!"What are your arguments for and against this statement?

28. Outline what you expect the role of computers to be in future.

29."Information Technology has done more good than harm to education."Give your arguments in favour and against the statement.

 

 

PAPER 2.

SECTION A.

1.      (a ) Type the document below as it is, and save it under the name "My work 1"

Comper expert calls for IT course in schools.

Uganda's youg generation neds to be taught to apreciae the rise of Information Technology (IT) in their day-to-day lives, Sultan Awan , the managing director, silicon compuer series said.

The website www.Uganda schools.org, for a fe of shillings 30, 000, school wil publish information abut themselves on the site. There is a separate pge for every school.

By John Ricks Kayizzi

(Monitor Publications).

You are required to:

(i) Change the heading to uppercase, bold and underline it

(ii) Correct any misspelled word(s) in the document.

(iii) Replace the fee of shillings 30,000 by shillings 40,000.

(iv) Add your name and index number as a footer.

(v) Save the document a "My work 2"

(b)The following rates were quoted by some forex bureau in Kampala, for some currencies sold in Uganda shillings. Enter this table into spreadsheets.

 

Bureaux.

Dollars.

Pounds.

Euros.

DM.

A

1808

2600

1560

800

B

1808

2605

1605

_

C

1805

2600

1600

_

D

1803

2650

1645

_

E.

1807

2600

1600

_

 

You are required to:

(i)Create a pie-chart representing Forex Bureau A entries in percentages. Put the legend at the bottom.

(ii)Add a title to the pie-chart in (b)(i).Place the chart as an object below the table.

(iii)Add your name and index number below the pie-chart.

(iv)Save the work sheet as "My chart."

 

SECTION B

2.      (a)Students of computer studies in a certain secondary school are to design their database with the following fields.

Surname of the student, first name,age,district of origin ,sex,index number, whether the student is an orphan or not, marks scored in a mathematics test.

(i)Use the above information to design a structure using the following format:

Table name . . . .  . . . . . . . . 9state it)

Field name

Data type

Size/Length

 

 

 

(ii)Create a table of five records

_Name the appropriate key field (primary key).

(iii)Save the database as "My file".

(b)A recent survey showed the following data. Enter the information below in the table called "survey".

Reg.No.

Surname

First Name

Sex

Age

District

0006

Okello

Rose

F

15

Tororo

0010

Opio

John

M

62

Tororo

0007

Masaba

Patrick

M

40

Mbale

0127

Mukasa

Alex

M

20

Masaka

0053

Lwanga

Lydia

F

34

Masaka

0080

Abaho

Kate

F

52

Bushenyi

0008

Mugisha

Joseph

M

6

Kabale

0021

Akot

Aisha

F

22

Lira

0458

Uwimana

Jane

F

45

Kisoro

0500

Namubiru

Grace

F

31

Masaka

(i)Create a query to show people from Masaka.

(ii)Given that all the males and females above 18 and below 60years of age pay graduated tax, write a query which will display only tax payers.

(iii)Create a report for all females showing their names and their districts.

Save as "My report."

3.      Using a web design software of your choice, design a website for your former primary school which includes:

(a)     An index page with the name of the school and picture of an important feature in the school. .(The picture does not have to be the actual one but should be closely related).

(b)     One page on the

(i) Different subjects offered.

(ii) School administration.

(iii) Sports and co-curricular activities,

(iv)neighboring community.

(c)In the website

(i) Write your name and index number at the end of the last page.

(ii) The pages should be well linked.

(iii)Save as 'My preschool"

4.      The ministry of Health has appointed you as a Health Educator. You are required to give a talk on "The role of sex Education in schools".

You are required to:

(a) Design 3 slides as follows:

(i)Slide I should have the introduction of the topic.

(ii)Slide II should have the content of the topic.

(iii)Slide III should have the relevancy of sex education in schools.

(b) Include your name and index number at the end of each slide.

( c)Save your presentation as "My slide".

(d)Use minimal graphical effects.

5. Dynamic Roses, a flower farm which produces red and white roses, red and purple carnations, sells its products both locally and abroad. It has 4 managers namely;

General Manager    _ in charge of overall management

Personnel Manager _in charge of human resources and is responsible for welfare of the employees.

Production Manager _responsible for growing and packing flowers.

Marketing Manager _responsible for selling, transportation and collection of revenue.

Imagine you have been approached to design a website for the company.

Create a website consisting of:

(a) An index page with links to all departments with a company logo.

(b)a page on the ;

(i) Production department detailing the varieties of flowers produced.

(ii)Marketing detailing the different managers and their roles.

(iii) Marketing detailing where the products are sold.

(c)A photo gallery showing pictures of different products and functions of the company.(use only three pictures)

(Note: The pictures do not have to be real ones but must be closely related)

(d)In the website;

(i) Include a feedback provision where a visitor to the page can send an e-mail.

(ii) Write your name and index number at the end of the last page as a footer.

(iii)Save the file as "Rose farm".

Tuesday, 21 February 2012 12:04

COMPUTER Paper 1&2 2005

Written by B.K.Sharon

PAPER1

SECTION A

1.      All these are data storage devices except:

A.       Floppy diskette

B.       Hard drive.

C.       Control unit.

D.      Zip drive.

2.      Which one of these is odd?

A.       Microsoft word

B.       Microsoft Access

C.       Epi Info

D.      UNIX

3.      A . . . . . . . . . . is a primary database structure.

A.         Table

B.         Report

C.         Form

D.        Query

4.      The operating system is not directly involved in one of these tasks.

A.      File management

B.      Formatting a diskette

C.       Scheduling of print jobs

D.      Displaying a web page

5.      A computer with a . . . . . . . . .specification will load programs faster.

A.         900MHz

B.         1 GHz

C.         700MHz

D.        600MHz

6.      . . . . . . . . is a popular 7-bit  encoding system.

A.      ASCII

B.      EBCDIC

C.      Hexa decimal

D.      Binary

7.      This component of the Central Processing Unit (CPU) carries out all the logic and mathematical operations.

A.       ALU

B.       System clock

C.       Register

D.      Control unit

8.       . . . . . . . . . is a group of commands available to the CPU which determines the basic computer operations that can be performed.

A.       Instruction set

B.       Operating system

C.      Rom Bios

D.     Hard disk

9.      Which of the following is not a computer peripheral?

A.       Monitor

B.       Printer

C.       CPU

D.      Keyboard

10.  A . . . . . . .is not an example of an output device.

A.      Printer

B.      Plotter

C.      Monitor

D.     Keyboard

11.  Which one of the following is not a programming tool?

A.       Debugger

B.       An interpreter

C.       Notepad

D.      A compiler

12.  Okello intends to draw up an inventory.Which of the following is the most suitable software to use?

A.      Ms-Word

B.       C++

C.       Ms-Excel

D.     Pascal

13.  A . . . . . . . . makes it easy to find your way round the internet.

A.       Network browser

B.       Microsoft word

C.      Compiler

D.     Digital camera

14.  Slides as an output are displayed using . . . . . . . software

A.       A word processing

B.       An internet explorer

C.       A spreadsheets

D.      A presentation

15.  Which of the following is not a storage device?

A.      Disk drive A

B.       Disk drive B

C.       Motherboard

D.      CD-ROM

16.  The process of starting a computer is reffered to as

A.       Surfing

B.       Booting

C.       Blocking

D.      Clicking

17.  The output displayed on the screen is termed as

A.       Photocopy.

B.       Softcopy

C.       Master-copy

D.      Hard-copy.

18.  One of these is a pointing device used to manipulate on screen objects.

A.       CD-ROM

B.       Digital camera

C.       Scanner

D.      Mouse

19.   Which of the following devices can be used to convert images or text on paper documents into electronic format that can display,store and print?

A.       Track ball

B.      Scanner

C.      Monitor

D.      CD-Rom device

20.  The option on the menu bar which enables one to name a document and store it on a storage device using another name is

A.      Save

B.      Save as.

C.       Edit

D.      New

 

SECTION B

21.  (a) Write the following abbreviations in full.

(i)GUI . . . . . .

(ii)ASCII . . . . .

(iii)EBCDIC . . . . .

(iv) URL . . . . . . .

(b) Explain the following Internet services:

(i)  TELNET

(ii)  WWW

(iii) E-mail

(c) What do you understand by the following terms?

(i) computer-file

(ii) File name extension

(iii) Specify the file types associated with the following file extensions:

.exe . . . . . . . . . .

.txt . . . . . . . . . . .

.doc . . . . . . . . . .

22.  (a) Why is the binary number system used for computers?

(b) Convert the

(i)  Binary number 10101010 to its decimal equivalent.

(ii) Decimal number 121 to its binary equivalent.

(c)(i)  Explain the meaning of the term control unit as used in a computer system.

(ii)State any two functions of the control unit.

(iii) Define a byte

(d) Distinguish between ROM and RAM

23.  (a) (i) define the term band width.

(ii) List three communication media.

(b) Below are specifications for two different types of computers A and B.

Specification:                  computer A                      computer B

 

RAM                    :                    64 MB                         128MB

HARD DISK         :                    700MB                         20GB

SPEED                  :                      800MHz                      1GHz

COMPUTER WORD:               32-bit                           64-bit

NETWORK CARD:                NO                                  YES

VIDEO CARD       :                 YES                                 YES

Study them and answer the questions that follow:

(i) Which computer is faster in processing data?

(ii) How many bytes can computer A handle at the same time?

(iii) Which computer is more likely to be connected to a LAN and why?

(c ) Define the following terms:

(i) Software

(ii)Hardware

(iii) Application programme

(d)Distinguish between down loading and uploading a computer.

24. (a)  (i)Define the term computer Virus

(ii)Identify any three possible symptoms of computer viruses.

(b) State two ways in which one can guard a computer system against viruses.

( c) (i) What do you understand by the term screen saver as applied to computers?

(ii) State any two applications of a screen saver programme.

(iii) State two precautions that should be taken when cleaning a screen display area.

(d) State any two steps that must be followed to safely shut down a computer from the Microsoft word file.

25.   (a)  Define the following terms:

(i)   Warm booting

(ii)  Monitor

(iii) Folder

(iv) Application intelligence

(b) (i) List any two ways of starting an application in windows.

(ii) What is the Windows utility used to view contents of a floppy, hard and network drives?

(iii) What must be done to floppy disks before they are used?

(i)                 What do we call the basic applications that are built into windows that allow us to perform tasks like drawing or text editing?

(c)(i)  CD-ROM stands for

(ii)State two ways in which a CD-ROM can be useful in education.

(iii) State three precautions for correct handling of diskettes.

26.(a)write the following abbreviations in full.

CAD

CPU

I.C

IP

(b) Define the following terms:

Hard copy

Soft copy

Bug

(c ) Explain the meaning of the following:

(i)HTTP

(ii)HTML

(d)Fill in the gaps in the table below.

Task

Type of software that can be used.

(i) . . . . . . . . . . . . . . . . . . . .

Adobe Photoshop, paintbrush, Ms-word.

(ii)present a lecture

. . . . . . . . . . . . . . . . . . . .

(iii) . . . . . . . . . . . . . . . . . . .

MS-Excel

(iv)Reading information on the internet.

. . . . . . . . . . . . . . . . . . . .

 

SECTION C

27.    Explain why a school should have a web site.

28.    (a) Outline the different forms of secondary storage.

(b) Describe the characteristics of each of the above forms of secondary storage.

29.  Give your arguments in favour and against the impact of computers in our society today.

 

PAPER 2

SECTION A

1.      (a)Type the following text as it is ,correcting any spelling mistakes therein.

From its very earliet day,the internethas been primarily concened wit one task,making it easier for people to communicate with one anther using computers.The intenet was creted to let university reseahers share their thoughts,work,and resources and for military people to comanicat with each other incas of war and even,theortically a nuclear attack.

By P Gralla

How the internet works.

Requiered to:

(b)    Set the page margins to the following measurements:

Left =2.5cm,Right=2.5cm,Top=1.5cm andBottom=1.5cm.

(ii)Insert a title called INTERNET to the top right,and bold it .

(iii) Change font size 14.

(iv) Add your name and index number on the header.

(v) Save your document on a floppy diskette as "text"

(b)The statistics below show rainfall received in a certain district of Uganda for six months (in mm) as follows:

June_186,July_181,August_191,September_158,October_181,November_133,December_91.

Required to:

(i) Tabulate the data in worksheet. Include a title for the table called rainfall statistics.

(ii) Create a column graph of the entries above showing the amount (mm) of rainfall per month.

(iii) Provide a suitable title for the graph in (ii) above and label the x- and y- axes. Place the chart as an object in sheet 1, below the table.

(iv) Create a pie chart showing the amount of rainfall received in percentage. Place the pie-chart as an object in sheet 1, just below the bar graph.

(v)Write your name and index number below the pie-chart bar.

(vi)Save your worksheet on a floppy diskette as graph 1.

 

SECTION B

2. Malaria is one of the major killer diseases in tropical countries. As an informed person, you are required to design a slide show on malaria, the killer:

(a)Create 4 slides:

(i) Slide one should elaborate on the causes.

(ii) Slide two should focus on the spread.

(iii) Slide three should show the prevention methods.

(iv)Use nominal graphics in the three slides.

(v)Slide Four should show an illustration using a suitable clip art picture related to malaria on the right hand side with related text on the left hand side.

(b)Link one slide to another.

(c)Include your name and index number on each slide as a copyright.

(d)Save the slide show on a floppy diskette as show.

3. You are contracted to design a webpage for Utop, an East African Company that manufactures toothpaste, washing soap, margarine and cooking oil. As a web master, you are required to include:

(i)a page title

(ii) Appropriate graphics.

(iii) Not more than 120 words on the company and its products.

(iv)a link for each of the products.

(v)a layout.

(vi)the author of the text who can be contacted.

(vii) Creativity.

Save your page on a floppy diskette as Upage

4. A school in kiboko county, Mbemba district has a population of 500 students and various subject departments. Some twenty students, 12 of them girls live in Maria and Thereza houses. The other 8 are boys who live in Muteesa and Kabalega houses.

Required to:

(i)create a database  file with the fields :

Surname,last name,age,sex,registration number,address,class and house for the 20 students.

(ii)sort the data in (i) above using, surname as the key field. Save your database file on a floppy diskette as Dfile.

(iii)Design a table using the data in (i) above in a Datasheet view.

(iv)Create a query for house members of Maria and Kabalega houses.

(v)Create a report showing the fields: surname, class and house.

(vi)Save your table on a floppy diskette as Dtable.

5.The Information Technology (IT) teacher has given you an assignment  to design a webpage for the IT Department in your school.

Required to include:

(i)a page title .

(ii)appropriate graphics.

(iii)not more than 110 words about the IT Department and computer programmes taught.

(iv)two links at the bottom of your home page.

(v)Creativity

(vi)date of publish/source of information.

Save your webpage on a floppy diskette as " My IT page".

Tuesday, 21 February 2012 11:13

COMPUTER Paper 1&2 2007

Written by B.K.Sharon

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.

Monday, 20 February 2012 12:47

COMPUTER Paper 1&2 2006

Written by B.K.Sharon

PAPER 1.

SECTION A

1.      The difference between hardware and software is that hardware is

A.      Tangible while software is intangible

B.      Metallic while software is plastic.

C.      Permanent while software is temporary.

D.     Reliable while software is unreliable.

2.      Which of these components is the brain of a computer system?

A.      Main memory

B.      The secondary memory

C.      The processor chip

D.     The power supply

3.      Which of the following are the two general types of programs?

A. Entertainment and productivity.

B. Microsoft and IBM.

C. Word processors and Databases.

D. System Software and Application Software.

4.   A computer performs all the following functions expect

A. storage.

B. processing

C. output

D. thinking.

5. Which of the following is used to give commands to the computer?

A. Input devices

B.  Storage devices

C.  Output devices

D.  Processing devices

6.  A communication device enables a computer to connect to a computer

A. system unit

B.  software

C. application

D. network.

7.  A file is

A.a section of the main memory used to store data

B. a part of a program used to describe what the programme does.

C. another name for floppy disk

D. a collection of information that has been given a name  and stored in secondary memory.

8.  An anti-virus is an example of

A. a user interface

B. an operating system

C. application software.

D. a utility program.

9.  A grid in a spreadsheet program where entries are made consists of

A. rows, columns and diagonals

B. columns and rows

C. rows and diagonals

D. columns and diagonals.

10.  What kind of hardware would you use to put photos of your family into a file?

A. Printer

B. DVD player

C. scanner

D.  power point

11.  In a database,a colletion of fields that contain data about asingle activity or transaction is reffered to as a

A. File

B. Table

C. Record

D. primary key

12. What  type of object is used to find answers to questions about the data in a database ?

A.  Macro

B.  Query

C.  Module

D.  Form

13.  Which of the following is not an example of a programming language ?

A.  COBOL

B.  Visual Basic

C.  Lotus

D. Java

14.  Kapere was doing his computer final examination when his computers hang up. He lost everything he had been typing because he forgot to

A. copy

B. save

C. cut

D. paste

15.The purpose of a screen saver is to

A. help prevent screen burn out

B. brighten up the screen

C. test the capability of the monitor to display various graphics.

D. entertain the computer user.

16.  HTTP stands for

A. hyper text transport protocol

B. hyper text transport platform

C. hyper text transfer platform

D. hyper text transfer protocol.

17.  Which of the following usually provides internet e-mail accounts and addresses ?

A.  ISP

B.  Internet café

C.  WWW

D.  TCP/IP

18.  Which of the following is the most promising use of a computer ?

A.  Error-free software

B.  On-line education

C.  Voice recognition software

D. Downloading music.

19.   Which type of software is used to request a specific resource from the server ?

A.  Server software

B.  Client software

C. System software

D. Messaging software.

20.Which of the following is credited using presentation software ?

A. A directory

B. A file structure .

C. An organization chart.

D. An e-mail message.

 

SECTION B

21.    (a) Give any three safety rules that should be followed in a computer laboratory.

(b)    Define the following terms as used in computer:

(i) Directory

(ii)Modem

(c)      (i)Name any five peripheral devices of a computer.

(ii)Give the function of each device named in ( c)(i) above.

1.      (a) Explain the following terms as used in computer  studies:

(i)System software

(ii)Application software

(iii)Utility programs

(b)Outline four functions of an operating system software.

( c) List any five operating systems that you know.

2.      (a) Write the following in full in relation to computer.

(i)RAM

(ii) ROM

(iii)EPROM

(b)Distinguish between primary storage and secondary storage devices, giving an example of each.

(c )  (i) Name three major parts of the CPU.

(ii)Explain the function of each part in (c)(i) above.

3.      (a) Explain the following

(i)Telnet

(ii)FTP

(iii)TCP/IP

(iv)Intranet

(b)What is a web browser? Give one example of a web browser.

(c) State four major components of an e-mail message.

25.    (a) Define the following terms in relation to database.

(i)File

(ii)Record

(iii)Field

(b) Name three functions of databases:

(c)Outline four steps taken to create a simple database.

(d)With an illustration,explain how a shopkeeper can use spreadsheets to run the business.

26. (a) Distinguish between the following as used in computers:

(i) data and information.

(ii)domain name and IP address.

(b) State two undesirable behaviours involving internet

(c)(i) How does the use of the mouse make  Windows easier compared to the use of the key board alone ?

(ii)State any two major problems that often affect the proper functioning of the mouse.

(iii)Suggest any two ways the mouse can be protected from the problems in ( c)(ii) above.

 

SECTION C

27. The Head teacher of your school wishes to buy computers for the school. As a student of computer studies, what type of computers would you advise the Head Teacher to buy and for what benefits are they to your school?

28. Suggest reasons why there is an increase in the use of computers in most organizations in Uganda today.

29. Total data security is not possible today.'Outline the areas where this has been achieved and challenged .

 

PAPER 2

SECTION A

1.      (a) (i) Using a suitable word processing software, type this document as it is.

TUBER CULOSIS(TB)IN AIDS

The global war on AIDS could lost if the ignores tuberculosis, often a death sentence for people infected with HIV , former south African president Nelson Mandela warned at a global AIDS conference recently held in Bangkok. The world has made defeating AIDS its top priority.This is a blessing, but TB remains ignored ,said Mandela.He steered  clear the controversay to focus on the plight of millions suffering from HIV and TB.

About 14 million people are infected with HIV and TB ,70% living in sub-saharan Africa,the region hardest hit by HIV/AIDS,which has killed 20 million peopleworldwide.HIV, the virus whichcauses AIDS,destroys the immune system and makes patients more vulnerable to diseases such as TB,an infectios illness that accounts for up to one-third of all  HIV/AIDS deaths.

"We cannot win the battle against AIDS if we do not also fight TB.TB is too often a death sentence for people with AIDS.it does not have to be this way".mandela said.He said resources for detecting and treating TB were woefukky short despite the world having had a cure for it more than 50 years ago.

(Adapted from: The New Vision,Monday,July 19,2004.)

(ii) copy and paste the document topage 2.

(iii)using the copy on page 2,centr,bold and underline the heading and make it font size 24.

(iv)Cetre align the third paragraph and make it all italics.

(v)Italicise the source of this document and make it font size 8.

(vi)Spell check your document.

(vii)Insert your name and index number as a footer.

(viii) Save your work as my work.

(b) The table below shows the average sales (in millions of litres of liquid soap of four companies in a certain city during the first quarter of the year 2003

 

 

Patro

Coltexn

Hellen

Pove

January

23.9

40.0

65.5

18.7

February

15.0

54.8

69.0

22.6

March

20.4

67.0

78.9

24.4

 

(i) Enter the above information in a spreadsheet.

(ii)Create a pie chart that includes a title and labels to represent the sales of the four companies in the first quarter of 2003.

(iii)Draw a bar chart to represent the sales of the companies.

(iv)Determine the totals sales of each month.

(v)Insert your name and index number in (i) and (iii) above.

(vi)save your work on a floppy diskette as my spreadsheet.

 

SECTION B:

2.      (a) Create a database structure (table) using appropriate data types in relation to the table given below. Set staff No. as the primary key. Save the table as staff table.

Staff pay roll

Staff no.

Surname

First Name

Sex

Department

salary

UTS652

Natukunda

Emilly

F

Physics

275,000

UTS441

Oloka

John

M

Chemistry

265,000

UTS102

Abaho

Benedict

M

Economics

500,000

UTS333

Among

Joyce

F

Physics

275,000

UTS459

Biriggwa

Joshua

M

Economics

490,000

UTS245

Namagembe

Hawa

F

Chemistry

310,000

UTS134

Nokrach

James

M

Economics

850,000

UTS101

Mwesigwa

Johnan

M

Physics

290,000

UTS376

Kakaire

Peter

M

Chemistry

540,000

(b)Create a form using the staff table in (a) above and use it to input the records above. Save the form as staff form.

(c)Create a query showing staff no, surname and department to filter out only staff in the physics department. Save it as query 1.

(d)Create a report using query1 table.

(e)Create another report which will produce a list of staff who are in economics department earning a salary of less than shs.600,000.

3. Gapro is abig industrial firmdealing in the production of various industrial goods such as iron sheets =,angle and iron bars,metallicdoors and windows and many other related products.It sells its products in local markets and in markets in some neighbouring countries.Local outlet branches  are in kampala,Jinja,Mbale and Arua.Regional branches are in  Nairobi,Dar-es-salam and Kigaliin neighbouring countries.The firm is managed by four managers in addition to the executive generalmanager .This includes the manager responsible for the department of production,Finance and Accounts,Marketing and Sales,and personnel and welfare.

The  firm has approached you to design a website.You are expected to create a website consisting of

(i) a page with a suitable company logo linking all the departments of the firm.

(ii)a page on the production and marketing of the various products.

(iii)a page linking the local and regional markets for the  firm's products.

(iv)minimal graphics showing the functions and products of the firm.

N.B.    The website should:

(i)have a link for the firm's e-mail address.

(ii)be well linked.

(iii)be creatively designed.

(iv)include  your name and index number on the  first and last pages as a footer.

(v)Save your work as Gapro.

4. as an education official in your district, you have been assigned a project to sensitize people in your locality about the importance of education.

You are required to design four slides.

(i)Slide I: Introduction (include definition of education,history of education in district and Uganda).

(ii)Slide II: Content(types of education)

(iii)Slide III: Benefits and achievements of education.

(iv)Slide IV: Short comings of education and conclusion.

(v)Save your presentations as 'education'.

N.B.      Insert a relevant graphic on each slide.

_ set your slides to have suitable background.

_ Include your name and index number on each slide as a header.

_ Set the slides to run automatically.

5. Using any available web publishing software, design a hotel's home page. Make sure the home page is very impressive but not too slow to down load.

You are expected to include the following:

(a)   A page title.

(b)  Appropriate graphics.

( c)  a 100-120 word text.

(d)      1 link (for the hotel's email address).

(e)       Table-showing at least four services offered by hotel.

(f)        Layout.

(g)       Creative designing

(h)       Save your work as Hotweb.

Monday, 20 February 2012 12:18

COMPUTER Paper 1&2 2008

Written by B.K.Sharon

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 18th 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.

12th / 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.

 

Monday, 20 February 2012 12:06

COMPUTER Paper 1&2 2009

Written by B.K.Sharon

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.

Secondary Level ( U.C.E)

ACCOUNTS
AGRICULTURE
BIOLOGY
COMPUTER
C.R.E
COMMERCE
ENGLISH LANGUAGE
ENTREPRENEURSHIP
FOOD $ NUTRITION
GEOGRAPHY
HOME MANAGEMENT
HISTORY
I.R.E
LITERATURE
MATHEMATICS
OFFICE PRACTICE
fashion journal