SCHOOL: GOOD SHEPHERD SCHOOLS SUBJECT: DATA PROCESSING SECOND HALF EXAMINATION SS3 EDUCATOR: MR.

EJIRO

1. Which of these measures would not secure data in a database 20. Which of the following is not an application of computer? w B.
A. encryption B. data integration C. personal identification point of sale terminal C. automated teller machine D. traffic
number D. username and passwords light control
2. Social networking does not promote A. personal publicity B. 21. Which of the following persons invented the punch card
business expansion C. e-commerce D. e-payment machine A. blaise pascal B. gottfried leibniz C. prosper ecker
3. The following are destructive software except A. drivers B. D. herman hollerith
worms C. trojan horses D. logic bomb 22. In graphic packages, the process of removing an unwanted
4. In spreadsheets, data would not be accepted into a cell by part of an image is known as A. shaping B. resizing C. editing
pressing the A. enter key B. arrow key C. esc key D. tab key D. cropping
5. The advantages of electronic data processing include the 23. The moral principles that regulate the use of computers, its
following except A. automatic processing B. hacking C. fast accessories and environment are called computer A. ethics B.
and reliable processing D. storage capacity conduct C. attitude D. appreciation
6. A program developed to protect the computer from malicious 24. A data element that uniquely identifies one record from the
software is referred to as A. trojan B. driver C. anti-virus D. other in a table is the A. attribute key B. determinant C. entity
spyware key D. primary key
7. Which of the following is not a preventive maintenance 25. Which of the following is not used for online shopping? A.
measure? A. regular update of the operating B. proper master card B. credit card C. verve card D. virtual
shutdown of the system C. use of uninterrupted power supply card
D. data recovery 26. In relational model, a tuple is a A. column of a table B. key of a
8. The type of data entered into a table in a database follow a table C. row of a table D. two-dimensional table
set of rules known as A. protocols B. regulators C. constraints 27. Computer virus cannot be transmitted by A. downloading files
D. algorithm B. e-mail attachment C. pen drives D. typing on keyboard
9. Which of these packages could be used by Mr. Ejiro to design 28. A search engine is a A. program that searches engines B.
a website for this school A. front page B. web page maker C. computer engine that searches a database C. tool that
powerpoint D. word perfect searches the web D. hardware component of a computer
10. Which of these is an alphabetic data? A. Bed B. Ax44jj C. 29. The performance of the computer can be enhanced by A.
AB+CD D. % using large monitor B. using a faster printer C. installing a
11. Facebook, twitter, likee, tiktok are examples of A. social media scanner D. increasing the memory size
B. social communication C. networking media D. search 30. Which of the following operations prevents file loss? A. file
engines backup B. file conversion C. file maintenance D. file sorting
12. Which of the following is not a source of data collection A. 31. Which of the following factors is not considered when
observation B. interview C. questionnaire D. classification classifying computer? A. location B. size C. type D. purpose
13. Which of the following drawing tools would create special 32. In Microsoft PowerPoint presentation, the special effects that
effects on texts A. smart art B. shape tool C. text box D. word control the order in which objects enter a slide and their
art manner of appearance is A. transition B. media C. clip art D.
14. Planning and creating websites are stages in A. web analysis B. animation
web maintenance C. web design D. web publishing 33. An operating system will perform the following functions
15. The operation of checking input data against specified criteria except A. files and folder management B. storage locations
is referred to as A. data verification B. arrow key C. data cross management C. user profile creation D. protection from surge
check D. data control 34. In Database Management System (DBMS), linking entities is
16. Which of the following is true about a digital computer? A. used to represent A. attributes B. objects C. relationship D.
they consist of magnetic core memory B. they recognize data relations
as continuous measurement of a physical quantity C. they 35. The rules for exchanging data on a network are known as A.
represent numbers through a string of binary digits D. they transmission rules B. transfer rules C. protocols D.
are mainly used for scientific purposes configuration
17. While typing a Microsft Word document, Ajuwon John 36. Data gathering involves the following means except A.
inserted footer in the document in order to A. enhance the counting process B. voting process C. measuring process D.
overall appearance of the document B. make the document calculating process
more readable C. insert page number D. make it appear on 37. Which generation of computer made use of integrated
the document when printed circuits? A. fourth B. third C. second D. first
18. The property of a system software that enables it to execute 38. The type of data which consists of text, number, audio, video,
more than one program at a time is referred to as A. graphic and animation is called A. data set B. multimedia data
compiling B. virtual memory C. multitasking D. load modules C. multi-purpose data D. multi-variable data
19. The feature in a database application that acts as an interface 39. Which of the following is not an ancient medium for
between user and the database is called a A. query B. report transmitting information? A. fire lighting B. beating of drums
C. form D. table C. telephone D. whistling
 43. Information transmission medium from one location P to
