UNEB UCE Computer Past Paper Year 2017

by
Contents hide
1 UNEB UCE Computer Past Paper Year 2017
1.1 COMPUTER STUDIES (PAPER 1) 2017
2 COMPUTER STUDIES PRACTICAL (PAPER 2) 2017

UNEB UCE Computer Past Paper Year 2017

COMPUTER STUDIES (PAPER 1) 2017

SECTION A

Answer all questions in this section.

  1. Which one of the following is not a storage device?
    1. Flash Disk
    2. Memory card
    3. Hard Disk
    4. Motherboard
  2. A good password contains
    1. very few characters
    2. text and numbers
    3. common words or names
    4. only numbers
  3. A light pen facility can best help computer users to
    1. draw pictures
    2. play computer games
    3. convert hardcopy text into bit-mapped image forms
    4. mark examinations on a computer
  4. In document production, a font is
    1. data of the same field.
    2. characters of the same face and shape.
    3. data of the same record.
    4. characters in the same document and file
  5. The error message that will appear in a cell when the formula used contains a function which is not recognized in spreadsheet is
    1. ###
    2. #VALUE
    3. #NAME?
    4. #REF!
  6. The process of checking whether essential computer peripherals are attached and operational is called
    1. configuration
    2. CMOS
    3. POST
    4. defragmentation
  7. Which of the sets below contains characteristics of advancement in computer technology?
    1. Smaller in size, faster and more expensive.
    2. Bigger in size, faster and cheaper.
    3. Bigger in size, more expensive and faster.
    4. Smaller in size, faster and cheaper.
  8. Computer maintenance, upgrade and configuration utilities are accessed through
    1. control panel.
    2. network manager
    3. system registry
    4. my computer
  9. The lowest level language of a computer is
    1. BASIC
    2. FORTRAN
    3. MACHINE
    4. COBOL
  10. The abbreviation MIS in system analysis stands for
    1. Memory Interface System
    2. Management Information System
    3. Memory Interface Structures
    4. Management Information Support
  11. The ________will enable users to optimize personal computers.
    1. utility routines
    2. operating system
    3. device drivers
    4. programming languages
  12. The service needed to transfer or upload files on the Internet Service Provider is called
    1. HTTP
    2. FTP
    3. IP
    4. HTML
  13. The first computing device used to perform arithmetic calculations is
    1. Weaving loom
    2. Slide rule
    3. Napier’s bones
    4. Abacus
  14. Software systems are developed using
    1. antivirus tools
    2. operating systems
    3. programming languages
    4. word processing
  15. Identify the correct rule for HTML tags from the following
    1. Do not use < and > symbols
    2. Symbols and tag text should be spaced.
    3. There should always be an opening and closing tag.
    4. All tags must start eith equal signs (=).
  16. A row in a database table that contains information about a given person, event, product ot asset is a
    1. field
    2. record
    3. key
    4. mask
  17. The important way to prptect data and other computer network resources is referred to as
    1. decoding
    2. backup
    3. zipping
    4. encryption
  18. The views that enable a user to rearrange the order of slides are:
    1. Outline view
    2. Slide sorter view
    3. Notes page view
    4. Slideshow view
    5. Normal view
      1. 1,2,3
      2. 2,3,4
      3. 3,4,5
      4. 1,2,5
  19. A computer that is not connected to a network is caleed a
    1. Stand-alone
    2. Client
    3. Server
    4. Terminal
  20. Publishing a webpage means;
    1. Creating files and placing them on a webserver
    2. Creating an advert and placing it in a Newspaper.
    3. Web content is printed directly from the source document
    4. The source documents are merged to webserver contents.

SECTION B

Answer all questions in this section
All answers must be written in the spaces provided.

  1. a) What is meant by Computer Evolution?
    b) Use the terms below to complete the statements (i) to (iv)
  • Data processing
  • Information
  • Computer
  • Data
  • Hard disk
  • Information technology
  1. An electronic device that accepts data input, processes it, outputs the desired information and stores the result is.
  2. The conversion of data into information is
  3. Raw facts or figures that are of little meaning until they are sorted in a useful way are called?
  4. Processed data that has meaning and is useful to the human being is?

c) Give two examples of how computer are used in each of the following sectors
i) Health
ii) Security

