DE PEAK MODEL PRIVATE look of your entire document D.

none of the
above
SCHOOL 7. In order to save an existing document
THIRD TERM EXAMINATION 2023/2024 ACADEMIC
with a different name you need to A.
SESSION
80, 0TA ITELE ROAD, LAFENWA, OGUN STATE
retype the document and give it a different
TEL: 08032149891, 08032589790 name B. use the save as command C. copy
SUBJECT: DATA PROCESSING CLASS: SS1 and paste the original document to a new
NAME: ____________________________ document and then save D. use windows
EXAMINER: ________________________ explorer to copy the document to a different
SECTION A: OBJECTIVE (20 MARKS) location and then rename it
1. To view paragraph marks, clicks on the 8. Suddenly the word does not display your
_____ tab, in the paragraph group, click favourite toolbar. What has happened? A. your
show/hide. A. view B. home C. page layout program has been infected by a micro
D. references virus B. this version of word does not
2. W h i c h of the following best support toolbars C. your toolbar option has
describes the ribbon? been deleted from the menus D. your toolbar
A. a feature that can translate text has been unchecked under the view/toolbars
into any language B. a slider that you menu
can use to zoom the document C. a 9. Ajuwon Janet carried out the
c a b l e t h a t c o n n e c t s y o u r computer to a assignment project given to her by her
printer D. a toolbar with various commands data processing teacher Mr. Ejiro at home
3. A k i n b o r o Kamiye made an error upon displaying the document in school she
while creating her document. She found out it displayed a different font, what
u s e d t h e w o r d “ m a r o o n ” instead of could be the reason for this A. because you
“burgundy” in several places. What is the have a different printer at school than at home
quickest way for Kamiye to correct her B. because you have a different monitor at
mistake? A. delete all of the text and school than at home C. because the font you
start over B. use the find and replace used at home is not installed on your
feature C. use the spelling and grammar school computer D. because the version of
feature D. insert SmartArt windows is different
4. What is the main advantage of using a 10. How many different documents can
text box? A. it gives you more freedom to you have open at one  me? A. no more
move the text around B. it allows you to than three B. only one C. as many as
change the page orientation C. it automatically your computer memory will hold D. no more
appears on every page of your document D. than your taskbar can display
it automatically makes the text larger 11. The acronym that is used to denote MS
5. If you want to add text to the top of Excel’s order of operation is A. PEDDAS B.
every page in your document, which PEMDAS C. PEMMAS D. PEDDMA
feature would you use? A. footer B. header 12. Which of the calculations are performed
C. page layout D. backstage view first in excel? A. Multiplication B. Addition C.
6. The following are advantages of using Parenthesis D. Division
Word’s built-in styles except A. you can 13. “*” represents _________ A. addition B.
easily give your document a exponential C. multiplication D. none
professional look and feel B. you can 14. All these except one are an example of
quickly format all of the images in spreadsheet packages. A. `Lotus 1-2-3 3 B.
y o u r document C. you can quickly change the Supercal C. Corel sheet D. Ms Excel
15. The cell that is been currently worked upon 25. T h e p r o c e s s o f a r r a n g i n g t h e
is known as _____ cell A. current B. active C. items of a column in some
reference D. Initial sequence or order is known as A.
16. The ________ can contain thousands of rows arranging B. autofill C. sorting D. filtering
of data and columns in the form of fields. A. 26. In which tab of the ribbon can you
cell B. worksheet C. reference cell D. excel change workbook views to page break
17. The address f a cell is known as ___ A. Cell preview? A. view B. review C. page layout
space B. Cell reference C. Cell menu D. Active D. data
cell 27. What is the best practi ce for
18. A d o c u m e n t i n p o r t r a i t p r i n t s A . financial modelling in excel? A. use
the same characters per line with black font for all hard-code d n u m b e r s
t h e s a m e d o c u m e n t i n landscape B. and formulas and blue font for only
more characters per line than the same the totals B. use blue font for all
document in landscape C. less h a r d - c o d e d numbers and formulas and
characters per line than the same document black font for only the totals C. use blue font
in landscape D. smaller fonts in order to print for hard-coded numbers and black font for
the same amount of characters per line with formulas D. use black font for hard-coded
landscape numbers and blue font for formulas
19. T o p e r f o r m w o r d p r o c e s s i n g , y o u 28. W h e r e i s t h e f i l l h a n d l e l o c a t e d ?
will need the following except A. a A. on the right side of the home tab
c o m p u t e r B . a s p e c i a l program called a o n t h e r i b b o n B . a t t h e beginning of
word processor C. a printer D. a scanner any formula or func tion C. in the bottom
20. Word processors that support basic right corner of the selected cell D. in
features such as insert text, delete text, copy, the backstage view
cut and paste etc. are called A. text editors 29. What would be a correct formula for sum in
B. full featured word processors C. graphics D. Excel? A. =SUM(B3:B9) B. =SUMB3+B9 C.
basic word processor SUM(B3:B9)D. =ADD(B3:B9)
21. The top part of the window 30. O g u n b a w o T o l u w a n i n e e d s t o a d d
displaying Microso ft word that includes three cells and then divide the sum
the name of the active file, which also b y 4 . W h i c h o f t h e following is an
houses minimize, maximize and close example of the correct formula to do
buttons for the word window A. menu this? A. =(A1+A2+A3)/4 B. A1+A2+A3/4
bar B. title bar C. control menu button C.=A1+A2+A3^4 D. (A1+A2) + A3/4
D. standard toolbar 31. Ajuwon Janet have decided to center
22. Which function excel tells how many the text within a cell. What have she
numeric entries are there? A. NUM B. done? A. changed alignment B. wrapped
COUNT C. SUM D .CHKNUM text C. merged cells D. autofit content
23. A feature that displays only the data 32. What function was used to find the highest
in column(s) according to speci fied grade? A. AVERAGE B. MIN C. SUM D. MAX
criteria A. formula B . sorting C. filtering D. 33. Located on the left side or the entry
pivot bar, displays the active cell reference A.
24. What type of chart is useful for entry bar B. cel l reference C. name box D.
showing trends or changes over  me? A. none of the above
pie chart B. colum n chart C. line chart D. 34. The following options are uses of
dot graph spreadsheet except A. cash flow analysis
preparation B. budget planning and control C.
Income and expenditure D. preparation of C. Explain the following terms; a. argument b.
memoranda range c. chart d. title bar e. quick access
35. When an unformatted number does not fit toolbar
in a cell, you see it in A. (###) B. scientific D. List two arithmetic operations that
notation C. number D. logic are performed on a row of numeric data
36. A predefined formula that performs in a spreadsheet package
a particular type of calculation A. QUESTION 3
function B. calculation C. relative cell A. Explain the following terms;i. character ii.
references D. chart Field iii. Record iv. File
37. A c o l l e c t i o n o f i n f o r m a t i o n t h a t B. Explain the following terms
is organized so that it can easily be i. superkey ii. Composite key iii. Simple key iv.
a c c e s s e d , m a n a g e d a n d updated is A. Alternate keys
database management B. database C. C. Explain the following terms; i. table ii. Query
database management system D. database iii. Form iv. Report v. cardinality vi. Degree
administrator Di. List four data types in database ii. What is
38. A d a t a b a s e t h a t i n c l u d e s s u c h f u the difference between Design view and
nctions as querying the database to Datasheet view
r e t r i e v e s p e c i f i c d a t a , updating the SECTION C: TEST OF PRACTICAL
database to reflect changes and (10marks)
generating reports from the data A. ANSWER ONE QUESTION
sharing B. manipulating C. defining D. QUESTION 4
constructing A. Write the steps to start Microsoft Word
39. A d a t a b a s e t h a t a l l o w s m u l t i p l e B. Write the steps for saving a document
users and programs to access the C. Write the steps for opening an existing
d a t a b a s e c o n c u r r e n t l y A . manipulating document
B. sharing C. granting access D. constructing D. Write the steps for printing a document
40. A row of data in a database table E. Write the steps in creating a table in
consisting of a single value from each Microsoft Word
column of data in th e table A. field B. QUESTION 5
record C. File D. database A. Write the steps in entering a formula
SECTION B: THEORY (30marks) B. Write the steps using a Fill handle to copy
ANSWER ALL QUESTION formula
QUESTION 1 C. Write the steps for adding borders to a table
A. What is a Word Processor and mention four D. Write the steps to delete range of cells
examples of a word processor E. Write the steps on how to chart your data
B. Mention three uses of Word Processing and mention three types of chart
C. Explain the following terms A. title Bar B. QUESTION 6
Menu Bar C. Tool Bar D. Scroll Bar E. A. Write the steps in creating a new database
Text Alignment from scratch
D. What is difference between Cut and Paste B. Write the steps in creating a table in design
and Copy and Paste view
QUESTION 2 C. Write the steps in adding tables to a
A. Explain the following features; a. cell b. cell database view
pointer c. labels d. cell address e. cell handle D. Write the steps in resizing columns and
B. List five uses of Microsoft Excel rows in a datasheet
E. Write the steps to insert a new field and
delete an existing field
 DE PEAK MODEL PRIVATE B. transparency applied to the background C. a
dull outline applied to the text D. all of the
SCHOOL above
THIRD TERM EXAMINATION 2023/2024 ACADEMIC 11. Which term describes how a designer
SESSION positions web page element to form
80, 0TA ITELE ROAD, LAFENWA, OGUN STATE relationships and direct the focus of
TEL: 08032149891, 08032589790 visitors A. hierarchy B. orientation C.
SUBJECT: DATA PROCESSING CLASS: SS 2 typography D. layout
NAME: ____________________________ 12. W h a t does a cascading style
sheet do? A. it makes your page
EXAMINER: ________________________
cascade B. controls the way your
SECTION A: OBJECTIVE (20 MARKS) content looks (or its presented) C. makes your
1. The dotted outline that appears when browser window bigger D. controls the scripts
you create a new slide A. placeholder B. in your webpage
animation C. slid e transition D. object view 13. How can you tell if a curve is not
2. The following are examples of presentation closed? A. it is white and not a colour B.
package except A. Ms Power Point B. Harvard it cannot be filled C. it is highlighted D. it
Graphics C. windows movie maker D. Google can be filled with a colour
duo 14. A text that scrolls across the screen,
3. Which term is used to describe the is used when you want to draw att ention
combined use of audio, video, animati on to a certain point A. advertising banner B.
and interactivity? A. compatibility B. pixlr table of content C. marquees D. search form
C. multimedia D. web design 15. For selecting and deselecting objects, we
4. A docked bar with tools for use A. freehand tool B. shape tool C. pick tool
creating, filling and modifying D. Bezier tool
objects in the drawing A. toolbox B. 16. ______ is used for selecting and deselecting
navigator C. drawing page D. docker objects A. Bezier tool B. freehand tool C. shape
5. The following are different types of views to tool [Link] tool
work with, while a presentation is being 17. The zoom tool is used for _____ objects A.
created A. slide view B. outline view C. note magnifying B. cropping C. marquee selecting
view D. print view D. embedding
6. What is the default paper type/size when 18. How can you import mul tiple
you open Corel Draw windows? A. A4 B. B2 C. consecutive files in one go? A. shift +
postcard D. letter select the first and last files B. control +
7. Which technology do web hosting select the first and last files C. alt +
companies commonly provide to their select the first and last files D. shift +
customers so the customers can add, update, control + alt + select the first and last files
remove and modify large le on a server A. 19. Which of the following refers to the
SSH B. HTTP C. SSL D. FTP detachable bar with commands that relate to
8. To determine download me for a web the active tool or object? A. menu bar B.
page you are creating, you need to check the property bar C. status bar D. title bar
size of the html file and all of its included 20. A window that contains available
resources, such as multimedia and commands and settings relevant to a specific
graphics. This file size is called A. page tool or task A. bitmap B. drawing C. docker D.
weight B. usability testing C. validation D. artistic text
compatibility 21. T h e r e c t a n g u l a r a r e a i n s i d e t h e
9. What do you call the visual e ffects, drawing window. It is the printable
you get going from one slide to another a r e a o f y o u r w o r k a r e a A . document
A. animations B. slide show C. transitions D. palette B. drawing page C. status bar
motion paths D. update text toolbar
10. When light colour texts are placed on a light 22. Why is a maintenance protocol for
colour background, it needs the following technology and supplies important? A. it
application A. transparency applied to the text ensures that employees receive the necessary
technology training B. it increases office repair software to fix the application
morale C. it helps avoid down time D. it helps because it’s probably a registry error
increase the storage capacity of older devices 28. If you get strange errors on your
23. If it takes a long me to open les, how computer and don’t have a virus, what
can you usually speed up windows without should you check next? A. you should
buying anything A. you can increase the check your firewall in case a hacker is
speed windows opens  les on a trying to break into your computer B.
magnetic hard drive by defragmenting you should check your BIOS in case you
the d r i v e w i t h windows defrag B. don’t have plug and play enabled C. you
rebooting windows will make files should check your computer memory
o p e n m o r e q u i c k l y C . r u n n i n g window (RAM) in case it’s starting to fail D. you should
scandisk or check disk to check your disk drive check your windows updates for any patches
for errors will speed up opening files D. turning you need to install
off your firewall will speed up opening files 29. If your computer is running slow, what
24. If your computer monitor turns on but default windows program will help you find
doesn’t seem to display an image (or which program is u s i n g a l l o f y o u r
even the built-in info s c r e e n ) , w h a t i s processing power (CPU) or memory?
probably wrong A. your computer A. you can use task manager to find
monitor isn’t connected to your t h e offending program B. you can use
c o m p u t e r correctly B. the light bulb (or the control panel to find the offending
LED bulb) which provides the ligh ting for program C. you can use s c a n d i s k t o
your monitor isn’t working correctly C. find the offending program D. you
the monitor firmware is broken D. you can use the device manager to find
used the wrong device driver on your t h e o f f e n d i n g program
computer for your current monitor 30. When you want to change the design of
25. T h e f o l l o w i n g a r e t h e g e n e r a l one slide, but not all, you must A. go to layouts
cleaning steps except A. never on the home tab and select single B. on the
spray any liquid onto any computer design tab, double left click the design you
component B. it is safe to use vacuum want C. on the design tab, right click on the
cleaner to suck up dirt, dust, food and design you want and choose “selected slides”
hair from keyboard C. your computer D. after selecting the design, click on the undo
should be placed on a clean lint-free symbol
surface D. use your breath to blow the 31. W h e r e w o u l d y o u f i n d a t i t l e a n d
dust off the components bullet box already made for you A.
26. Can you replace a sound card or video card c u s t o m a n i m a t i o n B . s l i d e transition C.
built into your motherboard (integrated sound slide layout D. view tab
and video) A. yes, you can replace built-in 32. You are ready to begin developing the
components by using the right replacement slides for a new presentation. What is the
modules B. yes, you can replace built-in default slide layout for slide1 of a new
components using generic replacement presentation A. blank B. title and content C.
modules C. yes, you can replace built-in title only D. title slide
components but you will need custom 33. Adeleye King wants to add De Peak Model
replacement parts D. no, you can’t Private School logo to the bottom right corner
normally replace built-in component of every slide. What’s the most efficient way to
27. What is usually the easiest way to  x do this? A. copy the picture, select all of the
an application which won’t start slides in the navigation pane, right click and
anymore A. run your virus scanner to fix choose paste B. use the pen tool to draw the
the application because you probably logo C. insert the logo on the slide master D.
have a virus B. reboot your computer to insert the logo once, copy it, then paste it to
 x t he application because it’s probably a the other slides
system error C. uninstall and reinstall the 34. How to select one hyperlink after another
application to reset the application during a slide presentation? A. ctrl + k B. ctrl +
completely D. run windows registry d C. ctrl + h D. tab
35. The type of presenta tion view that is (ii) Explain any one approach listed in l(b)(i)
used to view slides one by one on the C (a) Vera, a secretary to the manager of her o
screen. In this view you can insert text, rganization is saddled with theresponsibility of
movie clip, sounds etc. A. slide view B. outline typing a confidential report. She is also
view C. normal view D. note view instructed to insert the word . “CONFIDENTIAL "
SECTION B: THEORY diagonally in the background of every page of
INSTRUCTION: NOTE THE FOLLOWING the report.(i) State the Most suitable
ANSWER THREE QUESTIONS ONLY!!! application software needed by Vera to
QUESTION 1 produce the report.
A. What is a presentation package and list (ii) What feature of the application software ca
three examples n be used to insert the word “CONFIDENTIAL “as
B. What do we mean by grouping object instructed1? (iii) Mention one measure that
C. Mention four presentation view can be taken to ensure the confidentiality of
D. What is difference between transition and the soft copy of the report in the computer.
animations D. Explain the following terms: (i)
E. What is the difference between shape icon' , (ii)browser
fill and shape outline QUESTION 7
QUESTION 2 A. Outline the steps involved in printing the
A. What is graphic packages and mention first five pages of a Word document from the
three examples of graphical package print dialog box on a computer with two
B. Mention two types of graphics and explain printers installed.
one. (b) Sadiq complained that a pop-up usually ap
C. State the function of each of the following pears on the screen of his personalcomputer
in Corel Draw (i). Menu bar (ii). Tool bar (iii) thereby disturbing him while using the computer.
Colour Palette (iv). Rulers (v) power clip (i) What is the possible cause of the pop-up?(ii)
D. What are the usefulness of the following State a possible source of the element causing
tools (i) pick tool (ii) freehand tool (iii) text tool the pop-up.
(iv) zoom tool (v) shape tool (iii) What measure would be necessary to stop
E. Mention five components of Corel Draw and the pop-up from reoccuiring?
explain two (c) Mr. Aneke is billed to address a large audie
QUESTION 3 nce in an auditorium.(i) What computer applica
A. Mention three materials or tools for cleaning tion package is suitable to prepare and deliver
computer hardware hisspeech?(ii) State the output device that can
B. Mention three general cleaning tips be used to transmit Mr. Aneke’s speechnote
C. How often should you clean your computer? from his computer to a large screen in the
D. If you spill liquid on the keyboard what can auditorium.(d) Give two types of computer
be done to fix this issue network;
E. What is the major reason we have to shut
down the computer and detach all connecting
cables?
SECTION C: TEST OF PRACTICAL
ANSWER TWO QUESTIONS ONLY!!!
QUESTION 4
A. Write the steps on how to clean your
computer mouse
B. Write the steps on how to clean
your computer keyboard
C. Write the steps on how to clean the system
unit
QUESTION 6
A. (i) What is data model ? (ii) State three types
of data model.
B. (i) List three approaches to data modelling.