Use the Excel Sheet diagram to answer question 40 - 41 location Q in space is called A. wireless transmission B. wired
A B C D E transmission C. cabled transmission D. asynchronous
1 EMPLOYEE BASIC TOTAL TOTAL NET 44. Which of the following is not an advantage of file
SALARY ALLOWANCE DEDUCTION SALARY organization? A. faster processing of data input B. post data
(₦) (₦) (₦) (₦)
retrieval C. prevention of data failure and data loss D. safety
2 Akomolede 22000 29000 7000 44000
of data and information in a storage medium
Samuel
3 Ajuwon 26000 35000 9000 52000 45. In Microsoft Word, the symbol B, I and U are commonly used
John buttons found on the A. standard bar B. menu bar C.
4 Adepoju 15000 21000 6000 30000 formatting bar D. drawing bar
Pelumi 46. Which of the following is not an anti-virus? A. avast B. avg C.
5 Olajide 33000 41000 8000 66000 compaq D. norton
Deborah 47. The following software programs co-ordinate and control all
other computer program, hardware and user’s actions except
40. From the diagram, The Microsoft Excel Worksheet shows the A. linux B. unix C. dos D. dbms
salary distribution for four staff of a company. The net salary 48. Which of the following is a safety measure in the computer
is paid after deductions have been made, which of the laboratory? A. eating in the computer laboratory B.
following formulas would be used to obtain the value in cell illumination in the computer laboratory C. opening up the
E3? A. =B2 + C2 – D2 B. =B2 + C2 – D2 C. =(B2 + C2 + D2)/3 D. monitor by unauthorized persons D. poor ventilation in the
C2 – D2 computer laboratory
41. Olajide Deborah Total Allowance was omitted from the sheet 49. Which of the following is not a good computer maintenance
when compiling the list, which of the following options is the practice? A. blowing the system unit with a blower B. blowing
correct mathematical formula to determine Deborah’s the keyboard with a blower C. cleaning the screen with wet
allowance A. =E5 – B5 + D5 B. =E5 + B5 – D5 C. =E5 – B5 – D5 cloth D. cleaning the CD-ROM drive with lens water
D. =E5 + B5 + D5 50. A internet based system that allows people of different
42. Which of the following are parts of a computer processor A. geographical locations to have in person meeting is known as
cpu and main memory B. control unit and alu C. operation A. voice messaging system B. video conferencing system C.
system and applications D. main memory and storage online mailing system D. fax system

THEORY SECTION
QUESTION 1
A. What is an Operating System
B. State two functions of an operating system
C. List two differences between an operating system and application software

QUESTION 2
A. What is an application package
B. State one use each of any four application packages
C. State

QUESTION 3
A. What is Data Handling?
B. Explain two ways of handling data
C. State four factors to consider when handling data electronically

QUESTION 4
A. What is Information Processing
B. Outline four steps involved in information processing
C. Mention three advantages and disadvantages of using computers for information processing
D. with the aid of a simple diagram explain information processing and give three examples of information processing

TEST OF PRACTICAL SECTION

QUESTION 5
Akomolede Samuel was asked to record the type of vehicles that entered the school compound through the school’s main gate on a
Monday morning. The passage below is an excerpt from Samuel’s report on the assignment.
“Report on the vehicle traffic at the gate on Monday. 1. Introduction: I was directed by Mr. Ejiro to sit at the main gate and record the
type and number of vehicles that passed through the gate on Monday morning. 2. Observation: I arrived the gate at about 8:00am and
left at 12 noon. During this period, I made the following observations: car, bus, bus, car, car, lorry, motorcycle, bus, bus, car, car, car,
truck, motorcycle, car, tricycle, motorcycle, bus, bus”
A. Beginning from the desktop environment, outline a step by step procedure of how to type the passage in Microsoft Word using A4
paper size and portrait orientation.
B. State the procedure for carrying out the following operations in the passage:
i. Begin the second and third sentences in new paragraphs
ii. Write the first sentence in capital letters, underline it and bold it
iii. Begin the first letter of a sentence with capital letters
iv. Represent the student’s observation in a table with three columns under the headings: Serial Number, Type of Vehicle, Number of
Vehicle
v. Merge the first two cells of the last row of the table, type “Total and give the total number of vehicles observed in the column for
number of vehicles
vi. Save the document with the name “Akomolede Samuel Report”
vii. Print four of document with the name “Akomolede Samuel Report”

QUESTION 6
The below diagram is a sample data of students of SS3 Hope Town and their Result.
Note: This is not their actual result but a generated score to these excellent students.
1 A B C D E F G H I J K L M
2 S/N NAMES RESULT
3     ENG. MATHS CHEM PHY BIO. ECONS D.P F.MATHS CIVIC TOTAL AVG.
4 1 Adepoju Pelumi 72 68 81 70 80 70 58 76 69
5 2 Ajibona Ayomide 72 68 81 76 80 69 58 76 65
6 3 Ajibona Temiloluwa 78 69 81 70 67 75 58 76 89
7 4 Ajobere Peter 72 68 81 70 80 70 58 76 69
8 5 Ajuwon John 72 86 74 81 86 59 78 57 76
9 6 Akingbehin Akinwunmi 89 69 81 78 80 70 58 76 69
10 7 Akinsola Winner 72 68 81 70 80 70 58 76 69
11 8 Akomolafe Motunrayo 73 68 81 74 64 58 58 76 77
12 9 Akomolede Samuel 78 68 82 68 60 81 58 88 69
13 10 Ariehwe Isaac 72 80 81 70 80 94 74 76 86
14 11 Awosanya Abolade 72 68 74 70 86 83 58 76 69
15 12 Ebietomiye Adedamola 68 89 81 75 80 70 58 89 69
16 13 Lawal Feyikemi 72 99 81 70 55 70 58 76 75
17 14 Ndatah Abasiono 70 75 81 69 80 73 58 78 69
18 15 Ndu Chinonso 72 68 81 70 80 70 58 76 76
19 16 Olajide Deborah 72 68 81 70 80 70 58 76 69
20   TOTAL    
21   AVERAGE    
Write the procedural steps of the following
A. The formula to calculate the total score for D.P
B. The formula to calculate Akomolede Samuel average score in four subjects namely; English, Mathematics, Civic and D.P
C. Calculate Ajibona Ayomide total score in all the subjects and give the result in a cell L5
D. The formula to calculate the average score for Ebietomiye Adedamola
E. If the minimum pass mark is an average score of 60, write a formula to determine if Akomolafe Motunrayo passed or failed
F. How to the “Result” was centralize all through cell C to cell M
G. How to include the table to this result sheet
H. How to insert colour for the Result both for the cell and text (Note: the steps should be different for the cell and text)