2. a) Define the term computer hardware
b) Fill in the appropriate category of the hardware devices from the given list: Input, Output, Storage, Communication.

Hardware Device Category
  1. Compact Disk
  1. MODEM
  1. Projector
  1. Barcode Reader

c) Explain the functions of the computer components below

  1. Power supply Unit
  2. ROM chip

23 a) i) What is a wild card in database management systems?

ii)Give one importance of a wild card in a query criterion.
iii)Name one example of the frequently used wild cards.

b) i) State one characteristic of a label when placed in a spreadsheet cell.
ii) Outline three uses of electronic spreadsheets.

24. a) i) State any two ways a systems administrator can prevent access to some information on the Internet.

ii)Give three reasons for preventing access to such information.

b) i) Explain the term data transmission media in computer networks.

ii) List three examples of computer data transmission media.

25 a) Give the importance of the following features in word processing .

  1. Footnote
  2. Toggle Case

b) Distinguish between Cut and Copy editing features of a word processor.

c) What is presentation software?

d) Outline two areas where presentation software may be used.

26.a) Explain the function of each of the following programming concepts:

i) Termination
ii) Varaible declaration

b) State the use of a complier to a programmer.

c) Explain the term device drivers as applied to computers

d) Give any two forms of interfaces that can be provided by an operating system to the computer user.

SECTION C

Answer only one question from this section.

27. a) Assuming that an organization is faced with a challenge of choosing between a peer-to-peer network and a server-based network, outline five factors to consider before the final decision is made.

b) Explain any five limitations to full Internet use in Uganda.

28 a) Describe any five factors a Headteacher should consider before buying computers for a school.

b) Explain five ways in which computer hardware should be taken care of.

29. Describe five conditions that can lead to a computer system re-boot.

COMPUTER STUDIES PRACTICAL (PAPER 2) 2017

SECTION A
This section is compulsory
1.    a) i) Using an appropriate word processing software, type the passage below as it is. save it as your name and personal number.

‘The Internet is like a library.’ You will hear this kind of statement a lot from people who know very little about either.

If the Internet is a library, it’s a strange one indeed. For starters, there is no indexing system. At any rate, the books are arranged on numbered shelves but scattered on the floor. A lot of what is in the books is untrue, even in the non-fiction ones. There is no librarian, and no information desk. Did we mention also that the lights are turned off?

What’s more, you can make as much noise as you like when using the Internet, while at the same time collecting facts and figures (and fiction and music and video and sports results and weather reports and recipes) from all around the world.

In fact, the principle use of the Internet is for e-mail; a way of sending messages from your computer to someone else’s computer whether in the next room or in a different hemisphere.

Think of this as your chance to borrow knowledge and skills, you won’tever be asked to return, and become part of an online electronic community.
Welcome to the Internet Age.

ii) Insert a suitable heading for the passage. Bold and centre the heading.
iii) Copy the passage to another page.
iv) Set the font size of the passage to 10 points
v) Set the page orientation to landscape and divide it into two columns.
vi) Copy the passage and paste it on the second column.
vii) The last paragraph is a statement made by Paul Holden footnote to indicate the author.
viii) Insert a footer of your name and personal number.
ix) Save and print your work.

b) The table below shows the wages of staff in Otuke Technical school, in June 2014.

NAME BASIC PAY BONUS PAY RESPONSIBILITY ALLOWANCE GROSS PAY PAYE NSSF NET PAY
OBOTH KENT 170,000 59,000 3,000 5,700
APIYO CHRISTINE 172,000 59,000 2,000 6,200
BIRABWA DAPHINE 170,000 59,000 2,000 2,000
KARIM HUSEIN 160,000 59,000 2,0000 3,000
MALE JACKIE 200,000 59,000 5,000 2,300
MUSYA DAVID 240,000 59,000 3,000 2,119
TOTAL PAYMENT

