DREAMTECH TECHNOLOGIES
COMPUTER PACKAGES EXAM
JAN – APRIL 2024
INSTRUCTIONS:
Answer Question ONE and ANY other two Questions
QUESTION ONE (30 MARKS)
a) Outline the keyboard combination that could be used to achieve each of the following
in MS word: 5 marks
i. Start a new document
ii. Save the current document
iii. Save a copy of the current document
iv. Copy a paragraph of the current document
v. Cut a paragraph of the current document
b) Explain two types of software found in a computer 4 marks
c) State two examples of word processing programs 2 marks
d) Describe absolute cell referencing as used in worksheets with the aid of an example
4 marks
e) With the aid of a sketch, describe three types of views as used in MS. PowerPoint
6 marks
f) Outline two uses of forms in a database program 2 marks
g) Explain a calculated field as used in MS. Access 2 marks
h) Outline three advantages of using a presentation program in teaching 3 marks
i) Differentiating between word processing application and spreadsheet application
2 marks
Page 1 of 4
QUESTION TWO (15 MARKS)
a) Define the following terms as used in databases: 2 marks
i. Table
ii. Record
b) With the aid of a diagram, describe the hierarchical data model as used in databases
4 marks
c) Anita, a computer student at Dreamtech Technologies used the following formula
in a worksheet,
= (A1*C$1)/D$4 - $F$1+B2
Identify each of the following cell references from the formula 3 marks
i. Absolute
ii. Mixed
iii. Relative
d) The table below shows details of salaries of employees in a particular company. Use
to answer questions that follow:
House allowance, medical allowance, gross pay, Tax P.A.Y.E and Net Pay are
calculated as follows:
Using cell addresses only, write a formula that would be able to compute the
following for the company:
1. Medical Allowance 2 marks
Page 2 of 4
2. Gross Pay 2 marks
3. Net Pay 2 marks
QUESTION THREE (15 MARKS)
a) Describe the procedure for starting Microsoft Office PowerPoint. 3 marks
b) Explain each of the following Microsoft Office PowerPoint features: 4 marks
i. Animation
ii. Advance Slide
c) Differentiate between hanging indent and first line indent as used in Microsoft
Office Word. 4 marks
d) Describe the procedure used to set the margins page margins in Microsoft Office
Word. 4 marks
QUESTION FOUR (15 MARKS)
a) Explain three types of reports found in Microsoft Office Access 6 marks
b) Mr. Kennedy, the principal of Kings High School wants to develop a database that
will help him store and retrieve the details of students and staff at the school. He hires
you as a database developer to help him develop the database.
i. List two tables that you would create 2 marks
ii. Explain how you would use queries to retrieve data from the database.
2 marks
iii. Describe two ways which you can use to enter the student records into
the database. 5 marks
QUESTION FIVE
a) What is mail merging? 2 marks
b) Describe the steps involved in the mail merging process 3 marks
c) Differentiate between a formula and a function as used in Microsoft Excel.2 marks
d) List three types of charts found in excel. 3 marks
e) What is the importance of rehearse timings in Microsoft PowerPoint? 2 marks
f) Explain three slide layouts used in Microsoft Office PowerPoint 3 marks
Page 3 of 4
PRACICAL EXAM
WHAT IS A COMPUTER SYSTEM?
What is Computer: Computer is an electronic device that is designed to work with
Information. The term computer is derived from the Latin term ‘computare’, this means
to calculate or programmable machine. Computer cannot do anything without a
Program. It represents the decimal numbers through a string of binary digits.
The Word 'Computer' usually refers to the Center Processor Unit plus Internal memory.
Charles Babbage is called the "Grand Father" of the computer. The First mechanical
computer designed by Charles Babbage was called Analytical Engine. It uses read-only
memory in the form of punch cards. Computer is an advanced electronic device that takes raw
data as input from the user and processes these data under the control of set of instructions
(called program) and gives the result (output) and saves output for the future use.
It can process both numerical and non-numerical (arithmetic and logical) calculations. The
basic components of a modern digital computer are: Input Device, Output Device, Central
Processor Unit (CPU), mass storage device and memory. A Typical modern computer uses
LSI Chips.
Required:
1. Type the text above and use it to answer the questions below.
2. Save the file in the desktop in a under the file name “MS WORD EXERCISE 1”
3. Put the word Charles babbage in second paragraph to BOLD
4. Change the font size of the headline “WHAT IS A COMPUTER SYSTEM” to font size
31, font type “Arial black”, underlined, line spacing 2.0. and font color of the headings
to red
5. Align the headline “WHAT IS A COMPUTER SYSTEM”
6. LIST any FIVE hardware parts of a computer system after the last paragraph. Insert
numbering of your choice to “list of computer parts you have typed”
7. Insert a clipart of a COMPUTER after the last paragraph to represent a computer
8. Add the background of your document to green.
9. Spell check your document.
10. INSERT page numbers at the center.
Page 4 of 4