i)    Enter the above information into a spreadsheet application of your choice and save it as your name and personal number.
ii)    Provide an appropriate title for your worksheet.
Use appropriate formulae/function to calculate parts (iii) to (v)
iii)   GROSS PAY which is BASIC PAY, BONUS PAY and RESPONSIBILITY ALLOWANCE.
iv)   PAYE which is 10% of GROSS PAY.
v)    NET PAY which is GROSS PAY less PAYE and NSSF.
vi)   Determine the total for each type of payment.
vii)  Draw a bar chart to represent the NAME and NET PAY of the staff.
viii)  Insert your name and personal number as a footer.
ix)   Save and print your work.

SECTION B
Answer any two questions from this section.
The two web pages below are for Makindye University website

a)    Using web publishing software of your choice, create a website for Makindye University with the above web pages. Save it as your name and personal number.
i)    Home page
ii)    Page 2
b)     Create links to ease navigation within pages.
c)    Apply Marquee on the page titles
d)    Use different background color on each page.
e)    Insert appropriate graphics on each page.
f)    Add a suitable logo on the Home page.
g)    Add contact information on the Home page.
h)    Save and print your pages.

3. A Revenue Authority (RA) is an organization that is responsible for the collection of Taxes from eligible citizens. RA carries out sensitization exercises before imposing the Tax.

AREAS FOR SENSITIZATION
⦁    Types of taxes
⦁    Importance of taxes
⦁    Eligible people to pay taxes
⦁    RA departments

The organization is made up of departments with departmental heads in the following order; MANAGING DIRECTOR, GENERAL MANAGER, two ASSISTANT MANAGERS each with a BRANCH MANAGER.
You have been approached by RA to prepare a presentation for a one-day sensitization workshop.
a)    Make a five-slide presentation for the workshop as follows;
i) SLIDE ONE: The name of the organization, a welcome message and name of the presenter.
ii) SLIDE TWO: Types of taxes charged.
iii) SLIDE THREE: Reasons why people pay taxes.
iv) SLIDE FOUR: An organizational chart showing the departmental hierarchy.
v) SLIDE FIVE: A summary of the main points and an encouragement message.

b)    Apply a slide master for uniformity.
c)    Apply appropriate animation and transition effect.
d)    Link slide four to slide two using an action button.
e)    Save your work as your name and personal number.
f)    Print your presentation as a handout.

4. The following information is for BANANA-ZIWE, a company that buys bananas from local farmers, makes flour out of it and then sells the product to local buyers.
a)    Open a database application and create a database. Save it as your name and personal number.

FARMER’S ID FARMER’S NAME REGION QUANTITIES SOLD (Kg) FARMERS’ CONTACTS UNIT PER Kg TOTAL AMOUNT
R01
  1. Oposa
 WESTERN 6000 0752-2123333 UGX20,000
R02
  1. Lasue
 WESTERN 4500 077-66633322 UGX20,000
R03
  1. Maware
 SOUTHERN 8500 074-54254211 UGX20,000
R04
  1. Kopolo
 NORTHERN 1400 083-24569821 UGX20,000
R05
  1. Yujolo
 EASTERN 6540 077-44477712 UGX20,000
R06
  1. Wasedde
 WESTERN 3200 075-65665631 UGX20,000
R07
  1. Tendy
 EASTERN 7000 022-55566641 UGX20,000
R08
  1. Salilopo
 CENTRAL 4500 078-25632145 UGX20,000
R09
  1. Fishic
 CENTRAL 7400 012-33366602 UGX20,000
R10
  1. Sacoccol
 NORTHERN 200 077-85885862 UGX20,000
R11
  1. Ribon
 EASTERN 1200 034-01245630 UGX20,000
R12
  1. Elieto
 EASTERN 4000 085-23333225 UGX20,000

b) Create a table in design view with appropriate field data types and enter the given data. Save it as Farmers table.
c)    i) Create a form that can be used to enter data in the table and save it as Data entry form.
ii) Include a formula in the form that will calculate the TOTAL AMOUNT for each farmer.
iii) Insert a header of your name on the form.
d)   Create a query that will select only farmers from eastern region who sold quantities of less than 5500Kg and save it as Less than.
e)   Create a query showing only field of FARMER’S NAME and REGION for farmers who don’t come from NORTHERN region. Save it as NOT Northern.
f)    Create a report from the query Less than and save report as Quantities report.
g)    Print all your work.

 

 

 

Sponsored Links

2 thoughts on “UNEB UCE Computer Past Paper Year 2017”

Leave a Comment